CREATE TABLE `dic` (

   `id` int(32) NOT NULL AUTO_INCREMENT,

   `table_name` varchar(225) DEFAULT NULL,

   `field_name` varchar(225) DEFAULT NULL,

   `field_value` varchar(225) DEFAULT NULL,

   `field_describe` varchar(225) DEFAULT NULL,

   `describe` varchar(225) DEFAULT NULL,

   PRIMARY KEY (`id`)

 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

 package com.day02.sation.map;

 import com.day02.sation.dao.IDicDao;

 import com.day02.sation.model.Dic;

 import org.springframework.context.ApplicationContext;

 import org.springframework.context.support.ClassPathXmlApplicationContext;

 import java.util.HashMap;

 import java.util.List;

 import java.util.Map;

 /**

  * Created by Administrator on 1/3.

  */

 public class DicMap {

     private static IDicDao dicDao;

     private static Map<String, String> map = new HashMap();

     static {

         //获取应用上下文对象

         ApplicationContext ctx = new ClassPathXmlApplicationContext("spring-config.xml");

         //获取dicDao实例

         dicDao = ctx.getBean(IDicDao.class);

         //调用方法初始化字典

         addMapValue();

     }

     public static String getFieldDetail(String tableName, String fieldName, String filedValue) {

         String key = tableName + "_" + fieldName + "_" + filedValue;

         String value = map.get(key);

         if (value == null) { //如果 value 为空 重新查询数据库

             Dic dicQuery = new Dic();

             Dic dic = dicDao.getDic(dicQuery);

             if (dic != null) {//数据有该值

                 String fieldDescribe = dic.getFieldDescribe();

                 map.put(key, fieldDescribe);

                 return fieldDescribe;

             }

             value = "暂无";

         }

         return value;

     }

     /**

      * 初始化字典数据

      */

     private static void addMapValue() {

         List<Dic> list = dicDao.getList();

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

             Dic dic = list.get(i);

             String tableName = dic.getTableName();

             String fieldName = dic.getFieldName();

             String fieldValue = dic.getFieldValue();

             String key = tableName + "_" + fieldName + "_" + fieldValue;

             String fieldDescribe = dic.getFieldDescribe();

             map.put(key, fieldDescribe);

         }

     }

 }

     /**

      * 获取字典列表

      * @return

      */

     List<Dic> getList();

     /**

      * 根据 key 获取字典值

      * @param dic

      * @return

      */

     Dic getDic(Dic dic);

  <!--查询字典列表-->

    <select id="getList" resultType="com.day02.sation.model.Dic">

        SELECT d.id, d.table_name tableName, d.field_name fieldName, d.field_value fieldValue,

        d.field_describe fieldDescribe, d.`describe` FROM dic AS d

    </select>

     <!--根据key获取字典值-->

     <select id="getDic" parameterType="com.day02.sation.model.Dic" resultType="com.day02.sation.model.Dic">

         SELECT d.id, d.table_name tableName, d.field_name fieldName, d.field_value fieldValue,

         d.field_describe fieldDescribe, d.`describe` FROM dic AS d

         WHERE d.table_name=#{tableName} AND d.field_name=#{fieldName} AND  d.field_value=#{fieldValue}

     </select>