• hutool、esayPoi、easyExcel、读写数据，性能对比

    目录

    1.源码下载 

    2、先上结论

    3、代码

    3.1、实体、接口

    3.2、读CSV

    3.3、读Excel

    3.4、写CSV

    3.5、写Excel

    3.6、业务示例

    1.源码下载 

    示例源码下载（含模板）

    2、先上结论

    1. 注意注意：：：：导出大文件的时候可能会有临时存储，
    2. 我的是在C:\Users\xbx\AppData\Local\Temp\poifiles
    3.  
    4. 读csv文件
    5. 行数：1048575
    6. hutool：      5205
    7. esayPoi：     3929
    8. easyExcel1：  1917
    9. easyExcel2：  2832
    10.  
    11. 读excel文件
    12. 行数：1048575
    13. hutool：     58207
    14. esayPoi：    25513
    15. easyExce1：  10646
    16. easyExcel2： 10123
    17.  
    18. 写csv文件：
    19. 行数：1048575
    20. hutool：     6136
    21. esayPoi：     828
    22. easyExcel1： 6943
    23. easyExcel2： 5212
    24.  
    25. 写excel文件：
    26. 行数：1048575
    27. hutool1：  146655
    28. hutool2：   23570
    29. esayPoi1：  21805
    30. esayPoi2：  93034
    31. easyExcel1：20762
    32. easyExcel2：20523
    33. easyExcel3：15386
    34. easyExcel4：14586

    3、代码

    3.1、实体、接口

    1. package cn.sdjtky.ltpon.FileTest;
    2.  
    3. import cn.afterturn.easypoi.excel.annotation.Excel;
    4. import lombok.Data;
    5.  
    6. /**
    7.  * @version v1.0
    8.  * @ProjectName: ltpon
    9.  * @ClassName: Strainentey
    10.  * @Description:
    11.  * @Author: xbx
    12.  * @Date: 2023/12/8 13:55
    13.  */
    14. @Data
    15. public class DeviceDto {
    16.     //sn+channel
    17.     String sn;
    18.     //与地表距离（m）
    19.     Double surfaceDistance;
    20.     //结构层位
    21.     String structuralLayer;
    22.     //就写电信号
    23.     String channel;
    24.     //这个值就是StressStrainDataDto里面的key 如："t.v1","t.v2"
    25.     String dataKey;
    26. }
    1. package cn.sdjtky.ltpon.FileTest;
    2.  
    3. import cn.hutool.core.annotation.Alias;
    4. import lombok.Data;
    5.  
    6. /**
    7.  * @version v1.0
    8.  * @ProjectName: ltpon
    9.  * @ClassName: Strainentey
    10.  * @Description:
    11.  * @Author: xbx
    12.  * @Date: 2023/12/8 13:55
    13.  */
    14. @Data
    15. public class StrainEntity {
    16.     @Alias("时间")
    17.     String time;
    18.     @Alias("通道1")
    19.     String v1;
    20.     @Alias("通道2")
    21.     String v2;
    22.     @Alias("通道3")
    23.     String v3;
    24.     @Alias("通道4")
    25.     String v4;
    26.     Double v5;
    27.     Double v6;
    28.     Double v7;
    29.     Double v8;
    30. }
    1. package cn.sdjtky.ltpon.FileTest;
    2.  
    3. import cn.afterturn.easypoi.excel.annotation.Excel;
    4. import lombok.Data;
    5.  
    6. /**
    7.  * @version v1.0
    8.  * @ProjectName: ltpon
    9.  * @ClassName: Strainentey
    10.  * @Description:
    11.  * @Author: xbx
    12.  * @Date: 2023/12/8 13:55
    13.  */
    14. @Data
    15. public class StrainEntity2 {
    16.     @Excel(name = "时间")
    17.     String time;
    18.     @Excel(name = "通道1")
    19.     String v1;
    20.     @Excel(name = "通道2")
    21.     String v2;
    22.     @Excel(name = "通道3")
    23.     String v3;
    24.     @Excel(name = "通道4")
    25.     String v4;
    26.     Double v5;
    27.     Double v6;
    28.     Double v7;
    29.     Double v8;
    30. }
    1. package cn.sdjtky.ltpon.FileTest;
    2.  
    3. import com.alibaba.excel.annotation.ExcelProperty;
    4. import lombok.Data;
    5.  
    6. /**
    7.  * @version v1.0
    8.  * @ProjectName: ltpon
    9.  * @ClassName: Strainentey
    10.  * @Description:
    11.  * @Author: xbx
    12.  * @Date: 2023/12/8 13:55
    13.  */
    14. @Data
    15. public class StrainEntity3 {
    16.     @ExcelProperty("时间")
    17.     String time;
    18.     @ExcelProperty("通道1")
    19.     String v1;
    20.     @ExcelProperty("通道2")
    21.     String v2;
    22.     @ExcelProperty("通道3")
    23.     String v3;
    24.     @ExcelProperty("通道4")
    25.     String v4;
    26.     Double v5;
    27.     Double v6;
    28.     Double v7;
    29.     Double v8;
    30. }
    1. package cn.sdjtky.ltpon.FileTest;
    2.  
    3. import cn.afterturn.easypoi.excel.annotation.Excel;
    4. import lombok.Data;
    5.  
    6. import java.util.Date;
    7.  
    8. /**
    9.  * @version v1.0
    10.  * @ProjectName: ltpon
    11.  * @ClassName: Strainentey
    12.  * @Description:
    13.  * @Author: xbx
    14.  * @Date: 2023/12/8 13:55
    15.  */
    16. @Data
    17. public class StressStrainDataDto {
    18. //    年/月/日
    19.     String date;
    20. //    时/分/秒/毫秒
    21.     String time;
    22. //    时/分/秒/毫秒
    23.     String dateTime;
    24.  
    25.     Double v1;
    26.     Double v2;
    27.     Double v3;
    28.     Double v4;
    29.     Double v5;
    30.     Double v6;
    31.     Double v7;
    32.     Double v8;
    33.     Double v9;
    34.     Double v10;
    35.     Double v11;
    36.     Double v12;
    37.     Double v13;
    38. }
    1. package cn.sdjtky.ltpon.FileTest;
    2.  
    3. import cn.sdjtky.ltpon.FileTest.StrainEntity3;
    4. import com.alibaba.excel.context.AnalysisContext;
    5. import com.alibaba.excel.read.listener.ReadListener;
    6. import com.alibaba.excel.util.ListUtils;
    7. import com.alibaba.fastjson2.JSON;
    8. import org.apache.poi.ss.formula.functions.T;
    9.  
    10. import java.util.ArrayList;
    11. import java.util.List;
    12.  
    13. // 有个很重要的点 DemoDataListener 不能被spring管理，要每次读取excel都要new,然后里面用到spring可以构造方法传进去
    14. public class Strain3ReadListener implements ReadListener {
    15.  
    16.     /**
    17.      * 每隔5条存储数据库，实际使用中可以100条，然后清理list ，方便内存回收
    18.      */
    19.     /**
    20.      * 缓存的数据
    21.      */
    22.     private List cachedDataList = new ArrayList();
    23.  
    24.     /**
    25.      * 这个每一条数据解析都会来调用
    26.      *
    27.      * @param data    one row value. Is is same as {@link AnalysisContext#readRowHolder()}
    28.      * @param context
    29.      */
    30.     @Override
    31.     public void invoke(T data, AnalysisContext context) {
    32.         cachedDataList.add(data);
    33. //        // 达到BATCH_COUNT了，需要去存储一次数据库，防止数据几万条数据在内存，容易OOM
    34. //        if (cachedDataList.size() >= BATCH_COUNT) {
    35. //            // 存储完成清理 list
    36. //            cachedDataList = ListUtils.newArrayListWithExpectedSize(BATCH_COUNT);
    37. //        }
    38.     }
    39.  
    40.     /**
    41.      * 所有数据解析完成了 都会来调用
    42.      *
    43.      * @param context
    44.      */
    45.     @Override
    46.     public void doAfterAllAnalysed(AnalysisContext context) {
    47.         // 这里也要保存数据，确保最后遗留的数据也存储到数据库
    48.     }
    49.     public List getCachedDataList() {
    50.         return cachedDataList;
    51.     }
    52. }

    3.2、读CSV

    1. package cn.sdjtky.ltpon.FileTest;
    2.  
    3. import cn.afterturn.easypoi.csv.CsvImportUtil;
    4. import cn.afterturn.easypoi.csv.entity.CsvImportParams;
    5. import cn.afterturn.easypoi.excel.entity.ImportParams;
    6. import cn.hutool.core.io.resource.ResourceUtil;
    7. import cn.hutool.core.text.csv.CsvReader;
    8. import cn.hutool.core.text.csv.CsvUtil;
    9. import com.alibaba.excel.EasyExcel;
    10. import com.alibaba.excel.context.AnalysisContext;
    11. import com.alibaba.excel.event.AnalysisEventListener;
    12. import com.alibaba.excel.support.ExcelTypeEnum;
    13. import org.junit.jupiter.api.Test;
    14. import org.slf4j.Logger;
    15. import org.slf4j.LoggerFactory;
    16.  
    17. import java.io.File;
    18. import java.io.FileInputStream;
    19. import java.util.ArrayList;
    20. import java.util.List;
    21.  
    22. public class ReadCsvTest {
    23.  
    24.     private static final Logger LOGGER = LoggerFactory.getLogger(ReadCsvTest.class);
    25.     
    26.     @Test
    27.     public void test() {
    28.         String filePath = "G:/test/1048575.csv";
    29.         hutool(filePath);
    30. //        esayPoi(filePath);
    31. //        easyExcel1(filePath);
    32. //        easyExcel2(filePath);
    33.     }
    34.  
    35.     public void hutool(String filePath) {
    36.  
    37.         try {
    38.             long start = System.currentTimeMillis();
    39.             CsvReader reader = CsvUtil.getReader();
    40.             List result = reader.read(ResourceUtil.getUtf8Reader(filePath), StrainEntity.class);
    41.             long end = System.currentTimeMillis();
    42.             System.out.println("hutool："+ (end-start));
    43.             System.out.println("行数："+result.size());
    44.         } catch (Exception e) {
    45.             e.printStackTrace();
    46.         }
    47.     }
    48.  
    49.     public void esayPoi(String filePath) {
    50.  
    51.         try {
    52.             CsvImportParams params = new CsvImportParams(CsvImportParams.UTF8);
    53.             long start = System.currentTimeMillis();
    54.             List result = CsvImportUtil.importCsv(
    55.                     new FileInputStream(new File(filePath)),
    56.                     StrainEntity2.class,
    57.                     params);
    58.  
    59.             long end = System.currentTimeMillis();
    60.             System.out.println("esayPoi："+ (end-start));
    61.             System.out.println("行数："+result.size());
    62.         } catch (Exception e) {
    63.             e.printStackTrace();
    64.         }
    65.     }
    66.  
    67.     public void easyExcel1(String filePath) {
    68.         try {
    69.             ImportParams params = new ImportParams();
    70.             List result = new ArrayList();
    71.             long start = System.currentTimeMillis();
    72.  
    73.             EasyExcel.read(filePath, StrainEntity3.class, new AnalysisEventListener() {
    74.                 @Override
    75.                 public void invoke(StrainEntity3 reportExcel, AnalysisContext analysisContext) {
    76.                     // 将读取到的每一行存入reportDetails集合中
    77.                     result.add(reportExcel);
    78.                 }
    79.                 @Override
    80.                 public void doAfterAllAnalysed(AnalysisContext analysisContext) {}
    81.             }).excelType(ExcelTypeEnum.CSV).sheet().doRead();
    82.  
    83.             long end = System.currentTimeMillis();
    84.             System.out.println("easyExcel1："+ (end-start));
    85.             System.out.println("行数："+result.size());
    86.         } catch (Exception e) {
    87.             e.printStackTrace();
    88.         }
    89.     }
    90.  
    91.     public void easyExcel2(String filePath) {
    92.         final Strain3ReadListener strain3ReadListener = new Strain3ReadListener() ;
    93.  
    94.         try {
    95.             long start = System.currentTimeMillis();
    96.             EasyExcel.read(filePath, StrainEntity3.class, strain3ReadListener).sheet().doRead();
    97. //            EasyExcel.read(filePath)
    98. //                    .excelType(ExcelTypeEnum.CSV)
    99. //                    .registerReadListener(strain3ReadListener)
    100. //                    .sheet()
    101. //                    .doRead();
    102.             List result = strain3ReadListener.getCachedDataList();
    103.  
    104.             long end = System.currentTimeMillis();
    105.             System.out.println("easyExcel2："+ (end-start));
    106.             System.out.println("行数："+result.size());
    107.         } catch (Exception e) {
    108.             e.printStackTrace();
    109.         }
    110.     }
    111.  
    112. }

    3.3、读Excel

    1. package cn.sdjtky.ltpon.FileTest;
    2.  
    3. import cn.afterturn.easypoi.excel.ExcelImportUtil;
    4. import cn.afterturn.easypoi.excel.entity.ImportParams;
    5. import cn.afterturn.easypoi.handler.inter.IReadHandler;
    6. import cn.hutool.poi.excel.ExcelReader;
    7. import cn.hutool.poi.excel.ExcelUtil;
    8. import cn.sdjtky.ltpon.easy.excel.listener.MergeCellsReadListener;
    9. import cn.sdjtky.ltpon.poi.DemoDataListener;
    10. import com.alibaba.excel.EasyExcel;
    11. import com.alibaba.excel.context.AnalysisContext;
    12. import com.alibaba.excel.enums.CellExtraTypeEnum;
    13. import com.alibaba.excel.event.AnalysisEventListener;
    14. import com.alibaba.excel.read.listener.PageReadListener;
    15. import com.alibaba.excel.support.ExcelTypeEnum;
    16. import com.alibaba.fastjson2.JSON;
    17. import org.junit.jupiter.api.Test;
    18. import org.slf4j.Logger;
    19. import org.slf4j.LoggerFactory;
    20.  
    21. import java.io.File;
    22. import java.io.FileInputStream;
    23. import java.util.ArrayList;
    24. import java.util.List;
    25.  
    26. public class ReadExcelTest {
    27.  
    28.     private static final Logger LOGGER = LoggerFactory.getLogger(ReadExcelTest.class);
    29.     
    30.     @Test
    31.     public void test() {
    32.         String filePath = "G:/test/1048575.xlsx";
    33.         hutool(filePath);
    34. //        esayPoi(filePath);
    35. //        easyExcel1(filePath);
    36. //        easyExcel2(filePath);
    37.     }
    38.  
    39.  
    40.  
    41.     public void hutool(String filePath) {
    42.  
    43.         try {
    44.             long start = System.currentTimeMillis();
    45.             ExcelReader reader = ExcelUtil.getReader(filePath);
    46.             List result = reader.readAll(StrainEntity.class);
    47.             long end = System.currentTimeMillis();
    48.             System.out.println("hutool："+ (end-start));
    49.             System.out.println("行数："+result.size());
    50.         } catch (Exception e) {
    51.             e.printStackTrace();
    52.         }
    53.     }
    54.  
    55.     public void esayPoi(String filePath) {
    56.         try {
    57.             ImportParams params = new ImportParams();
    58.             List result = new ArrayList();
    59.             long start = System.currentTimeMillis();
    60.             ExcelImportUtil.importExcelBySax(
    61.                     new FileInputStream(new File(filePath)),
    62.                     StrainEntity2.class,
    63.                     params,
    64.                     new IReadHandler() {
    65.                         @Override
    66.                         public void handler(StrainEntity2 o) {
    67.                             result.add(o);
    68.                         }
    69.                         @Override
    70.                         public void doAfterAll() {
    71.                             System.out.println("全部执行完毕了--------------------------------");
    72.                         }
    73.                     });
    74.  
    75.             long end = System.currentTimeMillis();
    76.             System.out.println("esayPoi："+ (end-start));
    77.             System.out.println("行数："+result.size());
    78.         } catch (Exception e) {
    79.             e.printStackTrace();
    80.         }
    81.     }
    82.  
    83.     public void easyExcel1(String filePath) {
    84.         try {
    85.             ImportParams params = new ImportParams();
    86.             List result = new ArrayList();
    87.             long start = System.currentTimeMillis();
    88.  
    89.             EasyExcel.read(filePath, StrainEntity3.class, new AnalysisEventListener() {
    90.                 @Override
    91.                 public void invoke(StrainEntity3 reportExcel, AnalysisContext analysisContext) {
    92.                     // 将读取到的每一行存入reportDetails集合中
    93.                     result.add(reportExcel);
    94.                 }
    95.                 @Override
    96.                 public void doAfterAllAnalysed(AnalysisContext analysisContext) {}
    97.             }).sheet().doRead();
    98.  
    99.             long end = System.currentTimeMillis();
    100.             System.out.println("easyExcel1："+ (end-start));
    101.             System.out.println("行数："+result.size());
    102.         } catch (Exception e) {
    103.             e.printStackTrace();
    104.         }
    105.     }
    106.  
    107.     public void easyExcel2(String filePath) {
    108.         final Strain3ReadListener strain3ReadListener = new Strain3ReadListener() ;
    109.  
    110.         try {
    111.             long start = System.currentTimeMillis();
    112.             EasyExcel.read(filePath, StrainEntity3.class, strain3ReadListener).sheet().doRead();
    113. //            EasyExcel.read(filePath)
    114. //                    .registerReadListener(strain3ReadListener)
    115. //                    .sheet()
    116. //                    .doRead();
    117.             List result = strain3ReadListener.getCachedDataList();
    118.  
    119.             long end = System.currentTimeMillis();
    120.             System.out.println("easyExcel2："+ (end-start));
    121.             System.out.println("行数："+result.size());
    122.         } catch (Exception e) {
    123.             e.printStackTrace();
    124.         }
    125.     }
    126.  
    127. }

    3.4、写CSV

    1. package cn.sdjtky.ltpon.FileTest;
    2.  
    3. import cn.afterturn.easypoi.csv.CsvExportUtil;
    4. import cn.afterturn.easypoi.csv.CsvImportUtil;
    5. import cn.afterturn.easypoi.csv.entity.CsvExportParams;
    6. import cn.afterturn.easypoi.csv.entity.CsvImportParams;
    7. import cn.afterturn.easypoi.excel.entity.ImportParams;
    8. import cn.hutool.core.io.FastByteArrayOutputStream;
    9. import cn.hutool.core.io.resource.ResourceUtil;
    10. import cn.hutool.core.text.csv.CsvReader;
    11. import cn.hutool.core.text.csv.CsvUtil;
    12. import cn.hutool.core.text.csv.CsvWriter;
    13. import cn.hutool.core.util.CharsetUtil;
    14. import cn.sdjtky.ltpon.query.HumidityQuery;
    15. import cn.sdjtky.ltpon.utils.BeanCopierUtils;
    16. import com.alibaba.excel.EasyExcel;
    17. import com.alibaba.excel.ExcelWriter;
    18. import com.alibaba.excel.context.AnalysisContext;
    19. import com.alibaba.excel.event.AnalysisEventListener;
    20. import com.alibaba.excel.support.ExcelTypeEnum;
    21. import com.alibaba.excel.write.metadata.WriteSheet;
    22. import com.ruoyi.common.utils.uuid.IdUtils;
    23. import org.junit.jupiter.api.Test;
    24. import org.slf4j.Logger;
    25. import org.slf4j.LoggerFactory;
    26. import org.springframework.beans.BeanUtils;
    27.  
    28. import java.io.ByteArrayInputStream;
    29. import java.io.File;
    30. import java.io.FileInputStream;
    31. import java.io.FileOutputStream;
    32. import java.util.ArrayList;
    33. import java.util.List;
    34.  
    35. public class WriteCsvTest {
    36.  
    37.     private static final Logger LOGGER = LoggerFactory.getLogger(WriteCsvTest.class);
    38.     
    39.     @Test
    40.     public void test() {
    41.         String filePath = "G:/test/1048575.csv";
    42.         List strainEntity3List  = Rerad_easyExcel1(filePath);
    43.  
    44.         List strainEntityList = BeanCopierUtils.list(strainEntity3List, StrainEntity::new);
    45.         List strainEntity2List = BeanCopierUtils.list(strainEntity3List, StrainEntity2::new);
    46. //        List strainEntity3List = BeanCopierUtils.list(strainEntity3List, StrainEntity3::new);
    47. //        hutool(strainEntityList);
    48. //        esayPoi(strainEntity2List);
    49. //        easyExcel1(strainEntity3List);
    50.         easyExcel2(strainEntity3List);
    51.     }
    52.  
    53.     public List Rerad_easyExcel1(String filePath) {
    54.         List result = new ArrayList();
    55.         try {
    56.             ImportParams params = new ImportParams();
    57.  
    58.             EasyExcel.read(filePath, StrainEntity3.class, new AnalysisEventListener() {
    59.                 @Override
    60.                 public void invoke(StrainEntity3 reportExcel, AnalysisContext analysisContext) {
    61.                     // 将读取到的每一行存入reportDetails集合中
    62.                     result.add(reportExcel);
    63.                 }
    64.                 @Override
    65.                 public void doAfterAllAnalysed(AnalysisContext analysisContext) {}
    66.             }).excelType(ExcelTypeEnum.CSV).sheet().doRead();
    67.  
    68.         } catch (Exception e) {
    69.             e.printStackTrace();
    70.         }
    71.         return result;
    72.     }
    73.  
    74.     public void hutool(List list) {
    75.         System.out.println("数据行数："+list.size());
    76.         try {
    77.             long start = System.currentTimeMillis();
    78.             CsvWriter writer = CsvUtil.getWriter("G:/test/write/hutool.csv", CharsetUtil.CHARSET_UTF_8);
    79. //            writer.write(list);
    80.             writer.writeBeans(list);
    81.             long end = System.currentTimeMillis();
    82.             long cost = end-start;
    83.             System.out.println("hutool："+ cost);
    84.         } catch (Exception e) {
    85.             e.printStackTrace();
    86.         }
    87.     }
    88.  
    89.     public void esayPoi(List list) {
    90.         System.out.println("数据行数："+list.size());
    91.         try {
    92.             long start = System.currentTimeMillis();
    93.  
    94.             CsvExportParams params = new CsvExportParams(CsvImportParams.UTF8);
    95.             FileOutputStream fos = new FileOutputStream("G:/test/write/esayPoi.csv");
    96.             CsvExportUtil.exportCsv(params, StrainEntity2.class, list, fos);
    97.             fos.flush();
    98.             fos.close();
    99.  
    100.             long end = System.currentTimeMillis();
    101.             long cost = end-start;
    102.             System.out.println("esayPoi："+ cost);
    103.         } catch (Exception e) {
    104.             e.printStackTrace();
    105.         }
    106.     }
    107.  
    108.     public void easyExcel1(List list) {
    109.         System.out.println("数据行数："+list.size());
    110.         try {
    111.             long start = System.currentTimeMillis();
    112.  
    113.             FastByteArrayOutputStream fastByteArrayOutputStream = new FastByteArrayOutputStream();
    114.             try {
    115.                 EasyExcel.write(fastByteArrayOutputStream, StrainEntity3.class)
    116.                         .autoCloseStream(false)
    117.                         .excelType(ExcelTypeEnum.CSV)
    118.                         .sheet("sheet页")
    119.                         .doWrite(list);
    120.                 FileOutputStream fileOutputStream = new FileOutputStream("G:/test/write/easyExcel.csv");
    121.                 fastByteArrayOutputStream.writeTo(fileOutputStream);
    122.                 fileOutputStream.flush();
    123.                 fileOutputStream.close();
    124.  
    125.             } finally {
    126.             }
    127.  
    128.             long end = System.currentTimeMillis();
    129.             long cost = end-start;
    130.             System.out.println("easyExcel1："+ cost);
    131.         } catch (Exception e) {
    132.             e.printStackTrace();
    133.         }
    134.     }
    135.  
    136.     public void easyExcel2(List list) {
    137.         System.out.println("数据行数："+list.size());
    138.         try {
    139.             long start = System.currentTimeMillis();
    140.  
    141.             try {
    142.                 EasyExcel.write("G:/test/write/easyExcel.csv", StrainEntity3.class).excelType(ExcelTypeEnum.CSV).sheet("sss").doWrite(list);
    143.             } finally {
    144.             }
    145.  
    146.             long end = System.currentTimeMillis();
    147.             long cost = end-start;
    148.             System.out.println("easyExcel2："+ cost);
    149.         } catch (Exception e) {
    150.             e.printStackTrace();
    151.         }
    152.     }
    153.  
    154. }

    3.5、写Excel

    1. package cn.sdjtky.ltpon.FileTest;
    2.  
    3. import cn.afterturn.easypoi.excel.ExcelExportUtil;
    4. import cn.afterturn.easypoi.excel.ExcelImportUtil;
    5. import cn.afterturn.easypoi.excel.entity.ExportParams;
    6. import cn.afterturn.easypoi.excel.entity.ImportParams;
    7. import cn.afterturn.easypoi.excel.entity.TemplateExportParams;
    8. import cn.afterturn.easypoi.handler.inter.IExcelExportServer;
    9. import cn.afterturn.easypoi.handler.inter.IReadHandler;
    10. import cn.hutool.core.bean.BeanUtil;
    11. import cn.hutool.core.collection.CollUtil;
    12. import cn.hutool.core.io.FastByteArrayOutputStream;
    13. import cn.hutool.core.text.csv.CsvUtil;
    14. import cn.hutool.core.text.csv.CsvWriter;
    15. import cn.hutool.core.util.CharsetUtil;
    16. import cn.hutool.poi.excel.BigExcelWriter;
    17. import cn.hutool.poi.excel.ExcelReader;
    18. import cn.hutool.poi.excel.ExcelUtil;
    19. import cn.hutool.poi.excel.ExcelWriter;
    20. import cn.sdjtky.ltpon.utils.BeanCopierUtils;
    21. import com.alibaba.excel.EasyExcel;
    22. import com.alibaba.excel.context.AnalysisContext;
    23. import com.alibaba.excel.event.AnalysisEventListener;
    24. import com.alibaba.excel.support.ExcelTypeEnum;
    25. import com.alibaba.excel.write.metadata.WriteSheet;
    26. import com.alibaba.excel.write.metadata.fill.FillWrapper;
    27. import com.ruoyi.common.utils.uuid.IdUtils;
    28. import lombok.SneakyThrows;
    29. import org.apache.poi.ss.usermodel.Workbook;
    30. import org.apache.poi.xssf.streaming.SXSSFWorkbook;
    31. import org.junit.jupiter.api.Test;
    32. import org.slf4j.Logger;
    33. import org.slf4j.LoggerFactory;
    34.  
    35. import java.io.File;
    36. import java.io.FileInputStream;
    37. import java.io.FileOutputStream;
    38. import java.util.ArrayList;
    39. import java.util.HashMap;
    40. import java.util.List;
    41. import java.util.Map;
    42.  
    43. public class WriteExcelTest {
    44.  
    45.     private static final Logger LOGGER = LoggerFactory.getLogger(WriteExcelTest.class);
    46.     
    47.     @Test
    48.     public void test() {
    49.         String filePath = "G:/test/1048575.csv";
    50.         List strainEntity3List  = Rerad_easyExcel1(filePath);
    51.  
    52.         List strainEntityList = BeanCopierUtils.list(strainEntity3List, StrainEntity::new);
    53.         List strainEntity2List = BeanCopierUtils.list(strainEntity3List, StrainEntity2::new);
    54. //        hutool1(strainEntityList);
    55. //        hutool2(strainEntityList);
    56. //        esayPoi1(strainEntity2List);
    57. //        esayPoi2(strainEntity2List);
    58. //        easyExcel1(strainEntity3List);
    59. //        easyExcel2(strainEntity3List);
    60. //        easyExcel3(strainEntity3List);
    61.         easyExcel4(strainEntity3List);
    62.     }
    63.  
    64.     public List Rerad_easyExcel1(String filePath) {
    65.         List result = new ArrayList();
    66.         try {
    67.             ImportParams params = new ImportParams();
    68.  
    69.             EasyExcel.read(filePath, StrainEntity3.class, new AnalysisEventListener() {
    70.                 @Override
    71.                 public void invoke(StrainEntity3 reportExcel, AnalysisContext analysisContext) {
    72.                     // 将读取到的每一行存入reportDetails集合中
    73.                     result.add(reportExcel);
    74.                 }
    75.                 @Override
    76.                 public void doAfterAllAnalysed(AnalysisContext analysisContext) {}
    77.             }).excelType(ExcelTypeEnum.CSV).sheet().doRead();
    78.  
    79.         } catch (Exception e) {
    80.             e.printStackTrace();
    81.         }
    82.         return result;
    83.     }
    84.  
    85.     public void hutool1(List list) {
    86.         System.out.println("数据行数："+list.size());
    87.         try {
    88.             long start = System.currentTimeMillis();
    89.             ExcelWriter writer = ExcelUtil.getWriter("G:/test/write/hutool.xlsx");
    90.             writer.write(list, true);
    91.             // 关闭writer，释放内存
    92.             writer.close();
    93.             long end = System.currentTimeMillis();
    94.             long cost = end-start;
    95.             System.out.println("hutool："+ cost);
    96.         } catch (Exception e) {
    97.             e.printStackTrace();
    98.         }
    99.     }
    100.  
    101.     public void hutool2(List list) {
    102.         System.out.println("数据行数："+list.size());
    103.         try {
    104.             long start = System.currentTimeMillis();
    105.  
    106.             BigExcelWriter writer= ExcelUtil.getBigWriter("G:/test/write/hutool2"+ IdUtils.getSequenceID()+".xlsx");
    107.             writer.write(list);
    108.             writer.close();
    109.  
    110.             long end = System.currentTimeMillis();
    111.             long cost = end-start;
    112.             System.out.println("hutool2："+ cost);
    113.         } catch (Exception e) {
    114.             e.printStackTrace();
    115.         }
    116.     }
    117.  
    118.     public void esayPoi1(List list) {
    119.         System.out.println("数据行数："+list.size());
    120.         try {
    121.             long start = System.currentTimeMillis();
    122.  
    123.             ExportParams params   = new ExportParams();
    124.             params.setMaxNum(1048576);
    125.             Workbook  workbook = null;
    126.             workbook = ExcelExportUtil.exportBigExcel(params, StrainEntity2.class, new IExcelExportServer() {
    127.  
    128.                 @Override
    129.                 public List selectListForExcelExport(Object obj, int page) {
    130.                     if (list.size()<=0){
    131.                         return null;
    132.                     }
    133.                     List listObj = new ArrayList();
    134.                     listObj.addAll(list);
    135.                     list.clear();
    136.                     return listObj;
    137.                 }
    138.             }, 1);
    139.  
    140. //           workbook = ExcelExportUtil.exportExcel(params,StrainEntity2.class,list);
    141.  
    142.             FileOutputStream fos = new FileOutputStream("G:/test/write/esayPoi.xlsx");
    143.             workbook.write(fos);
    144.             fos.close();
    145.  
    146.             long end = System.currentTimeMillis();
    147.             long cost = end-start;
    148.             System.out.println("esayPoi："+ cost);
    149.         } catch (Exception e) {
    150.             e.printStackTrace();
    151.         }
    152.     }
    153.  
    154.     public void esayPoi2(List list) {
    155.         System.out.println("数据行数："+list.size());
    156.         try {
    157.             long start = System.currentTimeMillis();
    158.  
    159.             Map map = new HashMap();
    160.             map.put("list", list);
    161.             TemplateExportParams params = new TemplateExportParams("G:/test/t/StrainEntity2.xlsx");
    162.             Workbook workbook = ExcelExportUtil.exportExcel(params, map);
    163.             FileOutputStream fos = new FileOutputStream("G:/test/write/esayPoi2.xlsx");
    164.             workbook.write(fos);
    165.             fos.close();
    166.  
    167.             long end = System.currentTimeMillis();
    168.             long cost = end-start;
    169.             System.out.println("esayPoi2："+ cost);
    170.         } catch (Exception e) {
    171.             e.printStackTrace();
    172.         }
    173.     }
    174.  
    175.     public void easyExcel1(List list) {
    176.         System.out.println("数据行数："+list.size());
    177.         try {
    178.             long start = System.currentTimeMillis();
    179.  
    180.             FastByteArrayOutputStream fastByteArrayOutputStream = new FastByteArrayOutputStream();
    181.             try {
    182.                 EasyExcel.write(fastByteArrayOutputStream, StrainEntity3.class)
    183.                         .autoCloseStream(false)
    184.                         .excelType(ExcelTypeEnum.XLSX)
    185.                         .sheet("sheet页")
    186.                         .doWrite(list);
    187.                 FileOutputStream fileOutputStream = new FileOutputStream("G:/test/write/easyExcel.xlsx");
    188.                 fastByteArrayOutputStream.writeTo(fileOutputStream);
    189.                 fileOutputStream.flush();
    190.                 fileOutputStream.close();
    191.  
    192.             } finally {
    193.             }
    194.  
    195.             long end = System.currentTimeMillis();
    196.             long cost = end-start;
    197.             System.out.println("easyExcel1："+ cost);
    198.         } catch (Exception e) {
    199.             e.printStackTrace();
    200.         }
    201.     }
    202.  
    203.     public void easyExcel2(List list) {
    204.         System.out.println("数据行数："+list.size());
    205.         try {
    206.             long start = System.currentTimeMillis();
    207.  
    208.             try {
    209.                 EasyExcel.write("G:/test/write/easyExcel.xlsx", StrainEntity3.class).excelType(ExcelTypeEnum.XLSX).sheet("sss").doWrite(list);
    210.             } finally {
    211.             }
    212.  
    213.             long end = System.currentTimeMillis();
    214.             long cost = end-start;
    215.             System.out.println("easyExcel2："+ cost);
    216.         } catch (Exception e) {
    217.             e.printStackTrace();
    218.         }
    219.     }
    220.  
    221.     public void easyExcel3(List list) {
    222.         System.out.println("数据行数："+list.size());
    223.         try {
    224.             long start = System.currentTimeMillis();
    225.  
    226.             String templateFileName = "G:/test/t/StrainEntity3.xlsx";
    227.             String fileName = "G:/test/write/easyExcel.xlsx";
    228.             // 方案1 一下子全部放到内存里面 并填充
    229.             // 这里 会填充到第一个sheet， 然后文件流会自动关闭
    230.             EasyExcel.write(fileName).withTemplate(templateFileName).sheet().doFill(list);
    231.  
    232.             long end = System.currentTimeMillis();
    233.             long cost = end-start;
    234.             System.out.println("easyExcel3："+ cost);
    235.         } catch (Exception e) {
    236.             e.printStackTrace();
    237.         }
    238.     }
    239.  
    240.     public void easyExcel4(List list) {
    241.         System.out.println("数据行数："+list.size());
    242.         try {
    243.             long start = System.currentTimeMillis();
    244.             FastByteArrayOutputStream fastByteArrayOutputStream = new FastByteArrayOutputStream();
    245.             // 方案2 分多次 填充 会使用文件缓存（省内存）
    246.             String templateFileName = "G:/test/t/StrainEntity3.xlsx";
    247.             String fileName = "G:/test/write/easyExcel.xlsx";
    248.             try (com.alibaba.excel.ExcelWriter excelWriter = EasyExcel.write(fastByteArrayOutputStream).withTemplate(templateFileName).build()) {
    249.                 WriteSheet writeSheet = EasyExcel.writerSheet().build();
    250.                 excelWriter.fill(list, writeSheet);
    251.             }
    252.  
    253. //            String templateFileName = "G:/test/t/StrainEntity3.1.xlsx";
    254. //            String fileName = "G:/test/write/easyExcel.xlsx";
    255. //            try (com.alibaba.excel.ExcelWriter excelWriter = EasyExcel.write(fileName).withTemplate(templateFileName).build()) {
    256. //                WriteSheet writeSheet = EasyExcel.writerSheet().build();
    257. //                excelWriter.fill(new FillWrapper("sl", list),  writeSheet);
    258. //            }
    259.  
    260. //            String templateFileName = "G:/test/t/StrainEntity3.1.xlsx";
    261. //            String fileName = "G:/test/write/easyExcel.xlsx";
    262. //            try (com.alibaba.excel.ExcelWriter excelWriter = EasyExcel.write(fileName).withTemplate(templateFileName).build()) {
    263. //                WriteSheet writeSheet = EasyExcel.writerSheet().build();
    264. //                excelWriter.fill(new FillWrapper("sl", listX),  writeSheet);
    265. //                excelWriter.fill(new FillWrapper("sl", listX),  writeSheet);
    266. //                excelWriter.fill(new FillWrapper("sl", listX),  writeSheet);
    267. //                excelWriter.fill(new FillWrapper("sl", listX),  writeSheet);
    268. //                excelWriter.fill(new FillWrapper("sl", listX),  writeSheet);
    269. //            }
    270.  
    271.  
    272.             long end = System.currentTimeMillis();
    273.             long cost = end-start;
    274.             System.out.println("easyExcel4："+ cost);
    275.         } catch (Exception e) {
    276.             e.printStackTrace();
    277.         }
    278.     }
    279. }
      280.  

      3.6、业务示例
       

      1. package cn.sdjtky.ltpon.FileTest;
      2.  
      3. import cn.afterturn.easypoi.excel.ExcelExportUtil;
      4. import cn.afterturn.easypoi.excel.entity.ExportParams;
      5. import cn.afterturn.easypoi.excel.entity.ImportParams;
      6. import cn.afterturn.easypoi.excel.entity.TemplateExportParams;
      7. import cn.afterturn.easypoi.handler.inter.IExcelExportServer;
      8. import cn.hutool.core.io.FastByteArrayOutputStream;
      9. import cn.hutool.poi.excel.BigExcelWriter;
      10. import cn.hutool.poi.excel.ExcelUtil;
      11. import cn.hutool.poi.excel.ExcelWriter;
      12. import cn.sdjtky.ltpon.utils.BeanCopierUtils;
      13. import cn.sdjtky.ltpon.utils.LocalDateTimeUtils;
      14. import com.alibaba.excel.EasyExcel;
      15. import com.alibaba.excel.context.AnalysisContext;
      16. import com.alibaba.excel.enums.WriteDirectionEnum;
      17. import com.alibaba.excel.event.AnalysisEventListener;
      18. import com.alibaba.excel.support.ExcelTypeEnum;
      19. import com.alibaba.excel.write.metadata.WriteSheet;
      20. import com.alibaba.excel.write.metadata.fill.FillConfig;
      21. import com.alibaba.excel.write.metadata.fill.FillWrapper;
      22. import com.ruoyi.common.utils.DateUtils;
      23. import com.ruoyi.common.utils.uuid.IdUtils;
      24. import org.apache.poi.ss.usermodel.Workbook;
      25. import org.junit.jupiter.api.Test;
      26. import org.slf4j.Logger;
      27. import org.slf4j.LoggerFactory;
      28. import org.springframework.core.io.DefaultResourceLoader;
      29. import org.springframework.core.io.Resource;
      30.  
      31. import java.io.ByteArrayOutputStream;
      32. import java.io.FileOutputStream;
      33. import java.time.LocalDateTime;
      34. import java.util.*;
      35.  
      36. public class StressStrainTest {
      37.  
      38.     private static final Logger LOGGER = LoggerFactory.getLogger(StressStrainTest.class);
      39.  
      40.     private static final String stationName = "临沂G205观测点";
      41.     private static final String pileNumber = "K103--K113";
      42.     private static final String observer = "徐本锡";
      43.     private static final String observationDate = LocalDateTimeUtils.format(LocalDateTimeUtils.DEFAULT_PATTERN,LocalDateTime.now());
      44.     private static final String reviewer = "金小少";
      45.     private static final String reviewDate = LocalDateTimeUtils.format(LocalDateTimeUtils.DEFAULT_PATTERN,LocalDateTime.now());
      46.     @Test
      47.     public void test() {
      48. //        esayPoi2();
      49.         easyExcel4();
      50. //        easyExcelCSV2();
      51.     }
      52.  
      53.  
      54.     public Map getData(){
      55.         Map map = new HashMap();
      56.  
      57.         List deviceList = new ArrayList();
      58.         for (int i=1; i<=8; i++){
      59.             DeviceDto deviceDto= new DeviceDto();
      60.             deviceDto.setSn("传感器x_"+i);
      61.             deviceDto.setSurfaceDistance(Double.valueOf(i));
      62.             deviceDto.setStructuralLayer("层位"+i);
      63.             deviceDto.setChannel("电信号");
      64.             deviceDto.setDataKey("t.v"+i);
      65.             deviceList.add(deviceDto);
      66.         }
      67.  
      68.         List> dataList = new ArrayList>();
      69.         List dataList2 = new ArrayList();
      70.         for(int i=0; i<100; i++){
      71.             Map m = new HashMap();
      72.             StressStrainDataDto dto = new StressStrainDataDto();
      73.             for (int j=1; j<=8; j++){
      74.                 m.put("date", DateUtils.datePath());
      75.                 m.put("time", DateUtils.dateTimeNow(DateUtils.HHMMssSSS_1));
      76.                 m.put("v"+j, Math.random()+1);
      77.  
      78.                 dto.setDate(DateUtils.datePath());
      79.                 dto.setTime(DateUtils.dateTimeNow(DateUtils.HHMMssSSS_1));
      80.                 dto.setDateTime(DateUtils.dateTimeNow(DateUtils.YYYYMMDDHHMMssSSS_1));
      81.  
      82.                 dto.setV1( Math.random()+1);
      83.                 dto.setV2( Math.random()+1);
      84.                 dto.setV3( Math.random()+1);
      85.                 dto.setV4( Math.random()+1);
      86.                 dto.setV5( Math.random()+1);
      87.                 dto.setV6( Math.random()+1);
      88.                 dto.setV7( Math.random()+1);
      89.                 dto.setV8( Math.random()+1);
      90.             }
      91.             dataList.add(m);
      92.             dataList2.add(dto);
      93.         }
      94.  
      95.         map.put("stationName", stationName);
      96.         map.put("pileNumber", pileNumber);
      97.         map.put("observer", observer);
      98.         map.put("observationDate", observationDate);
      99.         map.put("reviewer", reviewer);
      100.         map.put("reviewDate", reviewDate);
      101.         map.put("deviceList", deviceList);
      102.         map.put("dataList", dataList2);
      103.  
      104.         return map;
      105.     }
      106.  
      107.     public void esayPoi2() {
      108.         Map data = getData();
      109.         System.out.println("数据行数："+((List)data.get("dataList")).size());
      110.         try {
      111.             long start = System.currentTimeMillis();
      112.             TemplateExportParams params = new TemplateExportParams("G:/test/t/stressStrainTemplateDongHua.xlsx");
      113.             params.setColForEach(true);
      114.             Workbook workbook = ExcelExportUtil.exportExcel(params, data);
      115.             FileOutputStream fos = new FileOutputStream("G:/test/write/stressStrainTemplateDongHua.xlsx");
      116.             workbook.write(fos);
      117.             fos.close();
      118.  
      119.             long end = System.currentTimeMillis();
      120.             long cost = end-start;
      121.             System.out.println("esayPoi2："+ cost);
      122.         } catch (Exception e) {
      123.             e.printStackTrace();
      124.         }
      125.     }
      126.  
      127.     public void easyExcel4() {
      128.         Map data = getData();
      129.         Map data1 = new HashMap();
      130.         data1.put("stationName", data.get("stationName"));
      131.         data1.put("pileNumber", data.get("pileNumber"));
      132.         data1.put("observer", data.get("observer"));
      133.         data1.put("observationDate", data.get("observationDate"));
      134.         data1.put("reviewer", data.get("reviewer"));
      135.         data1.put("reviewDate", data.get("reviewDate"));
      136.         List deviceList = (List) data.get("deviceList");
      137.         List dataList = (List) data.get("dataList");
      138.  
      139.         // 根据用户传入字段 导出数据
      140.         Set includeColumnFiledNames = new HashSet();
      141.         includeColumnFiledNames.add("date");
      142. //        includeColumnFiledNames.add("time");
      143.         for(int i=0; i
      144.             includeColumnFiledNames.add("v"+(i+1));
      145.         }
      146.  
      147.         System.out.println("数据行数："+((List)data.get("dataList")).size());
      148.         try {
      149.             long start = System.currentTimeMillis();
      150.             Resource resource = new DefaultResourceLoader().getResource("classpath:templates/stressStrain/stressStrainTemplateDongHua.xlsx");
      151.  
      152.             FastByteArrayOutputStream outputStream = new FastByteArrayOutputStream();
      153.             // 方案2 分多次 填充 会使用文件缓存（省内存）
      154. //            String templateFileName = "G:/test/t/stressStrainTemplateDongHua2.xlsx";
      155. //            try (com.alibaba.excel.ExcelWriter excelWriter = EasyExcel.write(fastByteArrayOutputStream).withTemplate(templateFileName).build()) {
      156. //                WriteSheet writeSheet = EasyExcel.writerSheet().build();
      157. //                FillConfig fillConfig = FillConfig.builder().autoStyle(true).direction(WriteDirectionEnum.HORIZONTAL).build();
      158. //                excelWriter.fill(data1,  writeSheet);
      159. //                excelWriter.fill(new FillWrapper("deviceList", deviceList), fillConfig, writeSheet);
      160.                 writeSheet.setIncludeColumnFieldNames(includeColumnFiledNames);
      161. //                excelWriter.fill(new FillWrapper("dataList", dataList),  writeSheet);
      162. //            }
      163.  
      164.  
      165.             try (com.alibaba.excel.ExcelWriter excelWriter = EasyExcel.write(outputStream).withTemplate(resource.getInputStream()).build()) {
      166.                 WriteSheet writeSheet = EasyExcel.writerSheet().build();
      167.                 FillConfig fillConfig = FillConfig.builder().autoStyle(true).direction(WriteDirectionEnum.HORIZONTAL).build();
      168.                 excelWriter.fill(data1,  writeSheet);
      169.                 excelWriter.fill(new FillWrapper("deviceList", deviceList), fillConfig, writeSheet);
      170.                 excelWriter.fill(new FillWrapper("dataList", dataList), writeSheet);
      171.                 excelWriter.close();
      172.                 outputStream.flush();
      173.                 outputStream.close();
      174.             }
      175. //            FileOutputStream fileOutputStream = new FileOutputStream("G:/test/write/123.xlsx");
      176. //            outputStream.writeTo(fileOutputStream);
      177. //            fileOutputStream.flush();
      178. //            fileOutputStream.close();
      179.             long end = System.currentTimeMillis();
      180. //            String templateFileName = "G:/test/t/stressStrainTemplateDongHua2.xlsx";
      181. //            String fileName = "G:/test/write/stressStrainTemplateDongHua2.xlsx";
      182. //            try (com.alibaba.excel.ExcelWriter excelWriter = EasyExcel.write(fileName).withTemplate(resource.getInputStream()).build()) {
      183. //                WriteSheet writeSheet = EasyExcel.writerSheet().build();
      184. //                FillConfig fillConfig = FillConfig.builder().autoStyle(true).direction(WriteDirectionEnum.HORIZONTAL).build();
      185. //                excelWriter.fill(data1,  writeSheet);
      186. //                excelWriter.fill(new FillWrapper("deviceList", deviceList), fillConfig, writeSheet);
      187.                 writeSheet.setIncludeColumnFieldNames(includeColumnFiledNames);
      188. //                excelWriter.fill(new FillWrapper("dataList", dataList),  writeSheet);
      189. //            }
      190.  
      191.  
      192.             long cost = end-start;
      193.             System.out.println("easyExcel4："+ cost);
      194.         } catch (Exception e) {
      195.             e.printStackTrace();
      196.         }
      197.     }
      198.  
      199.     public void easyExcelCSV2() {
      200.  
      201.  
      202.         Map data = getData();
      203.         List deviceList = (List) data.get("deviceList");
      204.         List dataList = (List) data.get("dataList");
      205.  
      206.         // 根据用户传入字段 导出数据
      207.         Set includeColumnFiledNames = new HashSet();
      208.  
      209.         List> headList = new ArrayList>();
      210.         List head0 = new ArrayList();
      211.         head0.add("时间");
      212.         head0.add("与路表距离");
      213.         head0.add("结构层位");
      214.         headList.add(head0);
      215.         includeColumnFiledNames.add("dateTime");
      216.  
      217.         for(int i=0; i
      218.             includeColumnFiledNames.add("v"+(i+1));
      219.             List head = new ArrayList();
      220.             head.add(deviceList.get(i).getSn());
      221.             head.add(deviceList.get(i).getSurfaceDistance().toString());
      222.             head.add(deviceList.get(i).getStructuralLayer());
      223.             headList.add(head);
      224.         }
      225.  
      226.         System.out.println("数据行数："+((List)data.get("dataList")).size());
      227.         try {
      228.             long start = System.currentTimeMillis();
      229.  
      230.             try {
      231.                 EasyExcel.write("G:/test/write/stressStrainTemplateDongHua2.csv", StressStrainDataDto.class).head(headList).includeColumnFieldNames(includeColumnFiledNames).excelType(ExcelTypeEnum.CSV).sheet("sss").doWrite(dataList);
      232.             } finally {
      233.             }
      234.  
      235.             long end = System.currentTimeMillis();
      236.             long cost = end-start;
      237.             System.out.println("easyExcel2："+ cost);
      238.         } catch (Exception e) {
      239.             e.printStackTrace();
      240.         }
      241.     }
      242.  
      243. }
       

      
                
                    
                

                
    280. 

                    相关阅读:
      
                    
[spark] RDD 编程指南（翻译）                            
      
[2023.09.25]:Rust编写基于web_sys的编辑器：输入光标再次定位的小结                            
      
一篇让你使用vue-cli搭建SPA项目                            
      
【Spring Web教程】SpringBoot 实现一应用多Tomcat容器                            
      
终于有人把不同标签的加工内容与落库讲明白了丨DTVision分析洞察篇                            
      
【博客551】实现主备高可用vip的几种方式                            
      
关于地方美食的HTML网页设计——地方美食介绍网站 HTML顺德美食介绍 html网页制作代码大全                            
      
从零开始运行YOLOV5                            
      
Win11中Yolo V10安装过程记录                            
      
实时即未来，车联网项目之电子围栏分析【六】                            
      
                          
                
      281. 
                
    281. 
                    原文地址：https://blog.csdn.net/xubenxismile/article/details/136375721
                
      282.