mybatis--分页

APIImpl
@Override
    public Pagination<Goods> getGoodsListByPager(Pagination<Goods> pager,List<String> gcList) {
        // TODO Auto-generated method stub
        List<Goods> goods = goodsDAO.getGoodsListByPager(pager,
                pager.getCondition(), gcList);
        Long size = goodsDAO.getGoodsListByPagerCount(pager.getCondition(),gcList);
        pager.setRows(goods);
        pager.setTotal(size.intValue());
        return pager;
    }

Dao层
/**
     * 
     * @param gcList // 分类ID集合
     * @return 商品搜索查询接口开发
     */
    public List<Goods> getGoodsListByPager(
            @Param("pager") Pagination<Goods> pager, @Param("goods") Goods goods,@Param("param1")List<String> gcList);

    /**
     * 商品条数
     * 
     * @param goods
     * @return
     */
    public Long getGoodsListByPagerCount(@Param("goods") Goods goods,@Param("param1")List<String> gcList);

Mybatis

<sql id="pagination_Head">
        <![CDATA[select * from (  ]]>
    </sql>
    <!-- oracle 分页尾 -->
    <sql id="pagination_Tail">
           <![CDATA[ )rows limit #{pager.startIndex},#{pager.pageSize}]]>
    </sql>
    <!-- count * from -->
    <sql id="count_Head">
        <![CDATA[select count(*) from ( ]]>
</sql>
<select id="getGoodsListByPager" resultMap="goodsMap">
        <include refid="pagination_Head" />
        <include refid="searchGoods_fragement" /> <!-- 代码片段 -->
        <include refid="pagination_Tail" />
    </select>
   <select id="getGoodsListByPagerCount" resultType="long">
        <include refid="count_Head" />
        <include refid="searchGoods_fragement" />
        <include refid="count_Tail" />
</select>

package com.XXX.common.page;

import java.io.Serializable;

public class SimplePage implements Serializable {
	
	private static final long serialVersionUID = 1L;

	public static final int DEF_COUNT = 20;
	
	protected int total = 0; // 数据总量
	protected int pageSize = 20; // 每页数据数量
	protected int pageNumber = 1; // 页码
	protected int startIndex = 0; // 每页开始序号
	
	public static int checkPageNo(Integer pageNumber) {
		return (pageNumber == null || pageNumber < 1) ? 1 : pageNumber;
	}
	
	public SimplePage() {
		
	}
	
	public SimplePage(int pageNumber, int pageSize, int total) {
		setTotal(total);
		setPageSize(pageSize);
		setPageNo(pageNumber);
		adjustPageNo();
	}
	
	/**
	 * 调整页码，使其不超过最大页数
	 */
	public void adjustPageNo() {
		if (pageNumber == 1) {
			return;
		}
		int totalPage = getTotalPage();
		if (pageNumber > totalPage) {
			pageNumber = totalPage;
		}
		startIndex = this.pageSize * (this.pageNumber - 1);
	}

	public int getTotal() {
		return total;
	}

	public int getPageSize() {
		return pageSize;
	}

	public int getPageNumber() {
		return pageNumber;
	}
	
	public int getStartIndex() {
		return startIndex;
	}
	
	public int getTotalPage() {
		int totlePage = total/pageSize;
		if(totlePage == 0 || total/pageSize != 0){
			totalPage ++;
		}
		return totalPage;

		int totalPage = total / pageSize;
		if (totalPage == 0 || total % pageSize != 0) {
			totalPage++;
		}
		return totalPage;
	}
	
	/**
	 * 是否第一页
	 * @return
	 */
	public boolean isFirstPage() {
		return pageNumber <= 1;
	}
	
	/**
	 * 是否最后一页
	 * @return
	 */
	public boolean isLastPage() {
		return pageNumber >= getTotalPage();
	}
	
	/**
	 * 下一页页码
	 * @return
	 */
	public int getNextPage() {
		if (isLastPage()) {
			return pageNumber;
		} else {
			return pageNumber + 1;        
		}
	}
	
	public int getPretPage() {
		if (isFirstPage()) {
			return pageNumber;
		} else {
			return pageNumber - 1;
		}
	}
	
	public void setTotal(int total) {
		if (total < 0) {
			this.total = 0;
		} else {
			this.total = total;
		}
	}
	
	public void setPageSize(Integer pageSize) {
		if (pageSize == null || pageSize < 1) {
			this.pageSize = DEF_COUNT;
		} else {
			this.pageSize = pageSize;
		}
		startIndex = this.pageSize * (this.pageNumber - 1);
	}
	
	public void setPageNo(Integer pageNumber) {
		if (pageNumber == null || pageNumber < 1) {
			this.pageNumber = 1;
		} else {
			this.pageNumber = pageNumber;
		}
		startIndex = this.pageSize * (this.pageNumber - 1);
	} 
}

package com.XXX.common.page;

import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;

public class Pagination<T> extends SimplePage implements Serializable {
	
	private static final long serialVersionUID = 1L;
	
	private String id;
	
	public Pagination() {
		
	}
	
	public Pagination(int pageNumber, int pageSize, int total) {
		super(pageNumber, pageSize, total);
	}
	
	public Pagination(int pageNumber, int pageSize, int total, List<?> rows) {
		super(pageNumber, pageSize, total);
		this.rows = rows;
	}
	
	public int getFirstResult() {
		return (pageNumber - 1) * pageSize;
	}
	
	private List<?> rows = new ArrayList();
	
	private T condition;
	
	private Integer sort;

	public List<?> getRows() {
		return rows;
	}

	public void setRows(List<?> rows) {
		this.rows = rows;
	}

	public T getCondition() {
		return condition;
	}

	public void setCondition(T condition) {
		this.condition = condition;
	}

	public Integer getSort() {
		return sort;
	}

	public void setSort(Integer sort) {
		this.sort = sort;
	}
	
	public String getId() {
		return id;
	}

	public void setId(String id) {
		this.id = id;
	}

	public final static String PAGE_CONDITION_CACHE = "PageCondition";
	public final static String PAGE_CURRENT_NO_CACHE = "PageCurrentNo";
	public final static String PAGE_SIZE_CACHE = "PageSize";
	public final static String PAGE_TOTAL_COUNT_CACHE = "PageTotalCount";
	public final static String PAGE_ALL_CONDITION_CACHE = "PageAllCondition";
}