mybatis分页插件进行拦截sql分页

1. 导包我使用的4.1.0

		<dependency>
			<groupId>com.github.pagehelper</groupId>
			<artifactId>pagehelper</artifactId>
			<version>4.1.0</version>
		</dependency>

2. 提供配置类

public class QueryCondition implements Serializable {

	private static final long serialVersionUID = -7247558539475199838L;

	private Integer pageNum =1; // 页码
	private Integer pageSize =10;// 每页显示数量
	private String memberName;
	
	public Integer getPageNum() {
		return pageNum;
	}

	public void setPageNum(Integer pageNum) {
		this.pageNum = pageNum;
	}

	public Integer getPageSize() {
		return pageSize;
	}

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

	public String getMemberName() {
		return memberName;
	}

	public void setMemberName(String memberName) {
		this.memberName = memberName;
	}

}

3. 实际操作

@RequestMapping(value = "/query", produces = "text/json;charset=UTF-8",
		method = RequestMethod.GET)
	@ResponseBody
	public ServerResponse query(QueryCondition qc, Model model) {
			// 判断是否传值页码
		if (qc.getPageNum() == null) {
			qc.setPageNum(1);
		}
		qc.setPageSize(10); // 每页显示数量
		PageHelper.startPage(qc.getPageNum(), qc.getPageSize(), true);
		List<xxxxx> list = xxxxx.query();
		// 将查询出来的所有数据扔给PageInfo
		PageInfo<xxxxx> pageInfo = new PageInfo<xxxxx>(list);
		System.out.println("分页："+pageInfo);
		model.addAttribute("pageInfo", pageInfo);
		return ServerResponse.createBySuccess("", pageInfo);
	}