如何使用 Spring 持久化框架调用 Oracle 函数或存储过程?

2021-12-24 00:00:00 spring oracle junit

我正在为我的项目使用 Spring 持久性框架.我想从这个框架调用oracle函数或存储过程.

I am using Spring persistence framework for my project. I want to call oracle function or stored procedure from this framework.

任何人都可以建议我如何实现这一目标.

Can anybody suggest how can I achieve this.

请给出* oracle函数和*存储过程的解决方案.

Please give solution for both * oracle function and *stored procedure.

谢谢.

推荐答案

假设您指的是 JdbcTemplate:

Assuming you are referring to JdbcTemplate:

jdbcTemplate.execute(
    new CallableStatementCreator() {
        public CallableStatement createCallableStatement(Connection con) throws SQLException{
            CallableStatement cs = con.prepareCall("{call MY_STORED_PROCEDURE(?, ?, ?)}");
            cs.setInt(1, ...); // first argument
            cs.setInt(2, ...); // second argument
            cs.setInt(3, ...); // third argument
            return cs;
        }
    },
    new CallableStatementCallback() {
        public Object doInCallableStatement(CallableStatement cs) throws SQLException{
            cs.execute();
            return null; // Whatever is returned here is returned from the jdbcTemplate.execute method
        }
    }
);

调用函数几乎相同:

jdbcTemplate.execute(
    new CallableStatementCreator() {
        public CallableStatement createCallableStatement(Connection con) {
            CallableStatement cs = con.prepareCall("{? = call MY_FUNCTION(?, ?, ?)}");
            cs.registerOutParameter(1, Types.INTEGER); // or whatever type your function returns.
            // Set your arguments
            cs.setInt(2, ...); // first argument
            cs.setInt(3, ...); // second argument
            cs.setInt(4, ...); // third argument
            return cs;
        }
    },
    new CallableStatementCallback {
        public Object doInCallableStatement(CallableStatement cs) {
            cs.execute();
            int result = cs.getInt(1);
            return result; // Whatever is returned here is returned from the jdbcTemplate.execute method
        }
    }
);

相关文章