SpringBoot通过mysql使用数据字典

1.在数据库建立两个数据表dictionary表和 dictionary_value映射表

dictionary

在dictionary表中插入职称字段信息

 

 dictionary_value

 在 dictionary_value表中映射四条职称信息

 在com.test.demo.core包下新建dict包，在dict包中，新建Dictionary.java、DictionaryHelper.java 和DictJsonSerializer.java三个类和Dict、DictCollecting两个接口

Dictionary.java

@Data
public class Dictionary {
    private Integer id;
    private String code;
    private String value;
}

DictionaryHelper.java

public class DictionaryHelper {

    public static Dictionary get(Integer id, List<Dictionary> dictionaries) {

        Dictionary dictionary = dictionaries.stream().filter(d -> d.getId() == id).findAny().orElse(null);
        return dictionary;
    }
}

DictJsonSerializer.java

@Slf4j
@Component
@NoArgsConstructor
public class DictJsonSerializer extends JsonSerializer<Object> implements ContextualSerializer {

    String dicKey = "";