QED数据库使用笔记之Developing With QED

 

Connecting to a database

In order to access a database, you need to obtain a JDBC Connection object. There are two basic ways to get a database connection:

Using the JDBC DriverManager interface, you can directly obtain a JDBC Connection, if you know:

• The name of the JDBC Driver class (com.quadcap.jdbc.JdbcDriver)
• The database URL (jdbc:qed:database-name)
• Any connection parameters (see below)

For QED, you could obtain a database connection using code similar to the following:

//获得驱动,建立连接
Class.forName("com.quadcap.jdbc.JdbcDriver");java.sql.Connection conn =     java.sql.DriverManager.getConnection("jdbc:qed:mydb");//mydb是要连接的数据库名称

or, to create a new database:

//创建一个新的数据库
Class.forName("com.quadcap.jdbc.JdbcDriver");java.util.Properties p = new java.util.Properties();p.setProperty("create", "true");java.sql.Connection conn =     java.sql.DriverManager.getConnection("jdbc:qed:mynewdb", p);

another way to create a new database:

//另外一种创建数据库的方法
Class.forName("com.quadcap.jdbc.JdbcDriver");java.sql.Connection conn =     java.sql.DriverManager.getConnection("jdbc:qed:mynewdb;create=true");