jdbc之调用procedure运用实例

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