递归中重复使用某个ResultSet对象,如何对其进行关闭
public void MakeTree(int pid) throws SQLException
{
String flage, url, url1, lev;
SQL = "select * From SAFETYSTANDARD where SAF_PID = '" + pid +
"' order by SAFE_ID";
dbs datebase = new dbs();
ResultSet rs1 = datebase.executeQuery(SQL);
while (rs1.next())
{
int Fid = rs1.getInt(2); //父亲id
int id = rs1.getInt(1); //自己id
flage = rs1.getString(3).trim(); //自己的标识
lev = rs1.getString("SAF_LEVEL");
saflev = java.lang.Integer.parseInt(lev);
url = "/safety/StandardAdmin/view.jsp?pId=" + id;
TreeNodes = TreeNodes + "\n" + "A[" + (i + 1) + "] = new TREE('" +
Fid +
"','" + id + "','" + flage + "','','','" + url + "','" + flage +
"','" + flage + "','" + flage + "','');";
i++;
if (!this.CheckLeaf(id))
{ //判断是否是叶子,如果不是叶子,继续递归
MakeTree(id);
//rs1.close();
//datebase.close();
}
}
//rs1.close();
//datebase.close();
}
在什么位置关闭结果集呢。。。急!!