Springboot项目配置PageHelper分页插件

PageHelper简介：MyBatis分页插件
PageHelper GitHub托管地址
中文文档
目前支持：

Oracle
Mysql
MariaDB
SQLite
Hsqldb
PostgreSQL
DB2
SqlServer(2005,2008)
Informix
H2
SqlServer2012
Derby
Phoenix
达梦数据库(dm)
阿里云PPAS数据库
神通数据库
HerdDB

一、pom.xml

<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper</artifactId>
    <version>5.1.11</version>
</dependency>
<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper-spring-boot-autoconfigure</artifactId>
    <version>1.2.13</version>
</dependency>
<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper-spring-boot-starter</artifactId>
    <version>1.2.13</version>
</dependency>

二、yml配置文件

pagehelper:
  helperDialect: mysql
  # 分页合理化
  reasonable: false
  supportMethodsArguments: true
  # 是否执行count参数名
  params: count=countSql

三、代码示例

service层：

PageInfo<UserVO> pageInfo = PageHelper.startPage(pageNum, pageSize)
        .doSelectPageInfo(() -> userMapper.selectList(vo));

mapper层：

public interface UserMapper {

    List<UserVO> selectList(@Param("vo") ParamVO vo);

    /**
     * 配合selectList分页使用，接口方法可不写，xml中写具体实现SQL即可
     * @param vo
     * @return 记录总条数
     * @see com.github.pagehelper.PageInterceptor
     */
    Long selectList_COUNT(@Param("vo") ParamVO vo);

}

xml:

 	<!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        ${tbl}.id, ${tbl}.name, ${tbl}.create_time, ${tbl}.update_time
    </sql>

	<sql id="Condition">
        where 1=1
        <if test="vo.id != null">
            and ${tbl}.id = #{vo.id}
        </if>
        <if test="vo.name != null and vo.name != '' ">
            and ${tbl}.name = #{vo.name}
        </if>
        <if test="vo.create_time != null and vo.create_time != '' ">
            and ${tbl}.create_time >= STR_TO_DATE(#{vo.create_time}, '%Y-%c-%e')
        </if>
        <if test="vo.update_time != null and vo.update_time != '' ">
            and ${tbl}.update_time &lt; DATE_ADD(STR_TO_DATE(#{vo.update_time}, '%Y-%c-%e'),INTERVAL 1 DAY)
        </if>
    </sql>

    <select id="selectList" resultMap="BaseResultMap">
        select <include refid="Base_Column_List"><property name="tbl" value="t1"/></include>   
        from tbl_user t1
        <include refid="Condition"><property name="tbl" value="t1"/></include>
    </select>


	<!-- 多表关联自定义COUNT_SQL，提升查询效率，若是单表查询可不写，此处仅作为示例 -->
    <select id="selectList_COUNT" resultType="java.lang.Long">
        select count(0) from tbl_user t1
        <include refid="Condition"><property name="tbl" value="t1"/></include>
    </select>