excel的jdbc驱动

上传者: u012454764 | 上传时间: 2021-09-27 13:32:51 | 文件大小: 1.48MB | 文件类型: ZIP
这是一个JAVA的jdbc驱动包,可以帮助你想操作数据库一样快速操作excel 示例代码: public static void main(String[] vars){ String driver = "com.hxtt.sql.excel.ExcelDriver"; String url = "jdbc:excel:///C:\\Users\\papio\\Desktop\\excel.xls"; try { Class.forName(driver).newInstance(); Connection con = DriverManager.getConnection(url); Statement stm = con.createStatement(); String sql = "select * from sheet"; for(int i=0;i<50;i++){ ResultSet rs = stm.executeQuery(sql); while (rs.next()){ System.out.println(rs.getString("NAME")); } System.out.println("第几次:"+i); } } catch (SQLException e) { e.printStackTrace(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (IllegalAccessException e) { e.printStackTrace(); } catch (InstantiationException e) { e.printStackTrace(); } }

文件下载

资源详情

[{"title":"( 43 个子文件 1.48MB ) excel的jdbc驱动","children":[{"title":"docs","children":[{"title":"json.html <span style='color:#111;'> 4.74KB </span>","children":null,"spread":false},{"title":"document.html <span style='color:#111;'> 9.05KB </span>","children":null,"spread":false},{"title":"advanced.html <span style='color:#111;'> 37.76KB </span>","children":null,"spread":false},{"title":"function.html <span style='color:#111;'> 68.29KB </span>","children":null,"spread":false},{"title":"transaction.html <span style='color:#111;'> 6.31KB </span>","children":null,"spread":false},{"title":"start.html <span style='color:#111;'> 8.20KB </span>","children":null,"spread":false},{"title":"resultset.html <span style='color:#111;'> 6.82KB </span>","children":null,"spread":false},{"title":"statement.html <span style='color:#111;'> 7.75KB </span>","children":null,"spread":false},{"title":"index.html <span style='color:#111;'> 2.85KB </span>","children":null,"spread":false},{"title":"sqlsyntax.html <span style='color:#111;'> 38.48KB </span>","children":null,"spread":false},{"title":"xml.html <span style='color:#111;'> 4.78KB </span>","children":null,"spread":false},{"title":"openapi.html <span style='color:#111;'> 18.18KB </span>","children":null,"spread":false},{"title":"array.html <span style='color:#111;'> 2.98KB </span>","children":null,"spread":false},{"title":"faq.html <span style='color:#111;'> 42.67KB </span>","children":null,"spread":false},{"title":"download.html <span style='color:#111;'> 3.51KB </span>","children":null,"spread":false},{"title":"introduction.html <span style='color:#111;'> 3.62KB </span>","children":null,"spread":false},{"title":"installation.html <span style='color:#111;'> 15.31KB </span>","children":null,"spread":false},{"title":"history.html <span style='color:#111;'> 15.52KB </span>","children":null,"spread":false},{"title":"components.html <span style='color:#111;'> 6.82KB </span>","children":null,"spread":false}],"spread":false},{"title":"META-INF","children":[{"title":"MANIFEST.MF <span style='color:#111;'> 69B </span>","children":null,"spread":false}],"spread":true},{"title":"lib","children":[{"title":"Excel_JDBC30.jar <span style='color:#111;'> 1.48MB </span>","children":null,"spread":false}],"spread":true},{"title":"demo","children":[{"title":"policy <span style='color:#111;'> 222B </span>","children":null,"spread":false},{"title":"testclient.bat <span style='color:#111;'> 405B </span>","children":null,"spread":false},{"title":"testApplet3.0.html <span style='color:#111;'> 1.46KB </span>","children":null,"spread":false},{"title":"server.bat <span style='color:#111;'> 505B </span>","children":null,"spread":false},{"title":"src","children":[{"title":"testPreparedStatement.java <span style='color:#111;'> 6.41KB </span>","children":null,"spread":false},{"title":"testApplet.java <span style='color:#111;'> 5.90KB </span>","children":null,"spread":false},{"title":"Example2.java <span style='color:#111;'> 1.15KB </span>","children":null,"spread":false},{"title":"testServlet.java <span style='color:#111;'> 12.60KB </span>","children":null,"spread":false},{"title":"Example1.java <span style='color:#111;'> 1.79KB </span>","children":null,"spread":false},{"title":"testSQL.java <span style='color:#111;'> 13.50KB </span>","children":null,"spread":false},{"title":"testResultSet.java <span style='color:#111;'> 2.65KB </span>","children":null,"spread":false}],"spread":true},{"title":"edit_action.cfm <span style='color:#111;'> 217B </span>","children":null,"spread":false},{"title":"classes","children":[{"title":"testPreparedStatement.class <span style='color:#111;'> 4.28KB </span>","children":null,"spread":false},{"title":"testResultSet.class <span style='color:#111;'> 2.87KB </span>","children":null,"spread":false},{"title":"testServlet.class <span style='color:#111;'> 10.45KB </span>","children":null,"spread":false},{"title":"testApplet.class <span style='color:#111;'> 5.06KB </span>","children":null,"spread":false},{"title":"Example2.class <span style='color:#111;'> 1.35KB </span>","children":null,"spread":false},{"title":"Example1.class <span style='color:#111;'> 1.90KB </span>","children":null,"spread":false},{"title":"testSQL.class <span style='color:#111;'> 5.12KB </span>","children":null,"spread":false}],"spread":true},{"title":"edit.cfm <span style='color:#111;'> 572B </span>","children":null,"spread":false},{"title":"test.bat <span style='color:#111;'> 382B </span>","children":null,"spread":false},{"title":"sql.txt <span style='color:#111;'> 779B </span>","children":null,"spread":false}],"spread":true}],"spread":true}]

评论信息

  • fxming70 :
    可以打开xls电子表格,但只能显示出表中的99条记录。不止什么原因?是版权限制吗?
    2019-09-04
  • s1289263571 :
    好贵呀...适用下怎么样
    2019-08-23

免责申明

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