数字字典通过数字获取汉字

public String queryDictTextByKey(String code, String key); /** * 通过查询指定code 获取字典值text * @param code * @param key * @return */ @Override @Cacheable(value = CacheConstant.SYS_DICT_CACHE,key = "#code+':'+#key") public String queryDictTextByKey(String code, String key) { log.info("无缓存dictText的时候调用这里！"); return sysDictMapper.queryDictTextByKey(code, key); } public String queryDictTextByKey(@Param("code") String code,@Param("key") String key); <!-- 通过字典code获取字典数据 --> <select id="queryDictTextByKey" parameterType="String" resultType="String"> select s.item_text from sys_dict_item s where s.dict_id = (select id from sys_dict where dict_code = #{code}) and s.item_value = #{key} </select>