From c00e3974050ff609fb34463d70292e768a786fea Mon Sep 17 00:00:00 2001 From: 疯狂的狮子li <15040126243@163.com> Date: 星期五, 26 十一月 2021 18:06:44 +0800 Subject: [PATCH] update 抽象 Excel 导入支持自定义监听器 --- ruoyi-demo/src/main/java/com/ruoyi/demo/controller/TestDemoController.java | 13 ++++++------- 1 files changed, 6 insertions(+), 7 deletions(-) diff --git a/ruoyi-demo/src/main/java/com/ruoyi/demo/controller/TestDemoController.java b/ruoyi-demo/src/main/java/com/ruoyi/demo/controller/TestDemoController.java index 695d254..a3b1c7f 100644 --- a/ruoyi-demo/src/main/java/com/ruoyi/demo/controller/TestDemoController.java +++ b/ruoyi-demo/src/main/java/com/ruoyi/demo/controller/TestDemoController.java @@ -5,14 +5,13 @@ import com.ruoyi.common.annotation.RepeatSubmit; import com.ruoyi.common.core.controller.BaseController; import com.ruoyi.common.core.domain.AjaxResult; -import com.ruoyi.common.core.domain.entity.SysUser; import com.ruoyi.common.core.page.TableDataInfo; import com.ruoyi.common.core.validate.AddGroup; import com.ruoyi.common.core.validate.EditGroup; import com.ruoyi.common.core.validate.QueryGroup; import com.ruoyi.common.enums.BusinessType; import com.ruoyi.common.utils.ValidatorUtils; -import com.ruoyi.common.utils.poi.ExcelResult; +import com.ruoyi.common.excel.ExcelResult; import com.ruoyi.common.utils.poi.ExcelUtil; import com.ruoyi.demo.domain.TestDemo; import com.ruoyi.demo.domain.bo.TestDemoBo; @@ -69,7 +68,7 @@ return iTestDemoService.customPageList(bo); } - @ApiOperation("瀵煎叆娴嬭瘯鍗曡〃") + @ApiOperation("瀵煎叆娴嬭瘯-鏍¢獙") @ApiImplicitParams({ @ApiImplicitParam(name = "file", value = "瀵煎叆鏂囦欢", dataType = "java.io.File", required = true), }) @@ -77,10 +76,10 @@ @PreAuthorize("@ss.hasPermi('demo:demo:import')") @PostMapping("/importData") public AjaxResult<Void> importData(@RequestPart("file") MultipartFile file) throws Exception { - ExcelResult<TestDemoImportVo> excelResult = ExcelUtil.importExcel(file.getInputStream(), TestDemoImportVo.class, true, true); - List<TestDemoImportVo> testDemoImportVoList = excelResult.getList(); - List<TestDemo> TestDemoList = BeanUtil.copyToList(testDemoImportVoList, TestDemo.class); - iTestDemoService.saveAll(TestDemoList); + ExcelResult<TestDemoImportVo> excelResult = ExcelUtil.importExcel(file.getInputStream(), TestDemoImportVo.class, true); + List<TestDemoImportVo> volist = excelResult.getList(); + List<TestDemo> list = BeanUtil.copyToList(volist, TestDemo.class); + iTestDemoService.saveAll(list); return AjaxResult.success(excelResult.getAnalysis()); } -- Gitblit v1.9.3