实现思路
完整代码
完整代码在最后面
1.导入jar包
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
//jdbc
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.27</version>
</dependency>
<!-- https://mvnrepository.com/artifact/net.sourceforge.jexcelapi/jxl -->
//excel
<dependency>
<groupId>net.sourceforge.jexcelapi</groupId>
<artifactId>jxl</artifactId>
<version>2.6.12</version>
</dependency>
<!-- https://mvnrepository.com/artifact/jexcelapi/jxl -->
<dependency>
<groupId>jexcelapi</groupId>
<artifactId>jxl</artifactId>
<version>2.4.2</version>
</dependency>
2.创建一个pojo类,在测试模块中进行excel表读取,将数据存到list集合中
try {
File file = new File("D:\\text.xls");
//创建workbook对象
Workbook book = Workbook.getWorkbook(file);
//获取第一个工作表对象
Sheet sheet = book.getSheet(0);
int rows = sheet.getRows();
int columns = sheet.getColumns();
for (int i = 0; i < rows; i++) {
Zfjl zfjl = new Zfjl();
for (int j = 0; j < columns; j++) {
//获取第j列第i行的单元格
Cell cell = sheet.getCell(j, i);
if (i == 0) {
if (j == 0) {
Long id= Long.valueOf("11111");
zfjl.setId(id);
}else if (j == 1) {
zfjl.setDjxh("11111");}
else if (j == 2) {
zfjl.setZffs(cell.getContents());}
else if (j == 3) {
zfjl.setSdzfrq(cell.getContents());}
else if (j == 4) {
zfjl.setZfr(cell.getContents());}
else if (j == 5) {
zfjl.setZfsx(cell.getContents());}
else if (j == 6) {
zfjl.setNsrwtms(cell.getContents());}
else if (j == 7) {
zfjl.setWtsqcyfx(cell.getContents());}
else if (j == 8) {
zfjl.setYjjy(cell.getContents());}
else if (j == 9) {
zfjl.setXxdz(cell.getContents());}
else if (j == 10) {
zfjl.setLat1(cell.getContents())