Java页面导入Excel并存入数据库示例

public class ReadExcelimpl  {
    public void importExcel(InputStream inputStream, String userExcelFileName) {
        try {
            boolean is03Excel = userExcelFileName.matches("^.+\\.(?i)(xls)$");
            //1、读取工作簿
            Workbook workbook = is03Excel ? new HSSFWorkbook(inputStream) : new XSSFWorkbook(inputStream);
            //2、读取工作表
            Sheet sheet = workbook.getSheetAt(0);
            if (sheet.getPhysicalNumberOfRows() > 2) {
                ReadExcel readExcel = null;
                for (int k = 1; k < sheet.getPhysicalNumberOfRows()-1; k++) {
                    Row row = sheet.getRow(k);
                    readExcel = new ReadExcel();
                    Cell cell0 = row.getCell(0);
                    readExcel.setAoid(cell0.getStringCellValue());
                    Cell cell1 = row.getCell(1);
                    readExcel.setCid(cell1.getStringCellValue());
                    Cell cell2 = row.getCell(2);
                    //强制转换数值类型
                    cell2.setCellType(Cell.CELL_TYPE_STRING);
                    readExcel.setCname(cell2.getStringCellValue());
                    Cell cell3 = row.getCell(3);
                    cell3.setCellType(Cell.CELL_TYPE_STRING);
                    readExcel.setCount(cell3.getStringCellValue());
                    save(readExcel);
                }
            }
            workbook.close();
            inputStream.close();
        } catch (FileNotFoundException e) {