Question

oracle 返回一条记录时，java端怎么取得？

--数据库端的包体
create or replace package body pkg_student is
function fun_student_all return stu_cur_type
is
stu_cur stu_cur_type;
begin
open stu_cur for select * from student;
return stu_cur;
end;
procedure pro_update_student(student_id_in in student.student_id%type,student_row_out out student%rowtype)
is
begin
update student set student.student_age = student.student_age+10
where student.student_id = student_id_in returning student_age,student_id,student_name into student_row_out;
end;
end pkg_student;

--java端的调用

package com.cctv.oracle;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.SQLException;

import oracle.jdbc.OracleTypes;

public class OracleTest_3 {

public static void main(String[] args) {
Connection conn = DBUtil.getConnection();
CallableStatement call = null;
try {
call = conn.prepareCall("call pkg_student.pro_update_student(?,?)");
call.setInt(1, 10000);
// ↓ 这行语句该怎么写？ 这是接收返回值为游标类型的
call.registerOutParameter(2, OracleTypes.CURSOR);
call.execute();
} catch (SQLException e) {
e.printStackTrace();
}

}

}

Answer 1

call.execute();
i = call.getString(1);
这样就可以了。。。
当然你代码里一定要写finally，用于做if(call!= null)call.close()

你给的包里方法是做update的吧？select才有结果集，update是返回整数表示成功更新了N行的

Answer 2

call.execute();
i = call.getString(1);