使用CallableStatement处理Oracle数据库的存储过程

使用CallableStatement处理Oracle数据库的存储过程:
1.预处理SQL语句；
2.使用registerOutParameter方法注册变量数据类型；
3.为每一个“？”赋值；
4.执行操作。


实例：
TestProc.java:

01.importjava.sql.*;

02.

03.publicclassTestProc{

04.

05.publicstaticvoidmain(String[]args){

06.Connectionconn=null;

07.CallableStatementcstmt=null;

08.try{

09.Class.forName("oracle.jdbc.driver.OracleDriver");

10.conn=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:mgc","system","admin");

11.Stringsql="{call my_pro_name(?,?,?,?)}";

12.cstmt=conn.prepareCall(sql);

13.cstmt.registerOutParameter(3,Types.INTEGER);

14.cstmt.registerOutParameter(4,Types.INTEGER);

15.cstmt.setInt(1,6);

16.cstmt.setInt(2,4);

17.cstmt.setInt(4,0);

18.cstmt.execute();

19.System.out.println(cstmt.getInt(3));

20.System.out.println(cstmt.getInt(4));

21.}catch(ClassNotFoundExceptione){

22.e.printStackTrace();

23.}catch(SQLExceptione){

24.e.printStackTrace();

25.}finally{

26.try{

27.if(cstmt!=null){

28.cstmt.close();

29.cstmt=null;

30.}

31.if(conn!=null){

32.conn.close();

33.conn=null;

34.}

35.}catch(SQLExceptione){

36.e.printStackTrace();

37.}

38.}

39.}

40.

41.}

proc.sql:

01.createorreplaceproceduremy_pro_name

02.(v_ainnumber,v_bnumber,v_retoutnumber,v_tmpinoutnumber)

03.is

04.begin

05.if(v_a>v_b)then

06.v_ret:=v_a;

07.else

08.v_ret:=v_b;

09.endif;

10.v_tmp:=v_tmp+1;

11.end;

12./