mysql json类型

json对象案例

创建表

-- 也可以把info设置为  json类型
create table t3(id int ,number VARCHAR(20),info VARCHAR(200));

插入数据

insert into t3 values(1,"001",'{ "name":"zs", "age":40, "city":"China"}');
insert into t3 values(2,"002",'{ "name":"zs01", "age":40, "city":"China"}');
insert into t3 values(3,"003",'{ "name":"ls", "age":40, "city":"China"}');

根据json中的名称查询数据

• 使用 字段->‘$.json属性’ 进行查询条件
• 使用 json_extract 函数查询，json_extract(字段, “$.json属性”)

select x.id,x.number,x.info from (select *,info->"$.name" as name from t3 ) x where x.name like '%zs%'

java实体类

    @ApiModelProperty("信息")
    @TableField(typeHandler = JacksonTypeHandler.class)
    private Info info;