very right!!
here is my code for updation..
there is a browse page..which has links at the end of each record..to modify..
like <a href="modify_teaching_load.jsp"?selected_Id="<%=ob.getLoad_id()%>" >Modify</a>
load_id is the identity column of my table..
and in modify page the code is like this:
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc
dbc:mech_iit");
stmt=con.createStatement();
String selected_Id="";
semester=request.getParameter("semester");
course=request.getParameter("course");
course_no=request.getParameter("course_no");
course_title=request.getParameter("course_title");
selected_Id=request.getParameter("selected_Id");
if(request.getParameter("Update")!=null)// if this page is called after hiting submit button.
{
stmt.executeUpdate("update teaching_load set semester='"+semester+"',course='"+course+"',course_no='"+course_no+"',course_title='"+course_title+"'");
%>
<jsp:forward page="teaching_load_modified.jsp?RecordCount=5"/>
<%
}
//this part will be executed..if this page is not called after hiting submit.
out.println("select semester, course, course_no, course_title from teaching_load where load_id in("+selected_Id+") ");
rs=stmt.executeQuery("select semester, course, course_no, course_title from teaching_load where load_id in("+selected_Id+") ");
if(rs.next())
{
semester=rs.getString("semester");
course=rs.getString("course");
course_no=rs.getString("course_no");
course_title=rs.getString("course_title");
}
}
catch(Exception ie)
{
System.out.println("ie");
}
%>
bt on the next page..all the values are gettign displayed as null..