在返回多行的jdbc模板中调用存储的proc

JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

String procedureName = "your_procedure_name";
String sql = "{call " + procedureName + "(?, ?)}";

CallableStatementCreator csc = con -> {
    CallableStatement cs = con.prepareCall(sql);
    cs.setString(1, param1); // 设置存储过程的参数
    cs.setInt(2, param2);
    return cs;
};

List<ResultObject> results = jdbcTemplate.execute(csc, (CallableStatementCallback<List<ResultObject>>) cs -> {
    List<ResultObject> resultList = new ArrayList<>();
    boolean hasResults = cs.execute();
    while (hasResults) {
        ResultSet rs = cs.getResultSet();
        while (rs.next()) {
            ResultObject result = new ResultObject();
            // 解析结果集并设置到ResultObject对象中
            result.setField1(rs.getString("field1"));
            result.setField2(rs.getInt("field2"));
            // ...
            resultList.add(result);
        }
        hasResults = cs.getMoreResults();
    }
    return resultList;
});