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.

Describes the 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. Section I focuses on the JDBC API, and Section II applies information in Section I to real- world database programming within the context of a banking application example. Section III is a reference for the JDBC Core and Optional Package APIs. This second edition is updated for JDBC 2.0.
Annotation c. Book News, Inc., Portland, OR (booknews.com)

Java "TM" and databases make a powerful combination. Getting the two sides to work together, however, takes some effort — largely because Java deals in objects while databases do not. JDBC is the Java API that allows Java to access relational databases without regard to which database software is used.

This book describes the standard Java interfaces that make portable object-oriented access to relational databases possible and gives readers a robust model for writing applications that are easy to maintain. The second edition, completely updated for JDBC 2.0, includes reference listings for JDBC and the most important RMI classes.

This text 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.

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.

This book describes the standard Java interfaces that make portableobject-oriented access to relational databases possible, and offers arobust model for writing applications that are easy to maintain. Itintroduces the JDBC and RMI packages and uses them to develop three-tierapplications (applications divided into a user interface, anobject-oriented logic component, and an information store). But the book's key contribution is a set of patterns that let developersisolate critical tasks like object creation, information storage andretrieval, and the committing or aborting of transactions.The second edition includes more basics of JDBC and SQL, with moreexamples, and a deeper discussion about the architecture of a robust, maintainable database application.

 
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