Java Oracle分页处理

package com.list.struts.util; import java.util.*; public class PaginationBean { int currentPage = 1; int totalPages = 0; int pageRecorders = 5; int totalRows = 0; int pageStartRow = 0; int pageEndRow = 0; boolean hasNextPage = false; boolean hasPreviousPage = false; boolean hasfirstPage=true; boolean haslastPage=true; ArrayList arrayList; /* *<P>接收数据库中的结果集的List *</P> */ public PaginationBean(List _products) { /* *<P>数据库中所有的记录 *</P> */ arrayList = (ArrayList)_products; totalRows = arrayList.size(); hasPreviousPage = false; currentPage = 1; /* *<P>判断总共有多少页 *</P> */ if((totalRows % pageRecorders) == 0) { totalPages = totalRows / pageRecorders; } else { totalPages = totalRows / pageRecorders + 1; } if(currentPage >= totalPages) { hasNextPage = false; } else { hasNextPage = true; } /* *<P>当前页的起始标记和结束标记（第几条到第几条） *</P> */ if(totalRows < pageRecorders) { pageStartRow = 0; pageEndRow = totalRows; } else { pageStartRow = 0; pageEndRow = pageRecorders; } } public ArrayList getJumpPage(String pagetype){ currentPage=Integer.parseInt(pagetype); /* *<P>判断是否有下一页和前一页 *</P> */ if((currentPage - 1) > 0) { hasPreviousPage = true; } else { hasPreviousPage = false; } if(currentPage >= totalPages) { hasNextPage = false; } else { hasNextPage = true; } /* *<P>返回当前页面所要显示的数据库记录的list *</P> */ ArrayList products = getProducts(); return products; } public ArrayList getFirstPage(){ currentPage=1; if((currentPage - 1) > 0) { hasPreviousPage = true; }else { hasPreviousPage = false; } if(currentPage >= totalPages) { hasNextPage = false; } else { hasNextPage = true; } ArrayList products = getProducts(); return products; } public ArrayList getLastPage(){ currentPage=totalPages; if((currentPage - 1) > 0){ hasPreviousPage = true; } else { hasPreviousPage = false; } if(currentPage >= totalPages){ hasNextPage = false; } else{ hasNextPage = true; } ArrayList products = getProducts(); return products; } /** */ public ArrayList getNextPage() { currentPage = currentPage + 1; if((currentPage - 1) > 0){ hasPreviousPage = true; } else{ hasPreviousPage = false; } if(currentPage >= totalPages){ hasNextPage = false; currentPage = totalPages; } else{ hasNextPage = true; } ArrayList products = getProducts(); return products; } /** */ public ArrayList getPreviouspage() { currentPage = currentPage-1; if(currentPage == 0) { currentPage = 1; } if(currentPage >= totalPages){ hasNextPage = false; } else{ hasNextPage = true; } if((currentPage-1) > 0){ hasPreviousPage = true; } else{ hasPreviousPage = false; } ArrayList products = getProducts(); return products; } /** * <P></p> */ @SuppressWarnings("unchecked") /* *<P>返回当前页的起始标记和结束标记之间的数据的list *</P> */ public ArrayList getProducts() { //System.out.println(pageRecorders); if(currentPage * pageRecorders < totalRows) { pageEndRow = currentPage * pageRecorders; pageStartRow = pageEndRow - pageRecorders; } else { pageEndRow = totalRows; pageStartRow = pageRecorders * (totalPages - 1); } ArrayList products = new ArrayList(); for(int i = pageStartRow; i < pageEndRow; i++) { /* *<P>从数据库中所有的记录中取出当前页面的记录 *arraylist存放的是数据库中所有的记录 *</P> */ Object product = arrayList.get(i); products.add(product); } return products; } public boolean isHasfirstPage() { return hasfirstPage; } public void setHasfirstPage(boolean hasfirstPage) { this.hasfirstPage = hasfirstPage; } public boolean isHaslastPage() { return haslastPage; } public void setHaslastPage(boolean haslastPage) { this.haslastPage = haslastPage; } public int getCurrentPage() { return currentPage; } public void setCurrentPage(int currentPage) { this.currentPage = currentPage; } public boolean isHasNextPage() { return hasNextPage; } public void setHasNextPage(boolean hasNextPage) { this.hasNextPage = hasNextPage; } public boolean isHasPreviousPage() { return hasPreviousPage; } public void setHasPreviousPage(boolean hasPreviousPage) { this.hasPreviousPage = hasPreviousPage; } public int getPageEndRow() { return pageEndRow; } public void setPageEndRow(int pageEndRow) { this.pageEndRow = pageEndRow; } public int getPageRecorders() { return pageRecorders; } public void setPageRecorders(int pageRecorders) { this.pageRecorders = pageRecorders; } public int getPageStartRow() { return pageStartRow; } public void setPageStartRow(int pageStartRow) { this.pageStartRow = pageStartRow; } public int getTotalPages() { return totalPages; } public void setTotalPages(int totalPages) { this.totalPages = totalPages; } public int getTotalRows() { return totalRows; } public void setTotalRows(int totalRows) { this.totalRows = totalRows; } }