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

struts2、hibernate 分页(自定义标签)_req.setattribute("cid", cid);

作者：很楠不爱3 | 2024-05-03 09:51:10

赞

踩

req.setattribute("cid", cid);

class :PagerTag 是用来实现自定义分页标签,继承SimpleTagSupport实现自定义标签

view plaincopy to clipboardprint?

  1. public class PagerTag extends SimpleTagSupport {   
  2.        
  3.     private String uri;//分页要执行的action路径   
  4.     private Integer curpage;//当前页   
  5.     private Integer pagesize;//每页显示的记录数   
  6.     private Integer pagecount;//总页数   
  7.     private Integer rowcount;//总记录数   
  8.        
  9.        
  10.        
  11.     public Integer getCurpage() {   
  12.         return curpage;   
  13.     }   
  14.     public void setCurpage(Integer curpage) {   
  15.         this.curpage = curpage;   
  16.     }   
  17.     public Integer getPagesize() {   
  18.         return pagesize;   
  19.     }   
  20.     public void setPagesize(Integer pagesize) {   
  21.         this.pagesize = pagesize;   
  22.     }   
  23.     public Integer getPagecount() {   
  24.         return pagecount;   
  25.     }   
  26.     public void setPagecount(Integer pagecount) {   
  27.         this.pagecount = pagecount;   
  28.     }   
  29.     public Integer getRowcount() {   
  30.         return rowcount;   
  31.     }   
  32.     public void setRowcount(Integer rowcount) {   
  33.         this.rowcount = rowcount;   
  34.     }   
  35.     public String getUri() {   
  36.         return uri;   
  37.     }   
  38.     public void setUri(String uri) {   
  39.         this.uri = uri;   
  40.     }   
  41.   
  42.     //每次执行标签时会调用toTag   
  43.     public void doTag() throws JspException, IOException {   
  44.        
  45.         //获得页面的输出流   
  46.         JspWriter out  = this.getJspContext().getOut();   
  47.            
  48.            
  49.         //通过流往页面写数据        
  50.         out.println("<div class=/"pager/">");   
  51.         out.println("共" +rowcount+ "行记录,每页");   
  52.         out.println("<input value=/""+ pagesize + "/" size=/"2/" />条");   
  53.         out.println("当前第<input value=/"" + (curpage +1 )+"/" size=/"2/"/>页/共"+ pagecount + "页");   
  54.         out.println("<a href="/" mce_href="/""" + uri+"&curpage=0/">第一页</a>");   
  55.        
  56.         if(curpage > 0) {   
  57.             out.println("<a href="/" mce_href="/""" + uri+"&curpage="+(curpage-1)+"/">上一页</a>");   
  58.         }   
  59.         if(curpage < pagecount -1) {   
  60.             out.println("<a href="/" mce_href="/""" + uri+"&curpage=" + (curpage+1)+"/">下一页</a>");   
  61.         }   
  62.         out.println("<a href="/" mce_href="/""" + uri+"&curpage=" +(pagecount-1)+"/">最后一页</a>");   
  63.         out.println("</div>");   
  64.     }   
  65.        
  66.        
  67.        
  68.   
  69. }  
  70. public class PagerTag extends SimpleTagSupport {
  71.  
  72.  private String uri;//分页要执行的action路径
  73.  private Integer curpage;//当前页
  74.  private Integer pagesize;//每页显示的记录数
  75.  private Integer pagecount;//总页数
  76.  private Integer rowcount;//总记录数
  77.  
  78.  
  79.  
  80.  public Integer getCurpage() {
  81.   return curpage;
  82.  }
  83.  public void setCurpage(Integer curpage) {
  84.   this.curpage = curpage;
  85.  }
  86.  public Integer getPagesize() {
  87.   return pagesize;
  88.  }
  89.  public void setPagesize(Integer pagesize) {
  90.   this.pagesize = pagesize;
  91.  }
  92.  public Integer getPagecount() {
  93.   return pagecount;
  94.  }
  95.  public void setPagecount(Integer pagecount) {
  96.   this.pagecount = pagecount;
  97.  }
  98.  public Integer getRowcount() {
  99.   return rowcount;
  100.  }
  101.  public void setRowcount(Integer rowcount) {
  102.   this.rowcount = rowcount;
  103.  }
  104.  public String getUri() {
  105.   return uri;
  106.  }
  107.  public void setUri(String uri) {
  108.   this.uri = uri;
  109.  }
  111.  //每次执行标签时会调用toTag
  112.  public void doTag() throws JspException, IOException {
  113.  
  114.   //获得页面的输出流
  115.   JspWriter out  = this.getJspContext().getOut();
  116.   
  117.   
  118.   //通过流往页面写数据  
  119.   out.println("<div class=/"pager/">");
  120.   out.println("共" +rowcount+ "行记录,每页");
  121.   out.println("<input value=/""+ pagesize + "/" size=/"2/" />条");
  122.   out.println("当前第<input value=/"" + (curpage +1 )+"/" size=/"2/"/>页/共"+ pagecount + "页");
  123.   out.println("<a href="/" mce_href="/""" + uri+"&curpage=0/">第一页</a>");
  124.  
  125.   if(curpage > 0) {
  126.    out.println("<a href="/" mce_href="/""" + uri+"&curpage="+(curpage-1)+"/">上一页</a>");
  127.   }
  128.   if(curpage < pagecount -1) {
  129.    out.println("<a href="/" mce_href="/""" + uri+"&curpage=" + (curpage+1)+"/">下一页</a>");
  130.   }
  131.   out.println("<a href="/" mce_href="/""" + uri+"&curpage=" +(pagecount-1)+"/">最后一页</a>");
  132.   out.println("</div>");
  133.  }
  134.  
  135.  
  136.  
  138. }



标签的tld文件 ：my.tld

view plaincopy to clipboardprint?

  1. <?xml version="1.0" encoding="UTF-8" ?>  
  2.   
  3. <taglib xmlns="http://java.sun.com/xml/ns/javaee"  
  4.     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  
  5.     xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-jsptaglibrary_2_1.xsd"  
  6.     version="2.1">  
  7.        
  8.      
  9.   <tlib-version>1.1</tlib-version>  
  10.   <short-name>my</short-name>  
  11.      
  12.   <!-- uri用来定位标签库  -->  
  13.   <uri>http://java.pojo.com/tag</uri>  
  14.   
  15.      
  16.     <!-- tag用来声明一个标签   
  17.     name:界面中标签的名字   
  18.     tag-class:标签的类名   
  19.     bodyContent:表示标签体的内容的形式   
  20.     attribute: 用来声明标签类具有的属性   
  21.         name:属性名   
  22.         required:是否一定要赋值   
  23.         rtexprvalue:是否允许使用el表达式   
  24.      -->  
  25.   <tag>  
  26.     <name>pager</name>  
  27.     <tag-class>com.pojo.web.tag.PagerTag</tag-class>  
  28.     <body-content>empty</body-content>  
  29.     <attribute>  
  30.         <name>uri</name>  
  31.         <required>true</required>  
  32.         <rtexprvalue>true</rtexprvalue>  
  33.     </attribute>  
  34.     <attribute>  
  35.         <name>curpage</name>  
  36.         <required>true</required>  
  37.         <rtexprvalue>true</rtexprvalue>  
  38.     </attribute>  
  39.     <attribute>  
  40.         <name>pagesize</name>  
  41.         <required>true</required>  
  42.         <rtexprvalue>true</rtexprvalue>  
  43.     </attribute>  
  44.     <attribute>  
  45.         <name>pagecount</name>  
  46.         <required>true</required>  
  47.         <rtexprvalue>true</rtexprvalue>  
  48.     </attribute>  
  49.     <attribute>  
  50.         <name>rowcount</name>  
  51.         <required>true</required>  
  52.         <rtexprvalue>true</rtexprvalue>  
  53.     </attribute>  
  54.   </tag>  
  55.   
  56. </taglib>  
  57. <?xml version="1.0" encoding="UTF-8" ?>
  58.  
  59. <taglib xmlns="http://java.sun.com/xml/ns/javaee"
  60.     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  61.     xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-jsptaglibrary_2_1.xsd"
  62.     version="2.1">
  63.     
  64.   
  65.   <tlib-version>1.1</tlib-version>
  66.   <short-name>my</short-name>
  67.   
  68.   <!-- uri用来定位标签库  -->
  69.   <uri>http://java.pojo.com/tag</uri>
  70.  
  71.   
  72.  <!-- tag用来声明一个标签
  73.  name:界面中标签的名字
  74.  tag-class:标签的类名
  75.  bodyContent:表示标签体的内容的形式
  76.  attribute: 用来声明标签类具有的属性
  77.   name:属性名
  78.   required:是否一定要赋值
  79.   rtexprvalue:是否允许使用el表达式
  80.   -->
  81.   <tag>
  82.     <name>pager</name>
  83.     <tag-class>com.pojo.web.tag.PagerTag</tag-class>
  84.     <body-content>empty</body-content>
  85.     <attribute>
  86.         <name>uri</name>
  87.         <required>true</required>
  88.         <rtexprvalue>true</rtexprvalue>
  89.     </attribute>
  90.     <attribute>
  91.         <name>curpage</name>
  92.         <required>true</required>
  93.         <rtexprvalue>true</rtexprvalue>
  94.     </attribute>
  95.     <attribute>
  96.         <name>pagesize</name>
  97.         <required>true</required>
  98.         <rtexprvalue>true</rtexprvalue>
  99.     </attribute>
  100.     <attribute>
  101.         <name>pagecount</name>
  102.         <required>true</required>
  103.         <rtexprvalue>true</rtexprvalue>
  104.     </attribute>
  105.     <attribute>
  106.         <name>rowcount</name>
  107.         <required>true</required>
  108.         <rtexprvalue>true</rtexprvalue>
  109.     </attribute>
  110.   </tag>
  111.  
  112. </taglib>
  113.  
  114.



模糊查询加分页的展示jsp界面

  1. view plaincopy to clipboardprint?
  2. <%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>  
  3. <%@ taglib prefix="s" uri="/struts-tags" %>  
  4. <%@ taglib uri="http://java.pojo.com/tag"  prefix="my" %>  
  5. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">  
  6. <html>  
  7.   <head>  
  8.     <title>管理电影档期</title>  
  9.     <!--  
  10.     <link rel="stylesheet" type="text/css" href="styles.css" mce_href="styles.css">  
  11.     -->  
  12.     <link rel="stylesheet" type="text/css" href="/project/css/style_admin.css" mce_href="project/css/style_admin.css">  
  13.     <mce:script type="text/javascript" src="/project/js/date.js" mce_src="project/js/date.js"></mce:script>  
  14.   </head>  
  15.      
  16. <body>  
  17. <form action="Release_findAllPaging.action" method="post" name="form1">  
  18.     <table cellspacing="0" cellpadding="4" width="100%" class="tableborder" id="table3">  
  19.         <tr>  
  20.             <td class="header" colspan="7">  
  21.                 信息查询   
  22.             </td>  
  23.         </tr>  
  24.         <tr align="left">  
  25.             <td width="52px">影片名称</td>  
  26.             <td width="60px"><input type="text" name="filmInfo.fname" /></td>  
  27.             <td width="52px">影厅名称</td>  
  28.             <td width="60px"><s:action name="Cinemainfo2_findAll" namespace="/" executeResult="true" ignoreContextParams="true" /></td>  
  29.             <td width="26px">日期</td>  
  30.             <td width="60px"><INPUT name="rdate" onFocus="this.select();" readonly="readonly" onClick="fPopCalendar(event,this,this);" size="20px"  /></td>  
  31.             <td><input type="submit" value="查询"/></td>  
  32.         </tr>  
  33.     </table>  
  34. </form>  
  35.   
  36. <table cellspacing="1" cellpadding="4" width="100%" class="tableborder" id="table3">  
  37.     <tr>  
  38.         <td colspan="9" class="header">  
  39.             电影档期管理   
  40.         </td>  
  41.     </tr>  
  42.     <tr>                       
  43.         <td align="center" class="altbg1">  
  44.             <b>电影图片</b>  
  45.     </td>  
  46.         <td align="center" class="altbg1">  
  47.             <b>电影名称</b>  
  48.         </td>  
  49.         <td align="center" class="altbg1">  
  50.             <b>日期</b>  
  51.         </td>  
  52.         <td align="center" class="altbg1">  
  53.             <b>时间</b>  
  54.         </td>  
  55.         <td align="center" class="altbg1">  
  56.             <b>影厅</b>  
  57.         </td>                
  58.         <td align="center" class="altbg1">  
  59.             <b>票价</b>  
  60.         </td>  
  61.         <td align="center" class="altbg1">  
  62.             <b>编辑</b>  
  63.         </td>  
  64.         <td align="center" class="altbg1">  
  65.             <b>删除</b>  
  66.         </td>  
  67.         <td align="center" class="altbg1">  
  68.             <b>查看电影订票情况</b>  
  69.         </td>  
  70.     </tr>  
  71. <s:iterator value="#request.list">  
  72.     <tr>  
  73.         <td align="center" class="altbg2">  
  74.             <img src="<s:property value=" mce_src="<s:property value="filmInfo.image" />" width="100px" height="100px" />      
  75.         </td>  
  76.         <td class="altbg2" align="center">  
  77.             <s:property value="filmInfo.fname" />  
  78.         </td>  
  79.         <td class="altbg2" align="center">  
  80.             <s:date name="rdate" format="yyyy-MM-dd" />  
  81.         </td>  
  82.         <td class="altbg2" align="center">  
  83.             <s:date name="rtime" format="HH:mm" />  
  84.         </td>  
  85.         <td class="altbg2" align="center">  
  86.             <s:property value="cinemaInfo.cname" />  
  87.         </td>  
  88.         <td class="altbg2" align="center">  
  89.             <s:property value="filmInfo.price" />元   
  90.         </td>  
  91.         <td class="altbg2" align="center">  
  92.             <a href="javascript:if(confirm('确实要删除吗?'))window.location='Release_delete.action?rid=<s:property value=" mce_href="javascript:if(confirm('确实要删除吗?'))window.location='Release_delete.action?rid=<s:property value="rid" ></a>'">删除</a>         
  93.         </td>                
  94.         <td class="altbg2" align="center">  
  95.             <a href="Release_show.action?rid=<s:property value=" mce_href="Release_show.action?rid=<s:property value="rid" ></a>">修改</a>    
  96.         </td>  
  97.         <td class="altbg2" align="center">  
  98.             <a href="SaleAction_getSaleByCondition.action?cid=<s:property value=" mce_href="SaleAction_getSaleByCondition.action?cid=<s:property value="cinemaInfo.cid"></a>&fid=<s:property value="filmInfo.fid"/>&rdate=<s:date name="rdate" format="yyyy-MM-dd"/>&rtime=<s:property value="rtime"/>">查看</a>    
  99.         </td>  
  100.     </tr>  
  101. </s:iterator>  
  102.     <tr style="font-size:12px" mce_style="font-size:12px" align="right">  
  103.         <th colspan="100" class="pager">  
  104.             <my:pager uri="Release_findAllPaging.action?temp=1&filmInfo.fname=${fname}&cinemaInfo.cid=${cid}&rdate=${rdate}"  
  105.                 curpage="${ curpage }"  
  106.                 pagesize="${ pagesize}"  
  107.                 pagecount="${ pagecount}"  
  108.                 rowcount="${rowcount }"  
  109.             />      
  110.         </th>  
  111.     </tr>                
  112. </table>     
  113. </body>  
  114. </html>  
  115. <%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
  116. <%@ taglib prefix="s" uri="/struts-tags" %>
  117. <%@ taglib uri="http://java.pojo.com/tag"  prefix="my" %>
  118. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  119. <html>
  120.   <head>
  121.    <title>管理电影档期</title>
  122.  <!--
  123.  <link rel="stylesheet" type="text/css" href="styles.css" mce_href="styles.css">
  124.  -->
  125.  <link rel="stylesheet" type="text/css" href="/project/css/style_admin.css" mce_href="project/css/style_admin.css">
  126.    <mce:script type="text/javascript" src="/project/js/date.js" mce_src="project/js/date.js"></mce:script>
  127.   </head>
  128.   
  129. <body>
  130. <form action="Release_findAllPaging.action" method="post" name="form1">
  131.  <table cellspacing="0" cellpadding="4" width="100%" class="tableborder" id="table3">
  132.   <tr>
  133.    <td class="header" colspan="7">
  134.     信息查询
  135.    </td>
  136.   </tr>
  137.   <tr align="left">
  138.    <td width="52px">影片名称</td>
  139.    <td width="60px"><input type="text" name="filmInfo.fname" /></td>
  140.    <td width="52px">影厅名称</td>
  141.    <td width="60px"><s:action name="Cinemainfo2_findAll" namespace="/" executeResult="true" ignoreContextParams="true" /></td>
  142.    <td width="26px">日期</td>
  143.    <td width="60px"><INPUT name="rdate" onFocus="this.select();" readonly="readonly" onClick="fPopCalendar(event,this,this);" size="20px"  /></td>
  144.    <td><input type="submit" value="查询"/></td>
  145.   </tr>
  146.  </table>
  147. </form>
  148.  
  149. <table cellspacing="1" cellpadding="4" width="100%" class="tableborder" id="table3">
  150.  <tr>
  151.   <td colspan="9" class="header">
  152.    电影档期管理
  153.   </td>
  154.  </tr>
  155.  <tr>                    
  156.   <td align="center" class="altbg1">
  157.    <b>电影图片</b>
  158.  </td>
  159.   <td align="center" class="altbg1">
  160.    <b>电影名称</b>
  161.   </td>
  162.   <td align="center" class="altbg1">
  163.    <b>日期</b>
  164.   </td>
  165.   <td align="center" class="altbg1">
  166.    <b>时间</b>
  167.   </td>
  168.   <td align="center" class="altbg1">
  169.    <b>影厅</b>
  170.   </td>    
  171.   <td align="center" class="altbg1">
  172.    <b>票价</b>
  173.   </td>
  174.   <td align="center" class="altbg1">
  175.    <b>编辑</b>
  176.   </td>
  177.   <td align="center" class="altbg1">
  178.    <b>删除</b>
  179.   </td>
  180.   <td align="center" class="altbg1">
  181.    <b>查看电影订票情况</b>
  182.   </td>
  183.  </tr>
  184. <s:iterator value="#request.list">
  185.  <tr>
  186.   <td align="center" class="altbg2">
  187.    <img src="<s:property value=" mce_src="<s:property value="filmInfo.image" />" width="100px" height="100px" />   
  188.   </td>
  189.   <td class="altbg2" align="center">
  190.    <s:property value="filmInfo.fname" />
  191.   </td>
  192.   <td class="altbg2" align="center">
  193.    <s:date name="rdate" format="yyyy-MM-dd" />
  194.   </td>
  195.   <td class="altbg2" align="center">
  196.    <s:date name="rtime" format="HH:mm" />
  197.   </td>
  198.   <td class="altbg2" align="center">
  199.    <s:property value="cinemaInfo.cname" />
  200.   </td>
  201.      <td class="altbg2" align="center">
  202.       <s:property value="filmInfo.price" />元
  203.   </td>
  204.   <td class="altbg2" align="center">
  205.    <a href="javascript:if(confirm('确实要删除吗?'))window.location='Release_delete.action?rid=<s:property value=" mce_href="javascript:if(confirm('确实要删除吗?'))window.location='Release_delete.action?rid=<s:property value="rid" ></a>'">删除</a>   
  206.   </td>    
  207.   <td class="altbg2" align="center">
  208.    <a href="Release_show.action?rid=<s:property value=" mce_href="Release_show.action?rid=<s:property value="rid" ></a>">修改</a> 
  209.   </td>
  210.   <td class="altbg2" align="center">
  211.    <a href="SaleAction_getSaleByCondition.action?cid=<s:property value=" mce_href="SaleAction_getSaleByCondition.action?cid=<s:property value="cinemaInfo.cid"></a>&fid=<s:property value="filmInfo.fid"/>&rdate=<s:date name="rdate" format="yyyy-MM-dd"/>&rtime=<s:property value="rtime"/>">查看</a> 
  212.   </td>
  213.  </tr>
  214. </s:iterator>
  215.  <tr style="font-size:12px" mce_style="font-size:12px" align="right">
  216.   <th colspan="100" class="pager">
  217.    <my:pager uri="Release_findAllPaging.action?temp=1&filmInfo.fname=${fname}&cinemaInfo.cid=${cid}&rdate=${rdate}"
  218.     curpage="${ curpage }"
  219.     pagesize="${ pagesize}"
  220.     pagecount="${ pagecount}"
  221.     rowcount="${rowcount }"
  222.    /> 
  223.   </th>
  224.  </tr>          
  225. </table>  
  226. </body>
  227. </html>
  228.  
  229.


 

这里注意到的一点就是 需要导入自定义标签

还有一点 注意到自定义标签<my> uri的写法  由于我的想法是 将查询条件利用参数传递过去(参数存在request作用域下)

最重要的就是我在路径后面加上了一个temp参数 方便没有带条件的查询[条件的参数为空] (需要对比前面的分页标签类里的uri写法)

上面 Release_findAllPaging.action  在struts.xml里配置 不打算贴出来了 对应的类是ReleaseAction 调用的dao类为ReleaseDao

ReleaseAction类重要方法和属性(get set 方法省略...)

//保存分页的属性
 protected Integer curpage = 0;//当前第几页
 protected Integer pagesize = 4;//每页条数
 protected Integer pagecount;//总页数
 protected Integer rowcount; //总行数

//分页查询
 public String findAllPaging(){
  //地址栏提交中文  tomcat 配置 URIEncoding="GB2312"
  HttpServletRequest req = ServletActionContext.getRequest();//拿到请求对象
  //表单里的值
  String fname = req.getParameter("filmInfo.fname");
  
  String cid = req.getParameter("cinemaInfo.cid");
  String rdate = req.getParameter("rdate");
  if(fname != null && !fname.equals("")){
   req.setAttribute("fname", fname);//不为空的话,放到request作用域下
  }
  if(cid != null && !cid.equals("")){
   req.setAttribute("cid", cid);
  }
  if(rdate != null && !rdate.equals("")){
   req.setAttribute("rdate", rdate);
  }
  
  if(fname == null){
   fname = (String)req.getAttribute("fname");//等于空 从request作用域下取
  }
  if(cid == null){
   cid = (String)req.getAttribute("cid");
  }
  if(rdate == null || rdate.equals("")){
   rdate = (String)req.getAttribute("rdate");
  }
  
  request.put("list",dao.findAllPaging(curpage, pagesize, fname, cid, rdate));//查询当前页的记录 放到list里
  //存入当前页
  request.put("curpage", curpage);
  //存入每页条数
  request.put("pagesize", pagesize);
  
  //调用dao获得总行数
  Integer rowcount = dao.getRowCount(fname,cid,rdate);
  //算出总页数
  //101行，每页10条 10.1 使用11页
  int pagecount =(int)Math.ceil( (rowcount /( pagesize + 0.0)) );
  //总页数
  request.put("pagecount", pagecount);
  //总条数
  request.put("rowcount", rowcount);
  
  return "listAction";
 }


dao类重要方法

//根据条件 模糊查询 总记录数
 public Integer getRowCount(String fname,String cid,String rdate){
  String strSQL = "select count(r) from Release as r where 1 = 1";
  if(fname != null && !fname.equals("")){//如果equals在前面的话，容易报 nullpoint 异常
   strSQL += " and r.filmInfo.fname like :fname";
  }
  if(cid != null && !cid.equals("")){
   strSQL += " and r.cinemaInfo.cid = :cid";
  }
  
  if(rdate != null && !rdate.equals("")){
   strSQL += " and r.rdate = :rdate";
  }
  Query query = HibernateSessionFactory.getSession().createQuery(strSQL);
  
  if(fname != null && !fname.equals("")){//如果equals在前面的话，容易报 nullpoint 异常
   query.setString("fname", "%" + fname + "%");
  }
  if(cid != null && !cid.equals("")){
   query.setInteger("cid", new Integer(cid));
  }
  
  if(rdate != null && !rdate.equals("")){
   query.setString("rdate", rdate);
  }
  
  List list = query.list();
  return (Integer)list.get(0);
 }
 
 
 //分页模糊查询 档期
 public List findAllPaging(int curpage,int pagesize,String fname,String cid,String rdate) {
  String strSQL = "select r from Release as r where 1 = 1";
  
  if(fname != null && !fname.equals("")){//如果equals在前面的话，容易报 nullpoint 异常
   strSQL += " and r.filmInfo.fname like :fname";
  }
  if(cid != null && !cid.equals("")){
   strSQL += " and r.cinemaInfo.cid = :cid";
  }
  
  if(rdate != null && !rdate.equals("")){
   strSQL += " and r.rdate = :rdate";
  }
  Query query = HibernateSessionFactory.getSession().createQuery(strSQL);
  if(fname != null && !fname.equals("")){//如果equals在前面的话，容易报 nullpoint 异常
   query.setString("fname", "%" + fname + "%");
  }
  if(cid != null && !cid.equals("")){
   query.setInteger("cid", new Integer(cid));
  }
  
  if(rdate != null && !rdate.equals("")){
   query.setString("rdate", rdate);
  }
  query.setFirstResult(curpage*pagesize)
    .setMaxResults(pagesize);
  List list = query.list();
  return list;
 }
 

还有要注意点的是 条件是采用get方式传递 中文的问题解决 需在tomcat下配置文件 加上URIEncoding="GB2312"

 

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/jayqean/archive/2010/06/20/5681763.aspx

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

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号