mybatisPlus查询返回JSON

最新推荐文章于 2024-06-05 09:24:29 发布

章鱼家的俊俊妹妹

最新推荐文章于 2024-06-05 09:24:29 发布

阅读量793

点赞数 7

文章标签： json java mysql

本文链接：https://blog.csdn.net/weixin_47268011/article/details/135452733

版权

1、自己写sql返回的字段有JSON格式；

<resultMap id="result" type="vo">
        <result property="jsonDetail" column="json_detail" typeHandler="com.baomidou.mybatisplus.extension.handlers.JacksonTypeHandler" />
        <result property="jsonDetailItem" column="json_detail_items" typeHandler="com.baomidou.mybatisplus.extension.handlers.JacksonTypeHandler" />
       
    </resultMap>

<select id="result" resultMap="rateManageEasyInf">
        select
		a.json_detail,
        JSON_EXTRACT(json_detail, '$.items') AS json_detail_items,
        a.json_detail->> '$.grade' as json_detail_grade 
        from table1 a

    </select>

2、MP提供的基础CRUD方法（@TableField(typeHandler = JacksonTypeHandler.class)）；

@TableName(value = "table1", autoResultMap = true)
@ApiModel("表1")
public class table{
 
    @TableId(value = "id", type = IdType.AUTO)
    private Integer id;
 
    @ApiModelProperty("名称")
    private String name;
 
    @ApiModelProperty("JSON字段")
    @TableField(typeHandler = JacksonTypeHandler.class)
    private MenuContentList operations;