jsp批量导入excel

<%@ page import="org.apache.poi.ss.usermodel.*, org.apache.poi.xssf.usermodel.XSSFWorkbook" %>
<%@ page import="java.io.*, java.sql.*" %>

<%
    String filePath = application.getRealPath("/excels/data.xlsx");
    FileInputStream file = new FileInputStream(new File(filePath));
    Workbook workbook = new XSSFWorkbook(file);
    Sheet sheet = workbook.getSheetAt(0);

    Connection conn = null;
    PreparedStatement pstmt = null;

    try {
        Class.forName("com.mysql.jdbc.Driver");
        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb", "username", "password");

        String sql = "INSERT INTO mytable (column1, column2) VALUES (?, ?)";
        pstmt = conn.prepareStatement(sql);

        for (Row row : sheet) {
            Cell cell1 = row.getCell(0);
            Cell cell2 = row.getCell(1);

            pstmt.setString(1, cell1.getStringCellValue());
            pstmt.setInt(2, (int) cell2.getNumericCellValue());

            pstmt.addBatch();
        }

        pstmt.executeBatch();
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        if (pstmt != null) pstmt.close();
        if (conn != null) conn.close();
        workbook.close();
        file.close();
    }
%>