POI导出easyui报表

        最近要写一个报表导出功能，第一次尝试，结合网上各位大牛的经验，总算完成该功能的实现，接下来是对实现的具体描述：

首先对于业务层的设计：

/**
* 通过POI导出报表
* @param fileName 
* @param titles
* @param contents
* @param response
*/
public void downloadXls(String fileName,List<String>titles,List<WyFeeVo> contents,
HttpServletResponse response);

接下来对于导出功能的具体实现：

 /**
     * 导出Excel
     * @param fileName 文件名
     * @param titles 标题栏
     * @param contents 内容
     */
public void downloadXls(String fileName,List<String>titles,List<WyFeeVo> contents,
HttpServletResponse response){
OutputStream out = null;
try {
SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
out = response.getOutputStream();
HSSFWorkbook workbook = new HSSFWorkbook();
Date date = new Date();
DateFormat format = new SimpleDateFormat("yyyy-MM-dd");
String time = format.format(date);
response.setContentType("application/x-download");
response.setCharacterEncoding("utf-8");
         response.setHeader("Content-Disposition", "attachment;fileName="+new String
(fileName.getBytes("gbk"), "iso8859-1")+time+".xls");
         Sheet sheet = workbook.createSheet("缴费记录表");
         Row row = sheet.createRow(0);
         Cell cell;
         for (int i = 0; i < titles.size(); i++) {
cell = row.createCell(i);
cell.setCellValue(titles.get(i));
}
         for (int i = 0; i < contents.size(); i++) {
WyFee wyFee = contents.get(i);
row = sheet.createRow(i+1);
cell = row.createCell((short)0);
cell.setCellValue(wyFee.getOwnerName());
cell = row.createCell((short)1);
cell.setCellValue(wyFee.getResourceNum());
cell = row.createCell((short)2);
cell.setCellValue(wyFee.getBillType());
cell = row.createCell((short)3);
cell.setCellValue(wyFee.getOrderNum());
cell = row.createCell((short)4);
cell.setCellValue(wyFee.getPayAmount());
cell = row.createCell((short)5);
Date date2  = wyFee.getPrintTime();
cell.setCellValue(simpleDateFormat.format(date2));
cell = row.createCell((short)6);
cell.setCellValue(wyFee.getRemark());
cell = row.createCell((short)7);
String stateDic = dicService.getDicNameByTypeAndValue(DicTypeEnum.COMPLANT_STATUS.getStatus(), wyFee.getState());
cell.setCellValue(stateDic);
cell = row.createCell((short)8);
Date date3 = wyFee.getCreateTime();
cell.setCellValue(simpleDateFormat.format(date3));
}
         workbook.write(out);
} catch (Exception e) {
e.printStackTrace();
}finally {
            if (out!=null) {
                try {
out.close();
} catch (IOException e) {
e.printStackTrace();
}
            }
        }
}

表示层调用方法：

@RequestMapping("exportExcel.do")
public void export(WyFeeQuery query,HttpServletResponse response){
String fileName = "缴费记录表";
List<String> titles = new ArrayList<String>();
titles.add("客户名称");
titles.add("资源号");
titles.add("票据类型");
titles.add("订单号");
titles.add("票据金额");
titles.add("打印时间");
titles.add("备注");
titles.add("状态");
titles.add("创建时间");
List<WyFeeVo> contents = wyfeeService.findAllWyFeeVo(query);
wyfeeService.downloadXls(fileName, titles, contents, response);
}

最后前端页面对其进行实现

var wyfee = (function(){
return{
exportExcel:function(){
var url =  DOMAIN_URL + "/wyFee/exportExcel.do";
window.location.href = url;  
}
}
})();