Call stored procedure in Java and get the result set : Java : Procedure Function MySQL TUTORIALS

MySQL TUTORIALS » Procedure Function » Java »

Call stored procedure in Java and get the result set


private void empsInDept(Connection myConnect, int deptId) throws SQLException {
          
          CallableStatement cStmt = myConnect.prepareCall("{CALL sp_emps_in_dept(?)}");
          cStmt.setInt(1, deptId);
          cStmt.execute();
          ResultSet rs1 = cStmt.getResultSet();
          while (rs1.next()) {
               System.out.println(rs1.getString("department_name") + " "
                         + rs1.getString("location"));
          }
          rs1.close();

          /* process second result set */
          if (cStmt.getMoreResults()) {
               ResultSet rs2 = cStmt.getResultSet();
               while (rs2.next()) {
                    System.out.println(rs2.getInt(1) + " " + rs2.getString(2) + " "
                              + rs2.getString(3));
               }
               rs2.close();
          }
          cStmt.close();
     }