|Java JDBC Tutorial|
|JDBC Driver Types|
|JDBC Open Database Connection|
|JDBC Query the Database|
|JDBC Update the Database|
|JDBC Batch Updates|
Before you can read or write data in a database via JDBC, you need to open a connection to the database. This text will show you how to do that.
The first thing you need to do before you can open a database connection is to load the JDBC driver for the database. Actually, from Java 6 this is no longer necessary, but doing so will not fail. You load the JDBC driver like this:
Each JDBC driver has a primary driver class that initializes the driver when it is loaded. For instance, to load the H2Database driver, you write this:
You only have to load the driver once. You do not need to load it before every connection opened. Only before the first connection opened.
To open a database connection you use the
java.sql.DriverManager class. You call its
getConnection() method, like this:
String url = "jdbc:h2:~/test"; //database specific url. String user = "sa"; String password = ""; Connection connection = DriverManager.getConnection(url, user, password);
url is the url to your database. You should check the documentation for your database and
JDBC driver to see what the format is for your specific database. The url shown above is for
password parameters are the user name and password for your database.
Once you are done using the database connection you should close it. This is done by calling the Connection.close() method, like this: