MyBatis分页插件PageHelper的使用

1、需要引入PageHelper的jar包

<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper</artifactId>
    <version>4.1.4</version>
</dependency>

2、在mybatis的全局配置文件SqlMapConfig.xml中配置该插件

 

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <!-- 配置分页插件 -->
    <plugins>
        <plugin interceptor="com.github.pagehelper.PageHelper">
            <!-- 设置数据库类型 Oracle,Mysql,MariaDB,SQLite,Hsqldb,PostgreSQL六种数据库-->        
            
        </plugin>
    </plugins>

</configuration>

3、在执行sql前添加插件，完成分页功能

@RequestMapping(value = "view.json")
public CommonRes export(HttpServletRequest request,
                        HttpServletResponse response,
                        @RequestParam(value = "owner",required = false)String owner,
                        @RequestParam(value = "vaild",required = false)String vaild,
                        @RequestParam(value = "pageSize",defaultValue ="10",required = false)Integer pageSize,
                        @RequestParam(value = "pageNo",defaultValue = "1",required = false)Integer pageNo){
DutyArea dutyArea=new DutyArea();
dutyArea.setOwner(owner);
dutyArea.setValid(vaild);
PageHelper.startPage(pageNo, pageSize);
List<DutyArea> list=dutyAreaService.select(dutyArea);
PageInfo<DutyArea> pageInfo=new PageInfo<DutyArea>(list);
return CommonRes.success(pageInfo);
}
4、查看打印的sql