＝＝＝＝＝＝＝分页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( "<a href=\"#\" onclick=\"document.forms(0).pages.value=1;document.forms(0).submit();\">首页</a> "); } else { str.append("<a href=\"#\">首页</a> "); } if (curPage > 1) { str.append( "<a href=\"#\" onclick='document.forms(0).pages.value=" +prev + ";document.forms(0).submit();'>上页</a> "); } else { str.append("<a href=\"#\">上页</a> "); } if (curPage < totalPage) { str.append( "<a href=\"#\" onclick='document.forms(0).pages.value=" +next + ";document.forms(0).submit();'>下页</a> "); } else { str.append("<a href=\"#\" >下页</a> "); } if (totalPage > 1 && curPage != totalPage) { str.append( "<a href=\"#\" onclick='document.forms(0).pages.value=" +totalPage + ";document.forms(0).submit();'>末页</a> "); } else { str.append("<a href=\"#\" >末页</a> "); } str.append(" 共" + totalRow + "条记录"); str.append(" 每页<SELECT size=1 name=pagesize onchange='this.form.pages.value=1;this.form.pageSize.value=this.value;this.form.submit();'>"); if (pageSize == 3) { str.append("<OPTION value=3 selected>3</OPTION>"); } else { str.append("<OPTION value=3>3</OPTION>"); } if (pageSize == 10) { str.append("<OPTION value=10 selected>10</OPTION>"); } else { str.append("<OPTION value=10>10</OPTION>"); } if (pageSize == 20) { str.append("<OPTION value=20 selected>20</OPTION>"); } else { str.append("<OPTION value=20>20</OPTION>"); } if (pageSize == 50) { str.append("<OPTION value=50 selected>50</OPTION>"); } else { str.append("<OPTION value=50>50</OPTION>"); } if (pageSize == 100) { str.append("<OPTION value=100 selected>100</OPTION>"); } else { str.append("<OPTION value=100>100</OPTION>"); } str.append("</SELECT>"); str.append("条 分" + pageSize + "页显示 转到"); str.append("<SELECT size=1 name=Pagelist onchange='this.form.pages.value=this.value;this.form.submit();'>"); for (int i = 1; i < totalPage + 1; i++) { if (i == curPage) { str.append("<OPTION value=" + i + " selected>" + i + "</OPTION>"); } else { str.append("<OPTION value=" + i + ">" + i + "</OPTION>"); } } str.append("</SELECT>页"); str.append("<INPUT type=hidden value=" + curPage + " name=\"pages\" > "); str.append("<INPUT type=hidden value=" + pageSize + " name=\"pageSize\"> "); return str.toString(); } } ＝＝＝＝＝＝＝＝配置文件＝＝＝＝＝＝＝ <typeAlias alias="leaveBill" type="com.luke.wz.kf.bean.LeaveBill"/> <typeAlias alias="page" type="com.luke.wz.kf.bean.PageUtil"/> <select id="getWaitingLeaveBillByPage" resultClass="leaveBill" parameterClass="page"> select <dynamic prepend=""> <isNotEqual compareValue="0" property="pageSize" prepend=""> top $pageSize$ </isNotEqual> * from leavebill <isNotEqual prepend="where" compareValue="0" property="pageSize"> id not in (select top $endSize$ id from leavebill) and state != '已归档' and state != '已完成' </isNotEqual> <isEqual prepend="where" compareValue="0" property="pageSize"> state != '已归档' and state != '已完成' </isEqual> </dynamic> </select> ＝＝＝＝＝＝＝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); } 这是针对ＭＳ ＳＱＬ的，针对ＭＹＳＱＬ或其它数据库的情况，改动一下配置文件即可。
