实战!Mybatis-plus操作json字段实战

packagecom.baomidou.mybatisplus.samples.typehandler.entity;
importcom.baomidou.mybatisplus.annotation.TableField;
importcom.baomidou.mybatisplus.annotation.TableName;
importcom.baomidou.mybatisplus.extension.handlers.FastjsonTypeHandler;
importcom.baomidou.mybatisplus.extension.handlers.JacksonTypeHandler;
importlombok.Data;
importlombok.experimental.Accessors;
/**用户实体对应表 user* @author hubin* @since 2018-08-11*/@Data@Accessors(chain=true)
@TableName(autoResultMap=true)
publicclassUser {
privateLongid;
privateStringname;
privateIntegerage;
privateStringemail;
/*** 注意！！必须开启映射注解** @TableName(autoResultMap = true)** 以下两种类型处理器，二选一 也可以同时存在** 注意！！选择对应的 JSON 处理器也必须存在对应依赖包*/@TableField(typeHandler=JacksonTypeHandler.class)
privateWalletwallet;
@TableField(typeHandler=FastjsonTypeHandler.class)
privateOtherInfootherInfo;
}

packagecom.baomidou.mybatisplus.samples.typehandler.entity;
importjava.util.List;
importlombok.Data;
/*** 钱包*/@DatapublicclassWallet {
/*** 名称*/privateStringname;
/*** 各种货币*/privateList<Currency>currencyList;
}

packagecom.baomidou.mybatisplus.samples.typehandler.entity;
importlombok.Data;
/*** 货币*/@DatapublicclassCurrency {
/*** 类型: 人民币 RMB , 美元 USD*/privateStringtype;
/*** 金额*/privateDoubleamount;
}

packagecom.baomidou.mybatisplus.samples.typehandler.entity;
importlombok.Data;
/*** 其他信息*/@DatapublicclassOtherInfo {
/*** 性别*/privateStringsex;
/*** 居住城市*/privateStringcity;
}

packagecom.baomidou.mybatisplus.samples.typehandler.mapper;
importcom.baomidou.mybatisplus.core.mapper.BaseMapper;
importcom.baomidou.mybatisplus.samples.typehandler.entity.User;
/*** <p>* MP 支持不需要 UserMapper.xml 这个模块演示内置 CRUD 咱们就不要 XML 部分了* </p>** @author hubin* @since 2018-08-11*/publicinterfaceUserMapperextendsBaseMapper<User> {
}

packagecom.baomidou.mybatisplus.samples.typehandler.config;
importcom.baomidou.mybatisplus.extension.handlers.GsonTypeHandler;
importcom.baomidou.mybatisplus.extension.handlers.JacksonTypeHandler;
importcom.fasterxml.jackson.databind.ObjectMapper;
importcom.google.gson.Gson;
importorg.springframework.boot.CommandLineRunner;
importorg.springframework.stereotype.Component;
/*** @author miemie* @since 2019-11-28*/@ComponentpublicclassMpJsonConfigimplementsCommandLineRunner {
/*** 可以set进去自己的*/@Overridepublicvoidrun(String... args) throwsException {
JacksonTypeHandler.setObjectMapper(newObjectMapper());
GsonTypeHandler.setGson(newGson());
    }
}

packagecom.baomidou.mybatisplus.samples.typehandler;
importjavax.annotation.Resource;
importorg.junit.Test;
importorg.junit.runner.RunWith;
importorg.springframework.boot.test.context.SpringBootTest;
importorg.springframework.test.context.junit4.SpringRunner;
importcom.baomidou.mybatisplus.samples.typehandler.entity.User;
importcom.baomidou.mybatisplus.samples.typehandler.mapper.UserMapper;
/*** <p>* 内置 类型处理器 演示* </p>** @author hubin* @since 2018-08-11*/@RunWith(SpringRunner.class)
@SpringBootTestpublicclassSampleTest {
@ResourceprivateUserMapperuserMapper;
/*** 自定义类型处理器演示参考 mybatis-plus-sample-deluxe 模块*/@Testpublicvoidtest() {
UserJone=userMapper.selectById(1);
System.out.println(Jone);
System.err.println(Jone.getName());
UserJack=userMapper.selectById(1);
System.err.println(Jack.getName());
    }
}

2020-11-2212:46:58.164INFO3168--- [           main] c.b.m.samples.typehandler.SampleTest     : StartedSampleTestin4.125seconds (JVMrunningfor5.707)
2020-11-2212:46:58.477DEBUG3168--- [           main] c.b.m.s.t.mapper.UserMapper.selectById   : ==>Preparing: SELECTid,name,age,email,wallet,other_infoFROMuserWHEREid=?2020-11-2212:46:58.509DEBUG3168--- [           main] c.b.m.s.t.mapper.UserMapper.selectById   : ==>Parameters: 1(Integer)
2020-11-2212:46:58.713DEBUG3168--- [           main] c.b.m.s.t.mapper.UserMapper.selectById   : <==Total: 1User(id=1, name=Jone, age=18, email=test1@baomidou.com, wallet=Wallet(name=支付宝钱包, currencyList=[Currency(type=USD, amount=999.19), Currency(type=RMB, amount=1000.19)]), otherInfo=OtherInfo(sex=男, city=南昌))
2020-11-2212:46:58.715DEBUG3168--- [           main] c.b.m.s.t.mapper.UserMapper.selectById   : ==>Preparing: SELECTid,name,age,email,wallet,other_infoFROMuserWHEREid=?2020-11-2212:46:58.715DEBUG3168--- [           main] c.b.m.s.t.mapper.UserMapper.selectById   : ==>Parameters: 2(Integer)
2020-11-2212:46:58.716DEBUG3168--- [           main] c.b.m.s.t.mapper.UserMapper.selectById   : <==Total: 1User(id=2, name=Jack, age=20, email=test2@baomidou.com, wallet=Wallet(name=微信钱包, currencyList=[Currency(type=USD, amount=888.18), Currency(type=RMB, amount=1000.18)]), otherInfo=OtherInfo(sex=男, city=青岛))
2020-11-2212:46:58.736INFO3168--- [extShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1-Shutdowninitiated...
2020-11-2212:46:58.747INFO3168--- [extShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1-Shutdowncompleted.