首页 开发技术 Java     /    java把excel表的数据导入到mysql数据库

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

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

文件下载

资源详情

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