Java程序中调用存储过程

               /**

               * 该方法用来调用Oracle存储过程

               * @param con 数据库连接

               * @param parameter传入存储过程的参数值

               * @throws SQLException SQL 异常

               */

              public void execute(Connection con,String sp_name, String parameter) throws SQLException{

 

                       //调用存储过程

                       CallableStatement callStat=con.prepareCall("{call "+sp_name+"(?,?,?)}");                        

                       //最后一次插入的行数

                       int last_inserted_rows=0;

                       //总影响行数

                       int all_effected_rows=0;

                       //设置输入参数值

                       callStat.setString(1, parameter);

                       //注册存储过程的第二、第三个参数类型

                       callStat.registerOutParameter(2, OracleTypes.NUMBER);

                       callStat.registerOutParameter(3, OracleTypes.NUMBER);

                       //执行存储过程

                       callStat.execute();

                       //从存储过程执行结果中获得第二、第三个参数值

                       last_inserted_rows=callStat.getInt(2);

                       all_effected_rows=callStat.getInt(3);

                       //关闭CallableStatement，释放资源

                       callStat.close();

   例子:

    Connection conn = ds.getConnection();
    CallableStatement cstmt = conn.prepareCall("call InsertXMLContact(?,?)");
    cstmt.setString(2, myContact.toXMLString());
    cstmt.registerOutParameter(1, Types.INTEGER);
    cstmt.execute();
    idNum = cstmt.getInt(1);
    cstmt.close();
    conn.close();