写了一个模糊查询,action中该怎么写,怎么调用呢,
这是我的代码
public String queryLinkReport(){
List<Report> reportName=reportBiz.findByName(report);
getSession().put("reportName", reportName);
return "linkname";
}
这个是jsp中的代码
<s:form action="r_queryLinkReport.action" method="post">
<div class="left">
考试名称 <input type="text" name="report.eusername">
<input type="submit" class="btn1" value="查询">
</div>
<table align="center" class="formdata" border="1px" cellpadding="0" cellspacing="0">
<tr>
<th width="5%">序号</th>
<th width="8%">姓名</th>
<th width="15%">工号</th>
<th width="15%">分行</th>
<th width="15%">准考证号</th>
<th width="20%">考试名称</th>
<th width="5%">用时</th>
<th width="5%">分数</th>
<th width="15%">查看考卷</th>
</tr>
<c:forEach items="${reportList}" var="list">
<tr>
<td>${list.rnumber}</td>
<td>${list.ename}</td>
<td>${list.jobnumber}</td>
<td>${list.branch}</td>
<td>${list.examnumber}</td>
<td>${list.eusername}</td>
<td>${list.usetime}</td>
<td>${list.sscore }</td>
<td><a href="#">查看</a></td>
</tr>
</c:forEach>
</table>
</s:form>
<div class="div_fenye">
<p class="font_p1">
<tr>
<td align="center">
第${pageNo}页
<a href="r_queryReport.action?pageNo=1">首页</a>
<s:if test="#attr.pageNo> 1">
<a href="r_queryReport.action?pageNo=${pageNo-1}">上一页</a>
</s:if>
<s:else>上一页</s:else>
<s:if test="#attr.pageNo lt #attr.totalpages">
<a href="r_queryReport.action?pageNo=${pageNo+1}">下一页</a>
</s:if>
<s:else>下一页</s:else>
<a href="r_queryReport.action?pageNo=${totalpages}">末页</a>
共${totalpages}页
</td>
</tr>
[ 每页显示<font color="red">${pageRows}</font>条记录/总共<font color="red">${count}</font>条记录 ]
</p>
</div>
<div >
<table class="btn2">
<tr>
<td class="t2">
<input type="button" name="export" value="导出" onClick="">
</td>
</tr>
</table>
</div>
</div>
还有就是怎么导出的,有具体的代码吗?谢谢JSP action
这是我的代码
public String queryLinkReport(){
List<Report> reportName=reportBiz.findByName(report);
getSession().put("reportName", reportName);
return "linkname";
}
这个是jsp中的代码
<s:form action="r_queryLinkReport.action" method="post">
<div class="left">
考试名称 <input type="text" name="report.eusername">
<input type="submit" class="btn1" value="查询">
</div>
<table align="center" class="formdata" border="1px" cellpadding="0" cellspacing="0">
<tr>
<th width="5%">序号</th>
<th width="8%">姓名</th>
<th width="15%">工号</th>
<th width="15%">分行</th>
<th width="15%">准考证号</th>
<th width="20%">考试名称</th>
<th width="5%">用时</th>
<th width="5%">分数</th>
<th width="15%">查看考卷</th>
</tr>
<c:forEach items="${reportList}" var="list">
<tr>
<td>${list.rnumber}</td>
<td>${list.ename}</td>
<td>${list.jobnumber}</td>
<td>${list.branch}</td>
<td>${list.examnumber}</td>
<td>${list.eusername}</td>
<td>${list.usetime}</td>
<td>${list.sscore }</td>
<td><a href="#">查看</a></td>
</tr>
</c:forEach>
</table>
</s:form>
<div class="div_fenye">
<p class="font_p1">
<tr>
<td align="center">
第${pageNo}页
<a href="r_queryReport.action?pageNo=1">首页</a>
<s:if test="#attr.pageNo> 1">
<a href="r_queryReport.action?pageNo=${pageNo-1}">上一页</a>
</s:if>
<s:else>上一页</s:else>
<s:if test="#attr.pageNo lt #attr.totalpages">
<a href="r_queryReport.action?pageNo=${pageNo+1}">下一页</a>
</s:if>
<s:else>下一页</s:else>
<a href="r_queryReport.action?pageNo=${totalpages}">末页</a>
共${totalpages}页
</td>
</tr>
[ 每页显示<font color="red">${pageRows}</font>条记录/总共<font color="red">${count}</font>条记录 ]
</p>
</div>
<div >
<table class="btn2">
<tr>
<td class="t2">
<input type="button" name="export" value="导出" onClick="">
</td>
</tr>
</table>
</div>
</div>
还有就是怎么导出的,有具体的代码吗?谢谢JSP action
如何跳到action,在struts.xml中配置,具体的找本书看看,不难的
public List<Report> fuzzyQuery(String username) {
return this.getHibernateTemplate().executeFind(new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException,
SQLException {
Criteria criteria = session.createCriteria(Report.class);
//添加模糊查询条件
criteria.add(Restrictions.like("username", "%"+username+"%"));
return criteria.list;
}
});
}然后再从aciton调用相应接口就可以了,上面是dao实现类的代码,service层只要简单调用就可以
只有点击的时候才能刷新,但是就不是模糊查询的数据了,而是全部的数据了