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



Home Answers Viewqa JSP-Servlet jsp to access query
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Kunal Thakare
jsp to access query
1 Answer(s)      2 years and 2 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
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
insert query in jsp
insert query in jsp  give me insert code in jsp at run time
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
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
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
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
Advertisements
 

 

 

DMCA.com