java把excel表的数据导入到mysql数据库

上传者: 38264372 | 上传时间: 2019-12-21 21:38:17 | 文件大小: 6.76MB | 文件类型: rar
用java把excel表的数据导入到数据库(可能有些类型还没考虑完全,抽空写的) 简单的思路 一、先获取数据库表的字段名、主键名, 二、读取excel文件的数据(注意:excel文件的数据表字段的顺序与该表的顺序一致,有空再做导出) 三、拼接sql

文件下载

资源详情

[{"title":"( 38 个子文件 6.76MB ) java把excel表的数据导入到mysql数据库","children":[{"title":"ExeclTool","children":[{"title":".project <span style='color:#111;'> 909B </span>","children":null,"spread":false},{"title":".settings","children":[{"title":".jsdtscope <span style='color:#111;'> 567B </span>","children":null,"spread":false},{"title":"org.eclipse.wst.common.component <span style='color:#111;'> 479B </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.common.project.facet.core.xml <span style='color:#111;'> 345B </span>","children":null,"spread":false},{"title":"org.eclipse.wst.jsdt.ui.superType.container <span style='color:#111;'> 49B </span>","children":null,"spread":false},{"title":"org.eclipse.wst.jsdt.ui.superType.name <span style='color:#111;'> 6B </span>","children":null,"spread":false}],"spread":true},{"title":"src","children":[{"title":"com","children":[{"title":"cn","children":[{"title":"wjq","children":[{"title":"dao","children":[{"title":"MysqlImpl.java <span style='color:#111;'> 3.44KB </span>","children":null,"spread":false}],"spread":true},{"title":"main","children":[{"title":"MyMain.java <span style='color:#111;'> 949B </span>","children":null,"spread":false}],"spread":true},{"title":"model","children":[{"title":"BeanInfo.java <span style='color:#111;'> 1.36KB </span>","children":null,"spread":false},{"title":"ClassType.java <span style='color:#111;'> 317B </span>","children":null,"spread":false},{"title":"ColumnInfo.java <span style='color:#111;'> 827B </span>","children":null,"spread":false}],"spread":true},{"title":"util","children":[{"title":"DBConnectUtil.java <span style='color:#111;'> 2.25KB </span>","children":null,"spread":false},{"title":"Generator.java <span style='color:#111;'> 13.79KB </span>","children":null,"spread":false},{"title":"ExcelInsertPiece.java <span style='color:#111;'> 5.48KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"config","children":[{"title":"props","children":[{"title":"db.properties <span style='color:#111;'> 166B </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"build","children":[{"title":"classes","children":[{"title":"com","children":[{"title":"cn","children":[{"title":"wjq","children":[{"title":"dao","children":[{"title":"MysqlImpl.class <span style='color:#111;'> 4.35KB </span>","children":null,"spread":false}],"spread":true},{"title":"main","children":[{"title":"MyMain.class <span style='color:#111;'> 1.93KB </span>","children":null,"spread":false}],"spread":true},{"title":"model","children":[{"title":"ClassType.class <span style='color:#111;'> 1.34KB </span>","children":null,"spread":false},{"title":"ColumnInfo.class <span style='color:#111;'> 1.24KB </span>","children":null,"spread":false},{"title":"BeanInfo.class <span style='color:#111;'> 2.25KB </span>","children":null,"spread":false}],"spread":true},{"title":"beam","children":[{"title":"ReadExcel.class <span style='color:#111;'> 3.84KB </span>","children":null,"spread":false},{"title":"JdbcUtil.class <span style='color:#111;'> 9.20KB </span>","children":null,"spread":false},{"title":"DatabaseUtil.class <span style='color:#111;'> 7.03KB </span>","children":null,"spread":false}],"spread":true},{"title":"util","children":[{"title":"DBConnectUtil.class <span style='color:#111;'> 2.80KB </span>","children":null,"spread":false},{"title":"Generator.class <span style='color:#111;'> 10.86KB </span>","children":null,"spread":false},{"title":"DatabaseUtil.class <span style='color:#111;'> 6.00KB </span>","children":null,"spread":false},{"title":"ExcelInsertPiece.class <span style='color:#111;'> 5.93KB </span>","children":null,"spread":false}],"spread":true},{"title":"demo","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"config","children":[{"title":"props","children":[{"title":"db.properties <span style='color:#111;'> 166B </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"WebContent","children":[{"title":"WEB-INF","children":[{"title":"lib","children":[{"title":"log4j-1.2.12.jar <span style='color:#111;'> 349.69KB </span>","children":null,"spread":false},{"title":"mysql-connector-java-5.1.41-bin.jar <span style='color:#111;'> 969.54KB </span>","children":null,"spread":false},{"title":"poi-ooxml-3.7-20101029.jar <span style='color:#111;'> 486.58KB </span>","children":null,"spread":false},{"title":"slf4j-log4j12.jar <span style='color:#111;'> 8.42KB </span>","children":null,"spread":false},{"title":"poi-3.9.jar <span style='color:#111;'> 1.78MB </span>","children":null,"spread":false},{"title":"slf4j-api-1.5.8.jar <span style='color:#111;'> 22.90KB </span>","children":null,"spread":false},{"title":"poi-ooxml-schemas-3.8.jar <span style='color:#111;'> 4.49MB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"META-INF","children":[{"title":"MANIFEST.MF <span style='color:#111;'> 39B </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":".classpath <span style='color:#111;'> 842B </span>","children":null,"spread":false}],"spread":true}],"spread":true}]

评论信息

  • baoyc :
    都是报错的 还少类少包
    2020-05-31
  • qq_16636163 :
    還沒試過行不行
    2019-04-23

免责申明

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