MyBatis处理 mysql json格式的字段_java在xml文件中如何写mysql updatejson字段类型

MyBatis处理 mysql json格式的字段

1）找了一个工具类

public class JsonToStringDeserializer extends JsonDeserializer<String> {
    @Override
    public String deserialize(JsonParser jsonParser,
                              DeserializationContext deserializationContext) throws IOException {
        if (jsonParser == null) {
            return null;
        }
        JsonNode node = jsonParser.getCodec().readTree(jsonParser);
        if (node == null) {
            return null;
        }
        return node.toString();
    }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14

2）字段上面这样写

    /**
     * 模板内容
     */
    @ApiModelProperty("模板内容")
    @JsonDeserialize(using = JsonToStringDeserializer.class)
    private String templateContent;
1
2
3
4
5
6

3）xml文件里面这样写

    <resultMap id="BaseResultMap" type="com.nwh.pumpedstorage.entity.pumpedstorage.SheetTemplate">
        <!--
          WARNING - @mbg.generated
          This element is automatically generated by MyBatis Generator, do not modify.
        -->
        <result column="template_content" jdbcType="VARCHAR" property="templateContent"/>
    </resultMap>
1
2
3
4
5
6
7

4)有时候需要去除转义符以及首尾的""引号，可以这么写

public class JsonToStringDeserializer extends JsonDeserializer<String> {
    @Override
    public String deserialize(JsonParser jsonParser,
                              DeserializationContext deserializationContext) throws IOException {
        if (jsonParser == null) {
            return null;
        }
        JsonNode node = jsonParser.getCodec().readTree(jsonParser);
        if (node == null) {
            return null;
        }

        String r1 = node.toString();
        //去除转义符
        String r2 = StringEscapeUtils.unescapeJava(r1);

        String r3 = trimFirstAndLastChar(r2, "\"");

        return r3;
    }


    /**
     * 去除首尾指定字符
     * @param str   字符串
     * @param element   指定字符
     * @return
     */
    public  String trimFirstAndLastChar(String str, String element){
        boolean beginIndexFlag = true;
        boolean endIndexFlag = true;
        do{
            int beginIndex = str.indexOf(element) == 0 ? 1 : 0;
            int endIndex = str.lastIndexOf(element) + 1 == str.length() ? str.lastIndexOf(element) : str.length();
            str = str.substring(beginIndex, endIndex);
            beginIndexFlag = (str.indexOf(element) == 0);
            endIndexFlag = (str.lastIndexOf(element) + 1 == str.length());
        } while (beginIndexFlag || endIndexFlag);
        return str;
    }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41