Description
Book SynopsisJava 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.
Table of ContentsPreface 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
