官术网_书友最值得收藏!

DriverManager Class

The DriverManager class is used to obtain a connection with a database. A JDBC driver is required to be loaded before obtaining a connection with the database. In JDBC 3.0, a JDBC driver can be loaded either by specifying it in the jdbc.drivers system property, or by using the Class.forName() method. We require invoking the Class.forName() method by loading the Oracle JDBC driver, oracle.jdbc.OracleDriver, using JDBC 3.0.

Class.forName("oracle.jdbc.OracleDriver");

In JDBC 4.0 specifications, the DriverManager class has added support to getConnection() and getDrivers() methods, for the Java SE (Service Provider) mechanism. By using these methods, JDBC drivers may be loaded automatically. The Class.forName() method is not required to be invoked. Loading drivers using the Java SE Service Provider mechanism will be discussed in the Automatic SQL Driver Loading section.

A JDBC connection is represented by a java.sql.Connection object, and may be obtained from a DriverManager by calling the overloaded static getConnection() methods. The getConnection() method is listed in following table:

For example, a connection with the Oracle database may be obtained as shown below:

String url="jdbc:oracle:thin:@localhost:1521:ORCL";
Connection connection = DriverManager.getConnection(url, "oe", "pw");
主站蜘蛛池模板: 利辛县| 赣榆县| 望城县| 文昌市| 邵东县| 南阳市| 镇赉县| 阳泉市| 佛山市| 卢湾区| 威海市| 桃园县| 盐亭县| 万全县| 娄底市| 黄龙县| 洪洞县| 大渡口区| 巴马| 汕尾市| 巍山| 枝江市| 临夏县| 高安市| 方城县| 五大连池市| 景洪市| 资阳市| 乐山市| 贺州市| 永昌县| 甘泉县| 万盛区| 察隅县| 个旧市| 金乡县| 黄山市| 获嘉县| 梅河口市| 成武县| 安塞县|