
suppose this if form1.jsp in which i am going to display records from database
out.println("<tr><td>"+"<input type='checkbox' id='r1' value="+r+" name='test' >"+"</td><td>"+r+"</td><td>"+pname+"</td><td>"+add1+"</td><td>"+add2+"</td><td>"+land+"</td><td>"+geon+"</td><td>"+geoe+"</td><td>"+plan+"</td>");
out.println("<td><select name='routecombo'id='routecombo'"+i+"'>");
ResultSet rs1=ps2.executeQuery("select Route_id from table1");
while(rs1.next())
{
s1=rs1.getString(1);
out.println("<option value='"+s1+"'>"+s1+"</option>");
}
out.println("</select>");
out.println("</td>");
out.println("</tr>");
now this is form2.jsp in which i am updating values which is selected from form1.jsp
String languages="";
String box="";
String box1="";
String lang[]=request.getParameterValues("test");
String txt[]=request.getParameterValues("routecombo");
for(k=1;k<=lang.length;k++)
{
System.out.println("k: "+k);
languages+=lang[k-1]+" ";
}
System.out.println("chk="+languages);
int j=0;
for(t=0;t<txt.length;t++){
box+=txt[t];
//box1+=txt1[t];
//System.out.println("txt="+box);
if(!((txt[t]).equals("")))
{
System.out.println("Route ID");
System.out.println(t);
System.out.println(txt[t]);
String query="update PROFILE set Route_Id='"+txt[t]+"' where Proid='"+lang[j]+"'";
System.out.println(query);
i=st.executeUpdate(query);
j++;
}
System.out.println("txt="+box);
//System.out.println("txt1="+box1);
out.println("Data is successfully inserted into database.");
}
catch(Exception e){
e.printStackTrace();
System.out.println(e);
}
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.