JDBC Introduction

Posted in: JDBC JDBC, the Java database−access technology, is probably the most widely known Java data−access API. Many books and Web sites exist to help educate you on its use. In addition, JDBC has wide industry support and you can find JDBC drivers for most databases on the market. Apart from JDBC, java also provide a wide set of technologies to interace with datastores and fulfill your data store needs. It provides numerous APIs that help you access the different types of data stores.



JDBC programming is very methodical. Ninety percent (90%) of JDBC applications use the same objects and methods regardless of what you want to accomplish. For example, you always load a driver, open a connection, submit an SQL statement, andexamine the results. The details of each step vary very little from task to task.
In this Tutorial, I guide you through building a simple JDBC application from start to finish. I start by discussing how to configure JDBC. Next, I identify the common components used in all JDBC applications, and then I present a sample application and cover the discrete steps involved in it. Lastly, We see how to compile and run a JDBCapplication.


Configuring JDBC:

JDBC is an API that encapsulates the low−level calls needed for database access and interaction into one common interface. JDBC mainly contains two things.

• JDBC API
• JDBC Driver

The JDBC API differs from a JDBC driver. The API defines the interfaces and methods vendors implement when writing a driver. If you examine the API source code you will find it consists mainly of interfaces. As a result, before you can write a JDBCapplication, you need to obtain and install a JDBC driver, which implements the interfaces