springmvc 输出流导出

最新推荐文章于 2023-07-09 18:51:41 发布

原创最新推荐文章于 2023-07-09 18:51:41 发布 · 3.3k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#spring mvc

springmvc 输出流导出专栏收录该内容

1 篇文章

订阅专栏

本文介绍了一种使用Java导出数据库中特定商户信息至CSV文件的方法，通过RESTful API接收参数并调用服务层方法完成数据导出。具体包括设置HTTP响应头、处理编码问题及构建CSV文件的内容。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

@RequestMapping(value = "/exportExcel")
@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;
}