1.控制层Controller,使用getLCCnsFeeCalMainExcel.do去接收
@SuppressWarnings("rawtypes") //去除警告
@RequestMapping("getLCCnsFeeCalMainExcel.do")
public ModelAndView queryExcel(@RequestParam("req") String hreq)
throws ParseException, IOException, SQLException {
// 根据保单号查询其他信息
hreq = URLDecoder.decode(hreq,"UTF-8");
LCCnsFeeCalMainDto tLCCnsFeeCalMainDto = JsonUtils.toJsonObject(hreq,
LCCnsFeeCalMainDto.class);
List<Map> ptpList = tLCCnsFeeCalMainBlo.queryExcel(tLCCnsFeeCalMainDto);// 数据导出数据查询
String excelName = "LCCnsFeeCalMain.xls";// 创建生成文件的名字
LCCnsFeeCalMainViewExcel tLCCnsFeeCalMainViewExcel = new LCCnsFeeCalMainViewExcel(
excelName, ptpList);// 保单跟进文件生成方法
return new ModelAndView(tLCCnsFeeCalMainViewExcel);
}
2.LCCnsFeeCalMainViewExcel
LCCnsFeeCalMainViewExcel类继承AbstractExcelView,调用构造方法及重写的buildExcelDocument方法
构造方法:创建变量templetFilePath,内容为模板地址,并赋值,赋值过程在步骤3中展示
package com.yunhui.oversea.policy.view;
import java.io.BufferedOutputStream;
import java.io.OutputStream;
import java.util.List;
import java.util.Map;
import java.util.Properties;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.springframework.web.servlet.view.document.AbstractExcelView;
import com.