PageHelper分页使用

PageHelper

1.获取总页数写法
Integer pageNum = 1, pageSize = 3000, pageCount = (totalNum + pageSize - 1) / pageSize;

oracle分页
下面的分页规律可以自行获取值来传参查询

–分页规律总结：每页显示m条数据，查询第n页数据
select * from (select rownum r,e. * from 要分页的表 e where rownum<=mn) t where r>mn-m ;

2.接口分页例子
PageHelper和PageInfo为包，根据当前页和页数大小，获取总页数，及返回数据，将pages总页数及list返回数据大小加入到返回实体类里

	PageHelper.startPage(pageNum, pageSize);
			List<WxWlLlqr> data = wxWlLlqrService.selectWxWlLlqrList(wxWlLlqr);
			PageInfo<WxWlLlqr> info = new PageInfo<>(data);
			List<WxWlLlqr> list = info.getList();
			Integer pages = info.getPages();
			ResponseObject<WxWlLlqr> resObj = new ResponseObject<>();
			resObj.setPages(pages);
			resObj.setList(list);
			result.setResponseObject(resObj);

			result.setMessageCode("1");
			result.setMessageDescription("成功");

3.分页实体类 pages总页数，list为查询数据
用泛型好处可以代码的复用，传任一一种类型

public class ResponseObject<T> {

	private Integer pages;

	private String lcslid;

	private String lltldid;

	private String lldid;

	private Integer lastNode;

	private List<T> list;

	List<WxWlLlTld> resList;

	public Integer getLastNode() {
		return lastNode;
	}

	public void setLastNode(Integer lastNode) {
		this.lastNode = lastNode;
	}

	public List<WxWlLlTld> getResList() {
		return resList;
	}

	public void setResList(List<WxWlLlTld> resList) {
		this.resList = resList;
	}

	public String getLldid() {
		return lldid;
	}

	public void setLldid(String lldid) {
		this.lldid = lldid;
	}

	public String getLltldid() {
		return lltldid;
	}

	public void setLltldid(String lltldid) {
		this.lltldid = lltldid;
	}

	public String getLcslid() {
		return lcslid;
	}

	public void setLcslid(String lcslid) {
		this.lcslid = lcslid;
	}

	public Integer getPages() {
		return pages;
	}

	public void setPages(Integer pages) {
		this.pages = pages;
	}

	public List<T> getList() {
		return list;
	}

	public void setList(List<T> list) {
		this.list = list;
	}
}

4.返回对象基类，可以包含错误提示
同理泛型的好处可以返回任一类型

public class BasePadResponse<T> {
	
	/**
	 * 信息代码
	 */
	private String messageCode;
	/**
	 * 返回信息
	 */
	private String messageDescription;
	
	/**
	 * 返回对象
	 */
	T responseObject;

	public String getMessageCode() {
		return messageCode;
	}

	public void setMessageCode(String messageCode) {
		this.messageCode = messageCode;
	}

	public String getMessageDescription() {
		return messageDescription;
	}

	public void setMessageDescription(String messageDescription) {
		this.messageDescription = messageDescription;
	}

	public T getResponseObject() {
		return responseObject;
	}

	public void setResponseObject(T responseObject) {
		this.responseObject = responseObject;
	}
	
	
	
}