Mastering MySQL 4 [Electronic resources] نسخه متنی

General Methods

This section describes some sundry methods for connecting or for accessing configuration data from a file.

getBundle

bundle.getBundle(filename)

Loads data from a properties file called Config.properties. Although not JDBC specific, it would be used when storing connection data in a configuration file.

For example, Config.properties contains the following:

Driver = com.mysql.jdbc.Driver
Conn = jdbc:mysql://test.host.com/firstdb?user
=guru2b&password=g00r002b

The main program then contains the following:

ResourceBundle rb = ResourceBundle.getBundle("Conn");
String conn = rb.getString("Conn");
...
Class.forName(rb.getString("Driver"));
Connection = DriverManager.getConnection(conn);

getConnection

DriverManager.getConnection(connection_details)

Requests a connection with the specified details, returning a connection object. Depending on the driver you use, the connection details will be specified in slightly different ways. For the Caucho driver, the format is as follows:

jdbc:mysql-caucho://host_name[:port]/database_name

For example:

Connection connection = DriverManager.getConnection("jdbc:mysql-caucho://–
test.host.co.za/firstdb", "guru2b", "g00r002b");

The Connector/J driver uses a slightly different format, as follows:

jdbc:mysql://[host_name][:port]/database_name
[?property1=value1][&property=value2]

The properties can be any of the ones listed in Table F.1, although you'll mostly just use the password and username.

For example:

DriverManager.getConnection("jdbc:mysql://–
test.host.co.za/firstdb?user=guru2b&password=g00r002b");

getString

bundle.getString(string)

See getBundle for an example of reading data from a configuration file.