Table of Contents

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

About the Author

George Reese has taken an unusual path into business software development. After earning a B.A. in philosophy from Bates College in Lewiston, Maine, George went off to Hollywood where he worked on television shows such as The People's Court and ESPN's Up Close. The L.A. riots convinced him to return to Maine where he finally became involved with software development and the Internet. George has since specialized in the development of Internet-oriented Java enterprise systems. He is the author of Database Programming with JDBC and Java and the world's first JDBC driver, the mSQL-JDBC driver for mSQL. He currently lives in Minneapolis, Minnesota with his wife Monique and three cats, Misty, Gypsy, and Tia. He makes his living as a senior architect for Imaginet, LLC.