具有ResultSet和OutPut参数的Spring JDBCTemplate存储过程 [英] Spring JDBCTemplate Stored Procedure with ResultSet and OutPut Parameter

问题描述

我创建了一个存储过程，该过程返回结果行和两个输出参数. 我在春季找不到任何可以得到ResultSet和outPutParameters的东西. 我想实现类似 使用Spring框架此.

I created a stored procedure which returns result rows and two output parameters. I am unable to find any thing in spring from which i can get ResultSet and outPutParameters. I want to achieve something like this using Spring framework.

推荐答案

我们在代码中使用了以下内容

We use something like the following in our code

public Map<String, Object> findData() {
        List prmtrsList = new ArrayList();
        prmtrsList.add(new SqlParameter(Types.VARCHAR));
        prmtrsList.add(new SqlParameter(Types.VARCHAR));
        prmtrsList.add(new SqlOutParameter("result", Types.VARCHAR));

        Map<String, Object> resultData = jdbcTemplate.call(connection -> {
            CallableStatement callableStatement = connection.prepareCall("{call STORED_PROC(?, ?, ?)}");
            callableStatement.setString(1, "first");
            callableStatement.setString(2, "last");
            callableStatement.registerOutParameter(3, Types.VARCHAR);
            return callableStatement;
        }, prmtrsList);
        return resultData;
    }

这篇关于具有ResultSet和OutPut参数的Spring JDBCTemplate存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！