存储过程在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); } } }