mysql json字段

实体 
1 加 autoResultMap = true 
2 实现序列化
3 加 @TableField(typeHandler = JacksonTypeHandler.class)
@Data
@EqualsAndHashCode(callSuper = false)
@TableName(value = "test",autoResultMap = true)
public class Test implements Serializable {
    private int id;
    private String typeid;
    private String gateway;
    @TableField(typeHandler = JacksonTypeHandler.class)
    private Map<String,Object> json;

}

url 加 &stringtype=unspecified 用于数据支持特殊类型的转换
url: jdbc:mysql://localhost:3306/localtest?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=UTC&stringtype=unspecified

测试

@RequestMapping("/getlist")
    public List<Test> getlist(){
        List<Test> list = testService.list();
        System.out.println(list);
        return list;
    }