JDBC Basics

Now that we have discussed what the JDBC is and some of its characteristics, let's start learning how to use it. In this section, we are going to discuss how to install and set up a Type 1 driver, make a connection to the database, and perform the basic SQL commands.

Installing and Setting Up a Type 1 Driver

In the JDBC examples throughout this book, we will be connecting to a Microsoft Access database using a Type 1 driver. To install the JDBC-ODBC Bridge, simply download the JDK and follow the installation directions. The JDBC-ODBC Bridge is included in version 1.1 and later.

The JDBC-ODBC Bridge requires no specific setup steps, but the ODBC driver does. For our examples, assume that you are using a PC and running Windows 9

Get Pure Java Server Pages™ now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.