如何在春季使用SimpleJDBCCall获得存储过程的多表结果? [英] How to get multi table results of an stored procedure using SimpleJDBCCall in spring?

问题描述

我正在实现Spring + MSSQL Server 2008应用程序. 我使用SimpleJDBCCall API执行存储过程并检索结果.

I'm implementing a Spring+ MSSQL Server 2008 application. I use SimpleJDBCCall API to execute stored procedures and retrieve results.

对于具有单表结果的存储过程，它可以正常工作，但是我不知道如何 将其用于具有多表结果的过程.

For stored procedures with mono table results, it works fine, but I don't know how to use it for procedures with multi table results.

示例程序正文:

多表结果

    SELECT * FROM TABLE1
    SELECT * FROM TABLE2

推荐答案

我最无知，它确实有效！您可以指定两个结果集，每个结果集都有自己的映射器. 在代码中看起来像这样:

I was most ignorant, it does in fact work! You can specify both resultsets, with each its own mapper. In code it looks like this:

SimpleJdbcCall call = new SimpleJdbcCall(this.jdbc)
           .withProcedureName("get_users3")
           .returningResultSet("rs1", new ParameterizedRowMapper<Object[]>()
           {
              @Override
              public Object[] mapRow(ResultSet rs, int rowNum) throws SQLException
              {
                 return new Object[] { rowNum, rs.getInt(1), rs.getString(2) };
              }
           })
           .returningResultSet("rs2", new ParameterizedRowMapper<Object[]>()
           {
              @Override
              public Object[] mapRow(ResultSet rs, int rowNum) throws SQLException
              {
                 return new Object[] { rowNum, rs.getInt(1), rs.getString(2) };
              }
           });

  Map<String, Object> res = call.execute();
  assertNotNull(res.get("rs1"));
  assertNotNull(res.get("rs2"));
  List<Object[]> l1 = (List<Object[]>)res.get("rs1");
  List<Object[]> l2 = (List<Object[]>)res.get("rs2");

这篇关于如何在春季使用SimpleJDBCCall获得存储过程的多表结果?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！