一点逻辑：新增的insert，原来的update，还有的要delete

原创于 2019-06-26 17:30:09 发布 · 180 阅读

0 ·

CC 4.0 BY-SA版权

java 专栏收录该内容

14 篇文章

订阅专栏

本文详细介绍了如何在CRM系统中更新客户关注信息的策略。通过分析客户关注字段，将其拆分为新关注列表和旧关注列表，进而确定需要插入和删除的关注项。该过程涉及字符串操作、集合处理以及数据库操作，确保了客户关注信息的准确性和时效性。

        String focus=crmCustInfo.getFdFocus();
		if(StringUtils.isNotBlank(focus)) {			
			
			List<String> newList =  Arrays.asList(focus.split(","));
			List<String> oldList = crmCustConcernDao.listConcern(crmInfoId);
			List<String> insertList = new ArrayList<String>(newList);
			insertList.removeAll(oldList);
			List<String> delList = new ArrayList<String>(oldList);
			delList.removeAll(newList);
			if(!CollectionUtils.isEmpty(delList)) {
				crmCustConcernDao.delete(new EntityWrapper<CrmCustConcern>().in("FD_CONCERN", delList));	
			}
			List<CrmCustConcern> crmCustConcernList = new ArrayList<CrmCustConcern>();
			for(int i=0;i<insertList.size();i++) {
				CrmCustConcern entity = new CrmCustConcern();
				entity.setFdCustId(crmInfoId);
				entity.setFdConcern(insertList.get(i).trim());
				crmCustConcernList.add(entity);				
			}
			if(!CollectionUtils.isEmpty(crmCustConcernList)) {
				crmCustConcernService.insertBatch(crmCustConcernList);
			}
		}else {
			crmCustConcernDao.delete(new EntityWrapper<CrmCustConcern>().eq("FD_CUST_ID", crmInfoId));
		}