poi是Apache提供可以操作ms office格式文档的api,本文主要介绍利用Poi结合Java代码实现一键批量导入excel,可以操作的后缀两种格式的excel。
首先 导入jar包
Maven方式
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.17</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.17</version>
</dependency>
这里主要针对四级题库excel文件进行导入
excel:
sql:
<insert id="exportWordList">
insert into wordmp.word_record(name,soundmark,explainword,rank) values
<foreach collection='list' item='word' separator=','>
(#{word.name},#{word.soundmark},#{word.explainword},4)
</foreach>
</insert>
Dao:
@Repository
public <