jsp页面代码:
//给下载列表数据按钮(选择下载)添加单击事件
$("#exportActivityXzBtn").on("click",function () {
//获取选中的数据信息
var checkeds = $("#tBody input:checked");
//判断数量
if (checkeds.length == 0){
alert("请重新选择您要导出的数据");
return;
}
//拼接选中记录的标识
//拼接参数:id=1&id=2&id=3&...
var ids = "";
//循环遍历
$.each(checkeds,function (index,obj) {
ids+="id="+$(obj).val()+"&";
});
ids=ids.substring(0,ids.length-1);
//发送请求
//拼接上以后:workbench/activity/exportXzActivityById.do?id=
window.location.href = "workbench/activity/exportXzActivityById.do?"+ids;
});
controller层代码:
@RequestMapping("/workbench/activity/exportXzActivityById.do")
public void exportXzActivityById(HttpServletRequest request,HttpServletResponse response,@RequestParam(value = "id",required = false)String[] ids) throws IOException {
List activityList = activityService.queryActivityById(ids);
createExcel(response,activityList);
}
createExcel()方法代码:
private void createExcel(HttpServletResponse response, List activityList) throws IOException {
//生成excel表
//创建工作簿对象
HSSFWorkbook workbook = new HSSFWorkbook();
//创建工作表对象
HSSFSheet sheet = workbook.createSheet();
//创建行
HSSFRow row = sheet.createRow(0);
HSSFCell cell = row.createCell(0);
cell.setCellValue("市场活动名称");
cell = row.createCell(1);
cell.setCellValue("所有者");
cell = row.createCell(2);
cell.setCellValue("活动开始时间");
cell = row.createCell(3);
cell.setCellValue("活动结束时间");
//循环遍历
for (int i = 0; i < activityList.size(); i++) {
//创建行对象
row = sheet.createRow(i+1);
//获取市场活动的值
Activity activity = activityList.get(i);
//创建列对象
cell = row.createCell(0);
cell.setCellValue(activity.getName());
cell = row.createCell(1);
cell.setCellValue(activity.getOwner());
cell = row.createCell(2);
cell.setCellValue(activity.getStartDate());
cell = row.createCell(3);
cell.setCellValue(activity.getEndDate());
}
//设置中文文件名称
String fileName = URLEncoder.encode("市场活动列表","UTF-8");
//浏览器默认服务器传过去的是html,不是excel文件
//设置响应类型:传输内容是流,并支持中文
response.setContentType("application/octet-stream;charset=UTF-8");
//设置响应头信息header,下载时以文件附件下载
response.setHeader("Content-Disposition","attachment;filename="+fileName+".xls");
//输出流对象
OutputStream os = response.getOutputStream();
workbook.write(os);
//强制刷新
os.flush();
os.close();
workbook.close();
}
过程遇到的问题:
在选中导出的数据时候总是会少导出选中的第一条数据。
发现并解决问题:
在参数拼接的时候,在”?“后边多拼接了id=,”workbench/activity/exportXzActivityById.do?id=“,
因为在循环遍历的时候已经拼接了"id=",取消掉以后解决了此问题。



