...
   T1Rec t1r =  null ;
   ArrayList list =  new  ArrayList();
   Connection connection =  null ;
    try  {
         connection = getConnection();
         PreparedStatement ps = сonnection.prepareStatement("SELECT * FROM TABLE1 WHERE T1_ID=?");
         ps.setInt( 1 ,_id);
         ResultSet rs = ps.executeQuery();
          while  (rs.next()) {
                                 t1r=load(rs);
               		list.add(t1r);
		}
          return  list;
   }  finally  {
	close(connection);
   } 
...
 private   static  T1Rec load(ResultSet rs)  throws  SQLException {
   T1Rec t1r  =  new  T1Rec();
   t1r.id        = rs.getInt("T1_ID");
   t1r.pnsdist = rs.getByte("DIST");
   t1r.insnum  = rs.getInt("INSNUM");
   t1r.cntnum = rs.getByte("CNTNUM");
   t1r.fam      = rs.getString("FAM");
   t1r.nam     = rs.getString("NAM");
   t1r.ptr       = rs.getString("PTR");
   ...
    return  pnr;
}
...

   PreparedStatement ps = сonnection.prepareStatement("SELECT p.*,t.* FROM TABLE1 p, TABLE2 t WHERE p.T1ID=t.T1ID");
   ResultSet rs = ps.executeQuery();

   ArrayList list =  new  ArrayList();
         ...
          while  (rs.next()) {
                                 Object [] cols= new  Object[rs.colcount];
                                  for (i= 0 ;i<rs.colcount;i++) cols[i]=rs.getObject(i);
               		list.add(cols);
		}
         ...