公共的分页方法

公共的分页方法

1，DAO层方法

	/**
	 * 分页的接口方法
	 * 
	 * @param   allSizeHql        查找所有记录条数的hql语句
	 * @param   queryListHql      查找结果集的hql语句
	 * @param   page              需要显示的分页的当前页码
	 * @param   size              每页需要显示多少条记录
	 * @return  Map<String,Object>   存入分页所需数据
	 * 				currentPage == 当前页的页码
	 * 				pages       == 查询结果的总页数
	 * 				allSize     == 记录总条数
	 * 				list        == 当前页的结果集
	 * 				
	 * @since   1.0
	 */
	@SuppressWarnings("unchecked")
    public Map<String, Object> paging(final String allSizeHql,
			final String queryListHql, final Integer page, final Integer size) {
		return (Map<String, Object>) getHibernateTemplate().execute(new HibernateCallback() {
			@SuppressWarnings("rawtypes")
            @Override
			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {
				Map<String, Object> map = new HashMap<String, Object>();
				int currentPage = page;

				Query query = session.createQuery(allSizeHql);
				// 一共多少条记录
				Integer allSize = Integer.parseInt(query.list().get(0)
						.toString());
				// 一共可以分多少页
				Integer pages = allSize % size == 0 ? allSize / size : allSize
						/ size + 1;

				if (currentPage > pages) {
					currentPage = pages;
				} else if (currentPage <= 0) {
					currentPage = 1;
				}

				// 得到分页的list
				Query listQuery = session.createQuery(queryListHql);
				listQuery.setFirstResult((currentPage - 1) * size)
						.setMaxResults(size);
				List list = listQuery.list();
				map.put("currentPage", currentPage);
				map.put("size", size);
				map.put("pages", pages);
				map.put("allSize", allSize);
				map.put("list", list);
				
				return map;
			}
		});
	}
	
}

2，js文件中的方法，用于判断输入框中只能输入数字

public class BaseDaoUtils extends HibernateDaoSupport {
	function checkPage(e) {
		var e = e ? e : window.event;// 前者FF,后者IE
		var src = e.target || e.srcElement;
		var c = e.charCode || e.keyCode;
		if (!(c >= 48 && c <= 57 || c == 8 || c == 37 || c == 39)) {
			c = 0;
			return false;
		} else {
			return true;
		}
	}

	function page(page) {
		$("#page").val(page);
		$("#goPageBnt").click();
	}

3，分页的公共页面

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<script type="text/javascript" src="${basepath}/zhjy/javascript/common/page.js"></script>
  <!--分页开始-->
  <div class="page fs14" style="padding-right:25px;">
  <c:if test="${param.pages>0}">
   <a class="page_up" href="javascript:page(${param.currentPage-1})">上一页</a> 
	<c:choose>
		<c:when test="${param.pages <= 5}">
			<c:forEach begin="1" step="1" end="${param.pages}" varStatus="pageId">
				<c:if test="${param.currentPage == pageId.index}" var="line">
					<a href="javascript:page(${pageId.index})"><u>${pageId.index}</u></a>
				</c:if>
				<c:if test="${!line}">
				   <a href="javascript:page(${pageId.index})">${pageId.index}</a>
				 </c:if>
			</c:forEach>
		</c:when>
		<c:when test="${param.pages > 5}">
			<c:if test="${param.currentPage <= 3}">
				<c:forEach begin="1" step="1" end="5" varStatus="pageId">
					<c:if test="${param.currentPage == pageId.index}" var="line">
					<a href="javascript:page(${pageId.index})"><u>${pageId.index}</u></a>
					</c:if>
					<c:if test="${!line}">
				   <a href="javascript:page(${pageId.index})">${pageId.index}</a>
				   </c:if>
				</c:forEach>
				...
			</c:if>
			<c:if test="${param.currentPage > 3 && param.currentPage < param.pages-2}">
				...
				<a href="javascript:page(${param.currentPage-2})">${param.currentPage-2}</a>
				<a href="javascript:page(${param.currentPage-1})">${param.currentPage-1}</a>
				<a href="javascript:page(${param.currentPage})"><u>${param.currentPage}</u></a>
				<a href="javascript:page(${param.currentPage+1})">${param.currentPage+1}</a>
				<a href="javascript:page(${param.currentPage+2})">${param.currentPage+2}</a>
				...
			</c:if>
			<c:if test="${param.currentPage >= param.pages-2}">
				...
				<c:forEach begin="${param.currentPage-2}" step="1" end="${param.pages}" varStatus="pageId">
					<c:if test="${param.currentPage == pageId.index}" var="line">
					<a href="javascript:page(${pageId.index})"><u>${pageId.index}</u></a>
					</c:if>
					<c:if test="${!line}">
				   		<a href="javascript:page(${pageId.index})">${pageId.index}</a>
				   </c:if>
				   
				</c:forEach>
			</c:if>
		</c:when>
	</c:choose>
	<a class="page_dn" href="javascript:page(${param.currentPage+1})">下一页</a>
	 
	共${param.pages}页
	 
	<span class="ml30 c717171 fs14">跳转到：</span>
	<input class="page_in w30" type="text" id="pageInput" name="page" value="${param.currentPage}"
		οnkeypress="return checkPage(event)" οndragenter="return false"
		οnpaste="return false" style="ime-mode:disabled" size="4" /> 页
	<input type="hidden" value="${param.pages}" id="pages"/>
	<input type="hidden" value="${param.size}" id="size" name="size" />
	<a class="page_go" id="goPageBnt" href="javascript:pageBnt();">确定</a>
  </c:if>
  </div>

4，在页面如何使用

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"%>
<c:set var="basepath" value="${pageContext.request.contextPath }"></c:set>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>产品页</title>
<style type="text/css">
.invalid{
color:red;
font-size:13px
}
</style>
//记得引用jquery.js
<script type="text/javascript" src="${basepath}/zhjy/javascript/common/jquery-1.7.1.js"></script>
</head>
<body> 
.......（分页的列表）
<!-- ####分页的底栏引用#### -->
<form id="pageForm" action="${basepath}/product/comments_toCommentPage.action">
//被引用的分页公共页面的地址
<jsp:include page="/WEB-INF/pages/common/page.jsp" flush="true">
<jsp:param value="${resultMap.currentPage}" name="currentPage"/>//当前页
<jsp:param value="${resultMap.size}" name="size"/>//每页大小
<jsp:param value="${resultMap.pages}" name="pages"/>//一共多少页
</jsp:include>
</form>
</body>
</html>