java处理导入Excel数据重复数据,整理后在导入
来源:互联网 发布:全民枪战刷头像软件 编辑:程序博客网 时间:2024/05/19 03:19
SysUser su = (SysUser) ContextUtil.getCurrentUser();
ModelAndView mv = new ModelAndView("hthrmis/htimport/importConfig.jsp");
UtilExcelFile uef=new UtilExcelFile();
List<ImportOrgPic> picllist=uef.readExcelPic(excelPicFile,su,request);
if(picllist.size()>5000){
return mv.addObject("viewOkSizeCount",picllist.size());
}
List<ImportOrgPic> newNoPics = new ArrayList<ImportOrgPic>();
List<ImportOrgPic> newPics = new ArrayList<ImportOrgPic>();
List<Long> orgIdslist = new ArrayList<Long>();
boolean contain;
for(int i = 0;i < picllist.size();i++){
contain = orgIdslist.contains(picllist.get(i).getOrgId());
if(contain == false){//封装数据
orgIdslist.add(picllist.get(i).getOrgId());
ImportOrgPic newU = new ImportOrgPic();//
newU.setOrgId(picllist.get(i).getOrgId());
newU.setOrgCode(picllist.get(i).getOrgCode());
newU.setOrgName(picllist.get(i).getOrgName());
newU.setOrgWholeName(picllist.get(i).getOrgWholeName());
newU.setPrincipalCode(picllist.get(i).getPrincipalCode());
newU.setPrincipalName(picllist.get(i).getPrincipalName());
newU.setInvYear(picllist.get(i).getInvYear());
newU.setOperation(picllist.get(i).getOperation());
newPics.add(newU);
}else{//
ImportOrgPic newU = new ImportOrgPic();//
newU.setOrgId(picllist.get(i).getOrgId());
newU.setOrgCode(picllist.get(i).getOrgCode());
newU.setOrgName(picllist.get(i).getOrgName());
newU.setOrgWholeName(picllist.get(i).getOrgWholeName());
newU.setPrincipalCode(picllist.get(i).getPrincipalCode());
newU.setPrincipalName(picllist.get(i).getPrincipalName());
newU.setInvYear(picllist.get(i).getInvYear());
newU.setOperation(picllist.get(i).getOperation());
newNoPics.add(newU);
}
}//数据清洗
List<ImportOrgPic> newNoOKPics = new ArrayList<ImportOrgPic>();
for(int k = 0; k < newNoPics.size();k++ ){
for(int p = 0; p < newPics.size();p++ ){
if(String.valueOf(newPics.get(p).getOrgId()).equals(String.valueOf(newNoPics.get(k).getOrgId()))){
ImportOrgPic newU = new ImportOrgPic();//id,newName,age
newU.setOrgId(newPics.get(p).getOrgId());
newU.setOrgName(newPics.get(p).getOrgName());
newU.setOrgCode(newPics.get(p).getOrgCode());
newU.setOrgWholeName(newPics.get(p).getOrgWholeName());
newU.setPrincipalCode(newPics.get(p).getPrincipalCode());
newU.setPrincipalName(newPics.get(p).getPrincipalName());
newU.setInvYear(newPics.get(p).getInvYear());
newU.setOperation(newPics.get(p).getOperation());
newNoOKPics.add(newU);
newPics.remove(p);
break;
}
}
}
newNoOKPics.addAll(newNoPics);//数据清洗后
OrgPiclList piclListOne=new OrgPiclList();
piclListOne.setUserId(su.getUserId());
piclListOne.setAccount(su.getAccount());
piclListOne.setOrgPiclist(newPics);
piclListOne.setNewNoOKPics(newNoOKPics);
piclListOne.setCreateEmpId(su.getUserId());
piclListOne.setCreateEmpCode(su.getAccount());
piclListOne.setModifyEmpCode(su.getAccount());
SystemInventoryDateView piclListOneDate=new SystemInventoryDateView();
piclListOneDate.setUserId(su.getUserId());
piclListOneDate.setAccount(su.getAccount());
piclListOneDate.setCreateEmpId(su.getUserId());
piclListOneDate.setCreateEmpCode(su.getAccount());
piclListOneDate.setModifyEmpCode(su.getAccount());
SystemInventoryDateView dateView = getIndexConfig(piclListOneDate);
Date currentDate = new Date();
String startDate="";
String strEndDate="";
String openSystemStatus="";
if(dateView!=null){
startDate=DateUtil.formatDate(dateView.getStartDate(), "yyyy-MM-dd");
strEndDate=DateUtil.formatDate(dateView.getEndDate(), "yyyy-MM-dd");
openSystemStatus=getSystemDate(currentDate, dateView.getStartDate(),dateView.getEndDate());
}
OrgPiclList picruturnlis=htimportServce.setSavePiclList(piclListOne);
String titleName="导入组织负责人";
String typeImpo="indexApic";
Integer addOkSize=0;//添加成功数据
Integer addErrorSize=0;//添加错数据
Integer updateOkSzie=0;//存在更新成功数据
Integer deleteOkSize=0;//删除
if(picruturnlis!=null){
if(picruturnlis.getAddErrorSize()!=null){
addErrorSize=picruturnlis.getAddErrorSize();
}
if(picruturnlis.getAddOkSize()!=null){
addOkSize=picruturnlis.getAddOkSize();
}
if(picruturnlis.getUpdateOkSzie()!=null){
updateOkSzie=picruturnlis.getUpdateOkSzie();
}
if(picruturnlis.getDeleteOkSize()!=null){
deleteOkSize=picruturnlis.getDeleteOkSize();
}
addOkSize=addOkSize+updateOkSzie;
}
String urlErrDow="hthrmis/htimport/htimportContro/exportExcelOrgPicErr.ht";
return mv.addObject("urlErrDow", urlErrDow).addObject("titleName", titleName).addObject("typeImpo", typeImpo).addObject("deleteOkSize", deleteOkSize).addObject("addOkSize",addOkSize).addObject("updateOkSzie",updateOkSzie).addObject("addErrorSize",addErrorSize).addObject("openSystemStatus", openSystemStatus).addObject("typeImpo", typeImpo).addObject("dateView", dateView).addObject("startDate", startDate).addObject("strEndDate", strEndDate);
ModelAndView mv = new ModelAndView("hthrmis/htimport/importConfig.jsp");
UtilExcelFile uef=new UtilExcelFile();
List<ImportOrgPic> picllist=uef.readExcelPic(excelPicFile,su,request);
if(picllist.size()>5000){
return mv.addObject("viewOkSizeCount",picllist.size());
}
List<ImportOrgPic> newNoPics = new ArrayList<ImportOrgPic>();
List<ImportOrgPic> newPics = new ArrayList<ImportOrgPic>();
List<Long> orgIdslist = new ArrayList<Long>();
boolean contain;
for(int i = 0;i < picllist.size();i++){
contain = orgIdslist.contains(picllist.get(i).getOrgId());
if(contain == false){//封装数据
orgIdslist.add(picllist.get(i).getOrgId());
ImportOrgPic newU = new ImportOrgPic();//
newU.setOrgId(picllist.get(i).getOrgId());
newU.setOrgCode(picllist.get(i).getOrgCode());
newU.setOrgName(picllist.get(i).getOrgName());
newU.setOrgWholeName(picllist.get(i).getOrgWholeName());
newU.setPrincipalCode(picllist.get(i).getPrincipalCode());
newU.setPrincipalName(picllist.get(i).getPrincipalName());
newU.setInvYear(picllist.get(i).getInvYear());
newU.setOperation(picllist.get(i).getOperation());
newPics.add(newU);
}else{//
ImportOrgPic newU = new ImportOrgPic();//
newU.setOrgId(picllist.get(i).getOrgId());
newU.setOrgCode(picllist.get(i).getOrgCode());
newU.setOrgName(picllist.get(i).getOrgName());
newU.setOrgWholeName(picllist.get(i).getOrgWholeName());
newU.setPrincipalCode(picllist.get(i).getPrincipalCode());
newU.setPrincipalName(picllist.get(i).getPrincipalName());
newU.setInvYear(picllist.get(i).getInvYear());
newU.setOperation(picllist.get(i).getOperation());
newNoPics.add(newU);
}
}//数据清洗
List<ImportOrgPic> newNoOKPics = new ArrayList<ImportOrgPic>();
for(int k = 0; k < newNoPics.size();k++ ){
for(int p = 0; p < newPics.size();p++ ){
if(String.valueOf(newPics.get(p).getOrgId()).equals(String.valueOf(newNoPics.get(k).getOrgId()))){
ImportOrgPic newU = new ImportOrgPic();//id,newName,age
newU.setOrgId(newPics.get(p).getOrgId());
newU.setOrgName(newPics.get(p).getOrgName());
newU.setOrgCode(newPics.get(p).getOrgCode());
newU.setOrgWholeName(newPics.get(p).getOrgWholeName());
newU.setPrincipalCode(newPics.get(p).getPrincipalCode());
newU.setPrincipalName(newPics.get(p).getPrincipalName());
newU.setInvYear(newPics.get(p).getInvYear());
newU.setOperation(newPics.get(p).getOperation());
newNoOKPics.add(newU);
newPics.remove(p);
break;
}
}
}
newNoOKPics.addAll(newNoPics);//数据清洗后
OrgPiclList piclListOne=new OrgPiclList();
piclListOne.setUserId(su.getUserId());
piclListOne.setAccount(su.getAccount());
piclListOne.setOrgPiclist(newPics);
piclListOne.setNewNoOKPics(newNoOKPics);
piclListOne.setCreateEmpId(su.getUserId());
piclListOne.setCreateEmpCode(su.getAccount());
piclListOne.setModifyEmpCode(su.getAccount());
SystemInventoryDateView piclListOneDate=new SystemInventoryDateView();
piclListOneDate.setUserId(su.getUserId());
piclListOneDate.setAccount(su.getAccount());
piclListOneDate.setCreateEmpId(su.getUserId());
piclListOneDate.setCreateEmpCode(su.getAccount());
piclListOneDate.setModifyEmpCode(su.getAccount());
SystemInventoryDateView dateView = getIndexConfig(piclListOneDate);
Date currentDate = new Date();
String startDate="";
String strEndDate="";
String openSystemStatus="";
if(dateView!=null){
startDate=DateUtil.formatDate(dateView.getStartDate(), "yyyy-MM-dd");
strEndDate=DateUtil.formatDate(dateView.getEndDate(), "yyyy-MM-dd");
openSystemStatus=getSystemDate(currentDate, dateView.getStartDate(),dateView.getEndDate());
}
OrgPiclList picruturnlis=htimportServce.setSavePiclList(piclListOne);
String titleName="导入组织负责人";
String typeImpo="indexApic";
Integer addOkSize=0;//添加成功数据
Integer addErrorSize=0;//添加错数据
Integer updateOkSzie=0;//存在更新成功数据
Integer deleteOkSize=0;//删除
if(picruturnlis!=null){
if(picruturnlis.getAddErrorSize()!=null){
addErrorSize=picruturnlis.getAddErrorSize();
}
if(picruturnlis.getAddOkSize()!=null){
addOkSize=picruturnlis.getAddOkSize();
}
if(picruturnlis.getUpdateOkSzie()!=null){
updateOkSzie=picruturnlis.getUpdateOkSzie();
}
if(picruturnlis.getDeleteOkSize()!=null){
deleteOkSize=picruturnlis.getDeleteOkSize();
}
addOkSize=addOkSize+updateOkSzie;
}
String urlErrDow="hthrmis/htimport/htimportContro/exportExcelOrgPicErr.ht";
return mv.addObject("urlErrDow", urlErrDow).addObject("titleName", titleName).addObject("typeImpo", typeImpo).addObject("deleteOkSize", deleteOkSize).addObject("addOkSize",addOkSize).addObject("updateOkSzie",updateOkSzie).addObject("addErrorSize",addErrorSize).addObject("openSystemStatus", openSystemStatus).addObject("typeImpo", typeImpo).addObject("dateView", dateView).addObject("startDate", startDate).addObject("strEndDate", strEndDate);
阅读全文
0 0
- java处理导入Excel数据重复数据,整理后在导入
- JAVA导入EXCEl处理数据简单教程
- Java数据导入Excel
- JAVA 数据导入Excel
- Java数据导入Excel
- Java数据导入Excel
- #.java数据导入Excel
- Java数据导入导出Excel
- Java中Excel导入数据
- JAVA EXCEL 数据 导入 ORACLE
- java EXCEL 数据 导入 Mysql
- Java 导入导出 excel数据
- Java数据导入导出excel
- java数据导入Excel中
- java excel表格数据导入
- Java导入Excel数据方法
- [***码农]当Excel数据慌乱数据 导入数据库后或转换数据的处理办法
- 利用java反射处理excel数据导入示例
- 【资讯】德勤在香港成立区块链实验室
- 使用MyEclipse开发Java EE应用:企业级应用程序项目(下)
- 《C++ Concurrency in Action》笔记 前言
- spark<java.nio.channels.ClosedChannelException>
- JDBC
- java处理导入Excel数据重复数据,整理后在导入
- Oracle 11g必须开启的服务及服务详细介绍,oracle的命令大全
- 构造函数
- 使用BottomNavigationView是activity无法启动问题
- 【国际】“风险极高”:英国金融监管机构发布ICO声明
- 【动态】保险巨头AXA利用以太坊区块链开发新的航空保险产品
- 【动态】金融机构需同金融科技创业公司加强合作
- 【行业】金融科技:美国发展最快的行业
- 【国际】俄罗斯央行发布加密货币和ICO警告