用java写一个excel导入数据库的方法

好的，以下是一个用Java写的Excel导入数据库的方法：

public void importExcelToDatabase(String filePath) {
    try {
        FileInputStream fileInputStream = new FileInputStream(filePath);
        Workbook workbook = new XSSFWorkbook(fileInputStream);
        Sheet sheet = workbook.getSheetAt(0);
        Iterator<Row> rowIterator = sheet.iterator();
        while (rowIterator.hasNext()) {
            Row row = rowIterator.next();
            Iterator<Cell> cellIterator = row.cellIterator();
            String name = cellIterator.next().getStringCellValue();
            int age = (int) cellIterator.next().getNumericCellValue();
            String address = cellIterator.next().getStringCellValue();
            // 将数据插入数据库
            // ...
        }
        workbook.close();
        fileInputStream.close();
    } catch (IOException e) {
        e.printStackTrace();
    }
}

希望这个方法能够帮到你！