Database Programming with JDBC and Java

Front Cover
"O'Reilly Media, Inc.", 2000 - Computers - 328 pages
5 Reviews
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 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 second edition also explains the relationship between JDBC and Enterprise JavaBeans. If you use Enterprise JavaBeans, JDBC can handle object persistence; if you choose not to use Enterprise JavaBeans, this book shows you how to achieve many of the same goals in your own code. 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 separate the various functions of the Java application and facilitate the growth and maintenance of your application. Patterns let you 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, suggestions for integrating JDBC with Swing using the model-view-controller model, and a deeper discussion about the architecture of a robust, maintainable database application. If you have a database at your site and have studied Java, this book will help you become a more effective application developer for Java database programs. It has been completely updated for JDBC 2.0, including full coverage of the JDBC 2.0 Optional Package (formerly known as the JDBC 2.0 Standard Extension). The book includes reference listings for both the JDBC Core (Java.sql) and the JDBC Optional Package (javax.sql) APIs.
 

What people are saying - Write a review

User ratings

5 stars
2
4 stars
0
3 stars
2
2 stars
1
1 star
0

Database Programming with JDBC and Java (Java S.)

User Review  - Not Available - Book Verdict

O'Reilly books are rarely for neophytes, but advanced users swear by them, and these will be no exception. Englander covers a hot Java subtopic for students, programmers, and professionals already ... Read full review

Selected pages

Contents

THE JDBC API
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
Relational Databases and SQL
15
An Introduction to SQL
19
Remote Method Invocation
108
Object Serialization
114
Enterprise JavaBeans
116
Distributed Application Architecture
126
Architecture
127
Design Patterns
137
The Banking Application
143
Distributed Component Models
146

A Note on SQL Versions
23
Introduction to 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
Advanced JDBC
57
Batch Processing
62
Updatable Result Sets
67
Advanced Datatypes
71
MetaData
79
The JDBC Optional Package
92
Connection Pooling
95
Rowsets
96
Distributed Transactions
99
APPLIED JDBC
103
Other Enterprise APIs
105
Kinds of Distributed Components
147
Security
156
Transactions
165
Lookups and Searches
170
Entity Relationships
172
Persistence
183
Mementos and Delegates
193
JDBC Persistence
195
Searches
197
The User Interface
207
Swing at a Glance
208
Models for Database Applications
210
Distributed Listeners
219
Worker Threads
221
REFERENCE
225
JDBC Reference
227
The JDBC Optional Package Reference
293
Index
317
Copyright

Other editions - View all

Common terms and phrases

References to this book

All Book Search results »

About the author (2000)

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 and the strategic role of technology in business processes. He is the author of Database Programming with JDBC and Java, 2nd Edition 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 a living as the National Practice Director of Technology Strategy for digital@jwt in Minneapolis.

Bibliographic information