java将excel导入mysql数据库

import org.apache.poi.ss.usermodel.*;
import java.io.File;
import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class ExcelToMySQL {
    public static void main(String[] args) {
        String excelFilePath = "path/to/your/excel/file.xlsx";
        String jdbcUrl = "jdbc:mysql://localhost:3306/your_database";
        String username = "your_username";
        String password = "your_password";

        try (FileInputStream fis = new FileInputStream(new File(excelFilePath));
             Connection conn = DriverManager.getConnection(jdbcUrl, username, password)) {

            Workbook workbook = WorkbookFactory.create(fis);
            Sheet sheet = workbook.getSheetAt(0);

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

            for (Row row : sheet) {
                if (row.getRowNum() == 0) continue; // Skip header row

                Cell cell1 = row.getCell(0);
                Cell cell2 = row.getCell(1);
                Cell cell3 = row.getCell(2);

                pstmt.setString(1, cell1.getStringCellValue());
                pstmt.setString(2, cell2.getStringCellValue());
                pstmt.setDouble(3, cell3.getNumericCellValue());

                pstmt.executeUpdate();
            }

            System.out.println("Data imported successfully!");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}