The Java JDBC API enables Java applications to connect to relational databases via a standard API, so your Java applications become independent (almost) of the database the application uses.
|Java application using JDBC to connect to a database.|
JDBC standardizes how to connect to a database, how to execute queries against it, how to navigate the result of such a query, and how to exeucte updates in the database. JDBC does not standardize the SQL sent to the database. This may still vary from database to database.
This JDBC tutorial covers the version of JDBC available in Java 6. The tutorial will not cover every single detail of the JDBC API, but focus on the most commonly used features. The rest you can read about in the JavaDoc's afterwards. Once you have a good understanding of JDBC, reading the last details in the JavaDoc or elsewhere, will not be so hard.
This JDBC tutorial only covers the JDBC API. It does not cover SQL, databases and database design rules etc. The reader should study these concepts elsewhere.
Work in Progress
This tutorial is very much "work in progress", so if you spot a missing JDBC class or interface, please be patient. I will add it when I get the time to do it.
Table of Contents
Here is a list of the topics covered in this JDBC trail. This list (menu) is also present at the top right of every page in the trail.
Feel Free to Contact Me
If you disagree with anything I write here about the JDBC tutorial, or just have comments, questions, etc, feel free to send me an email. You wouldn't be the first to do so. You can find my email address on the about page.