コード例 #1
0
 @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;
   }
 }
コード例 #2
0
 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;
 }