struts2查询条件分页无法带到下一页
各位好,我在用ssh做查询分页时,查询出数据点击下一页时,带不出查询条件,导致数据结果为不带条件的集合。
jsp页面:
<div class="tools">
<form action="queryPersonWomanPacesetterByCond.action" method="post">
<ul class="searchHBform">
<li><input name="" type="submit" class="scbtn2" value="查询"/></li>
<li><label>参选年份</label><input type="text" name="qElectionyear" id="qElectionyear" class="scinput" onfocus="new WdatePicker(this)" value="<s:property value="#request.qElectionyear"/>"></li>
<li><label>姓名</label><input type="text" name="qPacesettername" maxlength="10" id="qPacesettername" class="scinput" value="<s:property value="#request.qPacesettername"/>"></li>
</ul>
</form>
</div>
<table class="tablelist">
<thead>
<tr>
<th width="4%"><input name="" type="checkbox" value="" /></th>
<th width="5%">编号<i class="sort"><img src="./images/px.gif" /></i></th>
<th width="11%">姓名</th>
<th width="6%">参选年份</th>
<th width="31%">工作单位及职务</th>
<th width="10%">联系电话</th>
<th width="31%">地址</th>
</tr>
</thead>
<tbody>
<s:iterator value="pageBean.list" status="st" id="personWomanPacesetter">
<tr>
<td><input name="control" type="checkbox" value="<s:property value="#personWomanPacesetter.ppacesetterid" />" /></td>
<td onclick="womenPersonDetail('<s:property value="#personWomanPacesetter.ppacesetterid" />')"><s:property value="#st.count" /></td>
<td onclick="womenPersonDetail('<s:property value="#personWomanPacesetter.ppacesetterid" />')"><s:property value="#personWomanPacesetter.pacesettername" /></td>
<td onclick="womenPersonDetail('<s:property value="#personWomanPacesetter.ppacesetterid" />')"><s:property value="#personWomanPacesetter.electionyear" /></td>
<td onclick="womenPersonDetail('<s:property value="#personWomanPacesetter.ppacesetterid" />')"><s:property value="#personWomanPacesetter.unitposition" /></td>
<td onclick="womenPersonDetail('<s:property value="#personWomanPacesetter.ppacesetterid" />')"><s:property value="#personWomanPacesetter.tel" /></td>
<td onclick="womenPersonDetail('<s:property value="#personWomanPacesetter.ppacesetterid" />')"><s:property value="#personWomanPacesetter.contactaddress" /></td>
</tr>
</s:iterator>
</tbody>
</table>
<div class="pagin">
<div class="message">共<i class="blue"><s:property value="pageBean.allRow"/></i>条记录,当前显示第 <i class="blue"><s:property value="pageBean.currentPage"/> </i>页</div>
<table class="paginList">
<tr>
<td class="paginItem">
<s:if test="%{pageBean.currentPage == 1}">首页 上一页</s:if>
<s:else>
<a href="queryPersonWomanPacesetterByCond.action?page=1">首页</a>
<a href="queryPersonWomanPacesetterByCond.action?page=<s:property value="%{pageBean.currentPage-1}"/>" />上一页</a>
</s:else>
</td>
<td class="paginItem">
<s:if test="%{pageBean.currentPage != pageBean.totalPage}">
<a href="queryPersonWomanPacesetterByCond.action?page=<s:property value="%{pageBean.currentPage+1}"/>">下一页</a>
<a href="queryPersonWomanPacesetterByCond.action?page=<s:property value="pageBean.totalPage"/>">尾页</a>
</s:if>
<s:else>
下一页 尾页
</s:else>
</td>
</tr>
</table>
action代码如下:
/**
* 根据条件分页获取三八红旗手集体信息
* @return
* @throws Exception
*/
public String queryPersonWomanPacesetterByCond() throws Exception {
HttpServletRequest request = ServletActionContext.getRequest();
String hql = null;
String qElectionyear = null;
String qPacesettername = null;
StringBuffer condBuffer = new StringBuffer(" and 1 = 1 ");
//查询参选日期
if(request.getParameter("qElectionyear") != null && !request.getParameter("qElectionyear").trim().equals("")){
condBuffer.append(" and ");
condBuffer.append(" electionyear = '");
qElectionyear = request.getParameter("qElectionyear");
condBuffer.append(qElectionyear);
condBuffer.append("'");
}
//查询参选人
if(request.getParameter("qPacesettername") != null && !request.getParameter("qPacesettername").trim().equals("")){
condBuffer.append(" and ");
condBuffer.append(" pacesettername like '%");
qPacesettername = request.getParameter("qPacesettername");
condBuffer.append(qPacesettername);
condBuffer.append("%'");
}
hql = condBuffer.toString();
pageBean = personWomanService.queryForPage(hql,pageSize, page);
personWomanPacesetterList = pageBean.getList();
request.setAttribute("qPacesettername", qPacesettername);
request.setAttribute("qElectionyear", qElectionyear);
return SUCCESS;
}
如何做到把这两个查询条件带到下一页,困扰我很长时间,用<s:param>也不行,感谢了!
jsp页面:
<div class="tools">
<form action="queryPersonWomanPacesetterByCond.action" method="post">
<ul class="searchHBform">
<li><input name="" type="submit" class="scbtn2" value="查询"/></li>
<li><label>参选年份</label><input type="text" name="qElectionyear" id="qElectionyear" class="scinput" onfocus="new WdatePicker(this)" value="<s:property value="#request.qElectionyear"/>"></li>
<li><label>姓名</label><input type="text" name="qPacesettername" maxlength="10" id="qPacesettername" class="scinput" value="<s:property value="#request.qPacesettername"/>"></li>
</ul>
</form>
</div>
<table class="tablelist">
<thead>
<tr>
<th width="4%"><input name="" type="checkbox" value="" /></th>
<th width="5%">编号<i class="sort"><img src="./images/px.gif" /></i></th>
<th width="11%">姓名</th>
<th width="6%">参选年份</th>
<th width="31%">工作单位及职务</th>
<th width="10%">联系电话</th>
<th width="31%">地址</th>
</tr>
</thead>
<tbody>
<s:iterator value="pageBean.list" status="st" id="personWomanPacesetter">
<tr>
<td><input name="control" type="checkbox" value="<s:property value="#personWomanPacesetter.ppacesetterid" />" /></td>
<td onclick="womenPersonDetail('<s:property value="#personWomanPacesetter.ppacesetterid" />')"><s:property value="#st.count" /></td>
<td onclick="womenPersonDetail('<s:property value="#personWomanPacesetter.ppacesetterid" />')"><s:property value="#personWomanPacesetter.pacesettername" /></td>
<td onclick="womenPersonDetail('<s:property value="#personWomanPacesetter.ppacesetterid" />')"><s:property value="#personWomanPacesetter.electionyear" /></td>
<td onclick="womenPersonDetail('<s:property value="#personWomanPacesetter.ppacesetterid" />')"><s:property value="#personWomanPacesetter.unitposition" /></td>
<td onclick="womenPersonDetail('<s:property value="#personWomanPacesetter.ppacesetterid" />')"><s:property value="#personWomanPacesetter.tel" /></td>
<td onclick="womenPersonDetail('<s:property value="#personWomanPacesetter.ppacesetterid" />')"><s:property value="#personWomanPacesetter.contactaddress" /></td>
</tr>
</s:iterator>
</tbody>
</table>
<div class="pagin">
<div class="message">共<i class="blue"><s:property value="pageBean.allRow"/></i>条记录,当前显示第 <i class="blue"><s:property value="pageBean.currentPage"/> </i>页</div>
<table class="paginList">
<tr>
<td class="paginItem">
<s:if test="%{pageBean.currentPage == 1}">首页 上一页</s:if>
<s:else>
<a href="queryPersonWomanPacesetterByCond.action?page=1">首页</a>
<a href="queryPersonWomanPacesetterByCond.action?page=<s:property value="%{pageBean.currentPage-1}"/>" />上一页</a>
</s:else>
</td>
<td class="paginItem">
<s:if test="%{pageBean.currentPage != pageBean.totalPage}">
<a href="queryPersonWomanPacesetterByCond.action?page=<s:property value="%{pageBean.currentPage+1}"/>">下一页</a>
<a href="queryPersonWomanPacesetterByCond.action?page=<s:property value="pageBean.totalPage"/>">尾页</a>
</s:if>
<s:else>
下一页 尾页
</s:else>
</td>
</tr>
</table>
action代码如下:
/**
* 根据条件分页获取三八红旗手集体信息
* @return
* @throws Exception
*/
public String queryPersonWomanPacesetterByCond() throws Exception {
HttpServletRequest request = ServletActionContext.getRequest();
String hql = null;
String qElectionyear = null;
String qPacesettername = null;
StringBuffer condBuffer = new StringBuffer(" and 1 = 1 ");
//查询参选日期
if(request.getParameter("qElectionyear") != null && !request.getParameter("qElectionyear").trim().equals("")){
condBuffer.append(" and ");
condBuffer.append(" electionyear = '");
qElectionyear = request.getParameter("qElectionyear");
condBuffer.append(qElectionyear);
condBuffer.append("'");
}
//查询参选人
if(request.getParameter("qPacesettername") != null && !request.getParameter("qPacesettername").trim().equals("")){
condBuffer.append(" and ");
condBuffer.append(" pacesettername like '%");
qPacesettername = request.getParameter("qPacesettername");
condBuffer.append(qPacesettername);
condBuffer.append("%'");
}
hql = condBuffer.toString();
pageBean = personWomanService.queryForPage(hql,pageSize, page);
personWomanPacesetterList = pageBean.getList();
request.setAttribute("qPacesettername", qPacesettername);
request.setAttribute("qElectionyear", qElectionyear);
return SUCCESS;
}
如何做到把这两个查询条件带到下一页,困扰我很长时间,用<s:param>也不行,感谢了!
...全文
相关推荐
struts2+jdbc实现增删改查及带条件的分页查询
实现了struts2通过jdbc连接mysql数据库进行数据存储及从数据库中 查询出数据并显示到页面(jsp页面使用了struts2标签)上
Struts2组合查询与分页功能的实现示例
Struts2作为Java Web应用开发中的MVC框架,拥有丰富的标签库<sx:>。本章将对这些标签进行深入探讨,介绍它们的功能、使用方式以及在实际开发中的优化技巧。通过掌握<sx:>标签集,开发者可以高效地构建用户界面,减少代码冗余,同时提升应用的可维护性。我们首先从<sx:>标签集的基础概念开始,逐步深入到每一个具体的标签,分析其属性、用法和最佳实践,直至应用这些标签实现复杂的用户交互和数据展示。
struts2增删改查,struts2分页查询
struts2增删改查,struts2分页查询
纯Struts 2框架带条件分页Demo
采用纯Struts 2框架实现带查询条件分页,MyEclipse + Struts 2 + MySql.决对是一个完整的Demo.
ssh2实现查询分页
基于ssh2实现的分页查询,从bean到dao以及service、action,页面。只要复制上去,简单配置一下。就可以实现分页的功能,值得收藏!


Web 开发
