From a2c792ee79e69224d71dc6204c6cc01f92b9384e Mon Sep 17 00:00:00 2001 From: manailin <261030956@qq.com> Date: 星期一, 23 八月 2021 16:14:46 +0800 Subject: [PATCH] [新增]整理代码规范 --- springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/listen/ComMngCarExcelListen.java | 24 +++++++++++------------- 1 files changed, 11 insertions(+), 13 deletions(-) diff --git a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/listen/ComMngCarExcelListen.java b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/listen/ComMngCarExcelListen.java index bb7e9a6..cb91119 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/listen/ComMngCarExcelListen.java +++ b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/listen/ComMngCarExcelListen.java @@ -1,17 +1,17 @@ package com.panzhihua.common.listen; +import java.util.ArrayList; +import java.util.List; + import com.alibaba.excel.context.AnalysisContext; import com.alibaba.excel.event.AnalysisEventListener; import com.alibaba.fastjson.JSONObject; import com.panzhihua.common.exceptions.ServiceException; import com.panzhihua.common.model.vos.R; -import com.panzhihua.common.model.vos.community.ComCvtServeExcelVO; import com.panzhihua.common.model.vos.community.ComMngCarExcelVO; import com.panzhihua.common.service.community.CommunityService; -import lombok.extern.slf4j.Slf4j; -import java.util.ArrayList; -import java.util.List; +import lombok.extern.slf4j.Slf4j; /** * @description: 车辆导入监听 @@ -21,29 +21,27 @@ @Slf4j public class ComMngCarExcelListen extends AnalysisEventListener<ComMngCarExcelVO> { + private static final int BATCH_COUNT = 100; private CommunityService communityService; - private Long communityId; + private List<ComMngCarExcelVO> list = new ArrayList<>(); - public ComMngCarExcelListen(CommunityService communityService, Long communityId){ + public ComMngCarExcelListen(CommunityService communityService, Long communityId) { this.communityService = communityService; this.communityId = communityId; } - - private static final int BATCH_COUNT = 100; - private List<ComMngCarExcelVO> list = new ArrayList<>(); @Override public void invoke(ComMngCarExcelVO comMngCarExcelVO, AnalysisContext analysisContext) { list.add(comMngCarExcelVO); // 达到BATCH_COUNT了,需要去存储一次数据库,防止数据几万条数据在内存,容易OOM - if(list.size() >= BATCH_COUNT){ + if (list.size() >= BATCH_COUNT) { log.info("excel导入数据【{}】", JSONObject.toJSONString(list)); - R r = this.communityService.listSaveMngCarExcelVO(list,this.communityId); + R r = this.communityService.listSaveMngCarExcelVO(list, this.communityId); if (!R.isOk(r)) { throw new ServiceException(r.getMsg()); } - list.clear(); //清空list + list.clear(); // 清空list } } @@ -51,7 +49,7 @@ @Override public void doAfterAllAnalysed(AnalysisContext analysisContext) { log.info("excel导入数据【{}】", JSONObject.toJSONString(list)); - R r = this.communityService.listSaveMngCarExcelVO(list,this.communityId);//确保最后遗留的数据保存在数据库中 + R r = this.communityService.listSaveMngCarExcelVO(list, this.communityId);// 确保最后遗留的数据保存在数据库中 if (!R.isOk(r)) { throw new ServiceException(r.getMsg()); } -- Gitblit v1.7.1