struts分页的一种实现

使用一个页面控制类，它记录页面信息，如上页，下页，当前页等。在查询的Action中，将这个控制类和查询条件一起传递给数据库访问bean，然后将这两个参数保存在用户session中。在分页控制Action中，利用接收到的分页参数调用数据库访问的bean.

 (1)分页控制类

public class PageController {
 
 
 
 /****************设置参数**************************/ 
 int totalRowsAmount; //总行数
    boolean rowsAmountSet; //是否设置过totalRowsAmount
    int pageSize=9;   //每页行数
    int currentPage=1; //当前页码
    int nextPage;     //下一页
    int previousPage;  //上一页
    int totalPages;  //总页数
    boolean hasNext;  //是否有下一页
    boolean hasPrevious; //是否有前一页
    String description;
    int pageStartRow;  //指定到记录的某一行
    int pageEndRow;    //指定到结束的位置
    /******************************************/

  public PageController(){}
    
     public PageController(int totalRows)
     { 
         setTotalRowsAmount(totalRows);
     }
    
     public void setTotalRowsAmount(int i)
     {
      if(!this.rowsAmountSet)
      {
       totalRowsAmount = i;
       if(totalRowsAmount%pageSize==0)
       totalPages=totalRowsAmount/pageSize;
       else
       totalPages=totalRowsAmount/pageSize+1;
       setCurrentPage(1);
       this.rowsAmountSet=true;
      }
     }
    
  public void setCurrentPage(int i)
  {
   //设定当前页
   currentPage = i;
   nextPage=currentPage+1;
   previousPage=currentPage-1;
   //计算当前页开始行和结束行
   if(currentPage*pageSize<totalRowsAmount){
       pageEndRow=currentPage*pageSize;
       pageStartRow=pageEndRow-pageSize+1;
      
   }else{
       pageEndRow=totalRowsAmount;
       pageStartRow=pageSize*(totalPages-1)+1;
   }
   //判断是否有下一页
   if (nextPage>totalPages){
       hasNext=false;
   }else{
    hasNext=true;
   }
   //判断是否有上一页
   if(previousPage==0){
      hasPrevious=false;
   }else{
    hasPrevious=true;
   }
  
   System.out.println(this.description());
  }
 
  public int getCurrentPage() {
   return currentPage;
  }
  public boolean isHasNext() {
   return hasNext;
  }
  public boolean isHasPrevious() {
   return hasPrevious;
  }
  public int getNextPage() {
   return nextPage;
  }
  public int getPageSize() {
   return pageSize;
  }
  public int getPreviousPage() {
   return previousPage;
  }
  public int getTotalPages() {
   return totalPages;
  }
  public int getTotalRowsAmount() {
   return totalRowsAmount;
  }
  public void setHasNext(boolean b) {
   hasNext = b;
  }
  public void setHasPrevious(boolean b) {
   hasPrevious = b;
  }
  public void setNextPage(int i) {
   nextPage = i;
  }
  public void setPageSize(int i) {
   pageSize = i;
  }
  public void setPreviousPage(int i) {
   previousPage = i;
  }
  public void setTotalPages(int i) {
   totalPages = i;
  }
  public int getPageEndRow() {
   return pageEndRow;
  }
  public int getPageStartRow() {
   return pageStartRow;
  }
 
  public String getDescription(){
     String description="总:"+this.getTotalRowsAmount()+
     " items "+this.getTotalPages() +" pages";
     return description;
  }
 
  public String description(){
     String description="Total:"+this.getTotalRowsAmount()+
     " items "+this.getTotalPages() +" pages,Current page:"+
     this.currentPage+" Previous "+this.hasPrevious +
     " Next:"+this.hasNext+
     " start row:"+this.pageStartRow+
     " end row:"+this.pageEndRow;
     return description;
  } 
   
}

 

 public ActionForward execute(
  ActionMapping mapping,
  ActionForm form,
  HttpServletRequest request,
  HttpServletResponse response)
  throws Exception {
  Base queryForm= (Base) form;
   
     if(!queryForm.getName().equals("")){
   PageController pc=new PageController();       
         EmployeeBase service=new EmployeeBase();      
         ArrayList result=(ArrayList)service.search(queryForm,pc);
       
            HttpSession session=request.getSession();
           
   session.setAttribute("queryForm",queryForm);
         session.setAttribute("pageController",service.getPageController());
       
         request.setAttribute("queryResult",result); 
   request.setAttribute("pageController",service.getPageController());     
      return mapping.findForward("haveResult");
     }else{
        return mapping.findForward("noResult");
     }
  
  
  
 
 }

（3），翻页Action的代码片断

public ActionForward execute(
  ActionMapping mapping,
  ActionForm form,
  HttpServletRequest request,
  HttpServletResponse response)
  throws Exception {
 
   
        file://读取翻页参数
     
  TurnPageForm turnPageForm=(TurnPageForm)form;
  
  file://从PageController中取出查询信息，并使用bean提供的调用接口处理结果
  
  HttpSession session=request.getSession();
  PageController pc=(PageController)session.getAttribute("pageController");  
  Base queryForm=(Base)session.getAttribute("queryForm");
  
 
  pc.setCurrentPage(turnPageForm.getViewPage());
  
  EmployeeBase service=new EmployeeBase();
  
  ArrayList result=(ArrayList)service.search(queryForm,pc);
  
  file://根据参数将数据写入 request
  
        request.removeAttribute("queryResult");
  request.removeAttribute("pageController");
  request.setAttribute("queryResult",result); 
  request.setAttribute("pageController",pc);
    
  file://forward 到显示页面
  
  
  
  return mapping.findForward("haveResult");
  
  
  
  
 
 }

（4）数据库访问bean中的片断

public Collection search(Base base, PageController pc)
  throws SQLException {
  ArrayList emps = new ArrayList();
  ResultSet rs = getSearchResult(base);

  rs.absolute(-1);
  pc.setTotalRowsAmount(rs.getRow());
  setPageController(pc);
  if (rs.getRow() > 0) {

   rs.absolute(pc.getPageStartRow());

   do {
    System.out.println("in loop" + rs.getRow());

    Base b = new Base();
    b.setName(rs.getString("Name"));
    b.setIdCard(rs.getString("IDCard"));
    System.out.println("From db:" + rs.getString("IDCard"));
    emps.add(b);
    if (!rs.next()) {
     break;
    }
   } while (rs.getRow() < (pc.getPageEndRow() + 1));
  }
  return emps;
 }

(5)在jsp中，翻页部分的代码片断

<bean:write name="pageController" property="description"/>
  
  <logic:equal name="pageController" property="hasPrevious" value="true">
              <a href="turnPage.do?viewPage=<bean:write name="pageController" property="previousPage"/>" Previous
        </a>
  </logic:equal>

  <logic:equal name="pageController" property="hasNext" value="true">
     <a href="turnPage.do?viewPage=<bean:write name="pageController" property="nextPage"/>" Next
     </a>
  </logic:equal>

 

这样一来，翻页的功能可以以你喜欢的方式表现给client