@OverridepublicString excelUpload(String name, MultipartFile file, String docId){//处理EXCEL
ReadExcel readExcel = newReadExcel();//获得解析excel方法
List list =readExcel.getExcelInfo(name, file, docId);//第一行为标题
ArrayList titleList = new ArrayList();
Kypt_testData first= list.get(0);if(null!=first.getUc_1()&&!(("").equals(first.getUc_1()))){
titleList.add(first.getUc_1().toString()+"_"+1);
}if(null!=first.getUc_2()&&!(("").equals(first.getUc_2()))){
titleList.add(first.getUc_2().toString()+"_"+2);
}if(null!=first.getUc_3()&&!(("").equals(first.getUc_3()))){
titleList.add(first.getUc_3().toString()+"_"+3);
}if(null!=first.getUc_4()&&!(("").equals(first.getUc_4()))){
titleList.add(first.getUc_4().toString()+"_"+4);
}if(null!=first.getUc_5()&&!(("").equals(first.getUc_5()))){
titleList.add(first.getUc_5().toString()+"_"+5);
}if(null!=first.getUc_6()&&!(("").equals(first.getUc_6()))){
titleList.add(first.getUc_6().toString()+"_"+6);
}if(null!=first.getUc_7()&&!(("").equals(first.getUc_7()))){
titleList.add(first.getUc_7().toString()+"_"+7);
}if(null!=first.getUc_8()&&!(("").equals(first.getUc_8()))){
titleList.add(first.getUc_8().toString()+"_"+8);
}if(null!=first.getUc_9()&&!(("").equals(first.getUc_9()))){
titleList.add(first.getUc_9().toString()+"_"+9);
}if(null!=first.getUc_10()&&!(("").equals(first.getUc_10()))){
titleList.add(first.getUc_10().toString()+"_"+10);
}if(null!=first.getUc_11()&&!(("").equals(first.getUc_11()))){
titleList.add(first.getUc_11().toString()+"_"+11);
}if(null!=first.getUc_12()&&!(("").equals(first.getUc_12()))){
titleList.add(first.getUc_12().toString()+"_"+12);
}if(null!=first.getUc_13()&&!(("").equals(first.getUc_13()))){
titleList.add(first.getUc_13().toString()+"_"+13);
}if(null!=first.getUc_14()&&!(("").equals(first.getUc_14()))){
titleList.add(first.getUc_14().toString()+"_"+14);
}if(null!=first.getUc_15()&&!(("").equals(first.getUc_15()))){
titleList.add(first.getUc_15().toString()+"_"+15);
}if(null!=first.getUc_16()&&!(("").equals(first.getUc_16()))){
titleList.add(first.getUc_16().toString()+"_"+16);
}if(null!=first.getUc_17()&&!(("").equals(first.getUc_17()))){
titleList.add(first.getUc_17().toString()+"_"+17);
}if(null!=first.getUc_18()&&!(("").equals(first.getUc_18()))){
titleList.add(first.getUc_18().toString()+"_"+18);
}if(null!=first.getUc_19()&&!(("").equals(first.getUc_19()))){
titleList.add(first.getUc_19().toString()+"_"+19);
}if(null!=first.getUc_20()&&!(("").equals(first.getUc_20()))){
titleList.add(first.getUc_20().toString()+"_"+20);
}if(null!=first.getUc_21()&&!(("").equals(first.getUc_21()))){
titleList.add(first.getUc_21().toString()+"_"+21);
}if(null!=first.getUc_22()&&!(("").equals(first.getUc_22()))){
titleList.add(first.getUc_22().toString()+"_"+22);
}if(null!=first.getUc_23()&&!(("").equals(first.getUc_23()))){
titleList.add(first.getUc_23().toString()+"_"+23);
}if(null!=first.getUc_24()&&!(("").equals(first.getUc_24()))){
titleList.add(first.getUc_24().toString()+"_"+24);
}if(null!=first.getUc_25()&&!(("").equals(first.getUc_25()))){
titleList.add(first.getUc_25().toString()+"_"+25);
}if(null!=first.getUc_26()&&!(("").equals(first.getUc_26()))){
titleList.add(first.getUc_26().toString()+"_"+26);
}if(null!=first.getUc_27()&&!(("").equals(first.getUc_27()))){
titleList.add(first.getUc_27().toString()+"_"+27);
}if(null!=first.getUc_28()&&!(("").equals(first.getUc_28()))){
titleList.add(first.getUc_28().toString()+"_"+28);
}if(null!=first.getUc_29()&&!(("").equals(first.getUc_29()))){
titleList.add(first.getUc_29().toString()+"_"+29);
}if(null!=first.getUc_30()&&!(("").equals(first.getUc_30()))){
titleList.add(first.getUc_30().toString()+"_"+30);
}if(null!=first.getUc_31()&&!(("").equals(first.getUc_31()))){
titleList.add(first.getUc_31().toString()+"_"+31);
}if(null!=first.getUc_32()&&!(("").equals(first.getUc_32()))){
titleList.add(first.getUc_32().toString()+"_"+32);
}if(null!=first.getUc_33()&&!(("").equals(first.getUc_33()))){
titleList.add(first.getUc_33().toString()+"_"+33);
}if(null!=first.getUc_34()&&!(("").equals(first.getUc_34()))){
titleList.add(first.getUc_34().toString()+"_"+34);
}if(null!=first.getUc_35()&&!(("").equals(first.getUc_35()))){
titleList.add(first.getUc_35().toString()+"_"+35);
}if(null!=first.getUc_36()&&!(("").equals(first.getUc_36()))){
titleList.add(first.getUc_36().toString()+"_"+36);
}if(null!=first.getUc_37()&&!(("").equals(first.getUc_37()))){
titleList.add(first.getUc_37().toString()+"_"+37);
}if(null!=first.getUc_38()&&!(("").equals(first.getUc_38()))){
titleList.add(first.getUc_38().toString()+"_"+38);
}if(null!=first.getUc_39()&&!(("").equals(first.getUc_39()))){
titleList.add(first.getUc_39().toString()+"_"+39);
}if(null!=first.getUc_40()&&!(("").equals(first.getUc_40()))){
titleList.add(first.getUc_40().toString()+"_"+40);
}if(null!=first.getUc_41()&&!(("").equals(first.getUc_41()))){
titleList.add(first.getUc_41().toString()+"_"+41);
}if(null!=first.getUc_42()&&!(("").equals(first.getUc_42()))){
titleList.add(first.getUc_42().toString()+"_"+42);
}if(null!=first.getUc_43()&&!(("").equals(first.getUc_43()))){
titleList.add(first.getUc_43().toString()+"_"+43);
}if(null!=first.getUc_44()&&!(("").equals(first.getUc_44()))){
titleList.add(first.getUc_44().toString()+"_"+44);
}if(null!=first.getUc_45()&&!(("").equals(first.getUc_45()))){
titleList.add(first.getUc_45().toString()+"_"+45);
}if(null!=first.getUc_46()&&!(("").equals(first.getUc_46()))){
titleList.add(first.getUc_46().toString()+"_"+46);
}if(null!=first.getUc_47()&&!(("").equals(first.getUc_47()))){
titleList.add(first.getUc_47().toString()+"_"+47);
}if(null!=first.getUc_48()&&!(("").equals(first.getUc_48()))){
titleList.add(first.getUc_48().toString()+"_"+48);
}if(null!=first.getUc_49()&&!(("").equals(first.getUc_49()))){
titleList.add(first.getUc_49().toString()+"_"+49);
}if(null!=first.getUc_50()&&!(("").equals(first.getUc_50()))){
titleList.add(first.getUc_50().toString()+"_"+50);
}if(null!=first.getUc_51()&&!(("").equals(first.getUc_51()))){
titleList.add(first.getUc_51().toString()+"_"+51);
}if(null!=first.getUc_52()&&!(("").equals(first.getUc_52()))){
titleList.add(first.getUc_52().toString()+"_"+52);
}if(null!=first.getUc_53()&&!(("").equals(first.getUc_53()))){
titleList.add(first.getUc_53().toString()+"_"+53);
}if(null!=first.getUc_54()&&!(("").equals(first.getUc_54()))){
titleList.add(first.getUc_54().toString()+"_"+54);
}if(null!=first.getUc_55()&&!(("").equals(first.getUc_55()))){
titleList.add(first.getUc_55().toString()+"_"+55);
}if(null!=first.getUc_56()&&!(("").equals(first.getUc_56()))){
titleList.add(first.getUc_56().toString()+"_"+56);
}if(null!=first.getUc_57()&&!(("").equals(first.getUc_57()))){
titleList.add(first.getUc_57().toString()+"_"+57);
}if(null!=first.getUc_58()&&!(("").equals(first.getUc_58()))){
titleList.add(first.getUc_58().toString()+"_"+58);
}if(null!=first.getUc_59()&&!(("").equals(first.getUc_59()))){
titleList.add(first.getUc_59().toString()+"_"+59);
}if(null!=first.getUc_60()&&!(("").equals(first.getUc_60()))){
titleList.add(first.getUc_60().toString()+"_"+60);
}if(null!=first.getUc_61()&&!(("").equals(first.getUc_61()))){
titleList.add(first.getUc_61().toString()+"_"+61);
}if(null!=first.getUc_62()&&!(("").equals(first.getUc_62()))){
titleList.add(first.getUc_62().toString()+"_"+62);
}if(null!=first.getUc_63()&&!(("").equals(first.getUc_63()))){
titleList.add(first.getUc_63().toString()+"_"+63);
}if(null!=first.getUc_64()&&!(("").equals(first.getUc_64()))){
titleList.add(first.getUc_64().toString()+"_"+64);
}if(null!=first.getUc_65()&&!(("").equals(first.getUc_65()))){
titleList.add(first.getUc_65().toString()+"_"+65);
}if(null!=first.getUc_66()&&!(("").equals(first.getUc_66()))){
titleList.add(first.getUc_66().toString()+"_"+66);
}if(null!=first.getUc_67()&&!(("").equals(first.getUc_67()))){
titleList.add(first.getUc_67().toString()+"_"+67);
}if(null!=first.getUc_68()&&!(("").equals(first.getUc_68()))){
titleList.add(first.getUc_68().toString()+"_"+68);
}if(null!=first.getUc_69()&&!(("").equals(first.getUc_69()))){
titleList.add(first.getUc_69().toString()+"_"+69);
}if(null!=first.getUc_70()&&!(("").equals(first.getUc_70()))){
titleList.add(first.getUc_70().toString()+"_"+70);
}if(null!=first.getUc_71()&&!(("").equals(first.getUc_71()))){
titleList.add(first.getUc_71().toString()+"_"+71);
}if(null!=first.getUc_72()&&!(("").equals(first.getUc_72()))){
titleList.add(first.getUc_72().toString()+"_"+72);
}if(null!=first.getUc_73()&&!(("").equals(first.getUc_73()))){
titleList.add(first.getUc_73().toString()+"_"+73);
}if(null!=first.getUc_74()&&!(("").equals(first.getUc_74()))){
titleList.add(first.getUc_74().toString()+"_"+74);
}if(null!=first.getUc_75()&&!(("").equals(first.getUc_75()))){
titleList.add(first.getUc_75().toString()+"_"+75);
}if(null!=first.getUc_76()&&!(("").equals(first.getUc_76()))){
titleList.add(first.getUc_76().toString()+"_"+76);
}if(null!=first.getUc_77()&&!(("").equals(first.getUc_77()))){
titleList.add(first.getUc_77().toString()+"_"+77);
}if(null!=first.getUc_78()&&!(("").equals(first.getUc_78()))){
titleList.add(first.getUc_78().toString()+"_"+78);
}if(null!=first.getUc_79()&&!(("").equals(first.getUc_79()))){
titleList.add(first.getUc_79().toString()+"_"+79);
}if(null!=first.getUc_80()&&!(("").equals(first.getUc_80()))){
titleList.add(first.getUc_80().toString()+"_"+80);
}if(null!=first.getUc_81()&&!(("").equals(first.getUc_81()))){
titleList.add(first.getUc_81().toString()+"_"+81);
}if(null!=first.getUc_82()&&!(("").equals(first.getUc_82()))){
titleList.add(first.getUc_82().toString()+"_"+82);
}if(null!=first.getUc_83()&&!(("").equals(first.getUc_83()))){
titleList.add(first.getUc_83().toString()+"_"+83);
}if(null!=first.getUc_84()&&!(("").equals(first.getUc_84()))){
titleList.add(first.getUc_84().toString()+"_"+84);
}if(null!=first.getUc_85()&&!(("").equals(first.getUc_85()))){
titleList.add(first.getUc_85().toString()+"_"+85);
}if(null!=first.getUc_86()&&!(("").equals(first.getUc_86()))){
titleList.add(first.getUc_86().toString()+"_"+86);
}if(null!=first.getUc_87()&&!(("").equals(first.getUc_87()))){
titleList.add(first.getUc_87().toString()+"_"+87);
}if(null!=first.getUc_88()&&!(("").equals(first.getUc_88()))){
titleList.add(first.getUc_88().toString()+"_"+88);
}if(null!=first.getUc_89()&&!(("").equals(first.getUc_89()))){
titleList.add(first.getUc_89().toString()+"_"+89);
}if(null!=first.getUc_90()&&!(("").equals(first.getUc_90()))){
titleList.add(first.getUc_90().toString()+"_"+90);
}if(null!=first.getUc_91()&&!(("").equals(first.getUc_91()))){
titleList.add(first.getUc_91().toString()+"_"+91);
}if(null!=first.getUc_92()&&!(("").equals(first.getUc_92()))){
titleList.add(first.getUc_92().toString()+"_"+92);
}if(null!=first.getUc_93()&&!(("").equals(first.getUc_93()))){
titleList.add(first.getUc_93().toString()+"_"+93);
}if(null!=first.getUc_94()&&!(("").equals(first.getUc_94()))){
titleList.add(first.getUc_94().toString()+"_"+94);
}if(null!=first.getUc_95()&&!(("").equals(first.getUc_95()))){
titleList.add(first.getUc_95().toString()+"_"+95);
}if(null!=first.getUc_96()&&!(("").equals(first.getUc_96()))){
titleList.add(first.getUc_96().toString()+"_"+96);
}if(null!=first.getUc_97()&&!(("").equals(first.getUc_97()))){
titleList.add(first.getUc_97().toString()+"_"+97);
}if(null!=first.getUc_98()&&!(("").equals(first.getUc_98()))){
titleList.add(first.getUc_98().toString()+"_"+98);
}if(null!=first.getUc_99()&&!(("").equals(first.getUc_99()))){
titleList.add(first.getUc_99().toString()+"_"+99);
}if(null!=first.getUc_100()&&!(("").equals(first.getUc_100()))){
titleList.add(first.getUc_100().toString()+"_"+100);
}//for(String i : titleList){//System.out.println(i.toString());//}
Gson gson = newGson();
String titleJson=gson.toJson(titleList);//移除标题
list.remove(0);
ArrayList list2 = new ArrayList<>();for(Kypt_testData td : list){
list2.add(td);
}//执行新增操作,1000行执行1次插入
int score = 0; //记录影响行数
int count = 0; //计数,循环一次加1
int totalCount = 0; //记录执行插入的次数
List tempList = new ArrayList<>();//for (int i = 0; i <= list2.size(); i++) {
for (int i = 0; i < list2.size(); i++) {
count++;//将遍历到的元素添加到临时数组进行插入操作
tempList.add(list2.get(i));//1000行执行1次,后不足1000行的执行一次
if(i % 1000 == 0 && i != 0){
score+=daoMapper.add(tempList);
count= 0;
totalCount++;
tempList.clear();
System.out.println("第 " + totalCount + " 次插入,计 " + score + "行");
}else if ((list2.size() - (totalCount * 1000 + count)) < 1000 && i == list2.size() - 1) {
score+=daoMapper.add(tempList);
totalCount++;
System.out.println("最后一次插入是第 " + totalCount + " 次,计 " + score + "行");
}
}
System.out.println("score: " + score + "; excelTitle: "+titleJson );return score+";"+titleJson ;
}
}