MyBatis分页

先写个类，封装currentPage和pageSize；

public class PageCode {
	
	private int currentPage;
	
	private int pageSize;
	
	public PageCode(int currentPage,int pageSize) {
		this.currentPage = (currentPage-1)*pageSize;
		this.pageSize = pageSize;
	}
	
	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;
	}

}

xml映射语句：

<!--测试分页查询 -->
	<select id="selectExpectPages" parameterType="pageCode" resultType="User">
		select * from user limit #{currentPage},#{pageSize}
	</select>

接口：

public interface UserMapper {
    public List<User> selectExpectPages(PageCode pageCode);
}

test：

PageCode pageCode = new PageCode(2, 10);
		
List<User> pageContent = mapper.selectExpectPages(pageCode);
		
for (User user : pageContent) {
    system.out.println(user);
}