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);