Java & Jsp 이중 while문

이중 while문

InitialContext context = null;
DataSource ds = null;
Connection conn = null;
Connection conn1 = null;
ResultSet rs = null;
ResultSet rs1 = null;
PreparedStatement prep = null;
PreparedStatement prep1 = null;

context = new InitialContext();
ds = (DataSource) context.lookup("test"); 
conn = ds.getConnection();
conn1 = ds.getConnection();

try
{
 prep = conn.prepareStatement(sql);
 rs = prep.executeQuery();

 while(rs.next())
 {
  prep1 = conn1.prepareStatement(sql2);
  rs1 = prep1.executeQuery();

  while(rs1.next())
   {

   }
  rs1.close();
  prep1.close();
  conn1.close();
  }
 }
}
catch(Exception e)
{
System.out.println("list ::"+e);
e.printStackTrace();

if(rs != null) {rs.close(); rs = null;}
if(prep != null) {prep.close(); prep = null;}
if(conn != null) {conn.close(); conn = null;}
if(conn1 != null) {conn1.close(); conn1 = null;}
}
finally
{
if(rs != null) {rs.close(); rs = null;}
if(prep != null) {prep.close(); prep = null;}
if(conn != null) {conn.close(); conn = null;}
if(conn1 != null) {conn1.close(); conn1 = null;}
}