java利用POI技术上传&导出Excel表格并保存数据至数据库

[{"title":"（52个子文件10.96MB）java利用POI技术上传&导出Excel表格并保存数据至数据库","children":[{"title":"poi-master","children":[{"title":".project <span style='color:#111;'>1.01KB</span>","children":null,"spread":false},{"title":"WebContent","children":[{"title":"WEB-INF","children":[{"title":"lib","children":[{"title":"dom4j-1.6.1.jar <span style='color:#111;'>306.54KB</span>","children":null,"spread":false},{"title":"poi-3.10.1-20140818.jar <span style='color:#111;'>1.86MB</span>","children":null,"spread":false},{"title":"poi-ooxml-3.10.1-20140818.jar <span style='color:#111;'>1011.15KB</span>","children":null,"spread":false},{"title":"poi-ooxml-schemas-3.10.1-20140818.jar <span style='color:#111;'>4.72MB</span>","children":null,"spread":false},{"title":"commons-codec-1.5.jar <span style='color:#111;'>71.38KB</span>","children":null,"spread":false},{"title":"xmlbeans-2.6.0.jar <span style='color:#111;'>2.60MB</span>","children":null,"spread":false},{"title":"junit-4.11.jar <span style='color:#111;'>239.30KB</span>","children":null,"spread":false},{"title":"poi-examples-3.10.1-20140818.jar <span style='color:#111;'>305.44KB</span>","children":null,"spread":false},{"title":"commons-logging-1.1.jar <span style='color:#111;'>51.67KB</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-scratchpad-3.10.1-20140818.jar <span style='color:#111;'>1.18MB</span>","children":null,"spread":false},{"title":"poi-excelant-3.10.1-20140818.jar <span style='color:#111;'>29.82KB</span>","children":null,"spread":false}],"spread":false},{"title":"web.xml <span style='color:#111;'>1.82KB</span>","children":null,"spread":false}],"spread":true},{"title":"index.jsp <span style='color:#111;'>1.54KB</span>","children":null,"spread":false},{"title":"images","children":[{"title":"book.png <span style='color:#111;'>3.35KB</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},{"title":"docs","children":[{"title":"template.xls <span style='color:#111;'>19.50KB</span>","children":null,"spread":false},{"title":"replaceTemplate.xls <span style='color:#111;'>6.50KB</span>","children":null,"spread":false},{"title":"testRead.xls <span style='color:#111;'>5.50KB</span>","children":null,"spread":false}],"spread":true},{"title":"read.jsp <span style='color:#111;'>934B</span>","children":null,"spread":false}],"spread":true},{"title":"src","children":[{"title":"util","children":[{"title":"EPlatform.java <span style='color:#111;'>635B</span>","children":null,"spread":false},{"title":"OSinfo.java <span style='color:#111;'>3.17KB</span>","children":null,"spread":false}],"spread":true},{"title":"test","children":[{"title":"ReadExcelServlet.java <span style='color:#111;'>7.24KB</span>","children":null,"spread":false},{"title":"ReadExcel.java <span style='color:#111;'>6.21KB</span>","children":null,"spread":false}],"spread":true},{"title":"template","children":[{"title":"TestTemplate.java <span style='color:#111;'>1.30KB</span>","children":null,"spread":false},{"title":"TemplateServlet.java <span style='color:#111;'>3.30KB</span>","children":null,"spread":false},{"title":"ExcelTemplate.java <span style='color:#111;'>7.98KB</span>","children":null,"spread":false}],"spread":true},{"title":"testExport","children":[{"title":"Excel2007Servlet.java <span style='color:#111;'>2.89KB</span>","children":null,"spread":false},{"title":"ExportExcel.java <span style='color:#111;'>11.20KB</span>","children":null,"spread":false},{"title":"ExcelServlet.java <span style='color:#111;'>2.17KB</span>","children":null,"spread":false},{"title":"TestExportExcel.java <span style='color:#111;'>11.01KB</span>","children":null,"spread":false},{"title":"TestExportExcel2007.java <span style='color:#111;'>1.05KB</span>","children":null,"spread":false},{"title":"Book.java <span style='color:#111;'>1.35KB</span>","children":null,"spread":false},{"title":"Student.java <span style='color:#111;'>957B</span>","children":null,"spread":false}],"spread":true},{"title":"replace","children":[{"title":"ExcelUtil.java <span style='color:#111;'>1.58KB</span>","children":null,"spread":false},{"title":"ExcelReplaceDataVO.java <span style='color:#111;'>675B</span>","children":null,"spread":false},{"title":"TestExcelReplace.java <span style='color:#111;'>1.18KB</span>","children":null,"spread":false},{"title":"ReplaceExcelServlet.java <span style='color:#111;'>2.86KB</span>","children":null,"spread":false}],"spread":true},{"title":"org","children":[{"title":"apache","children":[{"title":"poi","children":[{"title":"ss","children":[{"title":"examples","children":[{"title":"CalendarDemo.java <span style='color:#111;'>8.01KB</span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"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;'>345B</span>","children":null,"spread":false},{"title":"org.eclipse.jdt.core.prefs <span style='color:#111;'>364B</span>","children":null,"spread":false},{"title":"org.eclipse.wst.jsdt.ui.superType.name <span style='color:#111;'>6B</span>","children":null,"spread":false},{"title":"org.eclipse.wst.common.component <span style='color:#111;'>463B</span>","children":null,"spread":false},{"title":".jsdtscope <span style='color:#111;'>503B</span>","children":null,"spread":false}],"spread":true},{"title":"build","children":[{"title":"classes","children":[{"title":".gitignore <span style='color:#111;'>48B</span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"LICENSE.md <span style='color:#111;'>1.07KB</span>","children":null,"spread":false},{"title":"README.md <span style='color:#111;'>2.01KB</span>","children":null,"spread":false},{"title":".classpath <span style='color:#111;'>754B</span>","children":null,"spread":false},{"title":".gitignore <span style='color:#111;'>69B</span>","children":null,"spread":false}],"spread":true}],"spread":true}]