Java 调用 MySQL 存储过程并获得返回值详解数据库

 

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(); 

原创文章，作者：ItWorker，如若转载，请注明出处：https://blog.ytso.com/6655.html