java 调用存储过程

create or replace procedure test_0 (fid in integer,reval out integer,reval1 out integer) as

begin
insert into test_1 values(fid);
commit;
reval := 10*fid;
reval1 := 20*fid;
end test_0;

 

public static void main(String[] args) throws Exception{

Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:BIDB","scott","tiger");

CallableStatement cs = con.prepareCall("{call test_0(?,?,?)}");
cs.setInt(1, 100);
cs.registerOutParameter(2, Types.INTEGER );
cs.registerOutParameter(3, Types.INTEGER);
cs.execute();
System.out.println(cs.getInt(2));
System.out.println(cs.getInt(3));
con.close();

}

 

 

 

转载于:https://www.cnblogs.com/hymumu/archive/2012/11/22/2782738.html