Java代码获取oracle存储过程返回值
下面以student表为例
1、创建表student
create table student(
id number,
name varchar2,
age number,
sex varchar2
)
2、创建存储过程:以id为条件查询student表信息
create or replace procedure stu_models
(
v_id student.id%type,
v_mycur out sys_refcursor
)
is
begin
open v_mycur for select * from student where id=v_id;
end;
解释:%type --》属性类型,sys_refcursor --》系统游标(oracle中的存储过程用来传递参数都是sys_refcursor)
3、下面为Java代码
实体类:
package cn.itcast.entity;
public class Student {
private Integer id;
private String name;
private Integer age;
private String sex;
public Integer getId() {
return id;
}
public void setId(Integer id) {