本文实例讲述了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(); }
希望本文所述对大家的java程序设计有所帮助。
如对本文有疑问, 点击进行留言回复!!
第三次学JAVA再学不好就吃翔(part88)--ArrayList嵌套ArrayList
使用ffmpeg视频切片并加密和视频AES-128加密后播放
JAVA程序设计:最长重复子串(LeetCode:1044)
LiveGBS国标GB/T28181云端录像分布式录像存储自动清理时移回看录像下载播放
网友评论