ResultSet rs = stmt.executeQuery();
stmt.execute();  ResultSet rs = stmt.getResultSet();
    public void testRun_emp_cs() throws Exception {        //        // Insert and select with callable statement        // 		         CallableStatement cstmt = connection.prepareCall(EXECUTE_PROCEDURE_EMP_INSERT);        try {          cstmt.setInt(1, 44);          cstmt.setString(2, "DGPII");          cstmt.setString(3, "Smith");          cstmt.setString(4, "Automap");          cstmt.execute();          cstmt.setInt(1, 44);          cstmt.setString(2, "VBASE");          cstmt.setString(3, "Jenner");          cstmt.setString(4, "Video Database");          cstmt.execute();          cstmt.setInt(1, 44);          cstmt.setString(2, "HWRII");          cstmt.setString(3, "Stevens");          cstmt.setString(4, "Translator upgrade");          cstmt.execute();			           cstmt.setInt(1, 22);          cstmt.setString(2, "OTHER");          cstmt.setString(3, "Smith");          cstmt.setString(4, "Automap");          cstmt.execute();        } finally {          cstmt.close();        }                cstmt = connection.prepareCall(EXECUTE_PROCEDURE_EMP_SELECT);        try {          cstmt.setInt(1, 44);          ResultSet rs = cstmt.executeQuery();          assertTrue("Should have three rows", rs.next());			 assertTrue("First row value must be DGPII", rs.getString(1).equals("DGPII"));          assertTrue("Should have three rows", !rs.next());			           cstmt.setInt(1, 22);			           rs = cstmt.executeQuery();          assertTrue("Should have one row", rs.next());			 assertTrue("First row value must be OTHER", rs.getString(1).equals("OTHER"));          assertTrue("Should have one row", !rs.next());			           rs.close();        } finally {          cstmt.close();        }        cstmt = connection.prepareCall(EXECUTE_PROCEDURE_EMP_SELECT);        try {          cstmt.setInt(1, 44);          cstmt.execute();			 assertTrue("First row value must be DGPII", cstmt.getString(1).equals("DGPII"));          cstmt.setInt(1, 22);			           cstmt.execute();			 assertTrue("First row value must be OTHER, is " +                      cstmt.getString(1), cstmt.getString(1).equals("OTHER"));			         } finally {          cstmt.close();        }		          PreparedStatement stmt = connection.prepareStatement(SELECT_PROCEDURE_EMP_SELECT);        try {          stmt.setInt(1, 44);          ResultSet rs = stmt.executeQuery();          assertTrue("Should have three rows", rs.next());			 assertTrue("First row value must be DGPII", rs.getString(1).equals("DGPII"));          assertTrue("Should have three rows", rs.next());			 assertTrue("Second row value must be HWRII", rs.getString(1).equals("HWRII"));          assertTrue("Should have three rows", rs.next());			 assertTrue("First row value must be VBASE", rs.getString(1).equals("VBASE"));          assertTrue("Should have three rows", !rs.next());			           stmt.setInt(1, 22);          rs = stmt.executeQuery();          assertTrue("Should have one row", rs.next());			 assertTrue("First row value must be OTHER", rs.getString(1).equals("OTHER"));          assertTrue("Should have one row", !rs.next());          rs.close();        } finally {          stmt.close();        }    }