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="post" action="csea.jsp">
<table border="1">
<tr><th>Reg No</th><th>Name</th><th>Present/Absent</th></tr>
<%
      String pa = request.getParameter("pa");
      try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection con = DriverManager.getConnection("jdbc:odbc:Studentwt");
      Statement st = con.createStatement();
      ResultSet rs = st.executeQuery("select * from csea");
      while (rs.next()) {
%>
<tr><th><%=rs.getString("reg_no")%></th><th><%=rs.getString("s_name")%></th>
     <th><input type="text" name="pa"/></th>
</tr>
<%
       }
       st.executeQuery("update csea  set pa='"+pa+"'");
       con.close();
       st.close();
       rs.close();
    } catch (Exception e) {
 }%>
</table>
<input type="submit" name="submit" value="SUBMIT"/>
</form>
</body>
</html>

View Answers

Advertisements

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

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

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

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

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

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

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

linking jsp with database using classes and methods and then access them all in to my jsp page - JSP-Servlet
linking jsp with database using classes and methods and then access them all in to my jsp page how to connect jsp page with mysql using classes... all with the help of java beans in u'r own jsp page

How can I access databse through JSP. I am using postgresql-8.4.4-1-windows as database and jboss-4.0.5.GA as server.
How can I access databse through JSP. I am using postgresql-8.4.4-1-windows as database and jboss-4.0.5.GA as server. I am using postgresql-8.4.4-1-windows as database, jboss-4.0.5.GA as server and jdk-6-windows-i586 with IDE

How to insert or delete records in MS access database using jsp - JSP-Servlet
How to insert or delete records in MS access database using jsp Hi friends please provide me a solution that i insert or delete record from a database using java server pages. I used the microsoft access 2003 database. PlZ

insert code jsp to access
insert code jsp to access insert code jsp to access

how to retrieve the id value itself from the access database to drop down listbox in jsp
how to retrieve the id value itself from the access database to drop down listbox in jsp how to retrieves the id which is an int datatype, from access database to drop down list box in jsp...plz send the code for that.....plz

Connect database in Access to Netbean?
Connect database in Access to Netbean? how to connect database in micrsoft access to Netbean?i know it can be connected by using JDBC-ODBC bridge, can i know the steps in connecting the database? Is there any source code

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

ACCESS DATABASE FROM HTML
ACCESS DATABASE FROM HTML I want to access sql 2008 database in html page without help of ADODB connection.. because if access through ADODB means there is a security problem. so, Access database in html page(client side

how i conditional access the data from database using combo box. - JSP-Servlet
access the data from database when i select class 11 0r 12. Here is JSP file...how i conditional access the data from database using combo box. i have combox box named class when i select its value 11 or 12, another combo box

Access 2007 database connectivity
Access 2007 database connectivity i design an application form... source and destination. pls tell me the code of connectivity with access 2007 database using JComboBox.thanks

how to retreive values from MS Access Database based on the values entered in textbox values in jsp file
how to retreive values from MS Access Database based on the values entered... in MS Access Database. the table structure is Sno JobName ProgramName Problem... Solution field from database and display in the textbox of the jsp. 1

link hibernate to MS ACCESS database
link hibernate to MS ACCESS database how to link hibernate to ms access database instead of sql database

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

jsp database
jsp database I want to retrive value in my jsp page but i dont want show my database query in my jsp page. is there any other method to show value in my jsp page using java class

connecting to access database
Add a user DSN Select Microsoft Access Driver(*.mdb) Select database name...connecting to access database print("code sample");Hi I Write java... this there is no error but my data is not going to my Acess Database. There is working

how to access database in applet
how to access database in applet HI... I'm having an applet where we should display the database values in the applet... It works fine in the local system(same network)... but when its in the server, we r getting null values

Video Tutorial: How to access MySQL database from JSP?
How to access MySQL database from JSP? In this tutorial,I will teach you how to access data from JSP page. We are using MySQL database and we have a table... the project - dynamic web project - JSP access database. Click next

Access all the fields from table through JSP
Access all the fields from table through JSP... dirctory of welcome_to_database_query.jsp. Click on the link given in the first jsp... to connect java application with MySql database and execute query to display

Applet database access - Applet
Applet database access HI... I'm having an applet where we should display the database values in the applet... It works fine in the local system... but when its in the server, we r getting null values in the local system.. I

MS Access - JSP-Servlet
stepts 1.to configure the ms access database to your system control panel...MS Access hello sir, i want to use MS.Access as my database..so my problem is how to connect MS Acces database with servlets ... thank you

how to access the MS ACCESS database with java
how to access the MS ACCESS database with java how to access the MS ACCESS database with java how can we insert,delete,update,search records of ms access with java Java MS Access database connectivity Follow

The JDBC API to access a desktop database like Microsoft Access over the network.
The JDBC API to access a desktop database like Microsoft Access over the network. How can I use the JDBC API to access a desktop database like Microsoft Access over the network

how to access the MS ACCESS database with java - Java Beginners
how to access the MS ACCESS database with java how can we insert,delete,update,search records of ms access with java

Migrating sql database to Access through coding
Migrating sql database to Access through coding How can i migrate SQL database(table) to My access through coding

connect to the database from JSP
connect to the database from JSP How do you connect to the database from JSP? A Connection to a database can be established from a jsp page by writing the code to establish a connection using a jsp scriptlets

jfreechart display from access database data.
jfreechart display from access database data. I have made a database... to retrieve the data from the access database using prepared statement and then display... is to be done in a servlet.. Note that it is a access made database. How can I

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

How to access (MySQL)database from J2ME?
How to access (MySQL)database from J2ME? I am new to J2ME. I am using NetBeans. Can anyone help me? How to access (MySQL)database from J2ME? ( I search a lot I found that there is need to access database through servlet

connec to database - JSP-Servlet
connec to database Need code to connect the application to database. I have developed the application JSP and Servlet

updating an access database with visual basic 2010
updating an access database with visual basic 2010 I am building a program in visual basic 2010 that connects to an access database. I... the information is entered I need it to update the information in access

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 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

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

upload to database - JSP-Servlet
to upload a pdf file into database(sqlserver2000) using jsp. In roseindia some examples... into database whenever i want that uploaded pdf file i have to retrieve it from database please help me friends thanks in advance it is very urgent

Remote desktop access - JSP-Servlet
reply me Thank a lots in advance I forgot to say i am using jsp

JSP Database Example
This example shows you how to develop JSP that connects to the database and retrieves the data from database. The retrieved data is displayed on the browser. Read Example JSP Database Example Thanks

jfreechart displaying chart from access database
jfreechart displaying chart from access database I have these 2 codes. array.java----in which i retrieve the values from the database . import... javax.servlet.http.HttpServletResponse; /** * * @author AARUSHI */ class database { int roll; String

How To Connect MS ACCESS 2003 Database in C Program with Graphics.
How To Connect MS ACCESS 2003 Database in C Program with Graphics. How To Connect MS ACCESS 2003 Database in C Program with Graphics

display data from a table in Access Database in a HTML page
display data from a table in Access Database in a HTML page how to display data from a table in Access Database in a HTML page in a Java Program

connection with database - JSP-Servlet
and the connection with the database using jsp code, I get exceptions that I have... with java code. Is there any other way to establish a connection with database in jsp... with the database by writing the program in java. Following is the code: import

JSP and Database access

Questions by Category