如何在java中对另一个select查询的ResultSet执行选择查询

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class SelectQueryExample {
    public static void main(String[] args) {
        // 假设已经建立了数据库连接
        Connection connection = null;
        Statement statement = null;
        ResultSet resultSet1 = null;
        ResultSet resultSet2 = null;

        try {
            // 创建连接
            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");

            // 创建Statement对象
            statement = connection.createStatement();

            // 执行第一个select查询
            resultSet1 = statement.executeQuery("SELECT * FROM table1");

            // 执行第二个select查询
            resultSet2 = statement.executeQuery("SELECT * FROM table2");

            // 对第二个查询结果进行选择查询
            while (resultSet2.next()) {
                // 获取需要的字段值
                int id = resultSet2.getInt("id");
                String name = resultSet2.getString("name");

                // 根据需要的条件进行筛选
                if (id > 100 && name.startsWith("A")) {
                    // 输出满足条件的结果
                    System.out.println("ID: " + id + ", Name: " + name);
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            // 关闭ResultSet、Statement和Connection
            try {
                if (resultSet1 != null) {
                    resultSet1.close();
                }
                if (resultSet2 != null) {
                    resultSet2.close();
                }
                if (statement != null) {
                    statement.close();
                }
                if (connection != null) {
                    connection.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}