package?demo.utils;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;


public?class?JDBCUtils?{
	private?static?String?driver?=?"oracle.jdbc.OracleDriver";
	private?static?String?url?=?"jdbc:oracle:thin:@localhost:zhang0519";
	private?static?String?user?=?"scott";
	private?static?String?password?=?"tiger";
	
	//注冊數據庫驅動
	static{

		try?{
			Class.forName(driver);
		}?catch?(ClassNotFoundException?e)?{
			throw?new?ExceptionInInitializerError(e);
		}
	}
	
	//獲取數據庫連接
	public?static?Connection?getConnection(){
		try?{
			return?DriverManager.getConnection(url,user,password);
		}?catch?(SQLException?e)?{
			e.printStackTrace();
		}
		return?null;
	}
	
	//釋放數據庫的資源
	public?static?void?release(Connection?conn,Statement?st,ResultSet?rs){
		if(rs?!=?null){
			try?{
				rs.close();
			}?catch?(SQLException?e)?{
				e.printStackTrace();
			}finally{
				rs?=?null;
			}
			
		}
		
		if(st?!=?null){
			try?{
				st.close();
			}?catch?(SQLException?e)?{
				e.printStackTrace();
			}finally{
				st?=?null;
			}
		}
		
		if(conn?!=?null){
			try?{
				conn.close();
			}?catch?(SQLException?e)?{
				e.printStackTrace();
			}finally{
				conn?=?null;
			}
		}
	}
	
}

package?demo.oracle;

import?java.sql.CallableStatement;
import?java.sql.Connection;

import?org.junit.Test;

import?demo.utils.JDBCUtils;
import?oracle.jdbc.driver.OracleTypes;

public?class?TestProcedure?{

	@Test
	public?void?testProcedure(){
		String?sql?=?"{call?queryempinf(?,?,?,?)}";
		Connection?conn?=?null;
		CallableStatement?call?=?null;
		try?{
			//得到一個連接
			conn?=?JDBCUtils.getConnection();
			
			//通過連接創建Statement
			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.getNString(2);
			double?sal?=?call.getDouble(3);
			String?job?=?call.getNString(4);
			System.out.println(name+"\t"+sal+"\t"+job);
		}?catch?(Exception?e)?{
			e.printStackTrace();
		}finally{
			JDBCUtils.release(conn,?call,?null);
		}
		
	}
}