java连接JDK内置的derby数据库(以服务方式启动)

来源：互联网发布：java开发知识编辑：程序博客网时间：2024/05/22 15:15

1.以服务方式启动derby

运行下面java类执行脚本,或直接在命令行窗口执行脚本启动derby服务

public class ServerDerby {public static void main(String[] args) throws IOException {String cmd = "cmd /c start java -jar D:/work/installedSoftware/Java/jdk1.7.0_79/db/lib/derbyrun.jar server start";Runtime.getRuntime().exec(cmd);}}

2.在Eclipse等工具中导入驱动包

路径在安装的JDK下，示例: .../jdk1.7.0_79\db\lib\derbyclient.jar

3.连接derby测试

public class DerbyConn2 {public static void main(String[] args) throws Exception {String url = "jdbc:derby://localhost:1527/dbname;create=true;";String username = "test";String password = "test";Connection conn = DriverManager.getConnection(url,username,password);System.out.println(conn);}}

数据库不存在会自动创建，输出不为空则成功连接到derby

阅读全文

0 0