java调用存储过程

先创建一个存储过程

create or replace function addvalue(value1 in number, value2 in number) return number is
result number;
begin
result:=value1+value2;
return(result);
end ;

下面是java调用
Connection conn = JDBCUtils.getConnection();
CallableStatement cs = conn.prepareCall("{? = call addvalue(?, ?)}");

// register input parameters
cs.setInt(2, 2);
cs.setInt(3, 3);

// regsiter ouput parameters
cs.registerOutParameter(1, Types.INTEGER);

cs.execute();
int outParam = cs.getInt(1);
System.out.println(outParam);