devbox
小蓝xlanll
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

用hibernate实现动态查询+分页的模板，另附struts2的标签在分页中的使用_hibernate的动态标签

作者：小蓝xlanll | 2024-05-03 09:54:04

赞

踩

hibernate的动态标签

用hibernate实现动态查询+分页的模板，适合于所有的页面

封装页面的信息，进行了泛型。

PageInfo.java
复制代码 
 1  package cn.jbit.auction.entity;
 2 
 3 import java.util.List;
 4 /**
 5  * 分页封装类
 6  */
 7 public class PageInfo<T> {//此处进行了泛型<T>,使用与所有的对象
 8     public static final int PAGESIZE = 3;
 9     private Integer count;// 总记录数
10     private List<T> pageList;// 当前页的记录集合
11     private Integer pageIndex;// 当前页号
12     private Integer totalPages;// 总页数
13 
14     public Integer getCount() {
15         return count;
16     }
17 
18     public void setCount(Integer count) {
19         this.count = count;
20     }
21 
22     public List<T> getPageList() {
23         return pageList;
24     }
25 
26     public void setPageList(List<T> pageList) {
27         this.pageList = pageList;
28     }
29 
30     public Integer getPageIndex() {
31         return pageIndex;
32     }
33 
34     public void setPageIndex(Integer pageIndex) {
35         this.pageIndex = pageIndex;
36     }
37 
38     public Integer getTotalPages() {
39         this.totalPages = this.count / this.PAGESIZE;
40         if (this.count % this.PAGESIZE != 0)
41             this.totalPages++;
42         return this.totalPages;
43     }
44 
45 }
复制代码

jsp页面auctionList.jsp

复制代码 
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
<link href="css/common.css" rel="stylesheet" type="text/css" />
<link href="css/style.css" rel="stylesheet" type="text/css" />
<script type="text/javascript">
    function goToPage(pageIndex){
        document.forms[0].action=document.forms[0].action+"?pageIndex="+pageIndex;
        document.forms[0].submit();
    }
</script>
</head>

<body>
<form method="post" action="auctionList">
<div class="wrap">
<!-- main begin-->
  <div class="sale">
    <h1 class="lf">在线拍卖系统</h1>
      <c:if test="${not empty sessionScope.user}">
        <div class="logout right"><a href="doLogout" title="注销">注销</a></div>
    </c:if>
    <c:if test="${empty sessionScope.user}">
        <div class="logout right"><a href="login.jsp" title="登录">登录</a></div>
    </c:if>
  </div>
  <div class="forms">
    <label for="name">名称</label>
    <input name="auctionName" type="text" class="nwinput" id="name"/>
    <label for="names">描述</label>
    <input name="auctionDesc" type="text" id="names" class="nwinput"/>
    <label for="time">开始时间</label>
    <input name="auctionStartTime" type="text" id="time" class="nwinput"/>
    <label for="end-time">结束时间</label>
    <input name="auctionEndTime" type="text" id="end-time" class="nwinput" />
    <label for="price">起拍价</label>
    <input name="auctionStartPrice" type="text" id="price" class="nwinput" />
    <input type="submit"  value="查询" class="spbg buttombg f14  sale-buttom"/>
    <c:if test="${sessionScope.user.userisadmin==true}">
        <input type="button" οnclick="location='addAuction.jsp'"  value="发布" class="spbg buttombg f14  sale-buttom buttomb"/>
    </c:if>
    <br/>
    <c:if test="${sessionScope.user.userisadmin==false}">
      &nbsp;&nbsp;&nbsp;&nbsp;<a href="auctionResult"><b>查看竞拍结果</b></a>
      </c:if>
  </div>
  <div class="items">
      <ul class="rows even strong">
        <li>名称</li>
        <li class="list-wd">描述</li>
        <li>开始时间</li>
        <li>结束时间</li>
        <li>起拍价</li>
        <li class="borderno">操作</li>
      </ul>
      <c:forEach items="${requestScope.auctionPageInfo.pageList }" var="auction">
      <ul class="rows">
        <li>${auction.auctionname }</li>
        <li class="list-wd">${auction.auctiondesc }</li>
        <li>${auction.auctionstarttime }</li>
        <li>${auction.auctionendtime }</li>
        <li>${auction.auctionstartprice }</li>
        <li class="borderno red">
            <c:if test="${sessionScope.user.userisadmin==true }">
                   修改|
                  删除
              </c:if>
            <c:if test="${sessionScope.user.userisadmin==false }">
                  <a href="auctionDetail?auctionId=${auction.auctionid }">竞拍</a>
              </c:if>
        </li>
      </ul>
      </c:forEach>
      <div class="page">
        <a href="javascript:goToPage(1)">首页</a>
        <c:if test="${requestScope.auctionPageInfo.pageIndex!=1}">
            <a href="javascript:goToPage(${requestScope.auctionPageInfo.pageIndex-1 })">上一页</a>
        </c:if>
        <c:forEach step="1" begin="1" end="${requestScope.auctionPageInfo.totalPages }" var="pageIndex">
        <a href="javascript:goToPage(${pageIndex })">${pageIndex }</a>
        </c:forEach> 
        <c:if test="${requestScope.auctionPageInfo.pageIndex!=requestScope.auctionPageInfo.totalPages}">
            <a href="javascript:goToPage(${requestScope.auctionPageInfo.pageIndex+1 })">下一页</a>
        </c:if>
        <a href="javascript:goToPage(${requestScope.auctionPageInfo.totalPages })" >尾页</a> 
      </div>
  </div>
<!-- main end-->
</div>
</form>
</body>
</html>
复制代码

Servlet页面

AuctionListServlet
复制代码 
package cn.jbit.auction.web;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import cn.jbit.auction.biz.IAuctionBiz;
import cn.jbit.auction.biz.impl.AuctionBizImpl;
import cn.jbit.auction.entity.Auction;
import cn.jbit.auction.entity.PageInfo;
import cn.jbit.auction.util.Tool;

public class AuctionListServlet extends EncodingServlet {

    
    public AuctionListServlet() {
        super();
    }

    
    public void destroy() {
        super.destroy(); // Just puts "destroy" string in log
        // Put your code here
    }

    
    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        this.doPost(request, response);
    }

    
    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        try {
            IAuctionBiz biz = new AuctionBizImpl();
            int pageIndex=1;
            if(request.getParameter("pageIndex")!=null){
                pageIndex=new Integer(request.getParameter("pageIndex")).intValue();
            }
            Auction condition=new Auction();
            if(request.getParameter("auctionName")!=null&&!"".equals(request.getParameter("auctionName"))){
                condition.setAuctionname(request.getParameter("auctionName"));
            }
            if(request.getParameter("auctionDesc")!=null&&!"".equals(request.getParameter("auctionDesc"))){
                condition.setAuctiondesc(request.getParameter("auctionDesc"));
            }
            if(request.getParameter("auctionStartTime")!=null&&!"".equals(request.getParameter("auctionStartTime"))){
                condition.setAuctionstarttime(new java.sql.Timestamp(Tool.strToDate(request.getParameter("auctionStartTime"), "yyyy-MM-dd HH:mm:dd").getTime()));
            }
            if(request.getParameter("auctionEndTime")!=null&&!"".equals(request.getParameter("auctionEndTime"))){
                condition.setAuctionendtime(new java.sql.Timestamp(Tool.strToDate(request.getParameter("auctionEndTime"), "yyyy-MM-dd HH:mm:dd").getTime()));
            }
            if(request.getParameter("auctionStartPrice")!=null&&!"".equals(request.getParameter("auctionStartPrice"))){
                condition.setAuctionstartprice(new Double(request.getParameter("auctionStartPrice")));
            }            
            PageInfo<Auction> auctionPageinfo = biz.find(condition,pageIndex);
            request.setAttribute("auctionPageInfo", auctionPageinfo);
            request.getRequestDispatcher("auctionList.jsp").forward(request, response);
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
            request.setAttribute("message", e.getMessage());
            request.getRequestDispatcher("error.jsp").forward(request,response);
        }
    }

    public void init() throws ServletException {
        // Put your code here
    }

}
复制代码

  dao层的实现方法

复制代码 
public PageInfo<Auction> select(Auction condition, int pageIndex)
            throws Exception {
        PageInfo<Auction> pageInfo = new PageInfo<Auction>();
        Session session = HibernateUtil.currentSession();
        DetachedCriteria dc = DetachedCriteria.forClass(Auction.class);
        Criteria c = session.createCriteria(Auction.class);// 用于列表
        Criteria c1 = session.createCriteria(Auction.class);// 用于查询总记录数
        if (condition.getAuctionname() != null
                && !condition.getAuctionname().equals("")) {
            c.add(Restrictions.ilike("auctionname", condition.getAuctionname(),
                    MatchMode.ANYWHERE));
            c1.add(Restrictions.ilike("auctionname",
                    condition.getAuctionname(), MatchMode.ANYWHERE));
        }
        if (condition.getAuctiondesc() != null
                && !"".equals(condition.getAuctiondesc())) {
            c.add(Restrictions.ilike("auctiondesc", condition.getAuctiondesc(),
                    MatchMode.ANYWHERE));
            c1.add(Restrictions.ilike("auctiondesc",
                    condition.getAuctiondesc(), MatchMode.ANYWHERE));
        }
        if (condition.getAuctionstarttime() != null) {
            c.add(Restrictions.ge("auctionstarttime",
                    condition.getAuctionstarttime()));
            c1.add(Restrictions.ge("auctionstarttime",
                    condition.getAuctionstarttime()));
        }
        if (condition.getAuctionendtime() != null) {
            c.add(Restrictions.le("auctionendtime",
                    condition.getAuctionendtime()));
            c1.add(Restrictions.le("auctionendtime",
                    condition.getAuctionendtime()));
        }
        if (condition.getAuctionstartprice() != null) {
            c.add(Restrictions.ge("auctionstartprice",
                    condition.getAuctionstartprice()));
            c1.add(Restrictions.ge("auctionstartprice",
                    condition.getAuctionstartprice()));
        }
        c.addOrder(Order.desc("auctionstarttime"));
        // 总记录数
        int count = (Integer) c1.setProjection(Projections.rowCount())
                .uniqueResult();
        pageInfo.setCount(count);
        // 当前页号
        pageInfo.setPageIndex(pageIndex);
        // 分页
        // 每页显示的记录数
        c.setMaxResults(PageInfo.PAGESIZE);
        c.setFirstResult((pageIndex - 1) * PageInfo.PAGESIZE);
        List<Auction> list = c.list();
        pageInfo.setPageList(list);
        return pageInfo;
    }
复制代码




dao层接口

PageInfo<Auction> select(Auction condition,int pageIndex) throws Exception;

biz层的实现方法

public PageInfo<Auction> find(Auction condition,int pageIndex) throws Exception {
        return this.dao.select(condition, pageIndex);
    }

==========================================

  1. <tr>
  2.                                               <td width="8%" class="add_listfont" >客户类别：</td>
  3.                                               <td width="15%" bgcolor="#FFFFFF">
  4.                                               <span style="white-space:pre">	</span><select name="tbContact.tbContactType.conTypeId" id="plan_comu_type" style="width:130px" class="input">
  5. <span style="white-space:pre">								</span>            <span style="white-space:pre">		</span><option value="">--请选择--</option>
  6. <span style="white-space:pre">								</span>            <span style="white-space:pre">		</span><s:iterator value="#session.contactTypeList" var="conType">
  7. <span style="white-space:pre">								</span>            <span style="white-space:pre">		</span><s:if test="#session.tbContact.tbContactType.conTypeId==#conType.conTypeId">
  8. <span style="white-space:pre">								</span>            <span style="white-space:pre">			</span><option value="<s:property value='#conType.conTypeId'/>" selected="selected"><s:property value="#conType.conTypeName"/></option>
  9. <span style="white-space:pre">								</span>            <span style="white-space:pre">		</span></s:if><s:else>
  10. <span style="white-space:pre">								</span>            <span style="white-space:pre">			</span><option value="<s:property value='#conType.conTypeId'/>"><s:property value="#conType.conTypeName"/></option>
  11. <span style="white-space:pre">								</span>            <span style="white-space:pre">		</span></s:else>
  12. <span style="white-space:pre">								</span>            <span style="white-space:pre">		</span></s:iterator>
  13. <span style="white-space:pre">								</span>            <span style="white-space:pre">	</span></select>
  14.                                               </td><span style="white-space:pre">	</span>
  15.                                               <td width="8%" class="add_listfont">联络方式：</td>
  16.                                               <td width="15%" bgcolor="#FFFFFF">
  17.                                               <span style="white-space:pre">	</span><select name="tbContact.tbContactCusType.conCusId" id="plan_comu_type" style="width:130px" class="input">
  18. <span style="white-space:pre">								</span>            <span style="white-space:pre">		</span><option value="">--请选择--</option>
  19. <span style="white-space:pre">								</span>            <span style="white-space:pre">		</span><s:iterator value="#session.contactCusTypeList" var="conCusType">
  20. <span style="white-space:pre">								</span>            <span style="white-space:pre">		</span><s:if test="#session.tbContact.tbContactCusType.conCusId==#conCusType.conCusId">
  21. <span style="white-space:pre">								</span>            <span style="white-space:pre">			</span><option selected="selected" value="<s:property value='#conCusType.conCusId'/>"><s:property value="#conCusType.conCusName"/></option>
  22. <span style="white-space:pre">								</span>            <span style="white-space:pre">		</span></s:if><s:else>
  23. <span style="white-space:pre">														</span><option value="<s:property value='#conCusType.conCusId'/>"><s:property value='#conCusType.conCusId'/><s:property value="#conCusType.conCusName"/></option>
  24. <span style="white-space:pre">								</span>            <span style="white-space:pre">		</span></s:else>
  25. <span style="white-space:pre">								</span>            <span style="white-space:pre">		</span></s:iterator>
  26. <span style="white-space:pre">								</span>            <span style="white-space:pre">	</span></select>
  27.                                               </td><span style="white-space:pre">	</span>
  28.                                               <td width="8%" class="add_listfont">联络日期：</td>
  29.                                               <td bgcolor="#FFFFFF" style="font-size:12px;">
  30.                                               
  31.                                               <span style="white-space:pre">	</span><input type="text" id="comu_date" name="tbContact.startContactDate" οnclick="WdatePicker({dateFmt:'yyyy-MM-dd'})" value="<s:date name='#session.tbContact.startContactDate' format="yyyy-MM-dd"/>" class="input" style="width:80px;"/>
  32.                                               <span style="white-space:pre">	</span><img src="../../images/pic03.gif" οnclick="WdatePicker({dateFmt:'yyyy-MM-dd',el:'comu_date'})"/>至
  33.                                               
  34.                                                <span style="white-space:pre">	</span><input type="text" id="comu_date_end" name="tbContact.endContactDate" οnclick="WdatePicker({dateFmt:'yyyy-MM-dd'})" value="<s:date name='#session.tbContact.endContactDate' format="yyyy-MM-dd"/>" class="input" style="width:80px;"/>
  35.                                               <span style="white-space:pre">	</span><img src="../../images/pic03.gif" οnclick="WdatePicker({dateFmt:'yyyy-MM-dd',el:'comu_date_end'})"/>
  36.                                              
  37.                                               <span style="white-space:pre">	</span></td>
  38.                                               <td width="8%" class="add_listfont">联络状态：</td>
  39.                                               <td width="15%" bgcolor="#FFFFFF">
  40.                                               <span style="white-space:pre">	</span><select name="tbContact.contactState" id="status" style="width:100px" class="input">
  41. <span style="white-space:pre">								</span>            <span style="white-space:pre">		</span><option value="">--请选择--</option>
  42. <span style="white-space:pre">								</span>            <span style="white-space:pre">		</span><s:if test="#session.tbContact.contactState==1">
  43. <span style="white-space:pre">								</span>            <span style="white-space:pre">			</span><option value="1" selected="selected">未联络</option><span style="white-space:pre">	</span>
  44. <span style="white-space:pre">									</span>            <span style="white-space:pre">		</span><option value="2">跟进中</option>
  45. <span style="white-space:pre">									</span>            <span style="white-space:pre">		</span><option value="3">已结束</option>
  46. <span style="white-space:pre">								</span>            <span style="white-space:pre">		</span></s:if><s:elseif test="">
  47. <span style="white-space:pre">								</span>            <span style="white-space:pre">			</span><option value="1">未联络</option>
  48. <span style="white-space:pre">									</span>            <span style="white-space:pre">		</span><option value="2" selected="selected">跟进中</option>
  49. <span style="white-space:pre">									</span>            <span style="white-space:pre">		</span><option value="3">已结束</option>
  50. <span style="white-space:pre">								</span>            <span style="white-space:pre">		</span></s:elseif>
  51. <span style="white-space:pre">								</span>            <span style="white-space:pre">		</span><s:elseif test="">
  52. <span style="white-space:pre">								</span>            <span style="white-space:pre">			</span><option value="1">未联络</option>
  53. <span style="white-space:pre">									</span>            <span style="white-space:pre">		</span><option value="2">跟进中</option>
  54. <span style="white-space:pre">									</span>            <span style="white-space:pre">		</span><option value="3" selected="selected">已结束</option>
  55. <span style="white-space:pre">								</span>            <span style="white-space:pre">		</span></s:elseif>
  56. <span style="white-space:pre">								</span>            <span style="white-space:pre">		</span><s:else>
  57. <span style="white-space:pre">														</span><option value="1">未联络</option>
  58. <span style="white-space:pre">									</span>            <span style="white-space:pre">		</span><option value="2">跟进中</option>
  59. <span style="white-space:pre">									</span>            <span style="white-space:pre">		</span><option value="3">已结束</option>
  60. <span style="white-space:pre">													</span></s:else>
  61. <span style="white-space:pre">								</span>            <span style="white-space:pre">	</span></select>
  62.                                               </td><span style="white-space:pre">	</span>

  1.  <s:if test="#session.PageHelpContact.allCount>0">
  2.          <table width="100%" border="0" cellspacing="0" cellpadding="0" class="page">
  3. 	          <tr>
  4. 	          <td>   当前第<s:property value="#session.PageHelpContact.pageIndex"/>页，
  5. 		          共<s:property value="#session.PageHelpContact.pageCount"/>页，
  6. 		          共<s:property value="#session.PageHelpContact.allCount"/>条记录</td>
  7. 	          <td width="40"> <a href="javascript:goToPage(1)">首页</a></td>
  8. 	        <s:if test="#session.PageHelpContact.pageIndex!=1"><td width="50">
  9. 	            <a href="javascript:goToPage(<s:property value='#session.PageHelpContact.pageIndex-1'/>)">上一页</a>
  10. 	        	</td></s:if>
  11. 	        <s:if test="#session.PageHelpContact.pageIndex!=#session.PageHelpContact.pageCount"><td width="50">
  12. 	            <a href="javascript:goToPage(<s:property value='#session.PageHelpContact.pageIndex+1'/>)">下一页</a>
  13. 	        	</td></s:if>
  14. 	        <td width="40"><a href="javascript:goToPage(<s:property value='#session.PageHelpContact.pageCount'/>)" >尾页</a> </td>
  15. 	        
  16. 	        
  17. 	          <td width="50">跳转到</td>
  18. 	          <td width="32"><label>
  19. 	            <select name="toPage" id="toPage" style="width:35px;">
  20. 		            <s:iterator step="1" begin="1" end="#session.PageHelpContact.pageCount" var="pageIndex">
  21. 				        <option value="<s:property value='#pageIndex'/>"><s:property value="#pageIndex"/></option>
  22. 			        </s:iterator>
  23. 	            </select>
  24. 	          </label></td>
  25. 	          <td width="20">页</td>
  26. 	          <td width="40">
  27. 	          
  28. 	          	<input name="input" type="button" style="width:30px; height:20px; background-image:url(<%=contextPath %>/images/pagebtn.gif);" οnclick="goto_page();" />
  29. 	          </td>
  30. 	        </tr>
  31. 	         </table>
  32. 	    </s:if>






 
  
 
 
 


                

        
声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/小蓝xlanll/article/detail/529027
推荐阅读
相关标签
Copyright ©  2003-2013 www.wpsshop.cn  版权所有，并保留所有权利。

  
闽ICP备14008679号