java springboot mybatisplus处理mysql JSON类型字段

/**
 * @author wuzhenyong
 * ClassName:EmpEntity.java
 * date:2022-05-25 10:31
 * Description:
 */
@TableName("sharding_emp")
@Data
public class EmpEntity {
    @TableId(type = IdType.AUTO)
    private long id;
    private String empno;
    private String empname;
    private String job;
    private String mgr;
    private LocalDateTime hiredate;
    private BigDecimal sal;
    private BigDecimal comn;
    private String depno;
    @TableField(exist = false)
    private long bb;
    @TableField(typeHandler = JacksonTypeHandler.class)
    private Map<String,Object> testJson;
}

@GetMapping("/testInsertJsonHandler")
public void testInsertJsonHandler() {
    EmpEntity entity = new EmpEntity();
    entity.setEmpno("36666");
    entity.setEmpname("36666");
    entity.setJob("36666");
    entity.setMgr("36666");
    entity.setHiredate(LocalDateTime.now());
    entity.setSal(new BigDecimal("0"));
    entity.setComn(new BigDecimal("0"));
    entity.setDepno("36666");
    Map<String, Object> map = new HashMap<>();
    map.put("name", "测试json添加");
    map.put("list", Lists.newArrayList("1", "2", "3"));
    entity.setTestJson(map);
    empMapper.insert(entity);
}