Hello people,
I am developing a web application using JSPs. Now I have a problem with a checked boxes. I am able to
put checked boxesin array, but when I want to print it is just printing one record even if I have selected more than one record. My code is below? How can I achieve this?

Code Java:
 
   <% 
String driver ="org.gjt.mm.mysql.Driver";
String url = "jdbc:mysql://localhost:3306/db2";
String username = "root";
String password = "yhhnmm";	
	 String sql =null;	
	 //ResultSet rs =null;					
  try {
    Class.forName(driver);
	 //Connection con = DriverManager.getConnection(url,username,password); 
	  Connection con = DriverManager.getConnection(url,username,password);
 
	  System.out.println(con); 
 
	 System.out.println("got connection"); 
 
  SelectedTrans = request.getParameterValues("SelectedTrans");
    Statement s = con.createStatement(); 
	for (int i = 0; i < SelectedTrans.length; i++) 
     {
 
 
 
   sql = "SELECT number,amount,date,type,year,serial,cuoCod,nber FROM sad_gen2 where number ='"+ SelectedTrans[i] +"'"; 
 
   }
 ResultSet rs = s.executeQuery(sql); 
  while (rs.next()) {
    System.out.println(rs.getString(1) + " " + rs.getString(2)); 
	System.out.println(rs.getString(3) + " " + rs.getString(4));
	System.out.println(rs.getString(5) + " " + rs.getString(6));
	System.out.println(rs.getString(7) + " " + rs.getString(8));
 
String amount =rs.getString(2);
String type =rs.getString(4);
String year = rs.getString(5);
String serial =rs.getString(6);
String cuo_cod =rs.getString(7);
String nber =rs.getString(8);
 
 
 
 
%></p>
                                <table width="96%" border="1" cellspacing="0" cellpadding="0">
                                  <tr>
                                    <td width="12%"><% String valueto=rs.getString(1);
 
									out.println(valueto);  %></td>
                                    <td width="12%"><% String valueto2=rs.getString(2);
 
									out.println(valueto2);  %></td>
                                    <td width="12%"><% String valueto3=rs.getString(3);
 
									out.println(valueto3);  %></td>
                                    <td width="12%"><% String valueto4=rs.getString(4);
 
									out.println(valueto4);  %></td>
                                    <td width="12%"><% String valueto5=rs.getString(5);
 
									out.println(valueto5);  %></td>
                                    <td width="12%"><% String valueto6=rs.getString(6);
 
									out.println(valueto6);  %></td>
                                    <td width="12%"><% String valueto7=rs.getString(7);
 
									out.println(valueto7);  %></td>
                                    <td width="6%"><% String valueto8=rs.getString(8);
 
									out.println(valueto8);  %></td>
                                    <td width="10%"><c:out value="${serviceResult.rcpYear}/${serviceResult.rcpSerial}/${serviceResult.rcpNber}"/></td>
                                  </tr>
                              </table>                                
      <%
 
 
		} 
 
  rs.close(); 
  s.close(); 
  con.close();   
 
 
  } 
  catch (Exception e) {
    out.println(e.toString()); 
  } 
%>