数据库并发操作丢失更新
两种丢失更新的区别:http://blog.csdn.net/mageshuai/article/details/4544188
一种解决方案:给数据库表添加版本号控制
修改前判断拿到的记录版本号和数据库中的版本号是否相同,
相同则更新记录并更新版本号,
不同则不修改
例:
public void updateObject(){
Date nextVersion = new Date();
if (isLatestVersion(recordId, currentVersion, nextVersion)) {
//TODO update this record
}
}
public boolean isLatestVersion(int recordId, Date currentVersion, Date nextVersion) {
String checkSql = "SELECT (? = version) from " + tableName + " WHERE recordId = ? LIMIT 1";
boolean isLatest = getJdbcTemplate(checkSql, new Object[]{currentVersion, recordId}, Boolean.class);
if (!isLatest)
return false;
String updateSql = "UPDATE " + tableName + " SET version = ? WHERE recordId = ?";
getJdbcTemplate(updateSql, new Object[]{nextVersion, recordId});
return true;
}