Database Programming with JDBC and Java

Java and databases make a powerful combination. Getting the two sides to
work together, however, takes some effort--largely because Java deals in
objects while most databases do not.

This book describes the standard Java interfaces that make portable
object-oriented access to relational databases possible and offers a
robust model for writing applications that are easy to maintain. It
introduces the JDBC and RMI packages and uses them to develop three-tier
applications (applications divided into a user interface, an object-
oriented logic component, and an information store).

The book begins with a quick overview of SQL for developers who may be
asked to handle a database for the first time. It then explains how to
issue database queries and updates through SQL and JDBC. It also covers
the use of stored procedures and other measures to improve efficiency,
where these are available.

But the book's key contribution is a set of patterns that let developers
isolate critical tasks like object creation, information storage and
retrieval, and the committing or aborting of transactions.

The second edition includes more basics of JDBC and SQL, with more
examples, and a deeper discussion about the architecture of a robust,
maintainable database application.
The second edition also explains the relationship between JDBC and
Enterprise JavaBeans.

Preface

I. The JDBC API

1. Java in the Enterprise
     The Enterprise
     Java as a Tool for Enterprise Development
     The Database
     Database Programming with Java

2. Relational Databases and SQL
     What Is a Relational Database?
     An Introduction to SQL
     A Note on SQL Versions

3. Introduction to JDBC
     What Is JDBC?
     Connecting to the Database
     Basic Database Access
     SQL Datatypes and Java Datatypes
     Scrollable Result Sets
     The JDBC Support Classes
     A Database Servlet

4. Advanced JDBC
     Prepared SQL
     Batch Processing
     Updatable Result Sets
     Advanced Datatypes
     Meta-Data

5. The JDBC Optional Package
     Data Sources
     Connection Pooling
     Rowsets
     Distributed Transactions

II. Applied JDBC

6. Other Enterprise APIs
     Java Naming and Directory Interface
     Remote Method Invocation
     Object Serialization
     Enterprise JavaBeans

7. Distributed Application Architecture
     Architecture
     Design Patterns
     The Banking Application

8. Distributed Component Models
     Kinds of Distributed Components
     Security
     Transactions
     Lookups and Searches
     Entity Relationships

9. Persistence
     Database Transactions
     Mementos and Delegates
     JDBC Persistence
     Searches

10. The User Interface
     Swing at a Glance
     Models for Database Applications
     Distributed Listeners
     Worker Threads

III. Reference

11. JDBC Reference

12. The JDBC Optional Package Reference

Index