存储过程在Java中的使用

存储过程的创建参考 存储过程的演示
关键代码如下：

import java.sql.CallableStatement;import java.sql.Connection;import java.sql.SQLException;import oracle.jdbc.OracleTypes;import util.JDBCUtil;public class Test1 {//CREATE OR REPLACE procedure queryemp// (eno in number,pename out varchar2,psal out varchar2,pjob out varchar2)    //  {call <procedure-name>[(<arg1>,<arg2>, ...)]}    public static void main(String[] args) {        Connection conn = null;        System.out.println("连接成功");        String sql = "{call queryemp(?,?,?,?)}";                CallableStatement call = null;        try {            conn = JDBCUtil.getConnection();            call = conn.prepareCall(sql);            //为In 参数赋值            call.setInt(1, 7839);            //为out参数声明类型            call.registerOutParameter(2, OracleTypes.VARCHAR);            call.registerOutParameter(3, OracleTypes.NUMBER);            call.registerOutParameter(4, OracleTypes.VARCHAR);            call.execute();            String name = call.getString(2);            String job = call.getString(4);            int sal = call.getInt(3);            System.out.println(name + ": " + job + " " + sal);        } catch (SQLException e) {            e.printStackTrace();        }finally{            JDBCUtil.release(conn, call, null);        }    }}