81,095
社区成员
发帖
与我相关
我的任务
分享
private boolean update(Connection donn, ArrayList list) {
String sql = "";
try {
Statement stat = donn.createStatement(); // 声明放在外面
for (int kk = 0; kk < list.size(); kk++) {
sql = "update fhpur set ebox_rmk=1,ebox_date=to_date('" + p.sdf2.format(new java.util.Date())
+ "','yyyy/MM/dd HH24:MI:SS') Where pur_no='" + list.get(kk) + "'";
logger.info(sql);
stat.executeUpdate(sql);
}
stat.close(); // 这里关闭
donn.commit();
donn.close();
return true;
} catch (SQLException sqleee) {
error.handle(sqleee, logger, p.smtpHost, p.from, p.programer, p.errorMailSubject, "更新资料数据时发生异常", "BIG5");
return false;
} catch (Exception e) {
error.handle(e, logger, p.smtpHost, p.from, p.programer, p.errorMailSubject, "更新数据时发生例外", "BIG5");
return false;
} finally {
try {
if (donn != null) {
donn.close();
}
} catch (Exception e) {
logger.info("close donn error");
}
}
}