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

获取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