分享

使用pager-taglib.jar实现的分页技术

 james_加贝 2011-01-21
//1.导入pager-taglib.jar包;
//2.引入pager-taglib标签:<%@ taglib prefix="pg"  uri="http:///tags/navigation/pager" %>
//3.建立PagerModel类:
public class PagerModel {
 /**
  * 总记录数
  */
 private int total;
 /**
  * 当前页结果集
  */
 private List datas;
 public List getDatas() {
  return datas;
 }
 public void setDatas(List datas) {
  this.datas = datas;
 }
 public int getTotal() {
  return total;
 }
 public void setTotal(int total) {
  this.total = total;
 }
}
//4.pager业务逻辑部分:
public class AbstractManager extends HibernateDaoSupport {
 public PagerModel searchHql(String hql){
  return searchHql(hql,null,SystemContext.getOffset(),SystemContext.getPageSize());
 }
 public PagerModel searchHql(String hql,Object datas){
  return searchHql(hql,new Object[]{datas},SystemContext.getOffset(),SystemContext.getPageSize());
 }
 public PagerModel searchHql(String hql,Object[] datas){
  return searchHql(hql,datas,SystemContext.getOffset(),SystemContext.getPageSize());
 }
 public PagerModel searchHql(String hql,int offset,int pageSize){
  return searchHql(hql,null,offset,pageSize);
 }
 public PagerModel searchHql(String hql,Object datas,int offset,int pageSize){
  return searchHql(hql,new Object[]{datas},offset,pageSize);
 }
 public PagerModel searchHql(String hql,Object[] datas,int offset,int pageSize){
  String countHql = getQuery(hql);
  Query query = getSession().createQuery(countHql);
  if(datas !=null && datas.length > 0){
   for(int i = 0 ; i<datas.length;i++)
    query.setParameter(i, datas[i]);
  }
  int total = ((Long)query.uniqueResult()).intValue();
  Query query1=getSession().createQuery(hql);
  if(datas !=null && datas.length > 0){
   for(int i = 0 ; i<datas.length;i++)
    query1.setParameter(i, datas[i]);
  }
  List list =query1.setFirstResult(offset)           .setMaxResults(pageSize).list();
  PagerModel pm = new PagerModel();
  pm.setDatas(list);
  pm.setTotal(total);
  return pm;
 }
 public String getQuery(String hql){
  int index =hql.indexOf("from");
  if(index != -1){
   return "select count(*)"+hql.substring(index);
  }
  throw new SystemException("查询语句出错!");
 }
}
//5.定义offset、pagesize类:
public class SystemContext {
 private static ThreadLocal offset = new ThreadLocal();
 private static ThreadLocal pageSize = new ThreadLocal();
 public static int getOffset(){
  Integer os = (Integer)offset.get();
  if(os == null){
   return 0;
  }
  return os;
 }
 public static void setOffset(int offsetvalue){
  offset.set(offsetvalue);
 }
 public static void removeOffset(){
  offset.remove();
 }
 public static int getPageSize(){
  Integer ps = (Integer)pageSize.get();
  if(ps == null){
   return Integer.MAX_VALUE;
  }
  return ps;
 }
 public static void setPageSize(int pageSizevalue){
  pageSize.set(pageSizevalue);
 }
 public static void removePageSize(){
  pageSize.remove();
 }
}
//6.过滤器中初始化pagesize、offset:
public class PagerFilter implements Filter {
 public void destroy() {
 }
 public void doFilter(ServletRequest request, ServletResponse response,
   FilterChain chain) throws IOException, ServletException {
  HttpServletRequest httpRequest =(HttpServletRequest)request;
  SystemContext.setOffset(getOffset(httpRequest));
  SystemContext.setPageSize(getPageSize(httpRequest));
  try{
   chain.doFilter(request, response);
  }finally{
   //清空ThreadLocal中的值
   SystemContext.removeOffset();
   SystemContext.removePageSize();
  }   
 }
 public void init(FilterConfig arg0) throws ServletException {
 }
 public int getOffset(HttpServletRequest request){
  int offset = 0;
  try {
   offset = Integer.parseInt(request.getParameter("pager.offset"));
  } catch (NumberFormatException ignore) {
  }
  return offset;
 } 
        //设置每页显示多少条记录
 public int getPageSize(HttpServletRequest request){
  return 3;
 }
}
//7.配置过滤器web.xml中:
<filter>
 <filter-name>pager-taglib</filter-name>
 <filter-class>com.oa.util.filter.PagerFilter</filter-class>
</filter>
<filter-mapping>
 <filter-name>pager-taglib</filter-name>
 <url-pattern>/*</url-pattern>
</filter-mapping>
//8.显示效果:
<pg:pager url="org.do" items="${pm.total }" export="currentPageNumber=pageNumber">
 <pg:param name="parentId"/>
 <pg:first>
  <a href="${pageUrl}" mce_href="${pageUrl}">首页</a>
 </pg:first>
 <pg:prev>
  <a href="${pageUrl }" mce_href="${pageUrl }">前页</a>
 </pg:prev>
 <pg:pages>
  <c:choose>
   <c:when test="${currentPageNumber eq pageNumber }">
   <font color="red">${pageNumber }</font>
   </c:when>
   <c:otherwise>
    <a href="${pageUrl }" mce_href="${pageUrl }">${pageNumber }</a>
   </c:otherwise>
  </c:choose>
 </pg:pages>
 <pg:next>
  <a href="${pageUrl }" mce_href="${pageUrl }">后页</a>
 </pg:next>
 <pg:last>
  <a href="${pageUrl }" mce_href="${pageUrl }">尾页</a>
 </pg:last>
</pg:pager>

    本站是提供个人知识管理的网络存储空间,所有内容均由用户发布,不代表本站观点。请注意甄别内容中的联系方式、诱导购买等信息,谨防诈骗。如发现有害或侵权内容,请点击一键举报。
    转藏 分享 献花(0

    0条评论

    发表

    请遵守用户 评论公约

    类似文章 更多