Operation not allowed after ResultSet closed

错误信息：Operation not allowed after ResultSet closed
分析原因：，
1、循环过程中关闭了rs

   解决此问题，只要将关闭连接放到循环外即可。

2、循环中的其他操作也会关闭rs

举例如下：

DBfunction dfb = new DBfunction(); 
String sql = "select ID from student"; 
ResultSet rs = dfb.executeQuery(sql1); 
while(rs.next()) 
{ 
String N_ID = rs2.getString(1); 
String sql2 = "insert into teacher(tname,tno) VALUES('"+tname+"','"+tno+"')"; 
dfb.execute(sql2); //执行dfb.execute(sql2)会关闭rs
}
//解决办法是用一个新的连接执行execute(sql2)
DBfunction dfb = new DBfunction(); 
DBfunction dfb1 = new DBfunction(); 
String sql = "select ID from student"; 
ResultSet rs = dfb.executeQuery(sql1); 
while(rs.next()) 
{ 
String N_ID = rs2.getString(1); 
String sql2 = "insert into teacher(tname,tno) VALUES('"+tname+"','"+tno+"')";
dfb1.execute(sql2); 
}