博客

maven文件引用:

<!--分页插件pageHelper -->
		<dependency>
			<groupId>com.github.pagehelper</groupId>
			<artifactId>pagehelper-spring-boot-starter</artifactId>
			<!-- 特别注意版本问题 -->
			<version>${pagehelper.version}</version>
			<exclusions>
				<exclusion>
					<groupId>com.github.jsqlparser</groupId>
					<artifactId>jsqlparser</artifactId>
				</exclusion>
			</exclusions>
		</dependency>

Service层:

@Override
    public String findPage(ParamsDto dto) {
        PageHelper.startPage(dto.getStartPage(), dto.getPageSize());
        return ResultUtil.result(EnumCode.OK.getValue(),"设备分页查询成功",JSON.toJSON(new PageInfo<>(super.baseMapper.findAll())));
    }

参数返回示例:

{
    "flag": true,
    "message": "出库分页查询成功",
    "data": {
        "lastPage": 23,
        "navigatepageNums": [
            16,
            17,
            18,
            19,
            20,
            21,
            22,
            23
        ],
        "startRow": 20,
        "hasNextPage": true,
        "prePage": 19,
        "nextPage": 21,
        "endRow": 20,
        "pageSize": 1,
        "list": [
            {
                "foursID": "1",
                "printstate": "0",
                "classes": "XP",
                "encodingID": "",
                "outtime": null,
                "printtime": null,
                "outname": "",
                "outstate": "0",
                "outboundID": 194,
                "equipmentID": "442"
            }
        ],
        "pageNum": 20,
        "navigatePages": 8,
        "navigateFirstPage": 16,
        "total": 126,
        "pages": 126,
        "firstPage": 16,
        "size": 1,
        "isLastPage": false,
        "hasPreviousPage": true,
        "navigateLastPage": 23,
        "isFirstPage": false
    }
}

pagehelper返回参数详情:

	//当前页
    private int pageNum;
    //每页的数量
    private int pageSize;
    //当前页的数量
    private int size;
    //由于startRow和endRow不常用，这里说个具体的用法
    //可以在页面中"显示startRow到endRow 共size条数据"
    //当前页面第一个元素在数据库中的行号
    private int startRow;
    //当前页面最后一个元素在数据库中的行号
    private int endRow;
    //总记录数
    private long total;
    //总页数
    private int pages;
    //结果集
    private List<T> list;
    //前一页
    private int prePage;
    //下一页
    private int nextPage;
    //是否为第一页
    private boolean isFirstPage = false;
    //是否为最后一页
    private boolean isLastPage = false;
    //是否有前一页
    private boolean hasPreviousPage = false;
    //是否有下一页
    private boolean hasNextPage = false;
    //导航页码数
    private int navigatePages;
    //所有导航页号
    private int[] navigatepageNums;
    //导航条上的第一页
    private int navigateFirstPage;
    //导航条上的最后一页
    private int navigateLastPage;