SpringBoot+MybatisPlus 存json读json
基础环境
springboot 2.5.3
mysql 8.0.22
fastjson2 2.0.38
主要配置
1. 返回VO字段添加注解
@ApiModelProperty("字段内容")
@TableField(typeHandler = JacksonTypeHandler.class)
private List<JSONObject> columnContent;
2. 返回Mapper中的resultMap中字段添加配置
<result property="columnContent" column="column_content" jdbcType="VARCHAR"
typeHandler="com.baomidou.mybatisplus.extension.handlers.JacksonTypeHandler"/>
查询效果
{
"errcode": 200,
"errmsg": "操作成功",
"data": {
"records": [
{
"id": 9,
"columnContent": [
{
"id": 1,
"name": "张三",
"email": "xiaomimg@163.com",
"tableName": "iot_person",
"sourceName": "测试库1",
"databasesName": "abd1"
},
{
"id": "/",
"name": "/",
"email": "/",
"table_name": "iot_person",
"source_name": "测试库2",
"databases_name": "abd2"
}
],
"recordUuid": "13a2b1d1a60549c78f5e2e461c91c00b"
},
{
"id": 10,
"columnContent": [
{
"id": 2,
"name": "李四",
"email": "xiaomimg@163.com",
"tableName": "iot_person",
"sourceName": "测试库1",
"databasesName": "abd1"
},
{
"id": 2,
"name": "李四",
"email": "lisi@163.com",
"table_name": "iot_person",
"source_name": "测试库2",
"databases_name": "abd2"
}
],
"recordUuid": "13a2b1d1a60549c78f5e2e461c91c00b"
}
],
"total": 4,
"size": 4,
"current": 1,
"orders": [],
"optimizeCountSql": true,
"searchCount": true,
"countId": null,
"maxLimit": null,
"pages": 1
}
}