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 '錢(qián)包',
  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, 'test1@baomidou.com', '{"name": "支付寶錢(qián)包","currencyList": [{"type": "USD","amount": 999.19},{"type": "RMB","amount": 1000.19}]}', '{"sex": "男","city": "南昌"}'),
(2, 'Jack', 20, 'test2@baomidou.com', '{"name": "微信錢(qián)包","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, 'test1@baomidou.com', '{"name": "支付寶錢(qián)包","currencyList": [{"type": "USD","amount": 999.19},{"type": "RMB

(2, 'Jack', 20, 'test2@baomidou.com', '{"name": "微信錢(qián)包","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;
/**用戶實(shí)體對(duì)應(yīng)表 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;

    /**
     * 注意！！必須開(kāi)啟映射注解
     *
     * @TableName(autoResultMap = true)
     *
     * 以下兩種類型處理器，二選一 也可以同時(shí)存在
     *
     * 注意?。∵x擇對(duì)應(yīng)的 JSON 處理器也必須存在對(duì)應(yīng)依賴包
     */
    @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;

/**
 * 錢(qián)包
 */
@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 這個(gè)模塊演示內(nèi)置 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進(jìn)去自己的
     */
    @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>
 * 內(nèi)置 類型處理器 演示
 * </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());
    }
}?????