1.数据字典表
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;
2. DicMap.java类
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);
} }
}
3.dao接口
/**
* 获取字典列表
* @return
*/
List<Dic> getList(); /**
* 根据 key 获取字典值
* @param dic
* @return
*/
Dic getDic(Dic dic);
4.mapper映射文件
<!--查询字典列表-->
<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>
5.在模型中使用
6.页面显示
7.浏览器中使用firbug查看返回数据
8.页面显示效果
到此字典使用完毕!
