公共的分页方法
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>