excel的jdbc驱动
这是一个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
-
其他资源
- ubuntu+freeradius搭建EAP-TLS双向认证测试环境.docx
- ArcGIS_Editor_OSM_10_2Desktop（真实For10.2）
- opnet使用教程(详细)
- TreeView Control.unitypackage
- PrinterShare_11.19.1破解版
- 高手进阶，终极内存技术指南——完整/进阶版.pdf
- Unity通信，服务器端与客户端的互传消息
- 基于51单片机循迹、红外避障、遥控综合程序--PWM调速
- hp黑苹果efi文件
- NIOSII那些事儿源代码
- 0.96 OLED显示程序，只需要调用，就能显示
- mysql多字段删除重复数据保留id最大的.txt
- 串口精灵——串口通信工具，免安装
- Comparison of Chemometrics Method on K Detection in Soil Using Laser Induced Breakdown Spectroscopy
- visual c++ vc 时间控件的用法.zip
- 【077期】心理与教育学研究的基本流程.docx
- A-PDF Scan Optimizer 2.9.2
- 基于TE6410的WINCE系统的录入学生成绩程序（VS2005通过）
- 设计计算两个32位的无符号数的乘法的程序
- J-Link_V8 AT91-ISP V1.13.exe
- IEEE 1609.12协议（2016版）
- PLC考试复习试题填空题综合题解答题
- Web编程小实例 新手练习
免责申明
【只为小站】的资源来自网友分享，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论 【只为小站】 经营者是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二条之规定，若资源存在侵权或相关问题请联系本站客服人员，zhiweidada#qq.com，请把#换成@，本站将给予最大的支持与配合，做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明
本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二条之规定，若资源存在侵权或相关问题请联系本站客服人员，zhiweidada#qq.com，请把#换成@，本站将给予最大的支持与配合，做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明