MyBatis分页查询：MyBatis PageHelper

1. 添加Maven依赖

<!--MyBatis 分页插件: MyBatis PageHelper-->
<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper-spring-boot-starter</artifactId>
    <version>1.2.5</version>
</dependency>

2.controller层

/**
 * 分页查询
 * @param pageNum 记录页数
 * @param pageSize 单页记录数量
 * @return
 */
@ResponseBody
@RequestMapping("/findPage")
public List<Student> findPage(@RequestParam int pageNum, @RequestParam int pageSize) {
    // 设置分页查询参数
    PageHelper.startPage(pageNum,pageSize);
    List<Student> studentList = studentService.findList();		//mapper里面的sql不需要写limit,就按照不分页的sql写即可

    for(Student student : studentList) {
        System.out.println("element : " + student);
    }

    // 封装分页查询结果到 PageInfo 对象中以获取相关分页信息
    PageInfo<Student> pageInfo = new PageInfo<>(studentList);
    System.out.println("总页数: " + pageInfo.getPages());
    System.out.println("总记录数: " + pageInfo.getTotal());
    System.out.println("当前页数: " + pageInfo.getPageNum());
    System.out.println("当前页面记录数量: " + pageInfo.getSize());

    return pageInfo.getList();
    }

若依框架中使用

    public TableDataInfo selectXHJGeneralTableList(int pageNum, int pageSize) {
        PageHelper.startPage(pageNum, pageSize);
        List<XhjGeneralTable> xhjGeneralTableList = xhjGeneralTableMapper.selectXhjGeneralTable(new XhjGeneralTable());
        PageInfo<XhjGeneralTable> pageInfo = new PageInfo<>(xhjGeneralTableList);
        return new TableDataInfo(pageInfo.getList(), (int) pageInfo.getTotal());
    }