springboot使用easypoi实现Excel的导出和导入到数据库mysql

1.引入easypoi依赖

  
            cn.afterturn
            easypoi-spring-boot-starter
            4.4.0
        

2.实体类 使用  @Excel(name = "") 标出需要导出的数据行头

    @Excel(name = "编号")
    private int id;
    @Excel(name = "校区名称")
    private String campusName;
    @Excel(name = "校区编码")
    private String campusCode;
    @Excel(name = "楼栋名称")
    private String buildingName;
    @Excel(name = "楼栋编码")
    private String buildingCode;

3.导出Controller

@Resource
    BuildRelaLockDao buildRelaLockDao;

    @GetMapping("haha")
    public void haha(HttpServletResponse response) {
        //查询出来的数据List
        List allBuildRelaLock = buildRelaLockDao.getAllBuildRelaLock();
        response.setHeader("content-Type", "application/vnd.ms-excel");
        // 下载文件的默认名称(设置下载文件的默认名称)
        response.setHeader("Content-Disposition", "attachment;filename=bull.xlsx");
        //导出操作
        Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams("门锁维护", "1"), BuildRelaLock.class, allBuildRelaLock);
        try {
            workbook.write(response.getOutputStream());
        } catch (IOException e) {
            e.printStackTrace();
        }

    }

4.Excel 导入到数据库

  
public void test(){
 importParams params = new importParams();
        params.setTitleRows(1); //行标题头
        params.setHeadRows(1);
            List list = ExcelimportUtil.importExcel(
                    file.getInputStream(),
                    BuildRelaLock.class, params);
           //打印list
            System.out.println(list);
           //下面执行数据库存储

}

以上代码稍做修改可直接CV使用