Java实现手写分页

1.实现类

public ResponseResult<List<AppDO>> page(AppPageQueryDto appPageQueryDto) {
    //开始页
    Integer currentPage = appPageQueryDto.getPageNum();
    //每页条数
    Integer pageSize = appPageQueryDto.getPageSize();
    //查询总条数
    int count = appMapper.count(appPageQueryDto);
    //计算总页数
    int totalPage = (count + pageSize - 1) / pageSize;
    /**
     * Pagination
     * 当前页码 pageNum
     * 分页大小 pageSize
     * 总数目 totalSize
     * 总页数 totalPage
     **/
    Pagination pagination = PaginationUtils.buildPagination(count, totalPage, currentPage, pageSize);
    List<AppDO> appDOList = Lists.newArrayList();
    if (count > 0) {
        appPageQueryDto.setStartRow((currentPage - 1) * pageSize);
        //查询sql LIMIT #{startRow}, #{pageSize}
        appDOList = appMapper.queryPage(appPageQueryDto);
    }
    return ResponseResult.newSuccessResponse(appDOList, pagination);
}

2.mapper

 /**
  * @Author kuli
  * @Date 2022/3/4
  * @Descriptio 查询总个数
  * @Param
  * @Return
  **/
int count(AppPageQueryDto appPageQueryDto);

 /**
  * @Author kuli
  * @Date 2022/3/3
  * @Description 分页查询接口
  * @Param
  * @Return
  **/
 List<AppDO> queryPage(AppPageQueryDto appPageQueryDto);

3.mapper.xml

<parameterMap id="appDOParam" type="com.sj.devops.cmdb.dao.model.AppDO"></parameterMap>
<parameterMap id="appPageParam" type="com.sj.devops.cmdb.dao.model.query.AppPageQueryDto"></parameterMap>

<select id="queryPage" resultMap="BaseResultMap" parameterMap="appPageParam">
    SELECT
    <include refid="BaseColumns"/>
    FROM cmdb_application
    <include refid="whereCondition"/>
    ORDER BY date_created DESC
    LIMIT #{startRow}, #{pageSize}
</select>

<select id="count" resultType="java.lang.Integer" parameterMap="appPageParam">
    SELECT
    count(1)
    FROM cmdb_application
    <include refid="whereCondition"/>
</select>

<sql id="whereCondition">
    <trim prefix="WHERE" prefixOverrides="AND|OR">
        <if test="code!=null and code != ''">
            AND code = #{code}
        </if>
    </trim>
</sql>