0
0

SpringBoot下获取resources目录下文件的常用方法

哈喽，大家好，今天给大家带来SpringBoot获取resources目录下文件的常用方法，示例中的方法是读取resources目录下的txt和xlsx文件，并将xlsx导出到excel的简单写法。完整代码放在最后。

通过this.getClass()方法获取

method1 - method4都是通过这个方法获取文件的写法，这四种写法在idea中都可以正常运行，jar包执行后method1和method2报错，提示找不到文件，method3和method4可以正常运行

通过ClassPathResource获取

method5是通过这种方法实现，idea中可以正常运行，打包后的jar中提示找不到文件

通过hutool工具类ResourceUtil获取

method6是通过这种方法实现，和method情况一样，同样是idea中可以正常运行，导出的jar中提示找不到文件

总结

不想折腾的同学可以直接用method3和method4的方法来使用，也可以将模板和资源文件外置，通过绝对路径获取对应文件。有好的方法也欢迎大家一起交流沟通~

代码

  1. import cn.hutool.core.io.FileUtil;
  2. import cn.hutool.core.io.resource.ClassPathResource;
  3. import cn.hutool.core.io.resource.ResourceUtil;
  4. import com.alibaba.excel.EasyExcel;
  5. import com.alibaba.excel.ExcelWriter;
  6. import com.alibaba.excel.enums.WriteDirectionEnum;
  7. import com.alibaba.excel.write.metadata.WriteSheet;
  8. import com.alibaba.excel.write.metadata.fill.FillConfig;
  9. import org.springframework.web.bind.annotation.RequestMapping;
  10. import org.springframework.web.bind.annotation.RestController;
  12. import javax.servlet.http.HttpServletResponse;
  13. import java.io.BufferedReader;
  14. import java.io.IOException;
  15. import java.io.InputStream;
  16. import java.io.InputStreamReader;
  17. import java.io.UnsupportedEncodingException;
  18. import java.net.URLEncoder;
  19. import java.nio.charset.StandardCharsets;
  20. import java.util.List;
  22. @RestController
  23. @RequestMapping("/temp")
  24. public class TemplateController {
  26.     /**
  27.      * this.getClass()方法获取
  28.      * @param response
  29.      * @throws IOException
  30.      */
  31.     @RequestMapping("/method1")
  32.     public void method1(HttpServletResponse response) throws IOException {
  33.         System.out.println("----------method1 start");
  34.         String filename = "template.xlsx";
  35.         String bashPatch = this.getClass().getClassLoader().getResource("").getPath();
  36.         System.out.println(bashPatch);
  38.         String textFile = "template.txt";
  39.         String textPath = this.getClass().getClassLoader().getResource("").getPath();
  40.         List<String> dataList = FileUtil.readUtf8Lines(textPath + "/template/" + textFile);
  41.         for (String data : dataList) {
  42.             System.out.println(data);
  43.         }
  45.         try (ExcelWriter excelWriter =
  46.                      EasyExcel.write(response.getOutputStream())
  47.                              .autoCloseStream(false) // 不要自动关闭，交给 Servlet 自己处理
  48. //                             .withTemplate(resource.getFile().getAbsolutePath())
  49.                              .withTemplate(bashPatch + "/template/" + filename)
  50.                              .build()
  51.         ) {
  52.             WriteSheet writeSheet = EasyExcel.writerSheet(0).build();
  53.             FillConfig userFillConfig = FillConfig.builder().forceNewRow(Boolean.TRUE).build();
  54.             
  55.             FillConfig titleFillConfig = FillConfig.builder().direction(WriteDirectionEnum.HORIZONTAL).build();
  56.             excelWriter.finish();
  57.         }
  58.         try {
  59.             response.addHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(filename, StandardCharsets.UTF_8.name()));
  60.         } catch (UnsupportedEncodingException e) {
  61.             throw new RuntimeException(e);
  62.         }
  63.         response.setContentType("application/vnd.ms-excel;charset=UTF-8");
  64.     }
  66.     @RequestMapping("/method2")
  67.     public void method2(HttpServletResponse response) throws IOException {
  68.         System.out.println("----------method2 start");
  69.         String filename = "template.xlsx";
  70.         String bashPatch = this.getClass().getClassLoader().getResource("template").getPath();
  71.         System.out.println(bashPatch);
  73.         String textFile = "template.txt";
  74.         String textPath = this.getClass().getClassLoader().getResource("template").getPath();
  75.         List<String> dataList = FileUtil.readUtf8Lines(textPath + "/" + textFile);
  76.         for (String data : dataList) {
  77.             System.out.println(data);
  78.         }
  80.         try (ExcelWriter excelWriter =
  81.                      EasyExcel.write(response.getOutputStream())
  82.                              .autoCloseStream(false) // 不要自动关闭，交给 Servlet 自己处理
  83. //                             .withTemplate(resource.getFile().getAbsolutePath())
  84.                              .withTemplate(bashPatch + "/" + filename)
  85.                              .build()
  86.         ) {
  87.             WriteSheet writeSheet = EasyExcel.writerSheet(0).build();
  88.             FillConfig userFillConfig = FillConfig.builder().forceNewRow(Boolean.TRUE).build();
  89.             
  90.             FillConfig titleFillConfig = FillConfig.builder().direction(WriteDirectionEnum.HORIZONTAL).build();
  91.             excelWriter.finish();
  92.         }
  93.         try {
  94.             response.addHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(filename, StandardCharsets.UTF_8.name()));
  95.         } catch (UnsupportedEncodingException e) {
  96.             throw new RuntimeException(e);
  97.         }
  98.         response.setContentType("application/vnd.ms-excel;charset=UTF-8");
  99.     }
  101.     @RequestMapping("/method3")
  102.     public void method3(HttpServletResponse response) throws IOException {
  103.         System.out.println("----------method3 start");
  104.         String filename = "template.xlsx";
  105.         InputStream inputStream = this.getClass().getClassLoader().getResourceAsStream("template" + "/" + filename);
  106. //        System.out.println(inputStream);
  108.         String textFile = "template.txt";
  109.         InputStream textStream = this.getClass().getClassLoader().getResourceAsStream("template" + "/" + textFile);
  110.         BufferedReader reader = new BufferedReader(new InputStreamReader(textStream));
  111.         String line;
  112.         try {
  113.             while ((line = reader.readLine()) != null) {
  114.                 System.out.println(line);
  115.             }
  116.         } catch (IOException e) {
  117.             e.printStackTrace(); // 异常处理
  118.         }
  120.         try (ExcelWriter excelWriter =
  121.                      EasyExcel.write(response.getOutputStream())
  122.                              .autoCloseStream(false) // 不要自动关闭，交给 Servlet 自己处理
  123. //                             .withTemplate(resource.getFile().getAbsolutePath())
  124.                              .withTemplate(inputStream)
  125.                              .build()
  126.         ) {
  127.             WriteSheet writeSheet = EasyExcel.writerSheet(0).build();
  128.             FillConfig userFillConfig = FillConfig.builder().forceNewRow(Boolean.TRUE).build();
  129.             
  130.             FillConfig titleFillConfig = FillConfig.builder().direction(WriteDirectionEnum.HORIZONTAL).build();
  131.             excelWriter.finish();
  132.         }
  133.         try {
  134.             response.addHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(filename, StandardCharsets.UTF_8.name()));
  135.         } catch (UnsupportedEncodingException e) {
  136.             throw new RuntimeException(e);
  137.         }
  138.         response.setContentType("application/vnd.ms-excel;charset=UTF-8");
  139.     }
  141.     @RequestMapping("/method4")
  142.     public void method4(HttpServletResponse response) throws IOException {
  143.         System.out.println("----------method4 start");
  144.         String filename = "template.xlsx";
  145.         InputStream inputStream = this.getClass().getResourceAsStream("/template" + "/" + filename);
  146. //        System.out.println(inputStream);
  148.         String textFile = "template.txt";
  149.         InputStream textStream = this.getClass().getResourceAsStream("/template" + "/" + textFile);
  150.         BufferedReader reader = new BufferedReader(new InputStreamReader(textStream));
  151.         String line;
  152.         try {
  153.             while ((line = reader.readLine()) != null) {
  154.                 System.out.println(line);
  155.             }
  156.         } catch (IOException e) {
  157.             e.printStackTrace(); // 异常处理
  158.         }
  159.         try (ExcelWriter excelWriter =
  160.                      EasyExcel.write(response.getOutputStream())
  161.                              .autoCloseStream(false) // 不要自动关闭，交给 Servlet 自己处理
  162. //                             .withTemplate(resource.getFile().getAbsolutePath())
  163.                              .withTemplate(inputStream)
  164.                              .build()
  165.         ) {
  166.             WriteSheet writeSheet = EasyExcel.writerSheet(0).build();
  167.             FillConfig userFillConfig = FillConfig.builder().forceNewRow(Boolean.TRUE).build();
  168.             
  169.             FillConfig titleFillConfig = FillConfig.builder().direction(WriteDirectionEnum.HORIZONTAL).build();
  170.             excelWriter.finish();
  171.         }
  172.         try {
  173.             response.addHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(filename, StandardCharsets.UTF_8.name()));
  174.         } catch (UnsupportedEncodingException e) {
  175.             throw new RuntimeException(e);
  176.         }
  177.         response.setContentType("application/vnd.ms-excel;charset=UTF-8");
  178.     }
  180.     /**
  181.      * 通过ClassPathResource获取
  182.      * @param response
  183.      * @throws IOException
  184.      */
  185.     @RequestMapping("/method5")
  186.     public void method5(HttpServletResponse response) throws IOException {
  187.         System.out.println("----------method5 start");
  188.         String filename = "template.xlsx";
  189.         ClassPathResource classPathResource = new ClassPathResource("template" + "/" + filename);
  191.         String textFile = "template.txt";
  192.         ClassPathResource textResource = new ClassPathResource("template" + "/" + textFile);
  193.         List<String> dataList = FileUtil.readUtf8Lines(textResource.getAbsolutePath());
  194.         for (String data : dataList) {
  195.             System.out.println(data);
  196.         }
  198.         try (ExcelWriter excelWriter =
  199.                      EasyExcel.write(response.getOutputStream())
  200.                              .autoCloseStream(false) // 不要自动关闭，交给 Servlet 自己处理
  201.                              .withTemplate(classPathResource.getAbsolutePath())
  202.                              .build()
  203.         ) {
  204.             WriteSheet writeSheet = EasyExcel.writerSheet(0).build();
  205.             FillConfig userFillConfig = FillConfig.builder().forceNewRow(Boolean.TRUE).build();
  206.             
  207.             FillConfig titleFillConfig = FillConfig.builder().direction(WriteDirectionEnum.HORIZONTAL).build();
  208.             excelWriter.finish();
  209.         }
  210.         try {
  211.             response.addHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(filename, StandardCharsets.UTF_8.name()));
  212.         } catch (UnsupportedEncodingException e) {
  213.             throw new RuntimeException(e);
  214.         }
  215.         response.setContentType("application/vnd.ms-excel;charset=UTF-8");
  216.     }
  218.     /**
  219.      * 通过hutool工具类ResourceUtil获取
  220.      * @param response
  221.      * @throws IOException
  222.      */
  223.     @RequestMapping("/method6")
  224.     public void method6(HttpServletResponse response) throws IOException {
  225.         System.out.println("----------method6 start");
  226.         String filename = "template.xlsx";
  227.         String filePath = ResourceUtil.getResource("template" + "/" + filename).getPath();
  229.         String textFile = "template.txt";
  230.         String textPath = ResourceUtil.getResource("template" + "/" + textFile).getPath();
  231.         List<String> dataList = FileUtil.readUtf8Lines(textPath);
  232.         for (String data : dataList) {
  233.             System.out.println(data);
  234.         }
  236.         try (ExcelWriter excelWriter =
  237.                      EasyExcel.write(response.getOutputStream())
  238.                              .autoCloseStream(false) // 不要自动关闭，交给 Servlet 自己处理
  239.                              .withTemplate(filePath)
  240.                              .build()
  241.         ) {
  242.             WriteSheet writeSheet = EasyExcel.writerSheet(0).build();
  243.             FillConfig userFillConfig = FillConfig.builder().forceNewRow(Boolean.TRUE).build();
  244.             
  245.             FillConfig titleFillConfig = FillConfig.builder().direction(WriteDirectionEnum.HORIZONTAL).build();
  246.             excelWriter.finish();
  247.         }
  248.         try {
  249.             response.addHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(filename, StandardCharsets.UTF_8.name()));
  250.         } catch (UnsupportedEncodingException e) {
  251.             throw new RuntimeException(e);
  252.         }
  253.         response.setContentType("application/vnd.ms-excel;charset=UTF-8");
  254.     }
  256. }

pom依赖

  1.         <dependency>
  2.             <groupId>cn.hutool</groupId>
  3.             <artifactId>hutool-all</artifactId>
  4.             <version>5.8.9</version>
  5.         </dependency>
  6.         <dependency>
  7.             <groupId>com.alibaba</groupId>
  8.             <artifactId>easyexcel</artifactId>
  9.             <version>3.3.3</version>
  10.         </dependency>
标签： spring boot 后端 java
本文转载自: https://blog.csdn.net/u010479989/article/details/141674584
版权归原作者 小灰灰__ 所有， 如有侵权，请联系我们删除。
登录后发布评论

“SpringBoot下获取resources目录下文件的常用方法”的评论:

还没有评论
关于作者
...
overfit同步小助手
文章同步
相关阅读

网络安全法-网络运行安全

使用selenium/drissionpage时如何阻止chrome自动跳转http到https

docker desktop 里部署的Open WebUI 管理员密码忘记了的处理方法

在ubuntu20.04中搭建onsite比赛运行环境

利用开源的低代码表单设计器FcDesigner高效管理和渲染复杂表单结构

Kafka学习笔记

【前端】浏览器输入url到页面呈现发生了什么？

文章导航
没有找到文章内容分段。。。