java调用存储过程

/* 存储过程为
  * CREATE TABLE EmployeeInfo
(ID int,
name varchar2(50))
/
CREATE OR REPLACE PROCEDURE INSERT_PRO
is
BEGIN
     INSERT INTO EmployeeInfo VALUES(8,'asdf');
END;
/

CREATE OR REPLACE PROCEDURE myPro
(
n int,       --传给存储过程的参数 用set赋值
result out int       --存储过程返回的参数
)
is
i int:=0;
sum1 int:=0;
begin
     while i<n
     loop
     sum1:=sum1+1;
     i:=i+1;
     end loop;
     result:=sum1;
end;
  */

import java.sql.*;
import oracle.jdbc.OracleTypes;
import java.sql.CallableStatement;
public class JavaConnOracle {
//    JavaConnOracle() throws Exception {
//        Class.forName("oracle.jdbc.driver.OracleDriver");
//        Connection conn = DriverManager.getConnection(
//                "jdbc:oracle:thin:@localhost:1521:WJDB", "wjorac", "wangjun");
//        String procedure="{call INSERT_PRO}";
     ////无参调用
//        CallableStatement cstmt=conn.prepareCall(procedure);
//        cstmt.executeUpdate();
//    }
     //******************************************888
     JavaConnOracle()throws Exception
     {
         Class.forName("oracle.jdbc.driver.OracleDriver");
         Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:WJDB","wjorac","wangjun");
         String procedure="{call myPro(?,?)}";
         CallableStatement cstmt =conn.prepareCall(procedure);
         cstmt.setInt(1, 5000);   //给第一个参数赋值
         cstmt.registerOutParameter(2,oracle.jdbc.OracleTypes.INTEGER);
         cstmt.execute();
         //取出第二个参数的值.
         System.out.println("bbb  "+cstmt.getInt(2));
     }
     public static void main(String args[])throws Exception {
         new JavaConnOracle();
     }
}