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

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");
主站蜘蛛池模板: 重庆市| 西贡区| 梅州市| 江陵县| 浪卡子县| 烟台市| 泽库县| 呼伦贝尔市| 正蓝旗| 呼伦贝尔市| 汤原县| 彩票| 东乡| 扎兰屯市| 衡山县| 新巴尔虎右旗| 利津县| 泸西县| 巴林右旗| 黔江区| 宁阳县| 长葛市| 南平市| 潍坊市| 昌平区| 集贤县| 平陆县| 广德县| 建阳市| 西乌珠穆沁旗| 宣威市| 老河口市| 南澳县| 大英县| 习水县| 延庆县| 冷水江市| 阿合奇县| 区。| 扶余县| 沾化县|