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