package com.wzy;import com.baomidou.mybatisplus.plugins.Page;import com.wzy.mapper.EmployeesMapper;import com.wzy.pojo.Employees;import org.junit.Test;import org.springframework.context.ApplicationContext;import org.springframework.context.support.ClassPathXmlApplicationContext;import java.util.List;public class testPage {//1.读取applicationContext.xmlprivate ApplicationContext applicationContext =new ClassPathXmlApplicationContext("applicationContext.xml");//2.根据applicationContext.xml配置文件与反射,获取 EmployeesMapper对象private EmployeesMapper employeesMapper =applicationContext.getBean("employeesMapper",EmployeesMapper.class);@Testpublic void test1(){Page<Employees> page = new Page<Employees>(1, 3);List<Employees> list = employeesMapper.selectPage(page, null);list.forEach(employee -> System.out.println(employee));System.out.println("总条数: " + page.getTotal());System.out.println("当前页码: " + page.getCurrent());System.out.println("总页码: " + page.getPages());System.out.println("每页显示的条数: " + page.getSize());System.out.println("是否有上一页: " + page.hasPrevious());System.out.println("是否有下一页: " + page.hasNext());//将查询结果封装为Page对象Page<Employees> employeesPage = page.setRecords(list);//将Page对象,转为list结果集List<Employees> records = employeesPage.getRecords();}}
输出结果:
Employees(id=1, lastName=Tom, email=tom@atguigu.com, gender=1, age=22) Employees(id=2, lastName=Jerry, email=jerry@atguigu.com, gender=0, age=25) Employees(id=3, lastName=Black, email=black@atguigu.com, gender=1, age=30) 总条数: 7 当前页码: 1 总页码: 3 每页显示的条数: 3 是否有上一页: false 是否有下一页: true
