JDBC is a very simple API in that 80% of what a database programmer does in writing a JDBC application is handled by a very small set of classes and methods. Unfortunately, database programming is not so simple. JDBC handles the complexities introduced in the other 20% of database programming tasks in a variety of interfaces not normally seen by database programmers. The focus of this tutorial is to expose database programmers to some of the less common interfaces and programming techniques so that they may build more efficient and robust database-driven applications.

What Attendees Will Learn:
Attendees will come away with a broader understanding of the JDBC and many of the hidden "gotchas" in database programming that basic database programming may not expose. The attendee will specifically learn how to use prepared SQL with JDBC, use the JDBC Optional Package, use JDBC as a tool for bean-managed EJB persistence, and make JDBC calls from a Swing application.

Prerequisites:
This course is aimed at Java programmers with some-but not necessarily extensive-Java database programming experience. Attendees should know what JDBC is and done some work with making connections and issuing SQL statements using the JDBC API.

Outline:

1. Review of the Basics
2. Prepared SQL Calls
3. The JDBC Optional Package
4. Connection Pooling without the Optional Package
5. Prepared Statement Pooling
6. Bean-managed EJB Persistence with JDBC
7. Swing and JDBC