public boolean deleteHoldTime0(List<HoldTime> holdTimes) {
Connection connection = DBUtil.getConnection();
Statement statement = DBUtil.getStatement(connection);
int executeUpdate = -1;
for (int i = 0; i < holdTimes.size(); i++) {
StringBuffer sbf = new StringBuffer();
sbf.append("delete from HoldTime where resouNo = '" + holdTimes.get(i).getResouNo() + "' and startTime = '" + holdTimes.get(i).getStartTime().toString() + "' and endTime = '" +holdTimes.get(i).getEndTime().toString() + "'");
System.out.println("sbf." + sbf.toString());
try {
executeUpdate = statement.executeUpdate(sbf.toString());
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
DBUtil.closeConn(connection, statement);
if(executeUpdate != -1){
return true;
}
return false;
}测试没问题,但是融入项目就开始报错
java.sql.SQLException: database is locked
该关闭的都关闭了,该启用的事务也都启用了
就是删除最后一个的时候报这个错误,
跪求大神们解答
谢谢
看看这个吧,最后说更新语句不要做成并发的,在更新前进行加锁。
额 不好意思 发错地址了