dowload.jsp
<body>
<form method="post" action="/search.html" id="serchform">
<input name="username" value="${user.username}">
<input name="sex" value="${user.sex}">
<button type="submit" id="search">搜索</button
<button type="button" id="export">导出</button>
</form>
</body>
<script type="text/javascript">
(function(){
$("#export").click(function(){
if(confirm("确定导出")){
var data=#("#serchform").serializeArray();
var form='<form style="display:none" method=post action="/export.html">';
for(var i in data){
if(typeof(data[i]!="function")){
form.append('<input type="hidden" name="'+data[i].name+'" value="'+data[i].value+'">');
}
}
form.append('</form>');
form.appendTo("body");
form.submit();
form.remove();
return false;
}
});
})();
</script>
searchController.java
@RequestMapping("/")
public class searchController{
@RequestMapping("/search")
public User search(User user,/*或者@RequestParam(value="username",required=false)String un,@RequestParam(value="sex",required=false)String s,*/
ModleMap map){
List<User> result;
//...查询
map.put("result",result);
return "jsp_name";
}
@RequestMapping("/export.html")
public void search(User user,HttpServletResponse resp){
List<User> result;
//...查询
String filename;//文件名
HSSFWorkbook hssf;
//...将result组装成Excel的HSSFWorkbook
response.setHeader("Content-Disposition","attachment;filename=\""+filename+"\";");
hssf.write(response.getOutputStream());
}
}
User.java
public Class User{
public String username;
public String sex;
//....
//...get/set方法
}