| 注册
请输入搜索内容

热门搜索

Java Linux MySQL PHP JavaScript Hibernate jQuery Nginx
eb5y
10年前发布

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