一个工具类搞定批量插入增加数据到Mysql数据库

[{"title":"（ 83 个子文件 13.18MB ） 一个工具类搞定批量插入增加数据到Mysql数据库","children":[{"title":"sql表结构","children":[{"title":"人员信息名单.xls <span style='color:#111;'> 20.50KB </span>","children":null,"spread":false},{"title":"bulkimport.sql <span style='color:#111;'> 5.42KB </span>","children":null,"spread":false}],"spread":true},{"title":"ssm_bulkimport","children":[{"title":"conf","children":[{"title":"ssm-servlet.xml <span style='color:#111;'> 2.54KB </span>","children":null,"spread":false},{"title":"SqlMapConfig.xml <span style='color:#111;'> 464B </span>","children":null,"spread":false},{"title":"db.properties <span style='color:#111;'> 154B </span>","children":null,"spread":false}],"spread":true},{"title":".project <span style='color:#111;'> 1.51KB </span>","children":null,"spread":false},{"title":"src","children":[{"title":"oaec","children":[{"title":"service","children":[{"title":"impl","children":[{"title":"UserServiceImpl.java <span style='color:#111;'> 473B </span>","children":null,"spread":false}],"spread":true},{"title":"UserService.java <span style='color:#111;'> 142B </span>","children":null,"spread":false}],"spread":true},{"title":"controller","children":[{"title":"UserController.java <span style='color:#111;'> 1.90KB </span>","children":null,"spread":false}],"spread":true},{"title":"mapper","children":[{"title":"UserMapper.java <span style='color:#111;'> 140B </span>","children":null,"spread":false},{"title":"UserMapper.xml <span style='color:#111;'> 457B </span>","children":null,"spread":false}],"spread":true},{"title":"util","children":[{"title":"BulkImportUtil.java <span style='color:#111;'> 4.14KB </span>","children":null,"spread":false}],"spread":true},{"title":"entity","children":[{"title":"User.java <span style='color:#111;'> 1.63KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"WebRoot","children":[{"title":"WEB-INF","children":[{"title":"classes","children":[{"title":"ssm-servlet.xml <span style='color:#111;'> 2.54KB </span>","children":null,"spread":false},{"title":"oaec","children":[{"title":"service","children":[{"title":"UserService.class <span style='color:#111;'> 206B </span>","children":null,"spread":false},{"title":"impl","children":[{"title":"UserServiceImpl.class <span style='color:#111;'> 802B </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"controller","children":[{"title":"UserController.class <span style='color:#111;'> 3.78KB </span>","children":null,"spread":false}],"spread":true},{"title":"mapper","children":[{"title":"UserMapper.class <span style='color:#111;'> 203B </span>","children":null,"spread":false},{"title":"UserMapper.xml <span style='color:#111;'> 457B </span>","children":null,"spread":false}],"spread":true},{"title":"util","children":[{"title":"BulkImportUtil.class <span style='color:#111;'> 4.83KB </span>","children":null,"spread":false}],"spread":true},{"title":"entity","children":[{"title":"User.class <span style='color:#111;'> 2.23KB </span>","children":null,"spread":false}],"spread":false}],"spread":true},{"title":"SqlMapConfig.xml <span style='color:#111;'> 464B </span>","children":null,"spread":false},{"title":"db.properties <span style='color:#111;'> 154B </span>","children":null,"spread":false}],"spread":true},{"title":"lib","children":[{"title":"javassist-3.17.1-GA.jar <span style='color:#111;'> 695.29KB </span>","children":null,"spread":false},{"title":"slf4j-api-1.7.5.jar <span style='color:#111;'> 25.47KB </span>","children":null,"spread":false},{"title":"spring-test-3.2.0.RELEASE.jar <span style='color:#111;'> 440.97KB </span>","children":null,"spread":false},{"title":"spring-context-support-3.2.0.RELEASE.jar <span style='color:#111;'> 124.11KB </span>","children":null,"spread":false},{"title":"commons-dbcp-1.2.2.jar <span style='color:#111;'> 118.90KB </span>","children":null,"spread":false},{"title":"json-lib-2.3-jdk15.jar <span style='color:#111;'> 148.28KB </span>","children":null,"spread":false},{"title":"commons-beanutils-1.5.jar <span style='color:#111;'> 108.09KB </span>","children":null,"spread":false},{"title":"json.jar <span style='color:#111;'> 45.17KB </span>","children":null,"spread":false},{"title":"mybatis-spring-1.2.2.jar <span style='color:#111;'> 47.64KB </span>","children":null,"spread":false},{"title":"spring-expression-3.2.0.RELEASE.jar <span style='color:#111;'> 189.25KB </span>","children":null,"spread":false},{"title":"commons-pool-1.3.jar <span style='color:#111;'> 60.63KB </span>","children":null,"spread":false},{"title":"ezmorph-1.0.6.jar <span style='color:#111;'> 84.46KB </span>","children":null,"spread":false},{"title":"spring-beans-3.2.0.RELEASE.jar <span style='color:#111;'> 590.57KB </span>","children":null,"spread":false},{"title":"spring-core-3.2.0.RELEASE.jar <span style='color:#111;'> 842.84KB </span>","children":null,"spread":false},{"title":"asm-3.3.1.jar <span style='color:#111;'> 42.56KB </span>","children":null,"spread":false},{"title":"jstl-1.2.jar <span style='color:#111;'> 404.53KB </span>","children":null,"spread":false},{"title":"log4j-api-2.0-rc1.jar <span style='color:#111;'> 113.49KB </span>","children":null,"spread":false},{"title":"spring-context-3.2.0.RELEASE.jar <span style='color:#111;'> 834.01KB </span>","children":null,"spread":false},{"title":"spring-orm-3.2.0.RELEASE.jar <span style='color:#111;'> 383.00KB </span>","children":null,"spread":false},{"title":"commons-logging-1.1.1.jar <span style='color:#111;'> 59.42KB </span>","children":null,"spread":false},{"title":"cglib-2.2.2.jar <span style='color:#111;'> 280.46KB </span>","children":null,"spread":false},{"title":"junit-4.9.jar <span style='color:#111;'> 243.16KB </span>","children":null,"spread":false},{"title":"log4j-core-2.0-rc1.jar <span style='color:#111;'> 686.20KB </span>","children":null,"spread":false},{"title":"log4j-1.2.17.jar <span style='color:#111;'> 478.40KB </span>","children":null,"spread":false},{"title":"spring-web-3.2.0.RELEASE.jar <span style='color:#111;'> 609.69KB </span>","children":null,"spread":false},{"title":"spring-webmvc-3.2.0.RELEASE.jar <span style='color:#111;'> 621.03KB </span>","children":null,"spread":false},{"title":"commons-collections-3.1.jar <span style='color:#111;'> 546.26KB </span>","children":null,"spread":false},{"title":"spring-aop-3.2.0.RELEASE.jar <span style='color:#111;'> 327.05KB </span>","children":null,"spread":false},{"title":"json-lib-2.4-jdk15.jar <span style='color:#111;'> 155.39KB </span>","children":null,"spread":false},{"title":"commons-io-1.3.2.jar <span style='color:#111;'> 85.72KB </span>","children":null,"spread":false},{"title":"commons-fileupload-1.2.1.jar <span style='color:#111;'> 56.42KB </span>","children":null,"spread":false},{"title":"aspectjweaver-1.6.11.jar <span style='color:#111;'> 1.61MB </span>","children":null,"spread":false},{"title":"aopalliance-1.0.jar <span style='color:#111;'> 4.36KB </span>","children":null,"spread":false},{"title":"mysql-connector-java-5.1.18-bin.jar <span style='color:#111;'> 771.37KB </span>","children":null,"spread":false},{"title":"spring-jdbc-3.2.0.RELEASE.jar <span style='color:#111;'> 391.55KB </span>","children":null,"spread":false},{"title":"spring-aspects-3.2.0.RELEASE.jar <span style='color:#111;'> 68.17KB </span>","children":null,"spread":false},{"title":"commons-lang-2.6.jar <span style='color:#111;'> 277.56KB </span>","children":null,"spread":false},{"title":"mysql-connector-java-5.1.7-bin.jar <span style='color:#111;'> 693.28KB </span>","children":null,"spread":false},{"title":"mybatis-3.2.7.jar <span style='color:#111;'> 696.03KB </span>","children":null,"spread":false},{"title":"spring-tx-3.2.0.RELEASE.jar <span style='color:#111;'> 235.30KB </span>","children":null,"spread":false},{"title":"slf4j-log4j12-1.7.5.jar <span style='color:#111;'> 8.66KB </span>","children":null,"spread":false},{"title":"jxl.jar <span style='color:#111;'> 708.73KB </span>","children":null,"spread":false}],"spread":false},{"title":"web.xml <span style='color:#111;'> 1.36KB </span>","children":null,"spread":false}],"spread":true},{"title":"excelimport.jsp <span style='color:#111;'> 1.89KB </span>","children":null,"spread":false},{"title":"js","children":[{"title":"ajaxfileupload.js <span style='color:#111;'> 7.22KB </span>","children":null,"spread":false},{"title":"jquery-2.1.1.js <span style='color:#111;'> 241.55KB </span>","children":null,"spread":false}],"spread":true},{"title":"META-INF","children":[{"title":"MANIFEST.MF <span style='color:#111;'> 39B </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":".settings","children":[{"title":"org.eclipse.wst.jsdt.ui.superType.container <span style='color:#111;'> 49B </span>","children":null,"spread":false},{"title":"org.eclipse.wst.common.project.facet.core.xml <span style='color:#111;'> 462B </span>","children":null,"spread":false},{"title":"org.eclipse.ltk.core.refactoring.prefs <span style='color:#111;'> 106B </span>","children":null,"spread":false},{"title":"org.eclipse.wst.ws.service.policy.prefs <span style='color:#111;'> 87B </span>","children":null,"spread":false},{"title":"com.genuitec.jboss.ide.eclipse.xdoclet.run.prefs <span style='color:#111;'> 89B </span>","children":null,"spread":false},{"title":"org.eclipse.jdt.core.prefs <span style='color:#111;'> 670B </span>","children":null,"spread":false},{"title":"org.eclipse.wst.jsdt.ui.superType.name <span style='color:#111;'> 6B </span>","children":null,"spread":false},{"title":"com.genuitec.eclipse.migration.prefs <span style='color:#111;'> 79B </span>","children":null,"spread":false},{"title":"org.eclipse.wst.common.project.facet.core.prefs.xml <span style='color:#111;'> 172B </span>","children":null,"spread":false},{"title":"org.eclipse.core.resources.prefs <span style='color:#111;'> 57B </span>","children":null,"spread":false},{"title":"org.eclipse.wst.common.component <span style='color:#111;'> 576B </span>","children":null,"spread":false},{"title":".jsdtscope <span style='color:#111;'> 522B </span>","children":null,"spread":false}],"spread":false},{"title":".classpath <span style='color:#111;'> 1.33KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}]