excel数据存储数据库到MySQL_Excel文件上传存储到数据库

@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 ;

}

}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值