注:代码来自于若依框架—RuoYi-master
实现效果
字典表
核心代码
视图层:
<select name="sex" th:with="type=${@dict.getType('sys_customer_sex')}">
<option value="">所有</option>
<option th:each="dict : ${type}" th:text="${dict.dictLabel}" th:value="${dict.dictValue}"></option
</select>
service层
@Service("dict")
public class DictService
{
@Autowired
private ISysDictTypeService dictTypeService;
public List<SysDictData> getType(String dictType)
{
return dictTypeService.selectDictDataByType(dictType);
}
}
mapper.xml层
<sql id="selectDictDataVo">
select dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark
from sys_dict_data
</sql>
<select id="selectDictDataByType" parameterType="SysDictData" resultMap="SysDictDataResult">
<include refid="selectDictDataVo"/>
where status = '0' and dict_type = #{dictType} order by dict_sort asc
</select>