根据实体类生成Excel压缩文件

根据实体类生成Excel压缩文件

• 坐标：

<!-- https://mvnrepository.com/artifact/cn.ibaijia/jsm-frame -->
<dependency>
    <groupId>cn.ibaijia</groupId>
    <artifactId>jsm-frame</artifactId>
    <version>1.3.24</version>
</dependency>

• 实体类(示例)

public class Test {

    @ExcelField(ignore = true)
    public Long orderId;  // 订单ID
    @ExcelField(name = "订单编号",height = 14)
    public String orderNo; // 订单编号
    @ExcelField(name = "订单类型", replaceRule="大货|1;打样|2;变更|3",height = 14)
  
    }

• 使用方式

       List<Test> dataList =new ArrayList<>();
       Workbook workbook = ExcelUtil.writeToNew(dataList);

• 生成表格压缩为zip

 public class Test{
        public static void main(String[] args) throws Exception {
            /** 测试压缩表格  */

            FileOutputStream fos2 = new FileOutputStream(new File("E:\\DaiMa\\pod\\pod-api\\src\\main\\resources\\template\\test.zip"));


            List<Map> list=new ArrayList<>();
            List<BookPriceItemModel> bookPriceItemModels=new ArrayList<>();
            Map<Object, Object> map = new HashMap<>();

            BookPriceItemModel bookPriceItemModel = new BookPriceItemModel();
            bookPriceItemModels.add(bookPriceItemModel);
            bookPriceItemModel.name="十点多发";
            map.put("name","表格");
            map.put("data",bookPriceItemModels);
            list.add(map);
            ZipUtils.getEcselZip(list,fos2);

        }
    }

• 压缩工具类

import com.hucai.rest.resp.BookPriceItemModel;
import com.jsmframe.excel.ExcelUtil;
import org.apache.poi.ss.formula.functions.T;
import org.apache.poi.ss.usermodel.Workbook;

import java.io.*;
import java.util.*;
import java.util.zip.ZipEntry;
import java.util.zip.ZipOutputStream;

/**
 * @className: com.hucai.utils-> ZipUtils
 * @描述: 压缩
 * @author: GouKuo
 * @createDate: 2021-08-22 15:49
 * @version: 1.0
 * @todo:
 */
public class ZipUtils {
    private static final int BUFFER_SIZE = 2 * 1024;

    /**
     * 压缩成ZIP 方法1
     *
     * @param srcDir           压缩文件夹路径
     * @param out              压缩文件输出流
     * @param KeepDirStructure 是否保留原来的目录结构,true:保留目录结构;
     *                         false:所有文件跑到压缩包根目录下(注意：不保留目录结构可能会出现同名文件,会压缩失败)
     * @throws RuntimeException 压缩失败会抛出运行时异常
     */
    public static void toZip(String srcDir, OutputStream out, boolean KeepDirStructure)
            throws RuntimeException {

        long start = System.currentTimeMillis();
        ZipOutputStream zos = null;
        try {
            zos = new ZipOutputStream(out);
            File sourceFile = new File(srcDir);
            compress(sourceFile, zos, sourceFile.getName(), KeepDirStructure);
            long end = System.currentTimeMillis();
            System.out.println("压缩完成，耗时：" + (end - start) + " ms");
        } catch (Exception e) {
            throw new RuntimeException("zip error from ZipUtils", e);
        } finally {
            if (zos != null) {
                try {
                    zos.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }
    }

    /**
     * 压缩成ZIP 方法2
     *
     * @param srcFiles 需要压缩的文件列表
     * @param out      压缩文件输出流
     * @throws RuntimeException 压缩失败会抛出运行时异常
     */
    public static void toZip(List<File> srcFiles, OutputStream out) throws RuntimeException {
        long start = System.currentTimeMillis();
        ZipOutputStream zos = null;
        try {
            zos = new ZipOutputStream(out);
            for (File srcFile : srcFiles) {
                byte[] buf = new byte[BUFFER_SIZE];
                zos.putNextEntry(new ZipEntry(srcFile.getName()));
                int len;
                FileInputStream in = new FileInputStream(srcFile);
                while ((len = in.read(buf)) != -1) {
                    zos.write(buf, 0, len);
                }
                zos.closeEntry();
                in.close();
            }
            long end = System.currentTimeMillis();
            System.out.println("压缩完成，耗时：" + (end - start) + " ms");
        } catch (Exception e) {
            throw new RuntimeException("zip error from ZipUtils", e);
        } finally {
            if (zos != null) {
                try {
                    zos.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }
    }

    /**
     * @return void
     * @编辑 GouKuo
     * @描述: srcFiles : 压缩内容
     * map.put(" IN ", InputStream);
     * map.put("name","文件名");
     * out     ：        压缩文件输出流
     * @Param [srcFiles, out]
     * @date 2021/9/1 14:29
     */
    public static void toInZip(List<Map> srcFiles, OutputStream out) throws RuntimeException {
        long start = System.currentTimeMillis();
        ZipOutputStream zos = null;

        try {
            zos = new ZipOutputStream(out);
            for (Map map : srcFiles) {
                ByteArrayInputStream in = (ByteArrayInputStream) map.get("IN");
                String name = (String) map.get("name");
                byte[] buf = new byte[BUFFER_SIZE];
                zos.putNextEntry(new ZipEntry(name));
                int len;

                while ((len = in.read(buf)) != -1) {
                    zos.write(buf, 0, len);
                }
                zos.closeEntry();
                in.close();
            }
            long end = System.currentTimeMillis();
            System.out.println("压缩完成，耗时：" + (end - start) + " ms");
        } catch (Exception e) {
            throw new RuntimeException("zip error from ZipUtils", e);
        } finally {
            if (zos != null) {
                try {
                    zos.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }
    }

    /**
     * @return void
     * @编辑 GouKuo
     * @描述: 根据传入数据集合生成表格并压缩为zip写入指定目录
     * list：数据集合
     *       map形式：
     *        map.put("data", List<实体类>);
     *        map.put("name", 表格文件名);    无效拼接.xlsx，方法自动拼接
     *
     * out：压缩文件输出流
     * @Param [srcFiles, out]
     * @date 2021/9/1 14:29
     */
    public static <T> void getEcselZip(List<Map> list, OutputStream fileOut ) throws RuntimeException {
        List<Map> mapList = new ArrayList<Map>();
        for (Map map : list) {
            ByteArrayInputStream excelStream = null;
            ByteArrayOutputStream out = new ByteArrayOutputStream();
            List<T> data = (List<T>) map.get("data");
            String name = (String) map.get("name")+".xlsx";
            Workbook workbook = ExcelUtil.writeToNew(data);
            try {
                workbook.write(out);
            } catch (IOException e) {
                e.printStackTrace();
            }
            excelStream = new ByteArrayInputStream(out.toByteArray());
            map.put("IN", excelStream);
            map.put("name", name);
            mapList.add(map);
        }
        toInZip(mapList, fileOut);
    }




    /**
     * 递归压缩方法
     *
     * @param sourceFile       源文件
     * @param zos              zip输出流
     * @param name             压缩后的名称
     * @param KeepDirStructure 是否保留原来的目录结构,true:保留目录结构;
     *                         false:所有文件跑到压缩包根目录下(注意：不保留目录结构可能会出现同名文件,会压缩失败)
     * @throws Exception
     */
    private static void compress(File sourceFile, ZipOutputStream zos, String name,
                                 boolean KeepDirStructure) throws Exception {
        byte[] buf = new byte[BUFFER_SIZE];
        if (sourceFile.isFile()) {
            // 向zip输出流中添加一个zip实体，构造器中name为zip实体的文件的名字
            zos.putNextEntry(new ZipEntry(name));
            // copy文件到zip输出流中
            int len;
            FileInputStream in = new FileInputStream(sourceFile);
            while ((len = in.read(buf)) != -1) {
                zos.write(buf, 0, len);
            }
            // Complete the entry
            zos.closeEntry();
            in.close();
        } else {
            File[] listFiles = sourceFile.listFiles();
            if (listFiles == null || listFiles.length == 0) {
                // 需要保留原来的文件结构时,需要对空文件夹进行处理
                if (KeepDirStructure) {
                    // 空文件夹的处理
                    zos.putNextEntry(new ZipEntry(name + "/"));
                    // 没有文件，不需要文件的copy
                    zos.closeEntry();
                }

            } else {
                for (File file : listFiles) {
                    // 判断是否需要保留原来的文件结构
                    if (KeepDirStructure) {
                        // 注意：file.getName()前面需要带上父文件夹的名字加一斜杠,
                        // 不然最后压缩包中就不能保留原来的文件结构,即：所有文件都跑到压缩包根目录下了
                        compress(file, zos, name + "/" + file.getName(), KeepDirStructure);
                    } else {
                        compress(file, zos, file.getName(), KeepDirStructure);
                    }

                }
            }
        }
    }

    public static void main(String[] args) throws Exception {
        /** 测试压缩表格  */

        FileOutputStream fos2 = new FileOutputStream(new File("E:\\DaiMa\\pod\\pod-api\\src\\main\\resources\\template\\test.zip"));


        List<Map> list=new ArrayList<>();
        List<BookPriceItemModel> bookPriceItemModels=new ArrayList<>();
        Map<Object, Object> map = new HashMap<>();

        BookPriceItemModel bookPriceItemModel = new BookPriceItemModel();
        bookPriceItemModels.add(bookPriceItemModel);
        bookPriceItemModel.name="十点多发";
        map.put("name","表格");
        map.put("data",bookPriceItemModels);
        list.add(map);
        getEcselZip(list,fos2);


    }


}