Struts2+Hibernate+Spring带条件的分页查询

最新推荐文章于 2019-06-19 15:43:29 发布

ld191474639

最新推荐文章于 2019-06-19 15:43:29 发布

阅读量5.8k

点赞数

文章标签： hibernate struts spring action string list

本文链接：https://blog.csdn.net/ld191474639/article/details/7325287

版权

Action类

public class ShopAction extends ActionSupport{

//省略get,set方法

@Resource ShopDao shop;  //接口注入

private List list; //集合

private int PageNow=1;  //当前页数，又称开始页

private int PageSize=6;  //当前页数需要显示的条数
private int PageCount=1; //总页数

private String bname; 书名

public String cha(){
 
 PageCount=this.shop.Count(bname);  //根据输入的名字,传入这个方法中
  list=this.shop.getname(bname, PageNow, PageSize);  );//根据输入的名字,传入这个方法中

 
 return SUCCESS;

}

 

}

另一个bean类

@Service @Transactional    //事务的提交

public class Shopbean implements ShopDao{

private Connection ct=null;
 private PreparedStatement ps=null;
 private ResultSet rs=null;

 @Resource private SessionFactory sessionFactory;  //注入

public List getname(String bname, int PageNow, int PageSize) { //执行上面传过来的参数
  Query query=this.sessionFactory.getCurrentSession().createQuery("from Book where bname like '%"+bname+"%'");  //带条件的查询语句
  query.setFirstResult((PageNow-1)*PageSize);
  query.setMaxResults(PageSize);
  List list=query.list();
  return list;
 }

public int Count(String bname) {   //根据上面传过来的参数，执行这个方法
 int rowCount=0;
 int PageSize=6;
 int PageCount=0;
 try{
  ct=new Conn().getconn();
  ps=ct.prepareStatement("select count(*) from  book where bname like '%"+bname+"%'"); //根据传过来的参数，来查询总共有多少条数据符合这个参数。
  rs=ps.executeQuery();
  if(rs.next()){
   rowCount=rs.getInt(1);
   }
  if(rowCount%PageSize==0){
   PageCount=rowCount/PageSize;    //总条数%条数=总页数；
  }else{
   PageCount=rowCount/PageSize+1;
  }
 }catch(Exception e){
  e.printStackTrace();           //关闭数据库省略，你们自己加上。
 }
  return PageCount;
 }

}

页面Find.jsp

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ taglib prefix="s" uri="/struts-tags"%>  //Struts2标签

<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
 
    <base href="<%=basePath%>">
    
    <title>My JSP 'Find.jsp' starting page</title>
    
 <meta http-equiv="pragma" content="no-cache">
 <meta http-equiv="cache-control" content="no-cache">
 <meta http-equiv="expires" content="0">    
 <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
 <meta http-equiv="description" content="This is my page">
 <!--
 <link rel="stylesheet" type="text/css" href="styles.css">
 -->

  </head>
  
  <body>
  
<jsp:include page="First.jsp"></jsp:include>

   <s:iterator value="list">
   
<s:url action="work.action" id="a">
<s:param value="bid" name="bid"></s:param>
</s:url>
<s:url action="Su.action" id="q">
   <s:param name="bid" value="bid"/>
 <s:param name="num" value="num"/>
   
   </s:url>
<table width="100%" border="0">
  <tr>
    <th height="246" scope="col"><table width="100%" border="0">
      <tr>
        <th width="25%" rowspan="4" scope="col"><s:a href="%{a}"><img src="img/<s:property value='photo'/>" width="111" height="153" border="0"/></s:a></th>
        <th width="75%" scope="col"><div align="left"><s:property value="bname"/></div></th>
      </tr>
      <tr>
        <td><br><br></td>
      </tr>
      <tr>
        <td><div align="left"><font color="#FF0000">价格:￥<s:property value="price"/>元</font></div></td>
      </tr>
      <tr>
        <td height="47"><s:a href="%{q}"><img src="img/<s:property value='photos'/>" width="191" height="77" border="0"/></s:a></td>
      </tr>
    </table></th>
  </tr>
  <input type="hidden" name="bid" value="<%=request.getParameter("bid")%>"/>
</table>
 
   </s:iterator>
   
<s:url action="Query.action" id="u">
<s:param name="PageNow" value="1"></s:param>
<s:param name="bname" value="bname"/>


</s:url>
<s:url action="Query.action" id="w">
<s:param name="PageNow" value="PageNow-1"></s:param>
<s:param name="bname" value="bname"></s:param>

</s:url>
<s:url action="Query.action" id="e">
<s:param name="PageNow" value="PageNow+1"></s:param>
<s:param name="bname" value="bname"></s:param>
</s:url>
<s:url id="l" action="Query.action">
<s:param name="PageNow" value="PageCount"></s:param>
<s:param name="bname" value="bname"/>
</s:url>

<s:property value="PageNow"/>/<s:property value="PageCount"/> 
<s:a href="%{u}">首页</s:a>


<s:a href="%{i}"></s:a>
<s:if test="PageNow!=1">
<s:a href="%{w}">上一页</s:a>
 </s:if>

 

<s:if test="PageNow!=PageCount">
<s:a href="%{e}">下一页</s:a>
</s:if>


<s:a href="%{l}">末页</s:a>
<s:debug></s:debug>

   
  </body>
</html>