A JDBC Version of the Featured App

As we have seen in the previous sections, creating a JDBC interface to a database is fairly easy. The difficult parts involve setting up the database and installing the driver. Although we won't discuss the finer points of drivers or database administration, we will create the database as well as the interface to it.

Creating the Database

Once again, we will create the database and associated queries using Microsoft Access as shown in Figure 4-12. As before, our decision to use Access is due largely to its ubiquity and ease of use. We want you to be able to create interfaces to databases quickly and easily, and Microsoft Access provides a simple means to do so. As with all third-party products, if you require assistance with Access, contact Microsoft. In any event, if you have access to Sybase, Oracle, or another database, feel free to use it. You should not have to modify the code, but you will have to install a driver for the database you plan to use.