Excel 自动录入数据库

最新推荐文章于 2023-01-02 13:35:59 发布

71z

最新推荐文章于 2023-01-02 13:35:59 发布

阅读量729

点赞数

文章标签： java

本文链接：https://blog.youkuaiyun.com/weixin_55936535/article/details/126460230

版权

Excel 自动录入数据库

kotlin写的，和java差不多

val file = File("C:\\Users\\Administrator\\Desktop\\问题级别3.xlsx")
        val fileInputStream = FileInputStream(file)
        val sheets = XSSFWorkbook(fileInputStream)
        val sheetAt = sheets.getSheetAt(0)

        // 第一行 默认标题 对应实体的属性
        val title = sheetAt.getRow(0)
        for (i in 1 until sheetAt.physicalNumberOfRows){
            val row = sheetAt.getRow(i)
            // 对应实体
            val zrbzs = Zrbzs()
            for (j in 0 until row.physicalNumberOfCells){
                val declaredFields = zrbzs.javaClass.declaredFields
                val titleCell = title.getCell(j)
                val cell = row.getCell(j)
                cell.cellType = CellType.STRING
                titleCell.cellType = CellType.STRING
                declaredFields.forEach { field ->
                    if (field.name == titleCell.stringCellValue){
                        field.isAccessible = true
                        field.set(zrbzs,cell.stringCellValue)
                    }
                }
            }
            zrbzsMapper.insert(zrbzs)
        }