直接附上案例:
环境:easyUi框架和ssm集成框架,java语言 ,maven管理jar包,tomcat服务器版本8.5, jdk1.8
设计思路:
1、循环遍历每行每列,内层根据列遍历根据io流读取到的信息将每个字段所处位置和实体字段相对应,根据使用set()方法保存如实体。
2、根据行遍历将实体保存入List集合中,最终返回list集合
3、遍历list集合,将每个实体存入到数据库中(这里是逐条添加)
导入jar 包
所需jar包依赖
<!-- 导入poi依赖 -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.10.1</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.14-beta1</version>
</dependency>
<dependency>
<groupId>commons-codec</groupId>
<artifactId>commons-codec</artifactId>
<version>1.10</version>
</dependency>
<!--文件上传 -->
<dependency>
<groupId>commons-fileupload</groupId>
<artifactId>commons-fileupload</artifactId>
<version>1.3.1</version>
</dependency>
<dependency>
<groupId>commons-io</groupId>
<artifactId>commons-io</artifactId>
<version>2.4</version>
</dependency>
<!-- 数据库连接池 -->
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.2</version>
</dependency>
<!-- 数据库驱动 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.6</version>
</dependency>
jsp页面(内部url自己参考修改)
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<form enctype="multipart/form-data" id="batchUpload" action="/excel/import" method="post" class="form-horizontal">
<table>
<tr>
<td><button class="btn btn-success btn-xs" id="uploadEventBtn" style="height:30px; width:100px" type="button" >选择文件</button> </td>
<td><input type="file" name