快速学习Oracle-Java 程序调用存储过程

String driver="oracle.jdbc.OracleDriver";
String url="jdbc:oracle:thin:@192.168.56.10:1521:orcl";
String username="scott";
String password="tiger";

--统计年薪的过程
create or replace procedure proc_countyearsal(eno in number,esal
out number)
as
begin
 select sal*12+nvl(comm,0) into esal from emp where empno=eno;
end;
--调用
declare
 esal number;
begin
 proc_countyearsal(7839,esal);
 dbms_output.put_line(esal);
end;

    @Test
    public void testProcedure01(){
        String driver="oracle.jdbc.OracleDriver";
        String url="jdbc:oracle:thin:@192.168.56.10:1521:orcl";
        String username="scott";
        String password="tiger";
        try {
            Class.forName(driver);
            Connection con = DriverManager.getConnection(url,
                    username, password);
            CallableStatement callSt = con.prepareCall("{call 
                    proc_countyearsal(?,?)}");
        callSt.setInt(1, 7839);
        callSt.registerOutParameter(2, OracleTypes.NUMBER);
        callSt.execute();
        System.out.println(callSt.getObject(2));
        } catch (Exception e) {
            e.printStackTrace();
        } 
    }