| 限定符和类型 | 方法和说明 |
|---|---|
String |
selectSysDictItemByCodeAndKey(String code,
String key)
根据字典标识与关键字查询字典信息
|
List<SysDictItem> |
selectSysDictItemListByCode(String code)
根据字典标识查询字典数据列表
|
@Select(value="select sdi.* from sys_dict sd join sys_dict_item sdi on sd.id = sdi.dict_id where sd.code = #{code} and sd.is_deleted = 0 and sdi.is_deleted = 0 order by sort asc")
List<SysDictItem> selectSysDictItemListByCode(@Param(value="code")
String code)
code - 字典标识@Select(value="select sdi.value from sys_dict sd join sys_dict_item sdi on sd.id = sdi.dict_id where sd.code = #{code} and sdi.key = #{key}")
String selectSysDictItemByCodeAndKey(@Param(value="code")
String code,
@Param(value="key")
String key)
code - 字典标识key - 数据库中的值Copyright © 2020. All rights reserved.