集成mybatis-plus
mysql
mysql-connector-java
com.baomidou
mybatis-plus-boot-starter
3.4.3.4
配置文件
#数据库连接
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8
spring.datasource.username=root
spring.datasource.password=root
插件配置(此处不配置会影响分页)
@Configuration
@MapperScan("com.wy.es.es.mapper*")
public class MybatisPlusConfig {
@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor() {
MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.H2));
return interceptor;
}
}
使用
QueryWrapper qw = new QueryWrapper();
//条件检索
qw.eq("username",username)
//页码和每页的大小
IPage page = new Page(pageNum,pageSize);
IPage result = userMapper.selectPage(page,qw);
