Myba…

MyBatis没有任何第三方依赖、没有任何拦截器在执行的过程中没有任何的

Sql

这带来了几个好处极高的性能、极易对代码进行跟踪和调试、把控性更高。

灵活支持

Entity

dependenciesdependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-web/artifactId/dependency!--1.数据库驱动--dependencygroupIdcom.mysql/groupIdartifactIdmysql-connector-j/artifactIdscoperuntime/scope/dependency!--

数据库连接池组件--dependencygroupIdcom.zaxxer/groupIdartifactIdHikariCP/artifactId/dependency!--2.lombok--dependencygroupIdorg.projectlombok/groupIdartifactIdlombok/artifactId/dependency!--3.mybatis-flex--dependencygroupIdcom.mybatis-flex/groupIdartifactIdmybatis-flex-spring-boot-starter/artifactIdversion1.5.4/version/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-test/artifactIdscopetest/scope/dependency/dependencies

2.4

8需要增加时区的配置serverTimezoneUTC放在url最后

#useSSLfalse

spring.datasource.urljdbc:mysql://localhost:3306/mybatis_plus?serverTimezoneUTCuseUnicodetruecharacterEncodingutf-8

spring.datasource.driver-class-namecom.mysql.cj.jdbc.Driver

Mybatis-Flex

路径src/main/java/com/yinyu/flex/pojo/User.java

User

com.mybatisflex.annotation.KeyType;

import

com.mybatisflex.annotation.Table;

import

路径src/main/java/com/yinyu/flex/mapper/UserMapper.java

package

com.mybatisflex.core.BaseMapper;

import

org.springframework.stereotype.Repository;Repository//代表持久层

public

路径src/main/java/com/yinyu/flex/MybatisFlexApplication.java

用于扫描

org.mybatis.spring.annotation.MapperScan;

import

org.springframework.boot.SpringApplication;

import

org.springframework.boot.autoconfigure.SpringBootApplication;SpringBootApplication

MapperScan(com.yinyu.flex.mapper)

public

{SpringApplication.run(MybatisFlexApplication.class,

args);}}

路径src/test/java/com/yinyu/flex/MybatisFlexApplicationTests.java

使用测试类进行测试~

com.yinyu.flex.mapper.UserMapper;

import

org.springframework.beans.factory.annotation.Autowired;

import

org.springframework.boot.test.context.SpringBootTest;

import

{//继承了BaseMapper所有的方法都来自父类我们也可以编写自己的扩展方法Autowiredprivate

UserMapper

userMapper.selectAll();users.forEach(System.out::println);}

输出成功

com.yinyu.flex.pojo.table.UserTableDef.USER;

...

QueryWrapper.create().select().where(USER.AGE.eq(18));User

account

userMapper.selectOneByQuery(queryWrapper);System.out.println(account);}

...

QueryWrapper.create().where(EMPLOYEE.LAST_NAME.like(searchWord))

//条件为null时自动忽略.and(EMPLOYEE.GENDER.eq(1)).and(EMPLOYEE.AGE.gt(24));

ListEmployee

employeeMapper.selectListByQuery(query);

MyBatis-Plus

Wrappers.query().like(searchWord

null,

employeeMapper.selectList(queryWrapper);//lambda

queryWrapper

Wrappers.EmployeelambdaQuery().like(StringUtils.isNotEmpty(searchWord),

Employee::getUserName,B).eq(Employee::getGender,

24);

employeeMapper.selectList(queryWrapper);

4.2

QueryWrapper.create().select(ACCOUNT.ID,ACCOUNT.USER_NAME,max(ACCOUNT.BIRTHDAY),avg(ACCOUNT.SEX).as(sex_avg));

ListEmployee

employeeMapper.selectListByQuery(query);

MyBatis-Plus

Wrappers.query().select(id,user_name,max(birthday),avg(birthday)

sex_avg);

employeeMapper.selectList(queryWrapper);

IDE

QueryWrapper.create().where(ACCOUNT.ID.ge(100)).and(ACCOUNT.SEX.eq(1).or(ACCOUNT.SEX.eq(2))).or(ACCOUNT.AGE.in(18,

19,

20).and(ACCOUNT.USER_NAME.like(michael)));

MyBatis-Plus

Wrappers.EmployeelambdaQuery().ge(Employee::getId,

100).and(i

20).like(Employee::getUserName,

michael));

QueryWrapper.create().select().from(ACCOUNT).leftJoin(ARTICLE).on(ACCOUNT.ID.eq(ARTICLE.ACCOUNT_ID)).where(ACCOUNT.AGE.ge(10));ListAccount

accounts

mapper.selectListByQuery(query);

MyBatis-Plus不支持

.where(ACCOUNT.ID.eq(ARTICLE.ACCOUNT_ID));

MyBatis-Plus不支持

UpdateEntity.of(Account.class);

account.setId(100);

account.setBirthday(null);accountMapper.update(account);

MyBatis-Plus

null);accountMapper.update(null,

updateWrapper);