利用poi获取excel数据批量插入大量数据到mysql

[{"title":"（ 38 个子文件 29.83MB ） 利用poi获取excel数据批量插入大量数据到mysql","children":[{"title":"NewExcel2DB","children":[{"title":".project <span style='color:#111;'> 387B </span>","children":null,"spread":false},{"title":"src","children":[{"title":"com","children":[{"title":"b510","children":[{"title":"common","children":[{"title":"Common.java <span style='color:#111;'> 1.69KB </span>","children":null,"spread":false}],"spread":true},{"title":"client","children":[{"title":"Client.java <span style='color:#111;'> 665B </span>","children":null,"spread":false}],"spread":true},{"title":"excel","children":[{"title":"SaveData2DB.java <span style='color:#111;'> 1.60KB </span>","children":null,"spread":false},{"title":"ReadExcel.java <span style='color:#111;'> 5.92KB </span>","children":null,"spread":false},{"title":"util","children":[{"title":"DbUtil.java <span style='color:#111;'> 2.97KB </span>","children":null,"spread":false}],"spread":true},{"title":"vo","children":[{"title":"Report.java <span style='color:#111;'> 2.25KB </span>","children":null,"spread":false}],"spread":true},{"title":"ReadRefundOrChangeExcel.java <span style='color:#111;'> 4.13KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"yaoqi","children":[{"title":"test","children":[{"title":"Test.java <span style='color:#111;'> 3.54KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"lib","children":[{"title":"poi-examples-3.8-20120326.jar <span style='color:#111;'> 293.20KB </span>","children":null,"spread":false},{"title":"dom4j-1.6.1.jar <span style='color:#111;'> 306.54KB </span>","children":null,"spread":false},{"title":"poi-ooxml-schemas-3.8-20120326.jar <span style='color:#111;'> 4.49MB </span>","children":null,"spread":false},{"title":"mysql-connector-java-5.1.10-bin.jar <span style='color:#111;'> 707.25KB </span>","children":null,"spread":false},{"title":"poi-ooxml-3.8-20120326.jar <span style='color:#111;'> 911.14KB </span>","children":null,"spread":false},{"title":"poi-ooxml-3.7-20101029.jar <span style='color:#111;'> 486.58KB </span>","children":null,"spread":false},{"title":"xmlbeans-2.3.0.jar <span style='color:#111;'> 2.54MB </span>","children":null,"spread":false},{"title":"国际10月份退票报表.xlsx <span style='color:#111;'> 427.35KB </span>","children":null,"spread":false},{"title":"poi-ooxml-3.5-beta5.jar <span style='color:#111;'> 332.59KB </span>","children":null,"spread":false},{"title":"commons-logging-1.1.jar <span style='color:#111;'> 51.67KB </span>","children":null,"spread":false},{"title":"junit-3.8.1.jar <span style='color:#111;'> 118.23KB </span>","children":null,"spread":false},{"title":"poi-scratchpad-3.8-20120326.jar <span style='color:#111;'> 1.13MB </span>","children":null,"spread":false},{"title":"log4j-1.2.13.jar <span style='color:#111;'> 349.79KB </span>","children":null,"spread":false},{"title":"stax-api-1.0.1.jar <span style='color:#111;'> 25.89KB </span>","children":null,"spread":false},{"title":"poi-excelant-3.8-20120326.jar <span style='color:#111;'> 29.73KB </span>","children":null,"spread":false},{"title":"poi-3.11-20141221.jar <span style='color:#111;'> 1.98MB </span>","children":null,"spread":false}],"spread":false},{"title":".settings","children":[{"title":"org.eclipse.jdt.core.prefs <span style='color:#111;'> 629B </span>","children":null,"spread":false}],"spread":true},{"title":"excel","children":[{"title":"2015年10月份国际部淘宝销售报表汇总.xlsx <span style='color:#111;'> 640.63KB </span>","children":null,"spread":false},{"title":"2015年10月份国际部同程销售报表汇总.xlsx <span style='color:#111;'> 20.26KB </span>","children":null,"spread":false},{"title":"2015年10月份国际部去哪儿销售报表汇总.xlsx <span style='color:#111;'> 17.41MB </span>","children":null,"spread":false}],"spread":true},{"title":".classpath <span style='color:#111;'> 777B </span>","children":null,"spread":false},{"title":"bin","children":[{"title":"com","children":[{"title":"b510","children":[{"title":"common","children":[{"title":"Common.class <span style='color:#111;'> 1.34KB </span>","children":null,"spread":false}],"spread":true},{"title":"client","children":[{"title":"Client.class <span style='color:#111;'> 1.14KB </span>","children":null,"spread":false}],"spread":true},{"title":"excel","children":[{"title":"ReadExcel.class <span style='color:#111;'> 5.58KB </span>","children":null,"spread":false},{"title":"util","children":[{"title":"DbUtil.class <span style='color:#111;'> 4.15KB </span>","children":null,"spread":false}],"spread":true},{"title":"SaveData2DB.class <span style='color:#111;'> 2.77KB </span>","children":null,"spread":false},{"title":"ReadRefundOrChangeExcel.class <span style='color:#111;'> 4.33KB </span>","children":null,"spread":false},{"title":"vo","children":[{"title":"Report.class <span style='color:#111;'> 2.68KB </span>","children":null,"spread":false}],"spread":false}],"spread":true}],"spread":true},{"title":"yaoqi","children":[{"title":"test","children":[{"title":"Test.class <span style='color:#111;'> 4.40KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true}]