获取java.sql.SQLException：ResultSet关闭后不允许进行操作

当我执行以下代码时，出现异常。我认为这是因为我正在与他相同的连接对象编写新语句。我应该如何重写它，以便可以创建准备好的语句并开始使用rs2？即使连接到相同的数据库，我也必须创建一个新的连接对象吗？

try 
{
    //Get some stuff
    String name = "";
    String sql = "SELECT `name` FROM `user` WHERE `id` = " + userId + " LIMIT 1;";
    ResultSet rs = statement.executeQuery(sql);
    if(rs.next())
    {
        name = rs.getString("name");
    }

    String sql2 = "SELECT `id` FROM  `profiles` WHERE `id` =" + profId + ";";
    ResultSet rs2 = statement.executeQuery(sql2);
    String updateSql = "INSERT INTO `blah`............"; 
    PreparedStatement pst = (PreparedStatement)connection.prepareStatement(updateSql);    

    while(rs2.next()) 
    { 
        int id = rs2.getInt("id");
        int stuff = getStuff(id);

        pst.setInt(1, stuff);
        pst.addBatch();

    }

    pst.executeBatch();

} 
catch (Exception e) 
{
    e.printStackTrace();
}

private int getStuff(int id) {

try
{   

        String sql = "SELECT ......;";
        ResultSet rs = statement.executeQuery(sql);

        if(rs.next())
        {
            return rs.getInt("something");

        }
        return -1;
}//code continues