mybatis 分页插件使用

引入插件

<dependency>
     <groupId>com.github.pagehelper</groupId>
     <artifactId>pagehelper-spring-boot-starter</artifactId>
     <version>1.2.3</version>
</dependency>

插件参数配置

pagehelper:
  helper-dialect: mysql
  reasonable: true
  support-methods-arguments: true
  params: count=countsql

使用

• 语句中不需要使用limit,插件自动增加

        select
        <include refid="Base_Column_List" />
        from `t_report_template`
        where 1=1
        and data_state != 'DELETED'
        <if test="reportName!=null and reportName!=''">
            and report_name = #{reportName,jdbcType=VARCHAR}
        </if>
        <if test="personId!=null and personId!=''">
            and person_id =  #{personId,jdbcType=VARCHAR}
        </if>
        <if test="startTime!=null">
            AND  <![CDATA[ create_time >= #{startTime,jdbcType=TIMESTAMP} ]]>
        </if>
        <if test="endTime!=null">
            AND  <![CDATA[ create_time <= #{endTime,jdbcType=TIMESTAMP} ]]>
        </if>
        order by  create_time desc

• mapper写法

    /**
     * 查询模板列表
     *
     * @param params 参数
     * @return 结果
     */
    List<TemplateDto> queryTemplates(ReportRequest params);

• dao实现类

    @Override
    public PageInfo<TemplateDto>  queryTemplates(ReportRequest request) {
        if (request == null) {
            return null;
        }
        int currentPage = request.getCurrentPage();
        int pageSize = request.getPageSize();
        PageHelper.startPage(currentPage,pageSize);
        List<TemplateDto> templateDtoList = templateMapper.queryTemplates(request);
        return new PageInfo<>(templateDtoList);
    }