1.resultset不能嵌套使用,使用完成要立即关闭;
2.executeUpdate函数和execute函数会自动返回resultSet!
<span style="font-size:14px;">ps = conn.prepareStatement();
sql = "SELECT LAST_INSERT_ID() from "+tableName;
rs = stmt.executeQuery(sql);
while(rs.next()){
sql = "update "+tableName+" set notifyURL=NotifyAction?id="+rs.getInt(1)+"' where id ="+rs.getInt(1);
ps.executeUpdate(sql);
}
rs.close();
ps.close();</span>