import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.Types;
/*
 * CallableStatement
 * --------------------
 * 1) {call 프로시저명}
 * 2) {call 프로시저명(?, ?, ...) }
 * 3) {?=call 프로시저명(?, ?, ...) }
 */
public class DbTest5 {
	public static void main(String[] args) {
		Connection con = null;
		CallableStatement stmt = null;

		try{
			Class.forName("oracle.jdbc.OracleDriver");
			con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "1111");

			stmt = con.prepareCall("{call usp_search(?,?,?)}");
			stmt.setString(1, "SCOTT");
			stmt.registerOutParameter(2, Types.VARCHAR);
			stmt.registerOutParameter(3, Types.NUMERIC);
			stmt.executeQuery();

			System.out.println("부서명 : " + stmt.getString(2));
			System.out.println("급여 : " + stmt.getInt(3));
		}
		catch(Exception err){
			err.printStackTrace();
		}
		finally{
			try{
				if(stmt!=null) stmt.close();
				if(con!=null) con.close();
			}
			catch(Exception err){}
		}
	}
}