public DictFireSkillQuality update(DictFireSkillQuality model, int instPlayerId)
throws Exception {
try {
Object[] params = null;
int version = model.getVersion() + 1;
StringBuffer sql = new StringBuffer("update Dict_FireSkillQuality set ");
sql.append("name=?,sname=?,description=?,version=? ");
sql.append("where id=? and version=?");
params =
new Object[] {
model.getName(),
model.getSname(),
model.getDescription(),
version,
model.getId(),
model.getVersion()
};
int count = this.getJdbcTemplate().update(sql.toString(), params);
if (count == 0) {
throw new Exception("Concurrent Exception");
} else {
model.setVersion(version, 0);
PlayerMemObj playerMemObj = getPlayerMemObjByPlayerId(instPlayerId);
if (instPlayerId != 0 && isUseCach() && playerMemObj != null) {
playerMemObj.dictFireSkillQualityMap.put(model.getId(), model);
}
}
} catch (Exception e) {
throw e;
}
return model;
}
@SuppressWarnings("unchecked")
public DictFireSkillQuality getModel(int id, int instPlayerId) {
try {
PlayerMemObj playerMemObj = getPlayerMemObjByPlayerId(instPlayerId);
if (instPlayerId != 0 && isUseCach() && playerMemObj != null) {
DictFireSkillQuality model = playerMemObj.dictFireSkillQualityMap.get(id);
if (model == null) {
String sql = "select * from Dict_FireSkillQuality where id=?";
Object[] params = new Object[] {id};
playerMemObj.dictFireSkillQualityMap.put(
id,
(DictFireSkillQuality)
this.getJdbcTemplate().queryForObject(sql, params, new ItemMapper()));
} else {
int cacheVersion = model.getVersion();
List<Map<String, Object>> list =
sqlHelper("select version from Dict_FireSkillQuality where id = " + id);
int dbVersion = (int) list.get(0).get("version");
if (cacheVersion != dbVersion) {
String sql = "select * from Dict_FireSkillQuality where id=?";
Object[] params = new Object[] {id};
playerMemObj.dictFireSkillQualityMap.put(
id,
(DictFireSkillQuality)
this.getJdbcTemplate().queryForObject(sql, params, new ItemMapper()));
}
}
model = playerMemObj.dictFireSkillQualityMap.get(id);
model.result = "";
return model;
} else {
String sql = "select * from Dict_FireSkillQuality where id=?";
Object[] params = new Object[] {id};
DictFireSkillQuality model =
(DictFireSkillQuality)
this.getJdbcTemplate().queryForObject(sql, params, new ItemMapper());
model.result = "";
return model;
}
} catch (DataAccessException e) {
return null;
}
}
public DictFireSkillQuality add(final DictFireSkillQuality model, int instPlayerId)
throws Exception {
try {
StringBuilder strSql = new StringBuilder();
strSql.append(" insert into Dict_FireSkillQuality (");
strSql.append("name,sname,description,version");
strSql.append(" )");
strSql.append(" values (?,?,?,?) ");
final String sql = strSql.toString();
KeyHolder keyHolder = new GeneratedKeyHolder();
this.getJdbcTemplate()
.update(
new PreparedStatementCreator() {
public PreparedStatement createPreparedStatement(Connection conn)
throws SQLException {
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, model.getName());
ps.setString(2, model.getSname());
ps.setString(3, model.getDescription());
ps.setInt(4, 0);
return ps;
}
},
keyHolder);
model.setId(keyHolder.getKey().intValue());
model.setVersion(0);
PlayerMemObj playerMemObj = getPlayerMemObjByPlayerId(instPlayerId);
if (instPlayerId != 0 && isUseCach() && playerMemObj != null) {
playerMemObj.dictFireSkillQualityMap.put(model.getId(), model);
}
} catch (Exception e) {
throw e;
}
return model;
}
private List<DictFireSkillQuality> listCacheCommonHandler(String sql, int instPlayerId) {
List<DictFireSkillQuality> modelList = new ArrayList<DictFireSkillQuality>();
PlayerMemObj playerMemObj = getPlayerMemObjByPlayerId(instPlayerId);
SqlRowSet rsSet = this.getJdbcTemplate().queryForRowSet(sql.toString());
while (rsSet.next()) {
int id = rsSet.getInt("id");
int dbVersion = rsSet.getInt("version");
DictFireSkillQuality model = playerMemObj.dictFireSkillQualityMap.get(id);
if (model == null) {
model = getModel(id, instPlayerId);
model.result = "";
modelList.add(model);
} else {
int cacheVersion = model.getVersion();
if (cacheVersion != dbVersion) {
model = getModel(id, instPlayerId);
}
model.result = "";
modelList.add(model);
}
}
return modelList;
}
public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
DictFireSkillQuality dictFireSkillQuality = new DictFireSkillQuality();
dictFireSkillQuality.setId(rs.getInt("id"), 0);
dictFireSkillQuality.setName(rs.getString("name"), 0);
dictFireSkillQuality.setSname(rs.getString("sname"), 0);
dictFireSkillQuality.setDescription(rs.getString("description"), 0);
dictFireSkillQuality.setVersion(rs.getInt("version"), 0);
return dictFireSkillQuality;
}