学步园

首先写一个分页类：

package com.zc.book.util;</p> <p>import java.util.List;</p> <p>public class PageUtil {</p> <p> private int pageSize=20;//每页显示的条数 默认20</p> <p> private int recordCount;//记录总数</p> <p> private int currentPage;//当前页</p> <p> private int pageIndex;//每页的第一条记录编号</p> <p> private List pageList;//每页的记录集</p> <p> private int totalPage;//总页数</p> <p> public int getPageSize() {<br /> return pageSize;<br /> }</p> <p> public void setPageSize(int pageSize) {<br /> this.pageSize = pageSize;<br /> }</p> <p> public int getRecordCount() {<br /> return recordCount;<br /> }</p> <p> public void setRecordCount(int recordCount) {<br /> this.recordCount = recordCount;<br /> }</p> <p> public int getCurrentPage() {<br /> return currentPage;<br /> }</p> <p> public void setCurrentPage(int currentPage) {<br /> this.currentPage = currentPage;<br /> }</p> <p> public int getPageIndex() {<br /> return pageIndex;<br /> }</p> <p> public void setPageIndex(int pageIndex) {<br /> this.pageIndex = pageIndex;<br /> }</p> <p> public List getPageList() {<br /> return pageList;<br /> }</p> <p> public void setPageList(List pageList) {<br /> this.pageList = pageList;<br /> }</p> <p> public int getTotalPage() {<br /> return totalPage;<br /> }</p> <p> public void setTotalPage(int totalPage) {<br /> this.totalPage = totalPage;<br /> }</p> <p> //初始化 currentPage 当前页,pageSize 每页大小,recordCount 总记录数,pageIndex 每页第一条记录序号<br /> public void init(int currentPage,int pageSize,int recordCount){<br /> this.currentPage=currentPage>0?currentPage:1;//设置当前页<br /> this.pageSize=pageSize;//设置每页大小<br /> this.recordCount=recordCount;//设置总记录数<br /> this.pageIndex=(currentPage-1)*pageSize;//设置每页第一条记录<br /> this.totalPage=recordCount/pageSize+1;<br /> if(currentPage>totalPage){<br /> currentPage=totalPage;<br /> }<br /> }<br /> }

在Action中

int currentPage = 1;</p> <p> try {<br /> currentPage = Integer.parseInt(request.getParameter("currentPage"));<br /> } catch(Exception ex) {<br /> }</p> <p> PageUtil pageUtil=new PageUtil();</p> <p> pageUtil=bookService.pageBookInfo(currentPage);<br /> request.setAttribute("pageUtil", pageUtil);</p> <p> return mapping.findForward("bookInfo");

service中的pageBookInfo方法：

 public PageUtil pageBookInfo(int currentPage) {<br /> // TODO Auto-generated method stub<br /> List list=bookDao.bookInfo();</p> <p> PageUtil pageUtil=new PageUtil();</p> <p> //设置当前页，每页记录数，总记录数<br /> pageUtil.init(currentPage, 25, list.size());</p> <p> //通过pageUtil的"pageIndex--每页的第一条记录编号"和"pageSize--每页显示的条数"<br /> //这两个参数去数据库中查询出其中一页的记录，放入List里<br /> list=bookDao.pageBook(pageUtil);</p> <p> //将list中一页的记录放入pageUtil<br /> pageUtil.setPageList(list);</p> <p> return pageUtil;<br /> }

sqlMap中的语句：

<select id="listAllBook" resultClass="Book"><br /> select * from bookinfo<br /> </select></p> <p> <select id="pageBook" resultClass="Book" parameterClass="PageUtil"><br /> select * from bookinfo limit #pageIndex#,#pageSize#<br /> </select>

在jsp中添加：

<table width="100%" border="0" cellspacing="0" cellpadding="0"><br /> <tr><br /> <td width="25%" height="29" nowrap="nowrap"><span class="STYLE1">共${pageUtil.recordCount }条纪录，当前第${pageUtil.currentPage }/${pageUtil.totalPage }页，每页${pageUtil.pageSize }条纪录</span></td><br /> <td width="75%" valign="top" class="STYLE1"><div align="right"><br /> <table width="352" height="20" border="0" cellpadding="0" cellspacing="0"><br /> <tr><br /> <c:if test="${pageUtil.currentPage == 1}"><br /> <td width="62" height="22" valign="middle"><div align="right"><img src="tab/images/first.gif" mce_src="tab/images/first.gif" width="37" height="15" /></div></td><br /> <td width="50" height="22" valign="middle"><div align="right"><img src="tab/images/back.gif" mce_src="tab/images/back.gif" width="43" height="15" /></div></td></p> <p> </c:if><br /> <c:if test="${pageUtil.currentPage != 1}"><br /> <td width="62" height="22" valign="middle" align="right" ><a href="<%=basePath%>book.do?method=page¤tPage=1" target='I1'><img src="tab/images/first.gif" mce_src="tab/images/first.gif" width="37" height="15" border="0"/></a></td><br /> <td width="50" height="22" valign="middle" align="right"><a href="<%=basePath%>book.do?method=page¤tPage=${pageUtil.currentPage-1 }" target='I1'><img src="tab/images/back.gif" mce_src="tab/images/back.gif" width="43" height="15" border="0"></a></td><br /> </c:if><br /> <c:if test="${pageUtil.currentPage == pageUtil.totalPage}"><br /> <td width="54" height="22" valign="middle" align="right"><img src="tab/images/next.gif" mce_src="tab/images/next.gif" width="43" height="15" /></td><br /> <td width="49" height="22" valign="middle" align="right"><img src="tab/images/last.gif" mce_src="tab/images/last.gif" width="37" height="15" /></td><br /> </c:if><br /> <c:if test="${pageUtil.currentPage != pageUtil.totalPage}"><br /> <td width="54" height="22" valign="middle" align="right"><a href="<%=basePath%>book.do?method=page¤tPage=${pageUtil.currentPage+1 }" target='I1'><img src="tab/images/next.gif" mce_src="tab/images/next.gif" width="43" height="15" border="0"/></a></td><br /> <td width="49" height="22" valign="middle" align="right"><a href="<%=basePath%>book.do?method=page¤tPage=${pageUtil.totalPage }" target='I1'><img src="tab/images/last.gif" mce_src="tab/images/last.gif" width="37" height="15" border="0"/></a></td><br /> </c:if><br /> <td width="59" height="22" valign="middle"><div align="right"><span class="STYLE1">转到第</span></div></td><br /> <td width="25" height="22" valign="middle"><span class="STYLE7"><br /> <!-- <input name="textfield" type="text" class="STYLE1" style="height:15px; width:30px;" size="5" /> --></p> <p> <select id="selectPage" name="selectPage"><br /> <c:forEach var="i" begin="1" end="${pageUtil.totalPage }" step="1"><br /> <option value="${i}"><c:out value="${i}" /></option><br /> </c:forEach><br /> </select></p> <p> </span></td><br /> <td width="23" height="22" valign="middle"><span class="STYLE1">页</span></td><br /> <td width="30" height="22" valign="middle"><a href="javascript:goPage()" mce_href="javascript:goPage()"><img src="tab/images/go.gif" mce_src="tab/images/go.gif" width="37" height="15" border="0"/></a></td><br /> </tr><br /> </table><br /> </div></td><br /> <td width="14"><img src="tab/images/tab_22.gif" mce_src="tab/images/tab_22.gif" width="14" height="29" /></td><br /> </tr><br /> </table>

<mce:script type="text/javascript"><!--<br /> //页数select随页数自动变化</p> <p> function selectPage(currentPage){<br /> var i,num,op<br /> num=document.getElementById("selectPage").length;</p> <p> for(i=0;i<num;i++){<br /> op=document.getElementById("selectPage").options[i];<br /> if(op.value==currentPage) op.selected=true;<br /> }<br /> }<br /> //根据所选页数进行跳转<br /> function goPage(){<br /> var currentpage;<br /> currentpage=document.getElementById("selectPage").value;<br /> window.location="<%=basePath%>book.do?method=page&currentPage="+currentpage;<br /> }<br /> // --></mce:script>