[转]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);
 }

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