poi解析jsp上传的excel文件并导入mysql（支持xls和xlsx）

[{"title":"（ 82 个子文件 20.31MB ） poi解析jsp上传的excel文件并导入mysql（支持xls和xlsx）","children":[{"title":"out","children":[{"title":"production","children":[{"title":"up","children":[{"title":"com","children":[{"title":"app","children":[{"title":"excel","children":[{"title":"ReadExcel.class <span style='color:#111;'> 3.62KB </span>","children":null,"spread":false},{"title":"Test.class <span style='color:#111;'> 1.28KB </span>","children":null,"spread":false}],"spread":true},{"title":"action","children":[{"title":"UpLoad.class <span style='color:#111;'> 6.53KB </span>","children":null,"spread":false}],"spread":true},{"title":"vo","children":[{"title":"UseBean.class <span style='color:#111;'> 322B </span>","children":null,"spread":false},{"title":"Student.class <span style='color:#111;'> 1.27KB </span>","children":null,"spread":false}],"spread":true},{"title":"common","children":[{"title":"Common.class <span style='color:#111;'> 1.02KB </span>","children":null,"spread":false}],"spread":true},{"title":"util","children":[{"title":"DbUtil.class <span style='color:#111;'> 3.84KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"artifacts","children":[{"title":"web_war_exploded","children":[{"title":"WEB-INF","children":[{"title":"web.xml <span style='color:#111;'> 805B </span>","children":null,"spread":false},{"title":"upload","children":[{"title":"10","children":[{"title":"7","children":[{"title":"bbea71b2-eb5e-49ba-9ff1-6854155fd34e_1.xlsx <span style='color:#111;'> 8.76KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"2","children":[{"title":"14","children":[{"title":"cd02870d-4a87-424c-a47b-8cff975ee4c5_1.xlsx <span style='color:#111;'> 8.76KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"temp","children":null,"spread":false},{"title":"lib","children":[{"title":"log4j-1.2.12.jar <span style='color:#111;'> 349.69KB </span>","children":null,"spread":false},{"title":"poi-3.6-20091214.jar <span style='color:#111;'> 1.47MB </span>","children":null,"spread":false},{"title":"commons-lang-2.4.jar <span style='color:#111;'> 255.67KB </span>","children":null,"spread":false},{"title":"mysql-connector-java-5.1.26-bin.jar <span style='color:#111;'> 835.89KB </span>","children":null,"spread":false},{"title":"commons-fileupload-1.3.2.jar <span style='color:#111;'> 68.63KB </span>","children":null,"spread":false},{"title":"ezmorph-1.0.6.jar <span style='color:#111;'> 84.46KB </span>","children":null,"spread":false},{"title":"xmlschema-core-2.1.0.jar <span style='color:#111;'> 161.90KB </span>","children":null,"spread":false},{"title":"poi-ooxml-schemas-3.6-20091214.jar <span style='color:#111;'> 3.60MB </span>","children":null,"spread":false},{"title":"commons-collections-3.1.jar <span style='color:#111;'> 546.26KB </span>","children":null,"spread":false},{"title":"poi-examples-3.6-20091214.jar <span style='color:#111;'> 177.64KB </span>","children":null,"spread":false},{"title":"dom4j-1.6.1.jar <span style='color:#111;'> 306.54KB </span>","children":null,"spread":false},{"title":"commons-logging-1.1.3.jar <span style='color:#111;'> 60.60KB </span>","children":null,"spread":false},{"title":"commons-io-2.2.jar <span style='color:#111;'> 169.52KB </span>","children":null,"spread":false},{"title":"slf4j-nop-1.7.25.jar <span style='color:#111;'> 3.91KB </span>","children":null,"spread":false},{"title":"json-lib-2.1-jdk15.jar <span style='color:#111;'> 122.00KB </span>","children":null,"spread":false},{"title":"slf4j-api-1.7.25.jar <span style='color:#111;'> 40.24KB </span>","children":null,"spread":false},{"title":"xmlbeans-2.6.0.jar <span style='color:#111;'> 2.60MB </span>","children":null,"spread":false},{"title":"commons-lang3-3.2.jar <span style='color:#111;'> 375.75KB </span>","children":null,"spread":false},{"title":"poi-ooxml-3.6-20091214.jar <span style='color:#111;'> 403.11KB </span>","children":null,"spread":false},{"title":"commons-beanutils-1.8.0.jar <span style='color:#111;'> 225.90KB </span>","children":null,"spread":false}],"spread":false},{"title":"classes","children":[{"title":"com","children":[{"title":"app","children":[{"title":"excel","children":[{"title":"ReadExcel.class <span style='color:#111;'> 3.62KB </span>","children":null,"spread":false},{"title":"Test.class <span style='color:#111;'> 1.28KB </span>","children":null,"spread":false}],"spread":true},{"title":"action","children":[{"title":"UpLoad.class <span style='color:#111;'> 6.53KB </span>","children":null,"spread":false}],"spread":true},{"title":"vo","children":[{"title":"UseBean.class <span style='color:#111;'> 322B </span>","children":null,"spread":false},{"title":"Student.class <span style='color:#111;'> 1.27KB </span>","children":null,"spread":false}],"spread":true},{"title":"common","children":[{"title":"Common.class <span style='color:#111;'> 1.02KB </span>","children":null,"spread":false}],"spread":false},{"title":"po","children":null,"spread":false},{"title":"util","children":[{"title":"DbUtil.class <span style='color:#111;'> 3.84KB </span>","children":null,"spread":false}],"spread":false}],"spread":true},{"title":"framework","children":[{"title":"common","children":[{"title":"filter","children":null,"spread":false},{"title":"util","children":null,"spread":false}],"spread":true},{"title":"ide","children":[{"title":"po","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"index.jsp <span style='color:#111;'> 559B </span>","children":null,"spread":false},{"title":"content.jsp <span style='color:#111;'> 1.67KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"src","children":[{"title":"com","children":[{"title":"app","children":[{"title":"excel","children":[{"title":"Test.java <span style='color:#111;'> 1.25KB </span>","children":null,"spread":false},{"title":"ReadExcel.java <span style='color:#111;'> 2.59KB </span>","children":null,"spread":false}],"spread":true},{"title":"action","children":[{"title":"UpLoad.java <span style='color:#111;'> 10.96KB </span>","children":null,"spread":false}],"spread":true},{"title":"vo","children":[{"title":"UseBean.java <span style='color:#111;'> 200B </span>","children":null,"spread":false},{"title":"Student.java <span style='color:#111;'> 1008B </span>","children":null,"spread":false}],"spread":true},{"title":"common","children":[{"title":"Common.java <span style='color:#111;'> 1.01KB </span>","children":null,"spread":false}],"spread":true},{"title":"util","children":[{"title":"DbUtil.java <span style='color:#111;'> 3.38KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"up.iml <span style='color:#111;'> 1.14KB </span>","children":null,"spread":false},{"title":"web","children":[{"title":"WEB-INF","children":[{"title":"web.xml <span style='color:#111;'> 805B </span>","children":null,"spread":false},{"title":"lib","children":[{"title":"log4j-1.2.12.jar <span style='color:#111;'> 349.69KB </span>","children":null,"spread":false},{"title":"poi-3.6-20091214.jar <span style='color:#111;'> 1.47MB </span>","children":null,"spread":false},{"title":"commons-lang-2.4.jar <span style='color:#111;'> 255.67KB </span>","children":null,"spread":false},{"title":"mysql-connector-java-5.1.26-bin.jar <span style='color:#111;'> 835.89KB </span>","children":null,"spread":false},{"title":"commons-fileupload-1.3.2.jar <span style='color:#111;'> 68.63KB </span>","children":null,"spread":false},{"title":"ezmorph-1.0.6.jar <span style='color:#111;'> 84.46KB </span>","children":null,"spread":false},{"title":"xmlschema-core-2.1.0.jar <span style='color:#111;'> 161.90KB </span>","children":null,"spread":false},{"title":"poi-ooxml-schemas-3.6-20091214.jar <span style='color:#111;'> 3.60MB </span>","children":null,"spread":false},{"title":"commons-collections-3.1.jar <span style='color:#111;'> 546.26KB </span>","children":null,"spread":false},{"title":"poi-examples-3.6-20091214.jar <span style='color:#111;'> 177.64KB </span>","children":null,"spread":false},{"title":"dom4j-1.6.1.jar <span style='color:#111;'> 306.54KB </span>","children":null,"spread":false},{"title":"commons-logging-1.1.3.jar <span style='color:#111;'> 60.60KB </span>","children":null,"spread":false},{"title":"commons-io-2.2.jar <span style='color:#111;'> 169.52KB </span>","children":null,"spread":false},{"title":"slf4j-nop-1.7.25.jar <span style='color:#111;'> 3.91KB </span>","children":null,"spread":false},{"title":"json-lib-2.1-jdk15.jar <span style='color:#111;'> 122.00KB </span>","children":null,"spread":false},{"title":"slf4j-api-1.7.25.jar <span style='color:#111;'> 40.24KB </span>","children":null,"spread":false},{"title":"xmlbeans-2.6.0.jar <span style='color:#111;'> 2.60MB </span>","children":null,"spread":false},{"title":"commons-lang3-3.2.jar <span style='color:#111;'> 375.75KB </span>","children":null,"spread":false},{"title":"poi-ooxml-3.6-20091214.jar <span style='color:#111;'> 403.11KB </span>","children":null,"spread":false},{"title":"commons-beanutils-1.8.0.jar <span style='color:#111;'> 225.90KB </span>","children":null,"spread":false}],"spread":false}],"spread":true},{"title":"index.jsp <span style='color:#111;'> 559B </span>","children":null,"spread":false},{"title":"content.jsp <span style='color:#111;'> 1.53KB </span>","children":null,"spread":false}],"spread":true},{"title":".idea","children":[{"title":"uiDesigner.xml <span style='color:#111;'> 8.59KB </span>","children":null,"spread":false},{"title":"libraries","children":[{"title":"xmlbeans_2_6_0.xml <span style='color:#111;'> 244B </span>","children":null,"spread":false},{"title":"commons_beanutils_1_8_0.xml <span style='color:#111;'> 1.75KB </span>","children":null,"spread":false},{"title":"slf4j_nop_1_7_25.xml <span style='color:#111;'> 335B </span>","children":null,"spread":false}],"spread":true},{"title":"workspace.xml <span style='color:#111;'> 36.72KB </span>","children":null,"spread":false},{"title":"misc.xml <span style='color:#111;'> 5.78KB </span>","children":null,"spread":false},{"title":"project-template.xml <span style='color:#111;'> 231B </span>","children":null,"spread":false},{"title":"modules.xml <span style='color:#111;'> 263B </span>","children":null,"spread":false},{"title":"artifacts","children":[{"title":"web_war_exploded.xml <span style='color:#111;'> 491B </span>","children":null,"spread":false}],"spread":true},{"title":"scopes","children":[{"title":"scope_settings.xml <span style='color:#111;'> 143B </span>","children":null,"spread":false}],"spread":true},{"title":"description.html <span style='color:#111;'> 36B </span>","children":null,"spread":false},{"title":"copyright","children":[{"title":"profiles_settings.xml <span style='color:#111;'> 115B </span>","children":null,"spread":false}],"spread":false},{"title":"inspectionProfiles","children":null,"spread":false}],"spread":false}],"spread":true}]