3.MyBatis-Plus物理分页
配置类
package com.example.wx_test.config;
import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
@Configuration
public class MybatisPlusConfig {
@Bean
public PaginationInterceptor paginationInterceptor(){
return new PaginationInterceptor();
}
}
分页查询
展示第一页数据
@Test
public void selectByQueryWrapperWithPage1(){
QueryWrapper<Employee> queryWrapper=new QueryWrapper();
queryWrapper.gt("salary",3000).like("name","小");
Page<Employee> page = new Page<>(1,3);//当前页的页码1,每页3条记录
IPage<Employee> employeePage = employeeMapper.selectPage(page,queryWrapper);
System.out.println("总记录数:"+employeePage.getTotal());
System.out.println("总页数"+employeePage.getPages());
System.out.println("当前页数据"+employeePage.getRecords());
}
展示第二页数据
@Test
public void selectByQueryWrapperWithPage2(){
QueryWrapper<Employee> queryWrapper=new QueryWrapper();
queryWrapper.gt("salary",3000).like("name","小");
Page<Employee> page = new Page<>(2,3);//当前页的页码1,每页3条记录
IPage<Employee> employeePage = employeeMapper.selectPage(page,queryWrapper);
System.out.println("总记录数:"+employeePage.getTotal());
System.out.println("总页数"+employeePage.getPages());
System.out.println("当前页数据"+employeePage.getRecords());
}