jsp实现excel上传至数据库,以及 从数据库导出excel

上传者: lujiafeng07 | 上传时间: 2019-12-21 18:51:39 | 文件大小: 4.29MB | 文件类型: zip
本人亲自调测通过,可以使用 jsp 实现excel 数据上传至服务器 然后上传至数据库 另外实现了 数据库数据 导出至excel 功能 希望对初学者有帮助

文件下载

资源详情

[{"title":"( 77 个子文件 4.29MB ) jsp实现excel上传至数据库,以及 从数据库导出excel","children":[{"title":"xxgk","children":[{"title":".project <span style='color:#111;'> 1.71KB </span>","children":null,"spread":false},{"title":".mymetadata <span style='color:#111;'> 285B </span>","children":null,"spread":false},{"title":"src","children":[{"title":"com","children":[{"title":"zd","children":[{"title":"bean","children":[{"title":"sql","children":[{"title":"Condb.java <span style='color:#111;'> 1.10KB </span>","children":null,"spread":false},{"title":"ExcelUtil.java <span style='color:#111;'> 1.42KB </span>","children":null,"spread":false},{"title":"downTable.java <span style='color:#111;'> 509B </span>","children":null,"spread":false},{"title":"Deletedb.java <span style='color:#111;'> 913B </span>","children":null,"spread":false},{"title":"POITest.java <span style='color:#111;'> 3.80KB </span>","children":null,"spread":false},{"title":"JobsBean.java <span style='color:#111;'> 746B </span>","children":null,"spread":false},{"title":"config.properties <span style='color:#111;'> 149B </span>","children":null,"spread":false},{"title":"connectDB.java <span style='color:#111;'> 1.14KB </span>","children":null,"spread":false},{"title":"Config.java <span style='color:#111;'> 771B </span>","children":null,"spread":false},{"title":"ReadExcelTest.java <span style='color:#111;'> 4.06KB </span>","children":null,"spread":false},{"title":"userTable1.java <span style='color:#111;'> 807B </span>","children":null,"spread":false},{"title":"MySql2Excel.java <span style='color:#111;'> 2.12KB </span>","children":null,"spread":false},{"title":"JdbcBean.java <span style='color:#111;'> 1.96KB </span>","children":null,"spread":false},{"title":"Condbc.java <span style='color:#111;'> 1.63KB </span>","children":null,"spread":false},{"title":"downDB.java <span style='color:#111;'> 1.27KB </span>","children":null,"spread":false},{"title":"Conpro6.java <span style='color:#111;'> 907B </span>","children":null,"spread":false},{"title":"POITest1.java <span style='color:#111;'> 4.04KB </span>","children":null,"spread":false},{"title":"DBConnection.java <span style='color:#111;'> 1.14KB </span>","children":null,"spread":false},{"title":"userDB1.java <span style='color:#111;'> 1.38KB </span>","children":null,"spread":false}],"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"WebRoot","children":[{"title":"WEB-INF","children":[{"title":"classes","children":[{"title":"com","children":[{"title":"zd","children":[{"title":"bean","children":[{"title":"sql","children":[{"title":"Condb.class <span style='color:#111;'> 1.85KB </span>","children":null,"spread":false},{"title":"JdbcBean.class <span style='color:#111;'> 2.20KB </span>","children":null,"spread":false},{"title":"DBConnection.class <span style='color:#111;'> 1.58KB </span>","children":null,"spread":false},{"title":"config.properties <span style='color:#111;'> 149B </span>","children":null,"spread":false},{"title":"MySql2Excel.class <span style='color:#111;'> 3.09KB </span>","children":null,"spread":false},{"title":"downTable.class <span style='color:#111;'> 953B </span>","children":null,"spread":false},{"title":"userTable1.class <span style='color:#111;'> 1.32KB </span>","children":null,"spread":false},{"title":"ExcelUtil.class <span style='color:#111;'> 2.49KB </span>","children":null,"spread":false},{"title":"connectDB.class <span style='color:#111;'> 1.84KB </span>","children":null,"spread":false},{"title":"POITest.class <span style='color:#111;'> 4.42KB </span>","children":null,"spread":false},{"title":"Config.class <span style='color:#111;'> 1.34KB </span>","children":null,"spread":false},{"title":"Condbc.class <span style='color:#111;'> 2.19KB </span>","children":null,"spread":false},{"title":"userDB1.class <span style='color:#111;'> 2.34KB </span>","children":null,"spread":false},{"title":"downDB.class <span style='color:#111;'> 2.23KB </span>","children":null,"spread":false},{"title":"Conpro6.class <span style='color:#111;'> 1.72KB </span>","children":null,"spread":false},{"title":"ReadExcelTest.class <span style='color:#111;'> 4.27KB </span>","children":null,"spread":false},{"title":"POITest1.class <span style='color:#111;'> 4.40KB </span>","children":null,"spread":false},{"title":"JobsBean.class <span style='color:#111;'> 1.15KB </span>","children":null,"spread":false},{"title":"Deletedb.class <span style='color:#111;'> 1.73KB </span>","children":null,"spread":false}],"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"lib","children":[{"title":"poi-3.6-20091214.jar <span style='color:#111;'> 1.47MB </span>","children":null,"spread":false},{"title":"poi-scratchpad-3.6-20091214.jar <span style='color:#111;'> 777.23KB </span>","children":null,"spread":false},{"title":"ojdbc14----(oracle driver).jar <span style='color:#111;'> 1.47MB </span>","children":null,"spread":false},{"title":"commons-fileupload-1.2.1.jar <span style='color:#111;'> 56.42KB </span>","children":null,"spread":false},{"title":"poi-contrib-3.6-20091214.jar <span style='color:#111;'> 67.52KB </span>","children":null,"spread":false},{"title":"commons-io-1.4.jar <span style='color:#111;'> 106.49KB </span>","children":null,"spread":false},{"title":"jspupload.jar <span style='color:#111;'> 11.59KB </span>","children":null,"spread":false},{"title":"jxl.jar <span style='color:#111;'> 664.46KB </span>","children":null,"spread":false}],"spread":true},{"title":"web.xml <span style='color:#111;'> 404B </span>","children":null,"spread":false}],"spread":true},{"title":"do_upload1.jsp <span style='color:#111;'> 2.32KB </span>","children":null,"spread":false},{"title":"MyJsp.jsp <span style='color:#111;'> 903B </span>","children":null,"spread":false},{"title":"upload.jsp <span style='color:#111;'> 841B </span>","children":null,"spread":false},{"title":"downdeal.jsp <span style='color:#111;'> 876B </span>","children":null,"spread":false},{"title":"top_index.jsp <span style='color:#111;'> 1.67KB </span>","children":null,"spread":false},{"title":"error.jsp <span style='color:#111;'> 672B </span>","children":null,"spread":false},{"title":"index.jsp <span style='color:#111;'> 1.10KB </span>","children":null,"spread":false},{"title":"top_index1.jsp <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"downmsg.jsp <span style='color:#111;'> 2.27KB </span>","children":null,"spread":false},{"title":"success.jsp <span style='color:#111;'> 927B </span>","children":null,"spread":false},{"title":"main_index.jsp <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"MyJsp1.jsp <span style='color:#111;'> 1.04KB </span>","children":null,"spread":false},{"title":"exportexl_new.jsp <span style='color:#111;'> 2.30KB </span>","children":null,"spread":false},{"title":"user_deal.jsp <span style='color:#111;'> 1.06KB </span>","children":null,"spread":false},{"title":"left_index.jsp <span style='color:#111;'> 801B </span>","children":null,"spread":false},{"title":"META-INF","children":[{"title":"MANIFEST.MF <span style='color:#111;'> 36B </span>","children":null,"spread":false}],"spread":false},{"title":"user_list_j.jsp <span style='color:#111;'> 2.20KB </span>","children":null,"spread":false},{"title":"css","children":[{"title":"style.css <span style='color:#111;'> 2.54KB </span>","children":null,"spread":false}],"spread":false},{"title":"user_add.jsp <span style='color:#111;'> 3.45KB </span>","children":null,"spread":false},{"title":"download.jsp <span style='color:#111;'> 1.08KB </span>","children":null,"spread":false}],"spread":false},{"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;'> 252B </span>","children":null,"spread":false},{"title":"org.eclipse.jdt.core.prefs <span style='color:#111;'> 395B </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.core.resources.prefs <span style='color:#111;'> 113B </span>","children":null,"spread":false},{"title":"org.eclipse.wst.common.component <span style='color:#111;'> 450B </span>","children":null,"spread":false},{"title":".jsdtscope <span style='color:#111;'> 500B </span>","children":null,"spread":false}],"spread":true},{"title":".classpath <span style='color:#111;'> 791B </span>","children":null,"spread":false}],"spread":true}],"spread":true}]

评论信息

  • ssZuoZuo :
    这种方法不太好用
    2014-06-13
  • cwc1305206287 :
    移植到别的电脑上要改的地方很多,运行起来十分不便
    2014-05-29

免责申明

【只为小站】的资源来自网友分享,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论 【只为小站】 经营者是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二条之规定,若资源存在侵权或相关问题请联系本站客服人员,zhiweidada#qq.com,请把#换成@,本站将给予最大的支持与配合,做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明