Mybatis和MybatisPlus使用分页插件

分页插件"/>

Mybatis和MybatisPlus使用分页插件

Mybatis分页

• 安装Pagehelper插件

    <dependency><groupId>com.github.pagehelper</groupId><artifactId>pagehelper-spring-boot-starter</artifactId><version>1.4.2</version></dependency>

• 分页查询

   public PageBean selectByPage(String name, Integer gender, LocalDate begin, LocalDate end, Integer page, Integer pageSize) {PageHelper.startPage(page, pageSize);// 执行分页查询List<Emp> empList = empMapper.selectEmps(name,gender,begin,end);// 获取分页结果Page<Emp> p = (Page<Emp>) empList;//封装PageBeanPageBean pageBean = new PageBean(p.getTotal(), p.getResult());return pageBean;
}

MybatisPlus分页

• 设置配置类

@Configuration
public class MybatisConfig {@Beanpublic MybatisPlusInterceptor mybatisPlusInterceptor(){//初始化核心插件MybatisPlusInterceptor interceptor=new MybatisPlusInterceptor();//添加分页插件PaginationInnerInterceptor paginationInnerInterceptor=new PaginationInnerInterceptor(DbType.MYSQL);//设置分页上线paginationInnerInterceptor.setMaxLimit(1000L);//添加插件interceptor.addInnerInterceptor(paginationInnerInterceptor);return interceptor;}
}

• 分页查询

    @Overridepublic void page(EmployeePageQueryDTO employeePageQueryDTO){//初始化Page<Employee> page=new Page<>(employeePageQueryDTO.getPage(),employeePageQueryDTO.getPageSize());//设置whereLambdaQueryWrapper<Employee> lambdaQueryWrapper=new LambdaQueryWrapper<>();lambdaQueryWrapper.like(StringUtils.hasLength(employeePageQueryDTO.getName()),Employee::getName,employeePageQueryDTO.getName());lambdaQueryWrapper.orderByDesc(Employee::getUpdateTime);lambdaQueryWrapper.orderByAsc(Employee::getCreateTime);//查询employeeMapper.selectPage(page,lambdaQueryWrapper);System.out.println(page.getTotal());System.out.println(page.getRecords());}