JSP
window.location = appContext + "/syzcdDksqxxb/export.do?parameter=" + JSON.stringify(form.getData());
}
contro
public void export(SyzcdDksqxxbVO vo, HttpServletResponse response, HttpServletRequest request) throws IOException {
logger.info("导出");
String message = "导出失败";
String parameter = request.getParameter("parameter");
vo = JSONObject.parseObject(parameter, SyzcdDksqxxbVO.class);
List<SyzcdDksqxxbVO> list = iSyzcdDksqxxbService.queryShow(vo);
if (list.size() == 0) {
message = "没有需要导出的信息";
}
// 保存数据
List<String[]> dataList = new ArrayList<>();
for (SyzcdDksqxxbVO listEach : list) {
String[] dataArr = listEach.getData().split(",");
dataList.add(dataArr);
}
// 导出文件名称
String title = "贷款申请信息文件明细表";
String date = DateUtil.getDate();
String fileName = title + date + ".xls";
// 表头,格式:[projectid=-3f21ad94.155a4d67453.-7cc5, planitemid=-3f21ad94.155a2267453.-7cc5, contractid=171100000992, applyid=fffffff, supplierid=10013513, suppliername=沈阳xxx有限公司, bankname=银行名称, accountname&