java中 resultset,在Java中将多个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.

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

Edit : we are using java.sql.ResultSet.

Edit : To make it more clear :

Let say I have

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

I want to create a consolidated ResultSet finalResults;

psudo code :

List resultSets = // poppulated from code

ResultSet rs = convert(resultSets) // psude conver method

解决方案

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.

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