分頁應該是在我們開發web應用時經常要做的工作，能夠比較簡潔的實現數據庫和視圖層的分頁十分重要。
在數據庫層利用hibernate進行數據庫的分頁，將從數據庫中查詢出的數據封裝為javabean；在視圖層就可以方便的實現分頁。
創建PageBean
package com.fishing.common.bean; import java.util.List; @SuppressWarnings("unchecked") public class PageBean { private List list; // 要返回的某一頁的記錄列表private int allRow; // 總記錄數private int totalPage; // 總頁數private int currentPage; // 當前頁private int pageSize; // 每頁記錄數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);// 如是當前頁是第1頁} public boolean isLastPage() { return currentPage == totalPage; //如果當前頁是最後一頁} public boolean isHasPreviousPage() { return currentPage != 1; //只要當前頁不是第1頁} public boolean isHasNextPage() { return currentPage != totalPage; //只要當前頁不是最後1頁} /** */ /** * 計算總頁數,靜態方法,供外部直接通過類名調用* * @param pageSize * 每頁記錄數* @param allRow * 總記錄數* @return 總頁數*/ public static int countTotalPage(final int pageSize, final int allRow) { int totalPage = allRow % pageSize == 0 ? allRow / pageSize : allRow / pageSize + 1; return totalPage; } /** */ /** * 計算當前頁開始記錄* * @param pageSize * 每頁記錄數* @param currentPage * 當前第幾頁* @return 當前頁開始記錄號*/ public static int countOffset(final int pageSize, final int currentPage) { final int offset = pageSize * (currentPage - 1); return offset; } /** */ /** * 計算當前頁,若為0或者請求的URL中沒有"?page=",則用1代替* * @param page * 傳入的參數(可能為空,即0,則返回1) * @return 當前頁*/ 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的實現類JianSheDWDaoImpl中實現方法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實現類中實現方法:
public PageBean queryForPage(int pageSize, int page) { final String hql = "from JianSheDWBean"; // 查詢語句int allRow = this.baseDao.getAllRowCount(hql); // 總記錄數int totalPage = PageBean.countTotalPage(pageSize, allRow); // 總頁數final int offset = PageBean.countOffset(pageSize, page); // 當前頁開始記錄final int length = pageSize; // 每頁記錄數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,參數pageSize表示每頁顯示記錄數,page為當前頁this.pageBean = jianSheDWService.queryForPage(10, page); return SUCCESS; } }在jsp中編寫分頁
<tr> <td> </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" /> 共<s:property value="pageBean.allRow" /> 記錄</div> <div align="center"></div> </td> </tr>上面只是代碼的實現，沒有說明配置文件的配置，讀者根據情況配置。
希望本文所述對你有所幫助，SSH2實現數據庫和界面的分頁內容就給大家介紹到這裡了。希望大家繼續關注我們的網站!想要學習java可以繼續關注本站。