java csv的zip导出代码示例

最新推荐文章于 2023-05-25 11:49:57 发布

原创最新推荐文章于 2023-05-25 11:49:57 发布 · 851 阅读

CC 4.0 BY-SA版权

本文介绍了一个使用Java生成包含CSV文件的ZIP压缩包的方法。通过示例代码展示了如何设置HTTP响应头来支持下载，并利用ZipOutputStream将字符串内容打包成CSV文件并压缩。此外，还记录了生成过程的时间消耗。

@RequestMapping(value = "getZip",method = RequestMethod.GET)
@ResponseBody
public CommonResponse getZip(HttpServletResponse response){
    try {
        long a = System.currentTimeMillis();
        response.setContentType("text/html;charset=UTF-8");
        response.setContentType("application/octet-stream");
        response.setHeader("Content-disposition", "attachment; filename=" + new String("压缩包测试.zip".getBytes("gb2312"), "ISO8859-1"));

        ZipOutputStream zipOut = new ZipOutputStream(response.getOutputStream());
        StringBuilder builder = new StringBuilder("");
        for (int i = 0; i < 1000000; i++) {
            if (i%3==0){
                builder.append("\n"+"dsdsdsds"+i).append(",");
            } else {
                builder.append("dsdsdsdds"+i).append(",");
            }
        }
        byte[] bytes = builder.toString().getBytes();
        
        InputStream excelIS = new ByteArrayInputStream(bytes);
        ZipEntry zipEntry = new ZipEntry("测试.csv");
        zipOut.putNextEntry(zipEntry);
        byte b[] = new byte[2048];
        int length = 0;
        while ((length = excelIS.read(b)) != -1) {
            zipOut.write(b, 0, length);
        }
        zipOut.closeEntry();
        excelIS.close();
        zipOut.close();
        long bb = System.currentTimeMillis();
        System.out.println("1000000 take time:"+(bb-a));
        return new CommonResponse(0,"SUCCESS");
    } catch (IOException e) {
        e.printStackTrace();
        log.error("getZip exception:{}",e.getMessage());
        return new CommonResponse(1,"FAIL");   
    }
}