亚洲在线久爱草,狠狠天天香蕉网,天天搞日日干久草,伊人亚洲日本欧美

為了賬號安全,請及時綁定郵箱和手機立即綁定
已解決430363個問題,去搜搜看,總會有你想問的

java調用返回一個光標的存儲過程出錯?

java調用返回一個光標的存儲過程出錯?

慕神8329975 2016-07-18 11:12:26
為什么我取不出結果,就是控制臺上沒有打印任何東西,也沒有出什么錯。代碼貼上:create or replace package mypackage as????type empcursor is ref cursor;????procedure queryemplist(dno in number,emplist out empcursor);end mypackage;create or replace package body mypackage as????procedure queryemplist(dno in number,emplist out empcursor) asbegin??? open emplist for select * from emp where empno=dno;??? end queryemplist; end mypackage;--------------------------------------------------------------------------------------------public static void main(String[] args) {?? ??? ?Connection conn = null;?? ??? ?CallableStatement call = null;?? ??? ?ResultSet rs = null;?? ??? ?try {?? ??? ??? ?String sql = "{call MYPACKAGE.queryemplist(?,?)}";?? ??? ??? ?conn? = JDBCUtil.getConn();?? ??? ??? ?call = conn.prepareCall(sql);?? ??? ??? ?call.setInt(1, 20);?? ??? ??? ?call.registerOutParameter(2,OracleTypes.CURSOR);?? ??? ??? ?call.execute();?? ??? ??? ?rs = ((OracleCallableStatement)call).getCursor(2);?? ??? ??? ?//rs = (ResultSet) call.getObject(2);?? ??? ??? ?while(rs.next()){?? ??? ??? ??? ?int deptno = rs.getInt("deptno");?? ??? ??? ??? ?String name = rs.getString("ename");?? ??? ??? ??? ?String job = rs.getString("job");?? ??? ??? ??? ?double salary = rs.getDouble("sal");?? ??? ??? ??? ?System.out.println(deptno+"\t"+name+"\t"+job+"\t"+salary);?? ??? ??? ?}?? ??? ?} catch (Exception e) {?? ??? ??? ?e.printStackTrace();?? ??? ?}?? ?}
查看完整描述

目前暫無任何回答

  • 0 回答
  • 0 關注
  • 1489 瀏覽
慕課專欄
更多

添加回答

舉報

0/150
提交
取消
微信客服

購課補貼
聯系客服咨詢優惠詳情

幫助反饋 APP下載

慕課網APP
您的移動學習伙伴

公眾號

掃描二維碼
關注慕課網微信公眾號