Java调用Oracle的存储过程(实例)

/* 存储过程为  * 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();     } }