Database Programming With Jdbc & Java: Developing Multi-tier Applications by George ReeseDatabase Programming With Jdbc & Java: Developing Multi-tier Applications by George Reese

Database Programming With Jdbc & Java: Developing Multi-tier Applications

byGeorge Reese

Paperback | September 3, 2000

Pricing and Purchase Info

$52.63

Earn 263 plum® points

Prices and offers may vary in store

Quantity:

In stock online

Ships free on orders over $25

Not available in stores

about

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.

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...
Loading
Title:Database Programming With Jdbc & Java: Developing Multi-tier ApplicationsFormat:PaperbackProduct dimensions:350 pages, 9.19 × 7 × 0.85 inShipping dimensions:9.19 × 7 × 0.85 inPublished:September 3, 2000Publisher:O'Reilly MediaLanguage:English

The following ISBNs are associated with this title:

ISBN - 10:1565926161

ISBN - 13:9781565926165

Reviews

Table of Contents

Preface; Audience; Using This Book; Software and Versions; Conventions Used in This Book; Comments and Questions; About the Philosophers; Acknowledgments; Feedback for the Author; The JDBC API; Chapter 1: Java in the Enterprise; 1.1 The Enterprise; 1.2 Java as a Tool for Enterprise Development; 1.3 The Database; 1.4 Database Programming with Java; Chapter 2: Relational Databases and SQL; 2.1 What Is a Relational Database?; 2.2 An Introduction to SQL; 2.3 A Note on SQL Versions; Chapter 3: Introduction to JDBC; 3.1 What Is JDBC?; 3.2 Connecting to the Database; 3.3 Basic Database Access; 3.4 SQL Datatypes and Java Datatypes; 3.5 Scrollable Result Sets; 3.6 The JDBC Support Classes; 3.7 A Database Servlet; Chapter 4: Advanced JDBC; 4.1 Prepared SQL; 4.2 Batch Processing; 4.3 Updatable Result Sets; 4.4 Advanced Datatypes; 4.5 Meta-Data; Chapter 5: The JDBC Optional Package; 5.1 Data Sources; 5.2 Connection Pooling; 5.3 Rowsets; 5.4 Distributed Transactions; Applied JDBC; Chapter 6: Other Enterprise APIs; 6.1 Java Naming and Directory Interface; 6.2 Remote Method Invocation; 6.3 Object Serialization; 6.4 Enterprise JavaBeans; Chapter 7: Distributed Application Architecture; 7.1 Architecture; 7.2 Design Patterns; 7.3 The Banking Application; Chapter 8: Distributed Component Models; 8.1 Kinds of Distributed Components; 8.2 Security; 8.3 Transactions; 8.4 Lookups and Searches; 8.5 Entity Relationships; Chapter 9: Persistence; 9.1 Database Transactions; 9.2 Mementos and Delegates; 9.3 JDBC Persistence; 9.4 Searches; Chapter 10: The User Interface; 10.1 Swing at a Glance; 10.2 Models for Database Applications; 10.3 Distributed Listeners; 10.4 Worker Threads; Reference; Chapter 11: JDBC Reference; 11.1 Reference; Chapter 12: The JDBC Optional Package Reference; 12.1 Reference; Colophon;

From Our Editors

Providing a comprehensive primer to the combined use of Java and databases, Database Programming with JDBC and Java: 2nd Edition offers an overview of SQL, while explaining how to issue database queries and updates through SQL and JDBC. In addition, this volume covers the use of stored procedures and other measures to improve efficiency and describes the standard Java interfaces that make portable object-oriented access to relational databases possible. Readers are given an introduction to JDBC and RMI, with instruction on using them in three-tier applications. Developers will learn how to isolate critical tasks like object creation, information storage and retrieval and the committing or aborting of transactions.