Mybatis-plus操作json字段實戰教程

DROP TABLE IF EXISTS user;
CREATE TABLE user(
  id BIGINT(20) NOT NULL COMMENT '主鍵ID',
  name VARCHAR(30) NULL DEFAULT NULL COMMENT '姓名',
  age INT(11) NULL DEFAULT NULL COMMENT '年齡',
  email VARCHAR(50) NULL DEFAULT NULL COMMENT '郵箱',
  wallet VARCHAR(3000) NULL DEFAULT NULL COMMENT '錢包',
  other_info VARCHAR(3000) NULL DEFAULT NULL COMMENT '其他信息',
  PRIMARY KEY (id)
);


INSERT INTO user (id, name, age, email, wallet, other_info) VALUES
(1, 'Jone', 18, '[email protected]', '{"name": "支付寶錢包","currencyList": [{"type": "USD","amount": 999.19},{"type": "RMB","amount": 1000.19}]}', '{"sex": "男","city": "南昌"}'),
(2, 'Jack', 20, '[email protected]', '{"name": "微信錢包","currencyList": [{"type": "USD","amount": 888.18},{"type": "RMB","amount": 1000.18}]}', '{"sex": "男","city": "青島"}');

INSERT INTO user (id, name, age, email, wallet, other_info) VALUES
(1, 'Jone', 18, '[email protected]', '{"name": "支付寶錢包","currencyList": [{"type": "USD","amount": 999.19},{"type": "RMB

(2, 'Jack', 20, '[email protected]', '{"name": "微信錢包","currencyList": [{"type": "USD","amount": 888.18},{"type": "RMB","amount": 1000.18}]}', '{"sex": "男","city": "青島"}');

import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableName;
import com.baomidou.mybatisplus.extension.handlers.FastjsonTypeHandler;
import com.baomidou.mybatisplus.extension.handlers.JacksonTypeHandler;
import lombok.Data;
import lombok.experimental.Accessors;
/**用戶實體對應表 user
 * @author hubin
 * @since 2018-08-11
 */
@Data
@Accessors(chain = true)
@TableName(autoResultMap = true)
public class User {
    private Long id;
    private String name;
    private Integer age;
    private String email;

    /**
     * 註意！！必須開啟映射註解
     *
     * @TableName(autoResultMap = true)
     *
     * 以下兩種類型處理器，二選一 也可以同時存在
     *
     * 註意！！選擇對應的 JSON 處理器也必須存在對應依賴包
     */
    @TableField(typeHandler = JacksonTypeHandler.class)
    private Wallet wallet;


    @TableField(typeHandler = FastjsonTypeHandler.class)
    private OtherInfo otherInfo;
}

package com.baomidou.mybatisplus.samples.typehandler.entity;
import java.util.List;
import lombok.Data;

/**
 * 錢包
 */
@Data
public class Wallet {
    /**
     * 名稱
     */
    private String name;
    /**
     * 各種貨幣
     */
    private List<Currency> currencyList;
}

package com.baomidou.mybatisplus.samples.typehandler.entity;

import lombok.Data;

/**
 * 貨幣
 */
@Data
public class Currency {
    /**
     * 類型: 人民幣 RMB , 美元 USD
     */
    private String type;
    /**
     * 金額
     */
    private Double amount;
}

package com.baomidou.mybatisplus.samples.typehandler.entity;
import lombok.Data;

/**
 * 其他信息
 */
@Data
public class OtherInfo {
    /**
     * 性別
     */
    private String sex;
    /**
     * 居住城市
     */
    private String city;
}

package com.baomidou.mybatisplus.samples.typehandler.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.samples.typehandler.entity.User;

/**
 * <p>
 * MP 支持不需要 UserMapper.xml 這個模塊演示內置 CRUD 咱們就不要 XML 部分瞭
 * </p>
 *
 * @author hubin
 * @since 2018-08-11
 */
public interface UserMapper extends BaseMapper<User> {
}

package com.baomidou.mybatisplus.samples.typehandler.config;
import com.baomidou.mybatisplus.extension.handlers.GsonTypeHandler;
import com.baomidou.mybatisplus.extension.handlers.JacksonTypeHandler;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.google.gson.Gson;
import org.springframework.boot.CommandLineRunner;
import org.springframework.stereotype.Component;

/**
 * @author miemie
 * @since 2019-11-28
 */
@Component
public class MpJsonConfig implements CommandLineRunner {

    /**
     * 可以set進去自己的
     */
    @Override
    public void run(String... args) throws Exception {
        JacksonTypeHandler.setObjectMapper(new ObjectMapper());
        GsonTypeHandler.setGson(new Gson());
    }
}

package com.baomidou.mybatisplus.samples.typehandler;
import javax.annotation.Resource;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import com.baomidou.mybatisplus.samples.typehandler.entity.User;
import com.baomidou.mybatisplus.samples.typehandler.mapper.UserMapper;

/**
 * <p>
 * 內置 類型處理器 演示
 * </p>
 *
 * @author hubin
 * @since 2018-08-11
 */
@RunWith(SpringRunner.class)
@SpringBootTest
public class SampleTest {

    @Resource
    private UserMapper userMapper;

    /**
     * 自定義類型處理器演示參考 mybatis-plus-sample-deluxe 模塊
     */
    @Test
    public void test() {
        User Jone = userMapper.selectById(1);
        System.out.println(Jone);
        System.err.println(Jone.getName());

        User Jack = userMapper.selectById(1);
        System.err.println(Jack.getName());
    }
}​​​​​