一直以来,前端展示字典一般以中文展示为主,若在表中存字典值中文,当字典表更改字典值对应的中文,会造成数据不一致,为此设置冗余字段并非最优方案,若由前端自己写死转义,不够灵活,若在业务代码转义,臃肿也不够通用,从网络上了解到注解、AOP是一种不错的解决方案,主要有两种方式:
1、通过注解获取结果集转为JSON字符串,通过正则查找附加字段;
2、通过获取结果集中相关字段上注解,此种方法有两个需要解决的问题,父类继承字段、嵌合对象难以解决获取对应注解字段问题,解决起来均比较麻烦;
因此本文采用第一种方法,能有效规避第二种方法相关问题,做到逻辑相对简单,引入缓存提高效率。
一、新建注解
标注方法上使用
1 @Retention(RetentionPolicy.RUNTIME) 2 @Target(ElementType.METHOD) 3 @Documented 4 public @interface TranslationDict { 5 FieldParam[] value(); 6 }
注解参数:FieldParam
1 @Retention(RetentionPolicy.RUNTIME) 2 @Target({ElementType.FIELD}) 3 @Documented 4 public @interface FieldParam { 5 6 /** 7 * 字段类型 默认字典 8 * Constant.FIELDTYPE_DICT 为自定义常量 9 * @return 10 */ 11 int type() default Constant.FIELDTYPE_DICT; 12 13 /** 14 * 字典dictType 15 * @return 16 */ 17 String dictType() default ""; 18 19 /** 20 * 要翻译的字段 目标字段为翻译的字段+Str 21 * @return 22 */ 23 String targetField() default ""; 24 25 /** 26 * 要翻译的字段值类型 27 * @return 28 */ 29 Class targetFieldValueClazz() default String.class; 30 31 }
二、注解的使用
在需要转义方法体上添加注解,在注解上指定需要转义的字段,不声明则使用默认值。
@TranslationDict({@FieldParam(dictType = "CUSTOMER_SEX", targetField = "sex"), @FieldParam(dictType = "CUSTOMER_STATUS", targetField = "status", targetFieldValueClazz = Integer.class)})
三、新建切面
切面核心在于将结果集转为JSON字符串,通过正则查询需要转义的字段,进行拼接替换,以增加属性。
1 @Aspect 2 @Component 3 @Slf4j 4 public class TranslateFieldAspect { 5 6 /** 7 * 翻译字典值 8 * @param joinPoint 9 * @return 10 * @throws Throwable 11 */ 12 @Around("@annotation(com.vfangtuan.vft.common.annotation.TranslationDict)") 13 public Object aroundMethodDict(ProceedingJoinPoint joinPoint) throws Throwable { 14 //接收到请求时间 15 Long startTime = System.currentTimeMillis(); 16 //注意,如果调用joinPoint.proceed()方法,则修改的参数值不会生效,必须调用joinPoint.proceed(Object[] args) 17 Object result = joinPoint.proceed(); 18 19 // 第一步、获取返回值类型 20 Class returnType = ((MethodSignature) joinPoint.getSignature()).getReturnType(); 21 22 //首先,取出要翻译字段的字典值 23 String returnJsonResult = JSONObject.toJSONString(result); 24 //开始解析(翻译字段注解参数指定的字段) 25 Method method = ((MethodSignature) joinPoint.getSignature()).getMethod(); 26 //获取注解上参数 27 TranslationDict annotation = method.getAnnotation(TranslationDict.class); 28 FieldParam[] fieldParams = annotation.value(); 29 //遍历 30 for (FieldParam fieldParam : fieldParams) { 31 log.info("开始翻译字典CODE:{},取值字段:{},取值字段值类型:{}.", 32 fieldParam.dictType(),fieldParam.targetField(),fieldParam.targetFieldValueClazz()); 33 Pattern dictPattern = getPattern(fieldParam); 34 Matcher dictMatcher=dictPattern.matcher(returnJsonResult); 35 StringBuffer sb = new StringBuffer(); 36 //转义字段 37 this.translateDict(fieldParam,dictPattern,dictMatcher,sb); 38 dictMatcher.appendTail(sb); 39 returnJsonResult = sb.toString(); 40 } 41 42 result = JSONObject.parseObject(returnJsonResult,returnType); 43 //如果这里不返回result,则目标对象实际返回值会被置为null 44 //处理完请求时间 45 Long endTime = System.currentTimeMillis(); 46 log.info("The request takes {}ms",endTime-startTime); 47 return result; 48 } 49 /** 50 * 字典值转义为中文 51 * @param fieldParam 52 * @param fieldPattern 53 * @param fieldMatcher 54 * @param sb 55 */ 56 private void translateDict(FieldParam fieldParam, Pattern fieldPattern, Matcher fieldMatcher, StringBuffer sb) { 57 //从缓存中一次性取值 58 Map<String, String> dictNames = DictData.getDictNames(fieldParam.dictType()); 59 while (fieldMatcher.find()){ 60 61 //取出要翻译字段对应的值 62 Matcher dictValueMatcher = fieldPattern.matcher(fieldMatcher.group()); 63 dictValueMatcher.find(); 64 String group = dictValueMatcher.group(); 65 //""sex":1", ""sex":"1"",""sex":null" 66 //属性无值 67 if (group.split(":").length <= 1) continue; 68 String dictName = ""; 69 70 //获取字典值 71 String dictValue = group.split(":")[1].replace("\"", ""); 72 //属性值非为空 为空赋值空串 73 if (StringUtils.isNotBlank(dictValue) && !dictValue.toLowerCase().equals("null")){ 74 //多值 75 if (dictValue.split(",").length > 1){ 76 for (String s : dictValue.split(",")) { 77 //fieldParam.dictType() + "_" + s 根据自己字典表设置的规则去查询 78 dictName += dictNames.get(fieldParam.dictType() + "_" + s) + "/"; 79 } 80 }else { 81 dictName = dictNames.get(fieldParam.dictType() + "_" + dictValue); 82 } 83 } 84 85 String s = "\"" + fieldParam.targetField() + "Str" + "\":\"" + dictName + "\"," + fieldMatcher.group(); 86 log.debug("拼接后字符串:{}",s); 87 fieldMatcher.appendReplacement(sb, s); 88 } 89 } 90 /** 91 * 获取对应的正则式 92 * @param fieldParam 93 * @return 94 */ 95 private Pattern getPattern(FieldParam fieldParam) { 96 Pattern fieldPattern;//属性整型 字符型 97 if (fieldParam.targetFieldValueClazz().equals(Integer.class) ){ 98 fieldPattern= Pattern.compile("\""+fieldParam.targetField() +"\":(\\d+)?"); 99 }else { 100 fieldPattern= Pattern.compile("\""+fieldParam.targetField() +"\":\"([0-9a-zA-Z_,]+)?\""); 101 } 102 return fieldPattern; 103 } 104 }
四、测试
测试类
1 @Slf4j 2 @RestController 3 @RequestMapping("/demo") 4 @Api(tags="demo") 5 public class DemoController { 6 7 8 /** 9 * 测试注解字典 10 * @return 11 */ 12 @TranslationDict({@FieldParam(dictType = "CUSTOMER_SEX", targetField = "sex"), 13 @FieldParam(dictType = "CUSTOMER_STATUS", targetField = "status", targetFieldValueClazz = Integer.class)}) 14 @GetMapping("/test") 15 @ApiOperation(value = "测试字典转义") 16 public ResultVo test1() { 17 //接收到请求时间 18 Long startTime = System.currentTimeMillis(); 19 List result = this.getResult(); 20 //处理完请求时间 21 Long endTime = System.currentTimeMillis(); 22 log.info("The request takes {}ms",endTime-startTime); 23 return new ResultVo().success(result); 24 } 25 26 private List getResult() { 27 List demos = new ArrayList<>(); 28 Demo demo = new Demo("张三","1,2",1); 29 Demo demo2= new Demo("李四","2,1",2); 30 demos.add(demo); 31 demos.add(demo2); 32 33 for (int i = 0; i < 5; i++) { 34 demos.add(new Demo("张三"+i,"1",1) ); 35 } 36 return demos; 37 }
实体对象
1 @Data 2 public class Demo { 3 4 private String name; 5 6 private String sex; 7 8 private Integer status; 9 10 public Demo() { 11 } 12 13 public Demo(String name, String sex, Integer status) { 14 this.name = name; 15 this.sex = sex; 16 this.status = status; 17 } 18 19 public Demo(String name) { 20 this.name = name; 21 } 22 23 public Demo(String name, String sex) { 24 this.name = name; 25 this.sex = sex; 26 } 27 28 }
测试效果
{ "code": 0, "message": "success", "data": [ { "statusStr": "报备", "sex": "1,2", "name": "张三", "sexStr": "男/女/", "status": 1 }, { "statusStr": "到访", "sex": "2,1", "name": "李四", "sexStr": "女/男/", "status": 2 }, { "statusStr": "报备", "sex": "1", "name": "张三0", "sexStr": "男", "status": 1 },... ] }
到此本文结束,如您有更好的解决方案,还请留言告知,非常感谢。
参考资料:https://blog.csdn.net/qq_44754081/article/details/106142458
https://blog.csdn.net/Better_Mei/article/details/103901273
https://my.oschina.net/angelbo/blog/2875887