分頁應(yīng)該是在我們開發(fā)web應(yīng)用時經(jīng)常要做的工作，能夠比較簡潔的實現(xiàn)數(shù)據(jù)庫和視圖層的分頁十分重要。

在數(shù)據(jù)庫層利用Hibernate進(jìn)行數(shù)據(jù)庫的分頁，將從數(shù)據(jù)庫中查詢出的數(shù)據(jù)封裝為javabean；在視圖層就可以方便的實現(xiàn)分頁。

創(chuàng)建PageBean

package com.fishing.common.bean;  
 
import java.util.List;  
@SuppressWarnings("unchecked")  
public class PageBean {  
      
    private List list; // 要返回的某一頁的記錄列表  
 
    private int allRow; // 總記錄數(shù)  
    private int totalPage; // 總頁數(shù)  
    private int currentPage; // 當(dāng)前頁  
    private int pageSize; // 每頁記錄數(shù)  
 
      
    private boolean isFirstPage; // 是否為第一頁  
    private boolean isLastPage; // 是否為最后一頁  
    private boolean hasPreviousPage; // 是否有前一頁  
    private boolean hasNextPage; // 是否有下一頁  
 
    public List getList() {  
        return list;  
    }  
 
    public void setList(List list) {  
        this.list = list;  
    }  
 
    public int getAllRow() {  
        return allRow;  
    }  
 
    public void setAllRow(int allRow) {  
        this.allRow = allRow;  
    }  
 
    public int getTotalPage() {  
        return totalPage;  
    }  
 
    public void setTotalPage(int totalPage) {  
        this.totalPage = totalPage;  
    }  
 
    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;  
    }  
 
    /** */ 
    /**  
     * 初始化分頁信息  
     */ 
    public void init() {  
        this.isFirstPage = isFirstPage();  
        this.isLastPage = isLastPage();  
        this.hasPreviousPage = isHasPreviousPage();  
        this.hasNextPage = isHasNextPage();  
    }  
 
    /** */ 
    /**  
     * 以下判斷頁的信息,只需getter方法(is方法)即可  
     *   
     * @return  
     */ 
 
    public boolean isFirstPage() {      
        return (currentPage == 1);// 如是當(dāng)前頁是第1頁      
    }     
    public boolean isLastPage() {      
 return currentPage == totalPage; //如果當(dāng)前頁是最后一頁      
}     
    public boolean isHasPreviousPage() {      
 return currentPage != 1; //只要當(dāng)前頁不是第1頁      
}     
    public boolean isHasNextPage() {      
 return currentPage != totalPage; //只要當(dāng)前頁不是最后1頁      
}     
    /** */ 
    /**  
     * 計算總頁數(shù),靜態(tài)方法,供外部直接通過類名調(diào)用  
     *   
     * @param pageSize  
     *            每頁記錄數(shù)  
     * @param allRow  
     *            總記錄數(shù)  
     * @return 總頁數(shù)  
     */ 
    public static int countTotalPage(final int pageSize, final int allRow) {  
        int totalPage = allRow % pageSize == 0 ? allRow / pageSize : allRow  
                / pageSize + 1;  
        return totalPage;  
    }  
 
    /** */ 
    /**  
     * 計算當(dāng)前頁開始記錄  
     *   
     * @param pageSize  
     *            每頁記錄數(shù)  
     * @param currentPage  
     *            當(dāng)前第幾頁  
     * @return 當(dāng)前頁開始記錄號  
     */ 
    public static int countOffset(final int pageSize, final int currentPage) {  
        final int offset = pageSize * (currentPage - 1);  
        return offset;  
    }  
 
    /** */ 
    /**  
     * 計算當(dāng)前頁,若為0或者請求的URL中沒有"?page=",則用1代替  
     *   
     * @param page  
     *            傳入的參數(shù)(可能為空,即0,則返回1)  
     * @return 當(dāng)前頁  
     */ 
    public static int countCurrentPage(int page) {  
        final int curPage = (page == 0 ? 1 : page);  
        return curPage;  
    }  
}  

在Dao的抽象接口BaseDao中添加方法

public List queryForPage(final String hql, final int offset,  
            final int length); 

在Dao的實現(xiàn)類JianSheDWDaoImpl中實現(xiàn)方法

public List queryForPage(final String hql, final int offset,  
            final int length) {  
        List list = getHibernateTemplate().executeFind(new HibernateCallback() {  
 
            public Object doInHibernate(Session session)  
                    throws HibernateException, SQLException {  
                Query query = session.createQuery(hql);  
                query.setFirstResult(offset);  
                query.setMaxResults(length);  
                List list = query.list();  
                return list;  
 
            }  
        });  
 
        return list;  
    } 

在service抽象層接口JianSheDWService中添加方法

public PageBean queryForPage(int pageSize,int currentPage);  

在service實現(xiàn)類中實現(xiàn)方法

public PageBean queryForPage(int pageSize, int page) {  
        final String hql = "from JianSheDWBean"; // 查詢語句  
        int allRow = this.baseDao.getAllRowCount(hql); // 總記錄數(shù)  
        int totalPage = PageBean.countTotalPage(pageSize, allRow); // 總頁數(shù)  
        final int offset = PageBean.countOffset(pageSize, page); // 當(dāng)前頁開始記錄  
        final int length = pageSize; // 每頁記錄數(shù)  
        final int currentPage = PageBean.countCurrentPage(page);  
        List<JianSheDWBean> list = this.baseDao.queryForPage(hql, offset, length); // "一頁"的記錄  
 
        // 把分頁信息保存到Bean中  
        PageBean pageBean = new PageBean();  
        pageBean.setPageSize(pageSize);  
        pageBean.setCurrentPage(currentPage);  
        pageBean.setAllRow(allRow);  
        pageBean.setTotalPage(totalPage);  
        pageBean.setList(list);  
        pageBean.init();  
        return pageBean;  
 
    } 

在視圖層action中建立分頁模型

package com.fishing.action.lcq;  
 
 
 
import com.fishing.common.bean.JianSheDWBean;  
import com.fishing.common.bean.PageBean;  
import com.fishing.service.lcq.JianSheDWService;  
import com.opensymphony.xwork2.ActionSupport;  
 
@SuppressWarnings("serial")  
public class GetInfoJSDWListAction extends ActionSupport {  
 
    private int page; // 第幾頁  
 
    private PageBean pageBean; // 包含分布信息的bean  
 
    private JianSheDWBean jianSheDWBean;  
    // private PageBean page;  
    private JianSheDWService jianSheDWService;  
 
    public int getPage() {  
        return page;  
    }  
 
    public void setPage(int page) {  
        this.page = page;  
    }  
 
    public PageBean getPageBean() {  
        return pageBean;  
    }  
 
    public void setPageBean(PageBean pageBean) {  
        this.pageBean = pageBean;  
    }  
 
    public JianSheDWBean getJianSheDWBean() {  
        return jianSheDWBean;  
    }  
 
    public void setJianSheDWBean(JianSheDWBean jianSheDWBean) {  
        this.jianSheDWBean = jianSheDWBean;  
    }  
 
    public JianSheDWService getJianSheDWService() {  
        return jianSheDWService;  
    }  
 
    public void setJianSheDWService(JianSheDWService jianSheDWService) {  
        this.jianSheDWService = jianSheDWService;  
    }  
 
    @Override     
     public String execute() throws Exception {      
          
     //分頁的pageBean,參數(shù)pageSize表示每頁顯示記錄數(shù),page為當(dāng)前頁      
     this.pageBean = jianSheDWService.queryForPage(10, page);      
     return SUCCESS;  
    }  
}  

在jsp中編寫分頁

<tr class="odd"> 
                                                    <td> 
                                                        &nbsp;  
                                                    </td> 
                                                    <td> 
                                                        <s:if test="%{pageBean.currentPage == 1}">     
　　　　　　                                          首頁      上一頁  
　　　　                                            </s:if> 
                                                        <s:else> 
                                                            <a href="jianguan/getJSDWInfos.action?page=1">首頁</a> 
                                                            <a 
                                                                href="jianguan/getJSDWInfos.action?page=<s:property value="%{pageBean.currentPage-1}"/>" />上一頁</a> 
 
                                                        </s:else> 
                                                    </td> 
                                                    <td> 
                                                        <s:if test="%{pageBean.currentPage != pageBean.totalPage}"> 
 
                                                            <a 
                                                                href="jianguan/getJSDWInfos.action?page=<s:property value="%{pageBean.currentPage+1}"/>">下一頁</a> 
                                                            <a 
                                                                href="jianguan/getJSDWInfos.action?page=<s:property value="pageBean.totalPage"/>">尾頁  
                                                            </a> 
                                                        </s:if> 
                                                        <s:else>   
　　　　　　                                          下一頁  尾頁   
　　　　                                            </s:else> 
                                                    </td> 
 
                                                    <td> 
                                                        <div align="center"> 
                                                            頁次  
                                                            <s:property value="pageBean.currentPage" /> 
                                                            /  
                                                            <s:property value="pageBean.totalPage" /> 
                                                            &nbsp;&nbsp;&nbsp;共  
                                                            <s:property value="pageBean.allRow" /> 
                                                            記錄  
                                                        </div> 
                                                        <div align="center"></div> 
                                                    </td> 
                                                </tr> 

上面只是代碼的實現(xiàn)，沒有說明配置文件的配置，讀者根據(jù)情況配置。

原文鏈接：http://blog.csdn.net/liuchangqing123/article/details/7396783

【編輯推薦】

1. JavaScript是一門令人愉悅的語言
2. 比較Java Swing中三種注冊事件的方法
3. 常見JSP中文亂碼例子及其解決方法
4. JSP自定義標(biāo)簽實現(xiàn)數(shù)據(jù)字典
5. JSP自定義標(biāo)簽開發(fā)入門