public static List<Content> getContentList(int positionId, String provCode, String areaCode) throws SQLException {

     String key_p_p_a = positionId + "_" + provCode + "_" + areaCode;

     List<Content> contentList = null;

     String strTemp = "|";

     StringBuilder cacheLogInfoSb = new StringBuilder("get cache [");

     /*判断本地缓存是否存在*/

     if (ContentService.MAP_CONTENT_P_P_A.containsKey(key_p_p_a)) {

         contentList = ContentService.MAP_CONTENT_P_P_A.get(key_p_p_a);

         cacheLogInfoSb.append(strTemp).append(" by cache MAP_CONTENT_P_P_A get List, key:").append(key_p_p_a)

                 .append(",List.size:").append(contentList.size());

     /*判断Reids缓存是否存在*/

     }else if (RedisCached.has(key_p_p_a)) {

         contentList = (List<Content>) RedisCached.get(key_p_p_a.getBytes());

         cacheLogInfoSb.append(strTemp).append(" by xmemcache MAP_CONTENT_P_P_A get List, key:").append(key_p_p_a)

                 .append(",List.size:").append(contentList.size());

     /*数据库查询操作*/

     } else {

         try {

             contentList = dao.getContentList(positionId, provCode, areaCode);

             cacheLogInfoSb = new StringBuilder(" cache is not exists,get data by database");

         } catch (SQLException e) {

             cacheLogInfoSb.append(strTemp).append("SQLException:").append(e.toString());

             e.printStackTrace();

             throw e;

         }

         log.info(cacheLogInfoSb.toString() + "]");

         log.info("[ContentService]加入缓存key_p_p_a, key:{},contentList.size:{}", key_p_p_a, contentList.size());

         /*数据库查询后,将结果写入redis,方便下次查询*/

         RedisCached.set(key_p_p_a, contentList, ContentService.Cache_ExPireTime_Day);

     }

     return contentList;

 }

  public static Map<String, List<Content>> MAP_CONTENT_P_P_A = new ConcurrentHashMap<String, List<Content>>();

 List<Content> list = ContentService.MAP_CONTENT_P_P_A.get(key);

 ContentService.MAP_CONTENT_P_P_A.put(key_p_p_a, contentList);

 /** 查询数据库,获取最新数据 **/

 Map<String, List<Content>> position_content_map_p_p_a = dao.queryContentListRelateProvCodeAreaCode(positionId);

 /** 清除本地缓存 **/

 Iterator<String> contentskeysIterPPA = MAP_CONTENT_P_P_A.keySet().iterator();

 while (contentskeysIterPPA.hasNext()) {

     String key = contentskeysIterPPA.next();

     if (key.startsWith(String.valueOf(positionId))) {

         removeKeys.add(key);

     }

 }

 /** 清除Redis缓存 **/

 for (int i = 0; i < removeKeys.size(); i++) {

     String key = removeKeys.get(i);

     contentList.addAll(MAP_CONTENT_P_P_A.remove(key));

     RedisCached.delete(key);

 }

 removeKeys.clear();

 /** 把最新内容加入MAP_CONTENT_P_P_A缓存 **/

 Iterator<String> keysIterppa = position_content_map_p_p_a.keySet().iterator();

 while (keysIterppa.hasNext()) {

     String key = keysIterppa.next();

     reFreshContenList.addAll(position_content_map_p_p_a.get(key));

     MAP_CONTENT_P_P_A.putAll(position_content_map_p_p_a);

 }