java jdbc oracle步骤_java通过JDBC连接Oracle并调用存储过程和存储方法

importjava.sql.CallableStatement;importjava.sql.Connection;importjava.sql.ResultSet;importoracle.jdbc.OracleCallableStatement;importoracle.jdbc.OracleTypes;importorg.junit.Test;importcn.ht.utils.JDBCUtils;public classTestOracle {/** create or replace procedure queryEmpInformation(eno in number,

pename out varchar2,

psal out number,

pjob out varchar2)*/@Testpublic voidtestProcedure(){//{call [(,, ...)]}

String sql = "{call queryEmpInformation(?,?,?,?)}";

Connection conn= null;

CallableStatement call= null;try{

conn=JDBCUtils.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);double sal = call.getDouble(3);

String job= call.getString(4);

System.out.println(name+"\t"+sal+"\t"+job);

}catch(Exception e) {

e.printStackTrace();

}finally{

JDBCUtils.release(conn, call,null);

}

}/** create or replace function queryEmpIncome(eno in number)

return number*/@Testpublic voidtestFunction(){//{?= call [(,, ...)]}

String sql = "{?=call queryEmpIncome(?)}";

Connection conn= null;

CallableStatement call= null;try{

conn=JDBCUtils.getConnection();

call=conn.prepareCall(sql);

call.registerOutParameter(1, OracleTypes.NUMBER);

call.setInt(2, 7839);//执行

call.execute();//取出年收入

double income = call.getDouble(1);

System.out.println(income);

}catch(Exception e) {

e.printStackTrace();

}finally{

JDBCUtils.release(conn, call,null);

}

}

}