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}]