Database programming with JDBC and Java / George Reese.

Format:

Book

Author/Creator:

Reese, George, 1913-1998.

Series:

Java series (O'Reilly & Associates)

The Java series

Language:

English

Subjects (All):

Database design.

Java (Computer program language).

Physical Description:

xvii, 328 pages : illustrations ; 24 cm.

Edition:

Second edition.

Place of Publication:

Beijing ; Cambridge [Mass.] : O'Reilly, [2000]

Summary:

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). 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.

Contents:

I. The JDBC API 1

1. Java in the Enterprise 3

The Enterprise 4

Java as a Tool for Enterprise Development 6

The Database 9

Database Programming with Java 12

2. Relational Databases and SQL 15

What Is a Relational Database? 15

An Introduction to SQL 19

A Note on SQL Versions 23

3. Introduction to JDBC 25

What Is JDBC? 25

Connecting to the Database 34

Basic Database Access 39

SQL Datatypes and Java Datatypes 44

Scrollable Result Sets 46

The JDBC Support Classes 50

A Database Servlet 51

4. Advanced JDBC 57

Prepared SQL 57

Batch Processing 62

Updatable Result Sets 67

Advanced Datatypes 71

Meta-Data 79

5. The JDBC Optional Package 92

Data Sources 92

Connection Pooling 95

Rowsets 96

Distributed Transactions 98

II. Applied JDBC 103

6. Other Enterprise APIs 105

Java Naming and Directory Interface 105

Remote Method Invocation 108

Object Serialization 114

Enterprise JavaBeans 116

7. Distributed Application Architecture 126

Architecture 127

Design Patterns 137

The Banking Application 143

8. Distributed Component Models 146

Kinds of Distributed Components 147

Security 156

Transactions 165

Lookups and Searches 170

Entity Relationships 172

9. Persistence 183

Database Transactions 183

Mementos and Delegates 193

JDBC Persistence 195

Searches 197

10. The User Interface 207

Swing at a Glance 208

Models for Database Applications 210

Distributed Listeners 219

Worker Threads 221

11. JDBC Reference 227

12. The JDBC Optional Package Reference 293.

Notes:

Includes index.

ISBN:

1565926161

OCLC:

44681848