在Java中将多个ResultSet合并为单个ResultSet [英] Merging Multiple ResultSet into Single ResultSet in Java

问题描述

假设我有多个ResultSet（每个resultSet将引用数据库中的1行）（它们是相同的表）。现在我想创建整合的ResultSet，其中intern将具有所有其他resultSet。所以我的主要目标是创建一个组合的ResultSet，它指向之前由单个resultSet指向的所有行。

Let say I have multiple ResultSet(each resultSet would refer to 1 row in database) (they are of same table.) . Now I want to create consolidated ResultSet which would intern have all other resultSet. So my primary goal is to create a combined ResultSet which would point to all rows which where previously pointed by individual resultSet.

我使用Java。任何人都知道我们可以如何务实地实现这一点？

I am using Java. Do any one know how pragmatically we can achieve this?

编辑：我们使用 java.sql.ResultSet 。

编辑：让它更清楚：

假设我有

List<ResultSet> someResults ; // each resultSet Would point to a single row in database.

我想创建一个合并的 ResultSet finalResults;

psudo代码：

List<ResultSet> resultSets = // poppulated from code
ResultSet rs  = convert(resultSets) // psude conver method

推荐答案

如果你正在谈论一个java.sql.ResultSet，它是不可能的，据我所知。建议您改为更改查询。

If you are talking about a java.sql.ResultSet, it's not possible as far as I know. I suggest you change your query instead.

或者，您可以将结果检索为java对象，然后将所有对象合并到集合中。

Or you can retrieve the results into an java object and then combine all the objects into a Collection.

这篇关于在Java中将多个ResultSet合并为单个ResultSet的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！