假设我有多个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
发布评论