C:\Users\75260942\IdeaProjects\SSMStudy\src\main\java\com\qcby\jdbc\Excel2Bean.java:28:39
java: 无法访问org.apache.poi.poifs.filesystem.NPOIFSFileSystem
找不到org.apache.poi.poifs.filesystem.NPOIFSFileSystem的类文件
```java
package com.qcby.jdbc;
import com.qcby.model.Account;
import org.apache.poi.ss.usermodel.*;
import org.springframework.stereotype.Component;
import java.io.FileInputStream;
import java.io.InputStream;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
@Component
public class Excel2Bean {
JDBCUtils jdbcUtils = new JDBCUtils();
public List readExcel(String filePath){
Connection connection = null;
PreparedStatement pstmt =null;
ResultSet rs = null;
List list = new ArrayList();
Workbook workbook = null;
try {
// 读取Excel文件
InputStream inputStream = new FileInputStream(filePath);
workbook = WorkbookFactory.create(inputStream);
inputStream.close();
} catch (Exception e) {
e.printStackTrace();
}
// 循环工作表
String sql = "insert into lzbi.mc_ctb_build_matrix values('111','222','','333','444','555',";
for (int numSheet = 0; numSheet < workbook.getNumberOfSheets(); numSheet++) {
Sheet hssfSheet = workbook.getSheetAt(numSheet);
// 循环行
for (int rowNum = 1; rowNum <= hssfSheet.getLastRowNum(); rowNum++) {
Row hssfRow = hssfSheet.getRow(rowNum);
if (hssfRow == null) {
continue;
}
// 将单元格中的内容存入集合
Account account = new Account();
Cell cell = hssfRow.getCell(0);
for (int i=0;i"'" + hssfRow.getCell(i).getStringCellValue() + "',";
}
try{
connection = jdbcUtils.getConnection();
pstmt = connection.prepareStatement(sql);
int j = pstmt.executeUpdate();
} catch (SQLException throwables) {
throwables.printStackTrace();
} finally {
jdbcUtils.close(connection,pstmt,rs);
}
}
}
return list;
}
}
```