[Oracle]JDBCTemplate調用Oracle預存程序樣本

[Oracle]JDBCTemplate調用Oracle預存程序樣本

this.getJdbcTemplate().execute(
    new CallableStatementCreator() {
        public CallableStatement createCallableStatement(Connection con) throws SQLException {
        String storedProc = "{call updatetractractcode(?, ?)}";// 調用的預存程序
        CallableStatement cs = con.prepareCall(storedProc);
        cs.setInt(1, contractId);// 設定輸入參數的值
        cs.registerOutParameter(2, java.sql.Types.INTEGER);// 註冊輸出參數的類型
        return cs;
        }
    }, new CallableStatementCallback() {
        public Object doInCallableStatement(CallableStatement cs) throws SQLException, DataAccessException {
        cs.execute();
        return cs.getString(2);// 擷取輸出參數的值
    }
});