@ResponseBody
public void exportExcel(WebRequest webRequest, Parameter parameter,
User user,@RequestParam("trdCode") String trdCode,
@RequestParam("name") String name, HttpServletResponse response) {
EleTabBusAcc etba =new EleTabBusAcc();
etba.setId(trdCode);
etba.setTrdNam(name);
String fileName = "Merchant information";
response.reset();
response.setContentType("application/octet-stream;charset=GBK");// 不同类型的文件对应不同的MIME类型
response.setHeader("content-disposition", "attachment;filename="
+ fileName + ".csv");
PrintWriter out = null;
try {
out = response.getWriter();
parameter.setPage(1);
parameter.setRows(500);
int retInt = eleTabService.exportExcel(etba, out, parameter,
0);
System.out.println("exportDatstatExcel=" + retInt);
} catch (Exception e) {
e.printStackTrace();
} finally {
if (null != out) {
out.flush();
out.close();
}
}
}
@Override
public int exportExcel(EleTabBusAcc etba, PrintWriter out,
Parameter parameter, int retInt) {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
if (retInt == 0) {
out.write("商户号,商户名,mcc,商户分类编码,商户分类名称,创建时间\r\n");
}
Grid<EleTabBusAcc> grip = queryBusAcc(parameter, etba);
if (null != grip) {
List<EleTabBusAcc> page = grip.getRows();
if (page.size() > 0) {
int idx = 0;
for (EleTabBusAcc obj : page) {
StringBuilder sb = new StringBuilder();
sb.append("\"");
sb.append(obj.getId());
sb.append("\",");
sb.append("\"");
sb.append(obj.getTrdNam());
sb.append("\",");
sb.append("\"");
sb.append(obj.getMcc());
sb.append("\",");
sb.append("\"");
sb.append(obj.getBusCod());
sb.append("\",");
sb.append("\"");
sb.append(obj.getBusNam());
sb.append("\",");
sb.append("\"");
sb.append(sdf.format(obj.getCreDat()));
sb.append("\"\r\n");
out.write(sb.toString());
idx++;
}
retInt = retInt + idx;
if (idx < 10000) {
parameter.setPage(parameter.getPage() + 1);
parameter.setRows(500);
retInt = exportExcel(etba, out, parameter, retInt);
}
}
}
return retInt;
}