手写分页方法

分页方法

• 前端传过来的pageSize、currentPage
  calculatePageCount()是计算分页的方法

public class PageInfo implements Serializable
{
	public static final int DEFAULT_PAGE_SIZE = 20;

	private int rowCount	= 0;
	//当前页数
	private int currentPage	= 1;
	//页面大小 默认20条一页
	private int pageSize	= DEFAULT_PAGE_SIZE;
	private int pageCount	= 0;
	//分页总条数
	private int totalCount	= 0;
	private String orderBy;

//计算分页方法
	public int calculatePageCount()
	{
		pageCount = totalCount / pageSize + ((totalCount % pageSize == 0) ? 0 : 1);
		
		if(currentPage < pageCount)
			rowCount = pageSize;
		else if(currentPage == pageCount)
			rowCount = totalCount - (pageCount - 1) * pageSize;
		
		return pageCount;
	}
	
	@JSONField(serialize = false)
	public boolean isOutofBounds()
	{
		return currentPage > pageCount || currentPage < 1;
	}
	
	@JSONField(serialize = false)
	public int getLimitStart()
	{
		return (currentPage - 1) * pageSize;
	}

	public int getRowCount()
	{
		return rowCount;
	}

	public void setRowCount(int rowCount)
	{
		this.rowCount = rowCount;
	}

	public int getCurrentPage()
	{
		return currentPage;
	}

	public void setCurrentPage(int currentPage)
	{
		this.currentPage = currentPage;
	}

	public int getPageSize()
	{
		return pageSize;
	}

	public void setPageSize(int pageSize)
	{
		this.pageSize = pageSize;
	}

	public int getPageCount()
	{
		return pageCount;
	}

	public void setPageCount(int pageCount)
	{
		this.pageCount = pageCount;
	}

	public int getTotalCount()
	{
		return totalCount;
	}

	public void setTotalCount(int totalCount)
	{
		this.totalCount = totalCount;
	}

	public String getOrderBy()
	{
		return orderBy;
	}

	public void setOrderBy(String orderBy)
	{
		this.orderBy = orderBy;
	}

}

使用

入参用pageInfo接收。count要从SQL查，查出总条数，方便
calculatePageCount()计算total。

 		PageInfo pageInfo = request.getPageInfo();
        pageInfo.setTotalCount(count);
        //计算total
        pageInfo.calculatePageCount();
        response.setPage(pageInfo);

还需要单独写个sql 传参limit 0,1这种，去分页查询数据。

总结

平常我们都用的是pageHelper，非常方便。我也是之前都用的这个开源的分页工具。其实pageHelper也是会通过sql计算count总数，也会去limit。