jdbc之调用procedure运用实例:
package jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
public class CallableStatement {
/**
* @Title: main
* @Description:
* @param:
* @return void
* @user: wangzg
* @Date:2014-7-1
* @throws
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection conn = null;
java.sql.CallableStatement cstm = null;
ResultSet rs = null;
try {
conn = getConnection();
cstm = conn.prepareCall("{call Test_procedure(?,?,?,?)}");
//输入参数
cstm.setInt(1, 12);
//输出参数
cstm.registerOutParameter(2, oracle.jdbc.driver.OracleTypes.NUMBER);
//输出参数游标(结果集)
cstm.registerOutParameter(3, oracle.jdbc.driver.OracleTypes.CURSOR);
//输入输出参数
cstm.setInt(4, 10