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

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