ex.zip_ex_huawei_javaexcelmysql_mysqlexcel资源-CSDN文库

共52个文件

jar：19个

class：9个

java：9个

版权申诉

huawei

99 浏览量 2022-09-24 01:43:51 上传评论收藏 7.88MB ZIP 举报

资源详情

资源评论

资源推荐

收起资源包目录

ex.zip （52个子文件）

bin

stu.xls 24KB

WEB-INF

web.xml 1KB

src

com

core

ExcelRead.java 3KB

DBManager.java 3KB

Config.java 2KB

test

Test.java 2KB

demo

UpdateExcel.java 3KB

demo.java 3KB

Test.java 697B

classes

com

core

DBManager.class 4KB

Config.class 2KB

ExcelRead.class 3KB

test

Test.class 2KB

demo

Test.class 1KB

demo.class 2KB

UpdateExcel.class 4KB

.cvsignore 7B

lib

oro-2.0.8.jar 64KB

sqljdbc.jar 570KB

standard-1.1.2.jar 384KB

commons-beanutils.jar 184KB

jstl-1.1.2.jar 20KB

jakarta-oro.jar 64KB

commons-validator.jar 82KB

commons-fileupload.jar 22KB

ojdbc14-10.2.0.4.0.jar 1.48MB

ojdbc14.jar 1.48MB

servlet-api.jar 91KB

mysql-connector-java-5.1.6-bin.jar 687KB

ognl-2.6.11.jar 164KB

commons-logging.jar 37KB

struts.jar 537KB

antlr.jar 350KB

commons-digester.jar 164KB

classes12.jar 1.07MB

jxl.jar 708KB

createTable.sql 247B

work

tldCache.ser 44B

org

apache

jsp

index_jsp.class 9KB

index_jsp.java 11KB

update_jsp.class 7KB

update_jsp.java 9KB

src

.tmp_update.jsp.53587~ 1KB

.project 445B

config.properties 121B

index.jsp 2KB

.tmp_index.jsp.37131~ 2KB

.cvsignore 4B

.classpath 2KB

update.jsp 1KB

.tomcatplugin 360B

jpg程序截图.rar 279KB

package org.apache.jsp; import javax.servlet.*; import javax.servlet.http.*; import javax.servlet.jsp.*; import java.util.*; public final class index_jsp extends org.apache.jasper.runtime.HttpJspBase implements org.apache.jasper.runtime.JspSourceDependent { private static java.util.List _jspx_dependants; private org.apache.jasper.runtime.TagHandlerPool _005fjspx_005ftagPool_005fc_005fforEach_0026_005fvar_005fitems; private org.apache.jasper.runtime.TagHandlerPool _005fjspx_005ftagPool_005fc_005fout_0026_005fvalue_005fnobody; public Object getDependants() { return _jspx_dependants; } public void _jspInit() { _005fjspx_005ftagPool_005fc_005fforEach_0026_005fvar_005fitems = org.apache.jasper.runtime.TagHandlerPool.getTagHandlerPool(getServletConfig()); _005fjspx_005ftagPool_005fc_005fout_0026_005fvalue_005fnobody = org.apache.jasper.runtime.TagHandlerPool.getTagHandlerPool(getServletConfig()); } public void _jspDestroy() { _005fjspx_005ftagPool_005fc_005fforEach_0026_005fvar_005fitems.release(); _005fjspx_005ftagPool_005fc_005fout_0026_005fvalue_005fnobody.release(); } public void _jspService(HttpServletRequest request, HttpServletResponse response) throws java.io.IOException, ServletException { JspFactory _jspxFactory = null; PageContext pageContext = null; HttpSession session = null; ServletContext application = null; ServletConfig config = null; JspWriter out = null; Object page = this; JspWriter _jspx_out = null; PageContext _jspx_page_context = null; try { _jspxFactory = JspFactory.getDefaultFactory(); response.setContentType("text/html;charset=GB2312"); pageContext = _jspxFactory.getPageContext(this, request, response, null, true, 8192, true); _jspx_page_context = pageContext; application = pageContext.getServletContext(); config = pageContext.getServletConfig(); session = pageContext.getSession(); out = pageContext.getOut(); _jspx_out = out; out.write("\r\n"); out.write("\r\n"); out.write("\r\n"); String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; out.write("\r\n"); out.write("\r\n"); out.write("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">\r\n"); out.write("<html>\r\n"); out.write(" <head>\r\n"); out.write(" <base href=\""); out.print(basePath); out.write("\">\r\n"); out.write(" \r\n"); out.write(" \r\n"); out.write(" <title>\r\n"); out.write(" \t数据库表记录查询\r\n"); out.write("\t\t<meta http-equiv=\"Content-Type\" content=\"text/html; charset=GB2312\">\r\n"); out.write("\t</title>\r\n"); out.write("\t<meta http-equiv=\"pragma\" content=\"no-cache\">\r\n"); out.write("\t<meta http-equiv=\"cache-control\" content=\"no-cache\">\r\n"); out.write("\t<meta http-equiv=\"expires\" content=\"0\"> \r\n"); out.write("\t<meta http-equiv=\"keywords\" content=\"keyword1,keyword2,keyword3\">\r\n"); out.write("\t<meta http-equiv=\"description\" content=\"This is my page\">\r\n"); out.write("\t\r\n"); out.write("\t<script type=\"text/javascript\">\r\n"); out.write("\t\tfunction check(){\r\n"); out.write("\t\t\t\r\n"); out.write("\t\t\tif(querform.table.value==\"\"){\r\n"); out.write("\t\t\t\talert(\"表名不能为空\");\r\n"); out.write("\t\t\t\treturn false;\r\n"); out.write("\t\t\t}\r\n"); out.write("\t\t\treturn true;\r\n"); out.write("\t\t}\r\n"); out.write("\t</script>\r\n"); out.write(" </head>\r\n"); out.write(" \r\n"); out.write(" <body>\r\n"); out.write(" <a href=\"update.jsp\">导入EXCEL表格</a>\r\n"); out.write(" <form action=\"demo\" method=\"post\" name=\"querform\" onsubmit=\"return check();\">\r\n"); out.write(" \t输入要查询的表名<input name=\"table\" type=\"text\" />\r\n"); out.write(" \t<input type=\"submit\"/>\r\n"); out.write(" </form>\r\n"); out.write(" \r\n"); out.write(" \r\n"); out.write("表数据如下<br>\r\n"); out.write("\r\n"); out.write(" <table border=\"1\">\r\n"); out.write(" "); if (_jspx_meth_c_005fforEach_005f0(_jspx_page_context)) return; out.write("\r\n"); out.write(" </table>\r\n"); out.write(" </body>\r\n"); out.write("</html>\r\n"); } catch (Throwable t) { if (!(t instanceof SkipPageException)){ out = _jspx_out; if (out != null && out.getBufferSize() != 0) out.clearBuffer(); if (_jspx_page_context != null) _jspx_page_context.handlePageException(t); } } finally { if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context); } } private boolean _jspx_meth_c_005fforEach_005f0(PageContext _jspx_page_context) throws Throwable { PageContext pageContext = _jspx_page_context; JspWriter out = _jspx_page_context.getOut(); // c:forEach org.apache.taglibs.standard.tag.rt.core.ForEachTag _jspx_th_c_005fforEach_005f0 = (org.apache.taglibs.standard.tag.rt.core.ForEachTag) _005fjspx_005ftagPool_005fc_005fforEach_0026_005fvar_005fitems.get(org.apache.taglibs.standard.tag.rt.core.ForEachTag.class); _jspx_th_c_005fforEach_005f0.setPageContext(_jspx_page_context); _jspx_th_c_005fforEach_005f0.setParent(null); _jspx_th_c_005fforEach_005f0.setVar("map"); _jspx_th_c_005fforEach_005f0.setItems((java.lang.Object) org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate("${list}", java.lang.Object.class, (PageContext)_jspx_page_context, null, false)); int[] _jspx_push_body_count_c_005fforEach_005f0 = new int[] { 0 }; try { int _jspx_eval_c_005fforEach_005f0 = _jspx_th_c_005fforEach_005f0.doStartTag(); if (_jspx_eval_c_005fforEach_005f0 != javax.servlet.jsp.tagext.Tag.SKIP_BODY) { do { out.write("\r\n"); out.write(" <tr>\r\n"); out.write(" "); if (_jspx_meth_c_005fforEach_005f1(_jspx_th_c_005fforEach_005f0, _jspx_page_context, _jspx_push_body_count_c_005fforEach_005f0)) return true; out.write("\r\n"); out.write(" </tr>\r\n"); out.write(" "); int evalDoAfterBody = _jspx_th_c_005fforEach_005f0.doAfterBody(); if (evalDoAfterBody != javax.servlet.jsp.tagext.BodyTag.EVAL_BODY_AGAIN) break; } while (true); } if (_jspx_th_c_005fforEach_005f0.doEndTag() == javax.servlet.jsp.tagext.Tag.SKIP_PAGE) { return true; } } catch (Throwable _jspx_exception) { while (_jspx_push_body_count_c_005fforEach_005f0[0]-- > 0) out = _jspx_page_context.popBody(); _jspx_th_c_005fforEach_005f0.doCatch(_jspx_exception); } finally { _jspx_th_c_005fforEach_005f0.doFinally(); _005fjspx_005ftagPool_005fc_005fforEach_0026_005fvar_005fitems.reuse(_jspx_th_c_005fforEach_005f0); } return false; } private boolean _jspx_meth_c_005fforEach_005f1(javax.servlet.jsp.tagext.JspTag _jspx_th_c_005fforEach_005f0, PageContext _jspx_page_context, int[] _jspx_push_body_count_c_005fforEach_005f0) throws Throwable { PageContext pageContext = _jspx_page_context; JspWriter out = _jspx_page_context.getOut(); // c:forEach org.apache.taglibs.standard.tag.rt.core.ForEachTag _jspx_th_c_005fforEach_005f1 = (org.apache.taglibs.standard.tag.rt.core.ForEachTag)