java分页实现

首先是dataobject，项目是用的是SpringMVC

public class MbChannelExtensionDO  {
    private static final long serialVersionUID = 741231858441822688L;

    //========== properties ==========

	/**
	 * This property corresponds to db column <tt>ID</tt>.
	 */
	private String id;

	/**
	 * This property corresponds to db column <tt>BANK_NAME</tt>.
	 */
	private String bankName;

	/**
	 * This property corresponds to db column <tt>PRODUCT_TYPE</tt>.
	 */
	private String productType;

	/**
	 * This property corresponds to db column <tt>EXCHANGE_TYPE</tt>.
	 */
	private String exchangeType;

	/**
	 * This property corresponds to db column <tt>SIGN_VERIFY_ELE</tt>.
	 */
	private String signVerifyEle;

	/**
	 * This property corresponds to db column <tt>CHANNEL_ID</tt>.
	 */
	private String channelId;

	/**
	 * This property corresponds to db column <tt>GMT_CREATE</tt>.
	 */
	private Date gmtCreate;

	/**
	 * This property corresponds to db column <tt>CREATOR</tt>.
	 */
	private String creator;

	/**
	 * This property corresponds to db column <tt>GMT_MODIFIED</tt>.
	 */
	private Date gmtModified;

	/**
	 * This property corresponds to db column <tt>UPDATOR</tt>.
	 */
	private String updator;

	/**
	 * This property corresponds to db column <tt>STATUS</tt>.
	 */
	private String status;

    //========== getters and setters ==========

    /**
     * Getter method for property <tt>id</tt>.
     *
     * @return property value of id
     */
	public String getId() {
		return id;
	}
	
	/**
	 * Setter method for property <tt>id</tt>.
	 * 
	 * @param id value to be assigned to property id
     */
	public void setId(String id) {
		this.id = id;
	}

    /**
     * Getter method for property <tt>BANK_NAME</tt>.
     *
     * @return property value of bankName
     */
	public String getBankName() {
		return bankName;
	}
	
	/**
	 * Setter method for property <tt>BANK_NAME</tt>.
	 * 
	 * @param bankName value to be assigned to property bankName
     */
	public void setBankName(String bankName) {
		this.bankName = bankName;
	}

    /**
     * Getter method for property <tt>PRODUCT_TYPE</tt>.
     *
     * @return property value of productTYPE
     */
	public String getProductType() {
		return productType;
	}
	
	/**
	 * Setter method for property <tt>PRODUCT_TYPE</tt>.
	 * 
	 * @param productType value to be assigned to property productType
     */
	public void setProductType(String productType) {
		this.productType = productType;
	}

	/**
	 * Getter method for property <tt>SIGN_VERIFY_ELE</tt>.
	 *
	 * @return property value of signVerifyEle
	 */
	public String getSignVerifyEle() {
		return signVerifyEle;
	}

	/**
	 * Setter method for property <tt>SIGN_VERIFY_ELE</tt>.
	 *
	 * @param signVerifyEle value to be assigned to property signVerifyEle
	 */
	public void setSignVerifyEle(String signVerifyEle) {
		this.signVerifyEle = signVerifyEle;
	}

    /**
     * Getter method for property <tt>EXCHANGE_TYPE</tt>.
     *
     * @return property value of signVerifyEle
     */
    public String getExchangeType() {
        return exchangeType;
    }

    /**
     * Setter method for property <tt>EXCHANGE_TYPE</tt>.
     *
     * @param exchangeType value to be assigned to property exchangeType
     */
    public void setExchangeType(String exchangeType ) { this.exchangeType = exchangeType;}
    /**
     * Getter method for property <tt>channelId</tt>.
     *
     * @return property value of channelId
     */
	public String getChannelId() {
		return channelId;
	}
	
	/**
	 * Setter method for property <tt>channelId</tt>.
	 * 
	 * @param channelId value to be assigned to property channelId
     */
	public void setChannelId(String channelId) {
		this.channelId = channelId;
	}

    /**
     * Getter method for property <tt>gmtCreate</tt>.
     *
     * @return property value of gmtCreate
     */
	public Date getGmtCreate() {
		return gmtCreate;
	}
	
	/**
	 * Setter method for property <tt>gmtCreate</tt>.
	 * 
	 * @param gmtCreate value to be assigned to property gmtCreate
     */
	public void setGmtCreate(Date gmtCreate) {
		this.gmtCreate = gmtCreate;
	}

    /**
     * Getter method for property <tt>creator</tt>.
     *
     * @return property value of creator
     */
	public String getCreator() {
		return creator;
	}
	
	/**
	 * Setter method for property <tt>creator</tt>.
	 * 
	 * @param creator value to be assigned to property creator
     */
	public void setCreator(String creator) {
		this.creator = creator;
	}

    /**
     * Getter method for property <tt>gmtModified</tt>.
     *
     * @return property value of gmtModified
     */
	public Date getGmtModified() {
		return gmtModified;
	}
	
	/**
	 * Setter method for property <tt>gmtModified</tt>.
	 * 
	 * @param gmtModified value to be assigned to property gmtModified
     */
	public void setGmtModified(Date gmtModified) {
		this.gmtModified = gmtModified;
	}

    /**
     * Getter method for property <tt>updator</tt>.
     *
     * @return property value of updator
     */
	public String getUpdator() {
		return updator;
	}
	
	/**
	 * Setter method for property <tt>updator</tt>.
	 * 
	 * @param updator value to be assigned to property updator
     */
	public void setUpdator(String updator) {
		this.updator = updator;
	}

    /**
     * Getter method for property <tt>status</tt>.
     *
     * @return property value of status
     */
	public String getStatus() {
		return status;
	}
	
	/**
	 * Setter method for property <tt>status</tt>.
	 * 
	 * @param status value to be assigned to property status
     */
	public void setStatus(String status) {
		this.status = status;
	}

接着是使用分页的Page类

public class PageDO {
    /**
     * 总条数
     */
    private int totalNumber;
    /**
     * 当前第几页
     */
    private int currentPage;
    /**
     * 总页数
     */
    private int totalPage;
    /**
     * 每页显示条数
     */
    private int pageNumber = 10;

    /**
     * 根据当前对象中属性值计算并设置相关属性值
     */
    public void count() {
        // 计算总页数
        int totalPageTemp = this.totalNumber / this.pageNumber;
        int plus = (this.totalNumber % this.pageNumber) == 0 ? 0 : 1;
        totalPageTemp = totalPageTemp + plus;
        if(totalPageTemp <= 0) {
            totalPageTemp = 1;
        }
        this.totalPage = totalPageTemp;

        // 设置当前页数
        // 总页数小于当前页数，应将当前页数设置为总页数
        if(this.totalPage < this.currentPage) {
            this.currentPage = this.totalPage;
        }
        // 当前页数小于1设置为1
        if(this.currentPage < 1) {
            this.currentPage = 1;
        }

    }

    public int getTotalNumber() {
        return totalNumber;
    }

    public void setTotalNumber(int totalNumber) {
        this.totalNumber = totalNumber;
        this.count();
    }

    public int getCurrentPage() {
        return currentPage;
    }

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

    public int getTotalPage() {
        return totalPage;
    }

    public void setTotalPage(int totalPage) {
        this.totalPage = totalPage;
    }

    public int getPageNumber() {
        return pageNumber;
    }

    public void setPageNumber(int pageNumber) {
        this.pageNumber = pageNumber;
        this.count();
    }
}

DAO层实现分页的两个方法

 /**
     *  select  <tt>MbChannelExtensionDO</tt> object by page to DB table <tt>MB_CHANNEL_EXTENSION</tt>, return primary key
     *
     *  <p>
     *  The sql statement for this operation is <br>
     *  <tt>select * from MB_CHANNEL_EXTENSION where id not in(select id from MB_CHANNEL_EXTENSION
     *  where rownum<=(PAGESIZE*(CURRENTPAGE-1))) and rownum<=PAGESIZE order by id; </tt>
     *
     *	@param page,mbChannelExtension
     *	@return List<MbChannelExtensionDO>
     *	@throws DataAccessException
     */
    @Override
    public List<MbChannelExtensionDO> getMbChannelExtensionByPage(MbChannelExtensionDO mbChannelExtensionDO,PageDO page) throws DataAccessException {
        if (page == null) {
            throw new IllegalArgumentException("Can't select by a null page.");
        }
        Map map=new HashMap();
        map.put("page",page);
        map.put("mbChannelExtension",mbChannelExtensionDO);
        return getSqlMapClientTemplate().queryForList("MS-MB-CHANNEL-EXTENSION-SELECT-BY-PAGE", map);
    }

    @Override
    public int countOfMbChannelExtension(MbChannelExtensionDO mbChannelExtensionDO ) throws DataAccessException {

        int count=(Integer)getSqlMapClientTemplate().queryForObject("MS-MB-CHANNEL-EXTENSION-COUNT",mbChannelExtensionDO);
        return count;
    }

以下是mybatis的mapping文件 

</pre><pre name="code" class="html" style="font-size: 11.8181819915771px;"><select id="MS-MB-CHANNEL-EXTENSION-SELECT-BY-PAGE" parameterClass="java.util.Map" resultMap="RM-MB-CHANNEL-EXTENSION">
        select
            *
        from
            MB_CHANNEL_EXTENSION
        where
            id
        not in
        (
            select
                id
            from
                MB_CHANNEL_EXTENSION
            where 1=1

                AND
                rownum
                  <![CDATA[ <=]]>
                (
                    #page.pageNumber#*(#page.currentPage#-1)
                )
        )
        <dynamic>
            <isNotEmpty prepend="AND" property="mbChannelExtension.bankName">
                BANK_NAME=#mbChannelExtension.bankName#
            </isNotEmpty>
            <isNotEmpty prepend="AND" property="mbChannelExtension.productType">
                PRODUCT_TYPE=#mbChannelExtension.productType#
            </isNotEmpty>
            <isNotEmpty prepend="AND" property="mbChannelExtension.exchangeType">
                EXCHANGE_TYPE=#mbChannelExtension.exchangeType#
            </isNotEmpty>
        </dynamic>
        and rownum
        <![CDATA[ <=]]> #page.pageNumber#
        order by
            id
    </select>


    <select id="MS-MB-CHANNEL-EXTENSION-COUNT" resultClass="java.lang.Integer">
        select count(ID)
        from
        MB_CHANNEL_EXTENSION
        where 1=1
        <dynamic>
            <isNotEmpty prepend="AND" property="bankName">
                BANK_NAME=#bankName#
            </isNotEmpty>
            <isNotEmpty prepend="AND" property="productType">
                PRODUCT_TYPE=#productType#
            </isNotEmpty>
            <isNotEmpty prepend="AND" property="exchangeType">
                EXCHANGE_TYPE=#exchangeType#
            </isNotEmpty>
        </dynamic>
<p>    </select></p><div>
</div>

以下是controller层

  @RequestMapping("/channlExtension")
    public String selectCustomer(MbChannelExtensionDO customer,PageDO page,
                                 HttpServletRequest request) {
        if(page==null){
            page=new PageDO();
            page.setPageNumber(1);
            page.count();
        }
        MbChannelExtensionDO channelExtension = new MbChannelExtensionDO();
        channelExtension = customer;
        page.setTotalNumber(channelExtensionService.countOfMbChannelExtension(customer));
        this.tcustomerList  = this.channelExtensionService.getMbChannelExtensionByPage(customer,page);
        request.setAttribute("tcustomerList", tcustomerList);
        request.setAttribute("page",page);
        request.setAttribute("channelExtension",channelExtension);
        return "/channlExtension/channlExtension";
    }

前端html和js

<form name ="frm" id="mainForm" method="post" action="<%=request.getContextPath()%>/channlExtension.html">
            <div class='page fix' style="text-align: end;margin:5px 30px 20px 30px;">
                共 <b>${page.totalNumber}</b> 条
                <c:if test="${page.currentPage != 1}">
                    <a href="javascript:changeCurrentPage('1')" class='first'>首页</a>
                    <a href="javascript:changeCurrentPage('${page.currentPage-1}')" class='pre'>上一页</a>
                </c:if>
                当前第<span>${page.currentPage}/${page.totalPage}</span>页
                <c:if test="${page.currentPage != page.totalPage}">
                    <a href="javascript:changeCurrentPage('${page.currentPage+1}')" class='next'>下一页</a>
                    <a href="javascript:changeCurrentPage('${page.totalPage}')" class='last'>末页</a>
                </c:if>
                跳至 <input id="currentPageText" name="currentPage" type='text' value='${page.currentPage}' class='allInput w28' /> 页 
                <a href="javascript:changeCurrentPage($('#currentPageText').val())" class='go'>GO</a>
            </div>
</form>

<script type="text/javascript">
    function changeCurrentPage(currentPage) {
        $("#currentPageText").val(currentPage);
        $("#mainForm").submit();
    }
</script>