1.首先我們先導(dǎo)入poi和文件上傳的依賴

1. <!--POI-->
2. <dependency>
3. <groupId>org.apache.poi</groupId>
4. <artifactId>poi-ooxml-schemas</artifactId>
5. <version>3.14-beta1</version>
6. </dependency>
7.  
8. <!--文件上傳依賴-->
9. <dependency>
10. <groupId>commons-fileupload</groupId>
11. <artifactId>commons-fileupload</artifactId>
12. <version>1.2.2</version>
13. </dependency>
14. <dependency>
15. <groupId>commons-io</groupId>
16. <artifactId>commons-io</artifactId>
17. <version>2.4</version>
18. </dependency>

2.在spring-mvc.xml中配置文件上傳解析器

1. <!-- 配置文件上傳解析器 -->
2. <!-- id 的值是固定的-->
3. <bean id="multipartResolver"
4. class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
5. <!-- 設(shè)置上傳文件的最大尺寸為 5MB -->
6. <property name="maxUploadSize">
7. <value>5242880</value>
8. </property>
9. </bean>

3.創(chuàng)建index.html

1. <!-- excel文件導(dǎo)出 -->
2. <p><a href="User/exportExcel.do" rel="external nofollow" >導(dǎo)出</a>
3. <!-- excel文件導(dǎo)入 -->
4. <form action="User/importExcel.do" method="post" enctype="multipart/form-data">
5. <input type="file" name="userExcel" />
6. <input type="submit" value="導(dǎo)入">
7. </form>

4.創(chuàng)建實體類

1. public class User {
2. private Integer id;
3. private String username;
4. private String password;
5. /* get 和 set */
6. }

5.Controller層

1. /**
2. * 導(dǎo)出Excel
3. * @param request
4. * @param response
5. */
6. @RequestMapping("/exportExcel")
7. @ResponseBody
8. public void exportExcel(HttpServletRequest request, HttpServletResponse response){
9. try {
10. //獲取數(shù)據(jù)源
11. List<User> userList = service.queryUserAll();
12. //導(dǎo)出excel
13. response.setHeader("Content-Disposition","attachment;filename="+new String("用戶信息.xls".getBytes(),"ISO-8859-1"));
14. response.setContentType("application/x-excel;charset=UTF-8");
15. OutputStream outputStream = response.getOutputStream();
16. //導(dǎo)出
17. service.exportExcel(userList,outputStream);
18. outputStream.close();
19. } catch (IOException e) {
20. e.printStackTrace();
21. }
22. }

1. /**
2. * 導(dǎo)入exc
3. * @param userExcel
4. * @param request
5. * @param session
6. * @return
7. */
8.  
9. @RequestMapping("/importExcel")
10. @ResponseBody
11. public String importExcel(MultipartFile userExcel, HttpServletRequest request, HttpSession session) throws IOException, InvalidFormatException {
12. if(userExcel == null){
13. session.setAttribute("excelName", "未上傳文件，上傳失敗！");
14. return null;
15. }
16. String userExcelFileName = userExcel.getOriginalFilename();
17. if(!userExcelFileName.matches("^.+\\.(?i)((xls)|(xlsx))$")){
18. session.setAttribute("excelName", "文件格式不正確！請使用.xls或.xlsx后綴的文檔，導(dǎo)入失敗！");
19. return null;
20. }
21. //導(dǎo)入
22. service.importExcel(userExcel);
23. session.setAttribute("excelName", "導(dǎo)入成功！");
24. return "redirect:queryUserAll.do";
25. }

6.運行測試

1.點擊導(dǎo)出將數(shù)據(jù)庫的內(nèi)容以后綴為 .xls的文件下載下來

2. 選擇Excel文件點擊導(dǎo)入會將文件里的內(nèi)容導(dǎo)入到數(shù)據(jù)庫中

到此這篇關(guān)于SSM框架使用poi導(dǎo)入導(dǎo)出Excel的文章就介紹到這了,更多相關(guān)SSM框架導(dǎo)入導(dǎo)出Excel內(nèi)容請搜索服務(wù)器之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持服務(wù)器之家！

原文鏈接：https://blog.csdn.net/weixin_51311866/article/details/115246070