连接数据库 同一Statement多次调用相关问题

        

         stmt = oaConn.createStatement();

         rs = stmt.executeQuery(sql);        
         while(rs.next()){
            System.out.println(rs.getString(1));

//          无法执行更新         
//          String sqlupd = "update  uf_zbyx set barcode = 11 where id = 161";
//          stmt.executeUpdate(sqlupd);

                                                
//          会导致rs不会继续循环
//          String sqlsel = "select id from uf_zbyx t where t.barcode='12'";           
//          rs1 = stmt.executeQuery(sqlsel);
//          while(rs1.next()){
//              System.out.println(rs1.getString(1));
//          }

         }