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

(2, 'Jack', 20, 'test2@baomidou.com', '{"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;

@Data
@Accessors(chain = true)
@TableName(autoResultMap = true)
public class User {
    private Long id;
    private String name;
    private Integer age;
    private String email;

    
    @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 {
    
    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;


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;


@Component
public class MpJsonConfig implements CommandLineRunner {

    
    @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;


@RunWith(SpringRunner.class)
@SpringBootTest
public class SampleTest {

    @Resource
    private UserMapper userMapper;

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