Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa JSP-Servlet jsp to access query

Have Programming Question? Ask it here!
 
 
 


Kunal Thakare
jsp to access query
1 Answer(s)      a year and 10 months ago
Posted in : JSP-Servlet


How to insert the values from jsp to access ?


Advertisement
View Answers

October 3, 2012 at 3:14 PM


Here is a jsp code that insert the values to MS access database.

Follow these steps:

1)Go to the start>>Control Panel>>Administrative Tools>> data sources.

2)Click Add button and select the driver Microsoft Access Driver(*.mdb).

3)After selecting the driver, click finish button.

4)Then give Data Source Name and click ok button.

5)Your DSN will get created.

6) Restart your server and run your jsp code.

<%@page import="java.sql.*"%>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:student","","");

Statement st=con.createStatement();
int i=st.executeUpdate("insert into data(name,address) values('Roseindia','Delhi')");
out.println("Data is inserted successfully");
%>


Related Tutorials/Questions & Answers:
jsp to access query
jsp to access query  How to insert the values from jsp to access ?   Here is a jsp code that insert the values to MS access database... Access Driver(*.mdb). 3)After selecting the driver, click finish button. 4
MS-ACCESS Query Problem - SQL
MS-ACCESS Query Problem  hi sir i have table which is initially... tables Course and Class wise Ex..Query like: if we execute this Query... records so these all records i want to insert into Deleted Table plz can u give Query
Advertisements
Query in jsp
Query in jsp  I have one textbox in jsp. when i will write any letter in that textbox i want all values which are starting from that letter in option from database. same as we are getting in google search textbox. Thank
insert code jsp to access
insert code jsp to access   insert code jsp to access
Jsp Query
Jsp Query  Can we display images in jsp file? If Can, How and please mention code
jsp query: - JSP-Servlet
jsp query:  hi, i was writing a program in jsp for accessing mysql database.. i was trying to print the each record in new line each time. even by using out.println("\n"), i am not getting the output on separate lines
Query regarding JSP, JDBC
Query regarding JSP, JDBC  can I get the code for the question asked by me regarding JSP,JDBC
insert query in jsp
insert query in jsp  give me insert code in jsp at run time
MS Access - JSP-Servlet
stepts 1.to configure the ms access database to your system control panel...", "", ""); Statement stmt = con.createStatement(); String query = "select...+"'"; ResultSet rs = stmt.executeQuery(query);   Hi friend, Code to help
jsp query - JSP-Servlet
jsp query  in first division there is one table which contains data with edit button... when i will click on edit button that division will become hidden and new division come with all related data
Query regarding JSP, JDBC
Query regarding JSP, JDBC  I have a table in SQL Server database storing some ids and names. In my jsp code a while loop is displaying the list... by running a query through the id corresponding the name using arraylist
query - JSP-Servlet
.... that means i wants update query n delete query that work in one page at onclick update.../jsp/edituser.jsp?id='+id,'mywindow','width=500, height=350,toolbar=no,resizable...://localhost:8080/examples/jsp/deleteuser.jsp?id='+id,'mywindow','width=500, height
JSP and Database access
JSP and Database access  Hi, Please help me with the following program. I am not able to update all the pa column values in my database. csea.jsp: <html> <body> <%@page import="java.sql.*"%> <form method
SQL Query - JSP-Servlet
SQL Query   AS mysql backend updation query shows a syntax error. I gave the full query and the generated error here. Please send me the correct query anyone. st.executeUpdate("update stud_detail set name='"+newname
small query - JSP-Servlet
small query  how to set value to textbox on browser side which is retrived from the database?  Hi friend, Plz explain problem in details which technology you have used e.g. JSP/Servlet/Java etc... For more
code for insert the value from jsp to access database
code for insert the value from jsp to access database  code for insert the value from jsp to access database
problem in jsp using ms-access
problem in jsp using ms-access  after starting server(tomcat) wen v... and select the driver Microsoft Access Driver(*.mdb). 3)After selecting...)Your DSN will get created. 6) Restart your server and run your jsp code. Here
how to insert values from jsp into ms access
how to insert values from jsp into ms access   how to insert values using jsp into ms access database
accessing ms access through jsp
accessing ms access through jsp  i have 3 tables in my database employee,project,task if i put employee id the search field .i should get details from other table what all queries should i use in servlet file and i am using
Remote desktop access - JSP-Servlet
reply me Thank a lots in advance   I forgot to say i am using jsp
sql/xml query in jsp - JSP-Servlet
sql/xml query in jsp  Sir I am coding in jsp and trying to retrieve xml data from db2 using sql/xml query in jsp but getting no result. When running jsp file in browser the output
How to access the Title tag from xml to jsp
How to access the Title tag from xml to jsp  How to access the Title tag from xml to jsp   Please visit the following link: http://www.roseindia.net/jsp/parsing-xml.shtml The above link will provide you an example
mask query string - JSP-Servlet
mask query string  i am using query strings in my servlet which is visible on the address bar, i want to hide the query string from the address bar, can any one please help me, If possible please provide me with the code snippet
how to access JQuery array in jsp page?
how to access JQuery array in jsp page?  JQury Array: var elems =this.value; var arr = jQuery.makeArray(elems); How to get in jsp page
Sending query with variable - JSP-Servlet
Sending query with variable   While displaying pages in frames concept, one page contains links and other page contains messages for that links... database and query should have a variable at the end. While using this variable we
problem in insert query - JSP-Servlet
  Hi friend, We check your Query it is correct .If you have
sql/xml query in jsp - JSP-Servlet
sql/xml query in jsp  Sir Here is my code which is not working Testing JSP select id from "SYSTEM".PROFILE where xmlexists('$d[first="nitin"]' passing "SYSTEM".PROFILE.INFO as "d
access
access   This is Nitha Sriram i am having a problem that, i am having a combo box in the JSP page when i select an item from that i am calling... this value to JSP scriptlet
How to access the following tag from xml to jsp
How to access the following tag from xml to jsp  How can i get... the following link: http://www.roseindia.net/jsp/parsing-xml.shtml The above link... into jsp table
problem of static in jsp page by multiple user access
problem of static in jsp page by multiple user access  hi , i am continuing my online exam project,but i have a Singleton class which i am invoking from my jsp page , ths page can access by more number of users .every user
how to connect to MS access database in JSP?
how to connect to MS access database in JSP?  how to connect to MS access database in JSP? Any seetings/drivers need to be set or installed before... and select the driver Microsoft Access Driver(*.mdb). 3)After selecting the driver
Passing Parameter Values to another jsp in Query Strings
Passing Parameter Values to another jsp in Query Strings  HI ALL, I m trying to pass a variable value to another JSP using query string... response.sendRedirect("http://localhost:8080/SWIFT/index.jsp?loginid='"+loginid
JSP:Passing query as parameter - Java Beginners
JSP:Passing query as parameter  Hi Friends, I have a real tough... problem. Please help me solve this problem. My Problem is: I have 3 query..."; String qry3="select age from table13"; string q=Insert into emp values
JSP:Passing query as parameter - Java Beginners
JSP:Passing query as parameter  Hi Friends, I have a real tough... problem. Please help me solve this problem. My Problem is: I have 3 query..."; String qry3="select age from table13"; string q=Insert into emp values
how to delete the access database value in jsp
how to delete the access database value in jsp  i loaded my database data into the dropdown list box...now i want to delete the value..plz send the source code to delete the value in dropdown list box and also from database
how to delete the access database value in jsp
how to delete the access database value in jsp  i loaded my database data into the dropdown list box...now i want to delete the value..plz send the source code to delete the value in dropdown list box and also from database
Select query in JSP
Select query in JSP We are going to describe select query in JSP.... After that we create JSP page than we have make database connection. After that we use SELECT query. SELECT query is a retrieve the data from database than
access image from ajax store in mysql using jsp
access image from ajax store in mysql using jsp  access image from ajax store in mysql using jsp (code to access image captured by camera and store in mysql
jsp directory created in net beans but not able to access
jsp directory created in net beans but not able to access  File f = new File (config.getServletContext().getRealPath("/") + "artists/" +username); f.mkdir(); File video = new File (config.getServletContext().getRealPath
Updating Ms Access Database using jsp - JSP-Servlet
Updating Ms Access Database using jsp  Hi I am new to jsp and I am trying to update a record in an access database. I only want to update part of the record because the other columns already have data. When I use Update
to get picture from ms access database by jsp-servlet....
to get picture from ms access database by jsp-servlet....  I have inserted a picture in ms access data base,,,how we can retrieve that picture by using jsp
HTML(Registration form) to Jsp to stored into MS ACCESS database
HTML(Registration form) to Jsp to stored into MS ACCESS database  i am sending one html file that contain 18 fields these are stored in ms-access database by using jsp code.i want to urgent jsp code. please urgent sir. thank
How to pass query as parameter? - JSP-Servlet
How to pass query as parameter?  Hi Friends, I have a real tough... of my problem. Please help me solve this problem. My Problem is: I have 3 query..."; String qry3="select age from table13"; string q=Insert into emp values
how to send emails to many using jsp by connecting to ms access dabase.
how to send emails to many using jsp by connecting to ms access dabase.  Hi. I am trying to send multiple emails and the email ids are stored in a table in a msaccess database.I am using jsp for this.And finally there should
why tomcat is shoutdown when access the jsp page - Development process
why tomcat is shoutdown when access the jsp page  I have a menu.when i click on menutitem(jsp page),some time tomcat is shoutdown and sometimes it is working fine  Hi Friend, Please send your code. Thanks
Query
Query  how can i set path and Classpath or Environmental Variable for jsp/servlet program to compile and run
retrive the data from access database to drop down list box in jsp
retrive the data from access database to drop down list box in jsp  hai, im new to jsp now im using the jsp along with access database.in table i load all the data's i need to retrive the data from database to dropdown list box
How to access Contacts from gmail using LDAP in JSP dropdown list
How to access Contacts from gmail using LDAP in JSP dropdown list  HI, I am creating a JSP page in which i have to make a dropdown box, and access gmail contacts in that drop downlist using LDAP. Can any one plz help me out
how to access element added via javascript dynamically using jsp code
how to access element added via javascript dynamically using jsp code  Urgent..Anyone please Assist how to access data from the elements added via... not able to access these dynamically added textboxes values from my jsp code
query
query  private member of a class can be used in its public function?? if yes tha how?   Yes, you can used the private member of a class in a public function.But private modifier does not allow to access the private
Advertisements
 

 

 

DMCA.com