[转]ibatis 分页

导读：


本文转自
http://www.blogjava.net/wyz191/articles/156923.html

 

ibatis　分页

＝＝＝＝＝＝＝分页BEAN＝＝＝＝＝＝＝＝

import java.util.List;

/**
 * ibatis分页Bean
 * @author Administrator
 *
 */
public class PageUtil {

 private int curPage = 0; //当前页
 private int pageSize = 0; //每页多少行
 private int endSize ; //用于not in(select top endSize id)不在多少行内
 private int totalRow ; //共多少行
 private int totalPage ; //共多少页
 
 public int getCurPage() {
  return curPage;
 }
 public void setCurPage(int curPage) {
  
  int temp = pageSize * (curPage-1);
  this.setEndSize(temp);
  this.curPage = curPage;
 }
 public int getEndSize() {
  return endSize;
 }
 public void setEndSize(int endSize) {
  this.endSize = endSize;
 }
 public int getPageSize() {
  return pageSize;
 }
 public void setPageSize(int pageSize) {
  this.pageSize = pageSize;
 }
 public int getTotalRow() {
  return totalRow;
 }
 public void setTotalRow(int totalRow) {
  
  totalPage = totalRow/pageSize;
  if(totalRow%pageSize > 0)
   totalPage = totalPage + 1;
  
  this.totalRow = totalRow;
 }
 public int getTotalPage(){
  
  return this.totalPage;
 }
 public String getToolsMenu() {
        StringBuffer str = new StringBuffer("");
        int next, prev;
        prev = curPage - 1;
        next = curPage + 1;

        if (curPage > 1) {
            str.append(
                "首页 ");
        } else {
            str.append("首页 ");
        }
        if (curPage > 1) {
            str.append(
                "上页 ");
        } else {
            str.append("上页 ");
        }
        if (curPage < totalPage) {
            str.append(
                "下页 ");
        } else {
            str.append("下页 ");
        }
        if (totalPage > 1 && curPage != totalPage) {
            str.append(
                "末页  ");
        } else {
            str.append("末页  ");
        }
        str.append(" 共" + totalRow + "条记录");
        str.append("  每页");

        if (pageSize == 3) {
            str.append("

3");
        } else {
            str.append("3");
        }

        if (pageSize == 10) {
            str.append("

10");
        } else {
            str.append("10");
        }
        if (pageSize == 20) {
            str.append("20");
        } else {
            str.append("20");
        }
        if (pageSize == 50) {
            str.append("50");
        } else {
            str.append("50");
        }
        if (pageSize == 100) {
            str.append("100");
        } else {
            str.append("100");
        }
        str.append("");
        str.append("条 分" + pageSize + "页显示 转到");
        str.append("");
        for (int i = 1; i < totalPage + 1; i++) {
            if (i == curPage) {
                str.append("" + i +
                           "");
            } else {
                str.append("" + i + "");
            }
        }
        str.append("页");
        str.append(" ");
        str.append(" ");
        return str.toString();
    }

}

＝＝＝＝＝＝＝＝配置文件＝＝＝＝＝＝＝

 

  select
  
   
    top $pageSize$
   
   * from leavebill
   
    id not in (select top $endSize$ id from leavebill) and state != '已归档' and state != '已完成'
   
   
    state != '已归档' and state != '已完成'
   
  
 

＝＝＝＝＝＝＝DAO　method＝＝＝＝＝＝＝＝

public List getWaitingLeaveBill(PageUtil page){
  
  List list = null;
  try {
   
   list = sqlMapClientTemplate.queryForList("getWaitingLeaveBillByPage",page);
  } catch (Exception e) {

   logger.error(e.getMessage());
  }
  return list;
 }

＝＝＝＝＝＝＝＝＝具体操作＝＝＝＝＝＝＝
public ModelAndView toWaitingLeaveBillList(HttpServletRequest request, HttpServletResponse response){
  
  PageUtil page = new PageUtil();
  java.util.List list = leaveBillDao.getWaitingLeaveBill(page);
  int temp = list.size();
  if(null != request.getParameter("pageSize") && !"".equals(request.getParameter("pageSize"))){
   page.setPageSize(Integer.parseInt(request.getParameter("pageSize")));
  }else{
   
   page.setPageSize(3);
  }
  page.setTotalRow(temp); 
  if(null != request.getParameter("pages") && !"".equals(request.getParameter("pages"))){
   page.setCurPage(Integer.parseInt(request.getParameter("pages")));
  }else{
   page.setCurPage(1);
  }
  request.setAttribute("menu",page.getToolsMenu());
  request.setAttribute("waitinglist",leaveBillDao.getWaitingLeaveBill(page));
  return new ModelAndView(WAITINGLIST);
 }

这是针对ＭＳ　ＳＱＬ的，针对ＭＹＳＱＬ或其它数据库的情况，改动一下配置文件即可。