java jdbc derby
来源:互联网 发布:网络支持中心网站域名 编辑:程序博客网 时间:2024/05/17 03:51
//package com.james.test;
import java.sql.*;
//import org.apache.derby.jdbc.*;
import java.util.Properties;
class DerbyTestDBClient{
public static void main(String[] args){
DerbyTestDBClient testClient = new DerbyTestDBClient();
testClient.showZipCodes();
}
public void showZipCodes()
{
String sql = "select * from zipcodes";
String driver = "org.apache.derby.jdbc.EmbeddedDriver";
//String url = "jdbc:derby://127.0.0.1:1527/DerbyTestDB";
//String url = "jdbc:derby:DerbyTestDB;create=true";
String url = "jdbc:derby:E:/database/db-derby-10.5.1.1-bin/bin/DerbyTestDB";//实际环境中的db位置
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try{
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
while(rs.next()){
System.out.println("City : " + rs.getString(1));
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e){
System.out.println("Exception: " + e);
e.printStackTrace();
}
}
}
- java jdbc derby
- java.lang.ClassNoFoundException:org.apache.derby.jdbc.ClientDriver
- java.sql.SQLException: No suitable driver found for jdbc:derby
- jdbc连接derby
- 调试经验-java.sql.SQLException: No suitable driver found for jdbc:derby:iDB
- Java使用Derby数据库
- CDH安装SQOOP错误:Caused by: java.sql.SQLException: No suitable driver found for jdbc:derby:/var/lib/sqoo
- derby
- Derby
- Derby
- derby
- Derby
- Derby
- Java如何MyEclipse Derby数据
- Java Database Derby Instance 1
- Java Database Derby Instance 2
- Apache Derby logo Java数据库服务器 Apache Derby
- 使用derby在auto ut中,No suitable driver found for jdbc:derby://localhost/...
- 摘要:不做这10件事,就把握99%的成功要素!
- 用oracle触发器实现出入库
- 摘录:《晨间日记的奇迹》
- CRM绩效管理优劣 四阶段指点出迷津
- 再次开始SmartClient
- java jdbc derby
- UNIX网络编程卷2进程间通信读书笔记(四)—XSI IPC
- 持久窗口与临时窗口
- 笛卡尔思考的步骤
- IT员工离不开的12项技术
- Intel 82801H(ICH8) HD Audio Controller 的驱动问题
- 压缩算法的历史
- spinlock与linux内核调度的关系
- 摘要:活力4大招,打造「不累」体质!