Struts2+Hibernate+Spring 分页自定义标签

分页问题一直是项目中不可避免的问题，之前由于一直忙着做项目，里面的分页觉得做的不是很完善，很多的代码需要复制粘帖，特别是在jsp页面上显示的时候，所以花了几天时间好好完善下！

1、封装分页信息的bean

package com.beckham.page;
import java.util.List;
/**
 * @author beckham
 *  Jul 30, 2009   4:13:43 PM
 *  分页信息
 */
public class PageBean {
	private int totalSize; // 记录总条数
	private int pageSize; // 每页显示条数
	private int prePage; // 上一页
	private int nextPage; // 下一页
	private int currPage; // 当前页
	private int lastPage; // 最后页
	private int pageCount; // 总页数
	private int beginIndex ;
	private int endIndex ;
	public int getBeginIndex() {
		return beginIndex;
	}
	public void setBeginIndex(int beginIndex) {
		this.beginIndex = beginIndex;
	}
	public int getEndIndex() {
		return endIndex;
	}
	public void setEndIndex(int endIndex) {
		this.endIndex = endIndex;
	}
	public int getTotalSize() {
		return totalSize;
	}
	public void setTotalSize(int totalSize) {
		this.totalSize = totalSize;
	}
	public int getPageSize() {
		return pageSize;
	}
	public void setPageSize(int pageSize) {
		this.pageSize = pageSize;
	}
	public int getPrePage() {
		return prePage;
	}
	public void setPrePage(int prePage) {
		this.prePage = prePage;
	}
	public int getNextPage() {
		return nextPage;
	}
	public void setNextPage(int nextPage) {
		this.nextPage = nextPage;
	}
	public int getCurrPage() {
		return currPage;
	}
	public void setCurrPage(int currPage) {
		this.currPage = currPage;
	}
	public int getLastPage() {
		return lastPage;
	}
	public void setLastPage(int lastPage) {
		this.lastPage = lastPage;
	}
	public int getPageCount() {
		return pageCount;
	}
	public void setPageCount(int pageCount) {
		this.pageCount = pageCount;
	}
}

2、通过 传递的参数来计算分页信息，参数主要有 当前页（currPage）、结果集的总条数（totalSize）、每页显示的数量（pageSize），我把pageSize写在了配置文件里面，这样可以灵活的修改配置。

package com.beckham.page;
import com.beckham.util.PropertyUtil;
public class PageMessage {
	/*
	 * (non-Javadoc)
	 * 获取分页信息
	 * @see com.beckham.page.PageMessageInterface#getPageMessage(int,
	 *      java.lang.String)
	 */
	public static PageBean getPageMessage(int currPage, int totalSize)
			throws Exception {
		PageBean pagebean = new PageBean();
		int pageSize = PropertyUtil.getPageSize();
		int pageCount = 0;
		int prePage = 0;
		int nextPage = 0;
		int begindex;
		int endindex;
		// 总页数
		if (totalSize % pageSize == 0) { // 判断是否整除
			pageCount = (int) totalSize / pageSize;
		} else {
			pageCount = (int) totalSize / pageSize + 1;
		}
		if (currPage > 1) {
			prePage = currPage - 1; // 上一页
		} else {
			prePage = 1;
		}
		if (currPage < pageCount) {
			nextPage = currPage + 1; // 下一页
		} else {
			nextPage = currPage;
		}
		 //开始索引
		 if (currPage > pageCount) {
			 begindex = (pageCount - 1) * pageSize;
			} else {
				begindex = (currPage - 1) * pageSize;
			}
		 //结束索引
		 if(currPage*pageSize>totalSize){
			 endindex = totalSize ;
		 }else{
			 endindex=currPage*pageSize ;
		 }
		
		pagebean.setPrePage(prePage);
		pagebean.setPageSize(pageSize);
		pagebean.setCurrPage(currPage);
		pagebean.setTotalSize(totalSize);
		pagebean.setPageCount(pageCount);
		pagebean.setLastPage(pageCount);
		pagebean.setNextPage(nextPage);
		pagebean.setBeginIndex(begindex) ;
		pagebean.setEndIndex(endindex) ;
		return pagebean;
	}
}

3、由此就可以在action里面调用了。

package com.beckham.struts.actions;
import java.util.List;
import java.util.Map;
import org.apache.struts2.interceptor.RequestAware;
import com.beckham.model.User;
import com.beckham.page.PageBean;
import com.beckham.page.PageMessage;
import com.beckham.service.UserService;
import com.opensymphony.xwork2.ActionSupport;
@SuppressWarnings("serial")
public class UserListAction extends ActionSupport implements RequestAware {
	private UserService userService;
	private int currPage;
	@SuppressWarnings("unchecked")
	private Map request;
	private String path;
	private String password ;

	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public String getPath() {
		return path;
	}
	public void setPath(String path) {
		this.path = path;
	}
	@SuppressWarnings( { "unchecked", "unchecked" })
	public String execute() throws Exception {
		//查询结果集总数
		String hqlSize = "select count(*) from User";
		//查询目标结果集
		String hql = "from User";
		
		if (currPage == 0) {
			currPage = 1;
		}
		//获取分页信息
		PageBean pageBean = PageMessage.getPageMessage(currPage, userService.gettotalSize(hqlSize));
       
		/*
		 * 
		 *获取结果集,这里是和hibernate结合使用，所以参数需要传一个beginIndex
		 * pageSize写在配置文件里面，所以这里就不用当做参数传递了
		 */
		List<User> list = userService.queryUser(hql, pageBean.getBeginIndex());
		StringBuffer sb = new StringBuffer();
		
		//带有参数的URL
		sb.append("userlist.action?password=").append(password).append("&") ;
		path = sb.toString();
		request.put("users", list);
		request.put("path", path) ;
		request.put("pageBean", pageBean);
		return SUCCESS;
	}
	public UserService getUserService() {
		return userService;
	}
	public void setUserService(UserService userService) {
		this.userService = userService;
	}
	@SuppressWarnings("unchecked")
	public void setRequest(Map request) {
		this.request = request;
	}
	@SuppressWarnings("unchecked")
	public Map getRequest() {
		return request;
	}
	public int getCurrPage() {
		return currPage;
	}
	public void setCurrPage(int currPage) {
		this.currPage = currPage;
	}
}

当然在调用的时候需要调用service里面的2个方法 gettotalSize(hqlSize) 和queryUser(hql, pageBean.getBeginIndex())

这2个方法的作用是获取结果集的总记录数和 获取本次查询的结果集，具体实现如下：

public int gettotalSize(String hql) throws Exception {
		int totalsize = 0;
		try {
			totalsize = Integer.parseInt(this.getHibernateTemplate().find(hql)
					.get(0).toString());
		} catch (Exception e) {
			e.printStackTrace();
			throw new Exception("查询用户总数失败", e);
		}
		return totalsize;
	}

	public List<User> queryUser(String hql, int beginIndex) throws Exception {
		try {
			return (List<User>) this.getHibernateTemplate().getSessionFactory()
					.getCurrentSession().createQuery(hql).setFirstResult(
							beginIndex).setMaxResults(
							PropertyUtil.getPageSize()).list();
		} catch (Exception e) {
			e.printStackTrace();
			throw new Exception("查询用户出现异常", e);
		}
	}

实现里面的PropertyUtil.getPageSize() 方法是从配置文件里面读取pageSize

   	 pageSize=5
	
	 downloadPath=img/
	
	 pageNumber=10

PropertyUtil.java

package com.beckham.util;
import java.io.IOException;
import java.io.InputStream;
import java.util.Properties;
public class PropertyUtil {
	private static Properties p = new Properties() ;
	private static InputStream inputStream = null ;
	static {
	 inputStream = PropertyUtil.class.getResourceAsStream("/page.properties")  ;
	 try {
		p.load(inputStream) ;
	} catch (IOException e) {
		e.printStackTrace();
	}
	}
	public static int getPageSize(){
		return Integer.parseInt(p.getProperty("pageSize"));
	}
	public static int getPageNumber(){
		return Integer.parseInt(p.getProperty("pageNumber"));
	}
	public static String getDownloadPath(){
		return p.getProperty("downloadPath");
	}
	public static void main(String[] args) {
		 System.out.println(getPageSize());
	}
	
}

到此，分页的逻辑已经算是完成了，主要实现是利用了hibernateTemplate来实现查询，所以在查询的时候其实只需要setFirstResult ，setMaxResults就可以，也就是从什么地方开始取，每次最多取多少条记录！

接下来就是写标签了

package com.tag;
import java.io.IOException;
import javax.servlet.jsp.JspException;
import javax.servlet.jsp.JspWriter;
import javax.servlet.jsp.tagext.SimpleTagSupport;
import com.beckham.util.PropertyUtil;
/**
 * @author beckham 分页标签 Oct 22, 2009 9:20:49 PM
 */
public class PageTag extends SimpleTagSupport {
	private String path; // 请求路径
	private String param; // 传递参数
	private int currPage; // 当前页
	private int totalPage;// 总页数
	private int totalSize;
	private int pageCount;
	private int pageSize;
	public int getTotalSize() {
		return totalSize;
	}
	public void setTotalSize(int totalSize) {
		this.totalSize = totalSize;
	}
	public int getPageCount() {
		return pageCount;
	}
	public void setPageCount(int pageCount) {
		this.pageCount = pageCount;
	}
	public int getPageSize() {
		return pageSize;
	}
	public void setPageSize(int pageSize) {
		this.pageSize = pageSize;
	}
	public String getPath() {
		return path;
	}
	public void setPath(String path) {
		this.path = path;
	}
	public String getParam() {
		return param;
	}
	public void setParam(String param) {
		this.param = param;
	}
	public int getCurrPage() {
		return currPage;
	}
	public void setCurrPage(int currPage) {
		this.currPage = currPage;
	}
	public int getTotalPage() {
		return totalPage;
	}
	public void setTotalPage(int totalPage) {
		this.totalPage = totalPage;
	}
	public void doTag() throws JspException, IOException {
		JspWriter out = this.getJspContext().getOut();
		StringBuffer sb = new StringBuffer();
		
		sb.append("<mce:style type=\"text/css\"><!--
") ;
		 
		sb.append("* { margin:0; padding:0;}") ;
		 
		sb.append("body { font-size:13px; font-family:Verdana;width:100%;}") ;
		 
		sb.append("a { color:#333; text-decoration:none;}") ;
		sb.append("a:hover {text-decoration:none;color:#FF0000;font-weight:bold;}");
		 
		sb.append("ul { list-style:none;}") ;
		 
		sb.append("#pagelist {width:100%; margin:30px auto; padding:6px 0px; height:20px;}") ;
		 
		sb.append("#pagelist ul li { float:left; border:1px solid #5d9cdf; height:20px; line-height:20px; margin:0px 2px;}") ;
		 
		sb.append("#pagelist ul li a, .pageinfo { display:block; padding:0px 6px; background:#e6f2fe;}") ;
		 
		sb.append(".current { background:#a9d2ff; display:block; padding:0px 6px; font-weight:bold;}") ;
		 
		sb.append("
--></mce:style><style type=\"text/css\" mce_bogus="1">") ;
		 
		sb.append("* { margin:0; padding:0;}") ;
		 
		sb.append("body { font-size:13px; font-family:Verdana;width:100%;}") ;
		 
		sb.append("a { color:#333; text-decoration:none;}") ;
		sb.append("a:hover {text-decoration:none;color:#FF0000;font-weight:bold;}");
		 
		sb.append("ul { list-style:none;}") ;
		 
		sb.append("#pagelist {width:100%; margin:30px auto; padding:6px 0px; height:20px;}") ;
		 
		sb.append("#pagelist ul li { float:left; border:1px solid #5d9cdf; height:20px; line-height:20px; margin:0px 2px;}") ;
		 
		sb.append("#pagelist ul li a, .pageinfo { display:block; padding:0px 6px; background:#e6f2fe;}") ;
		 
		sb.append(".current { background:#a9d2ff; display:block; padding:0px 6px; font-weight:bold;}") ;
		 
		sb.append("</style>") ;
		 
		
		sb.append("<div id=\"pagelist\">");
		sb.append("<ul>") ;

		if (currPage == 1) {
			sb.append("<li>") ;
			sb.append("首页");
			sb.append("</li>") ;
			sb.append("<li>") ;
			sb.append("上一页");
			sb.append("</li>") ;
			
		} else {
			sb.append("<li>") ;
			sb.append("<a href="\" mce_href="\""");
			sb.append(path);
			sb.append(param);
			sb.append("=1");
			sb.append("\"");
			sb.append(">");
			sb.append("首页");
			sb.append("</a>");
			sb.append("</li>") ;
			sb.append("<li>") ;
			sb.append("<a href="\" mce_href="\""");
			sb.append(path);
			sb.append(param);
			sb.append("=");
			sb.append(currPage - 1);
			sb.append("\"");
			sb.append(">");
			sb.append("上一页");
			sb.append("</a>");
			sb.append("</li>") ;
			 
		}
		// 显示页码 默认显示pageNumber个页码
		int pageNumber = PropertyUtil.getPageNumber();
		// 总页数小于需要显示的页码数
		int result = (currPage-1) / pageNumber;
		int begin = 1;
		int end = 1;
		begin = result * pageNumber+1;
		end = (result + 1) * pageNumber;
		if (end >= totalPage) {
			end = totalPage;
		}
		for (int i = begin; i <currPage; i++) {
			sb.append("<li>").append("<a href="\" mce_href="\""").append(path).append(param).append("=")
					.append(i).append("\"").append("></a>").append(i).append(
							"</a>").append("</li>");
		}
		sb.append("<li class=\"current\">").append(currPage).append("</li>");
		for (int i = currPage+1; i <=end; i++) {
			sb.append("<li>").append("<a href="\" mce_href="\""").append(path).append(param).append("=")
					.append(i).append("\"").append("></a>").append(i).append(
							"</a>").append("</li>");
		}
		if (currPage == totalPage) {
			sb.append("<li>") ;
			sb.append("下一页");
			sb.append("</li>") ;
			 
			sb.append("<li>") ;
			sb.append("末页");
			sb.append("</li>") ;
		} else {
			sb.append("<li>") ;
			sb.append("<a href="\" mce_href="\""");
			sb.append(path);
			sb.append(param);
			sb.append("=");
			sb.append(currPage + 1);
			sb.append("\"");
			sb.append(">");
			sb.append("下一页");
			sb.append("</a>");
			sb.append("</li>") ;
			 
			sb.append("<li>") ;
			sb.append("<a href="\" mce_href="\""");
			sb.append(path);
			sb.append(param);
			sb.append("=");
			sb.append(totalPage);
			sb.append("\"");
			sb.append(">");
			sb.append("末页");
			sb.append("</a>");
			sb.append("</li>") ;
			 
		}
		sb.append("<li>") ;
		sb.append("");
		sb.append("总共");
		sb.append("<font color=\"red\">");
		sb.append(totalSize);
		sb.append("</font>");
		sb.append("条结果");
		sb.append("");
		sb.append("");
		sb.append("当前");
		sb.append("<font color=\"red\">");
		sb.append(currPage);
		sb.append("</font>");
		sb.append("/");
		sb.append("<font color=\"red\">");
		sb.append(pageCount);
		sb.append("页") ;
		sb.append("</font>");
		sb.append("</li>") ;
		sb.append("");
		sb.append("</ul>") ;
		 
		sb.append("</div>");
		out.println(sb);
	}
}

标签写完，当然就是写tld文件了

<?xml version="1.0" encoding="UTF-8" ?>
<taglib xmlns="http://java.sun.com/xml/ns/javaee"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-jsptaglibrary_2_1.xsd"
	version="2.1">
	<tlib-version>1.1</tlib-version>
	<short-name>pageTag</short-name>
	<uri>/WEB-INF/pagetag.tld</uri>
	<tag>
		<name>pageInfo</name>
		<tag-class>com.tag.PageTag</tag-class>
		<body-content>empty</body-content>
		
		<attribute>
			<name>path</name>
			<required>true</required>
			<rtexprvalue>true</rtexprvalue>
		</attribute>
		<attribute>
			<name>currPage</name>
			<required>true</required>
			<rtexprvalue>true</rtexprvalue>
			<type>java.lang.Integer</type>
		</attribute>
		<attribute>
			<name>param</name>
			<required>true</required>
			<rtexprvalue>true</rtexprvalue>
		</attribute>
		<attribute>
			<name>totalPage</name>
			<required>true</required>
			<rtexprvalue>true</rtexprvalue>
			<type>java.lang.Integer</type>
		</attribute>
		<attribute>
			<name>totalSize</name>
			<required>true</required>
			<rtexprvalue>true</rtexprvalue>
			<type>java.lang.Integer</type>
		</attribute>
		<attribute>
			<name>pageCount</name>
			<required>true</required>
			<rtexprvalue>true</rtexprvalue>
			<type>java.lang.Integer</type>
		</attribute>
		<attribute>
			<name>pageSize</name>
			<required>true</required>
			<rtexprvalue>true</rtexprvalue>
			<type>java.lang.Integer</type>
		</attribute>
	</tag>
</taglib>

最后的一步就是在页面上显示查询结果和用标签显示分页信息

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib uri="/struts-tags" prefix="s"%>
<%@ taglib uri="/WEB-INF/pagetag.tld" prefix="pt"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://"
			+ request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
	<head>
		<base href="<%=basePath%>">
		<title>My JSP 'mess.jsp' starting page</title>
		<meta http-equiv="pragma" content="no-cache">
		<meta http-equiv="cache-control" content="no-cache">
		<meta http-equiv="expires" content="0">
		<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
		<meta http-equiv="description" content="This is my page">
	</head>
	<body>
<div>
		<table border="1" style="width: 100%" align="center">
			<tr>
				<td>
					id
				</td>
				<td>
					用户名
				</td>
				<td>
					姓名
				</td>
				<td>
					年龄
				</td>
				<td>
					性别
				</td>
				<s:iterator id="user" value="#request.users">
					<tr>
						<td>
							<s:property value="#user.id" />
						</td>
						<td>
							<s:property value="#user.username" />
						</td>
						<td>
							<s:property value="#user.realname" />
						</td>
						<td>
							<s:property value="#user.age" />
						</td>
						<td>
							<s:property value="#user.sex" />
						</td>
					</tr>
				</s:iterator>
			</tr>
			<tr>
		</table>
	</div>
	<div style="width: 100%">
	              <pt:pageInfo pageCount="${pageBean.pageCount }"  
								             currPage="${pageBean.currPage }" 
								             param="currPage" 
								             path="${path}"
								             totalPage="${pageBean.lastPage }" 
								             pageSize="${pageBean.pageSize }" 
								             totalSize="${pageBean.totalSize }" 
								             />       
								          
								 
</div>
	</body>
</html>

显示效果由于图片无法上传，所以也就贴不上来了！

评论

2 楼 gaowenming 2011-08-22  

bissalor 写道

大哥，请问一下，Action类中有一个password属性是做什么用的啊？有点想不通

password只是一个参数而已，当时我也不记得为什么要啦，这都是好久前的东西了，当然你可以不用这个password！

1 楼 bissalor 2011-08-22  

大哥，请问一下，Action类中有一个password属性是做什么用的啊？有点想不通