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());
    }
}​​​​​