java分页 Struts+Ibatis

转载

胡雨生 2017-05-14 15:19:18

文章标签 private package return import public 文章分类 Java 后端开发

首先写一个分页类：

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

在Action中

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

service中的pageBookInfo方法：

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

sqlMap中的语句：

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

在jsp中添加：

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