JDBC(TM) API Tutorial and Reference: Universal Data Access for the Java(TM) 2 Platform (2nd Edition) [Paperback]

Seth White (Author), Mark Hapner (Author), Rick Cattell (Author), Graham Hamilton (Author), Maydene Fisher (Author)

Book Description

ISBN-10: 0201433281 | ISBN-13: 978-0201433289 | Publication Date: June 11, 1999 | Edition: 2

This book provides the definitive description of the JDBCaA A API, the technology that enables universal data access for the JavaaA A programming language. This new edition has been updated and expanded to cover all of the JDBC 2.0 API, including the JDBC 2.0 core API and the JDBC Standard Extension API, the package that facilitates building server-side applications. Containing in-depth explanations that go beyond the specification, this complete resource pairs a step-by-step tutorial with a comprehensive reference to all of the classes and interfaces. For those new to Java technology, the book includes an introduction to the Java programming language and to SQL. It builds on this basic knowledge to walk you through creating a JDBC application-from setting up a database and establishing a connection to retrieving values from result sets and using prepared statements. In addition, the authors provide many examples along the way that demonstrate how to execute common tasks. The book proceeds to more advanced topics, focusing on the new features of the JDBC 2.0 API, including scrollable and updatable result sets, batch updates, SQL3 data types, custom mapping, and more.You will also find an introduction to working with the JDBC metadata API as well as information on rowsets, the technology that makes it possible to handle data sets from any source such as JavaBeansaA A components. From array to XADataSource, a useful alphabetical reference provides concise but complete information on each class and interface in the JDBC API. Each entry includes an overview as well as a list and explanation of the methods and fields. A chapter on mapping SQL types and types in the Java programming language, a summary of the new JDBC 2.0 features, and a glossary complete this indispensable resource for all database programmers. 0201433281B04062001

Editorial Reviews

Amazon.com Review

The second edition of the JDBC API Tutorial and Reference provides a worthwhile tour of the new features in Java Database Connectivity (JDBC) 2.0 and serves well as a reference to Sun's new standard for Java database programming.

Once you open this book, it becomes quickly obvious that it is more comprehensive than the first edition. The new edition begins with an overview of the JDBC API, including its architecture and overall design. Beginners will also be pleased with a short breakdown of the Java programming language and SQL basics.

Early sections of the book walk through an approachable tutorial of JDBC, concentrating on topics such as connecting to databases, retrieving result sets, manipulating records, and handling database transactions. There's also coverage of using stored procedures, including embedded SQL with SQLJ.

The book then turns to new JDBC 2.0 API features, like scrollable cursors, updateable record sets, and batch updates. Experienced readers will appreciate how the authors show off JDBC 1.0 code before presenting these new features. An explanation of SQL3 data types supported in JDBC 2.0 follow the discussion of the API features.

The book provides extensive support for finding and understanding recordsets and databases, including the use of the oddly named ResultSetMetaData and DatabaseMetaData classes, which have been greatly enhanced in JDBC 2.0. (You can now write Java code that customizes itself at runtime for almost any SQL platform.) Similar in spirit to the Microsoft OLE DB, the new JDBC 2.0 now supports rowsets, which let programmers work with any tabular data store from within their applications.

Most of the book (over 600 pages) functions as a reference containing every JDBC 2.0 class. Presented alphabetically, each class comes with an introductory definition and a complete listing of its constituent members and methods (including deprecated APIs). Final sections include a guide to "SQL to Java" mappings and tips for writing JDBC drivers.

Whether you are approaching JDBC for the very first time or are ramping up from JDBC 1.0, there is perhaps no better source for learning about the enhanced powers of the new JDBC than this "official" guide from Sun. --Richard Dragan

From the Back Cover

Containing in-depth explanations that go beyond the specification, this complete resource pairs a step-by-step tutorial with a comprehensive reference to all of the classes and interfaces.

For those new to Java technology, the book includes an introduction to the Java programming language and to SQL. It builds on this basic knowledge to walk you through creating a JDBC application–from setting up a database and establishing a connection to retrieving values from result sets and using prepared statements. In addition, the authors provide many examples along the way that demonstrate how to execute common tasks. The book proceeds to more advanced topics, focusing on the new features of the JDBC 2.0 API, including scrollable and updatable result sets, batch updates, SQL3 data types, custom mapping, and more.

You will also find an introduction to working with the JDBC metadata API as well as information on rowsets, the technology that makes it possible to handle data sets from any source such as JavaBeans™ components.

From array to XADataSource, a useful alphabetical reference provides concise but complete information on each class and interface in the JDBC API. Each entry includes an overview as well as a list and explanation of the methods and fields.

A chapter on mapping SQL types and types in the Java programming language, a summary of the new JDBC 2.0 features, and a glossary complete this indispensable resource for all database programmers.

0201433281B04062001

See all Editorial Reviews

Product Details

• Paperback: 1104 pages
• Publisher: Pearson Education; 2 edition (June 11, 1999)
• Language: English
• ISBN-10: 0201433281
• ISBN-13: 978-0201433289
• Product Dimensions: 9.2 x 7.4 x 2 inches
• Shipping Weight: 3.8 pounds
• Average Customer Review: 4.5 out of 5 stars  See all reviews (22 customer reviews)
• Amazon Best Sellers Rank: #2,087,739 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

26 of 26 people found the following review helpful:

4.0 out of 5 stars The details that are needed., September 28, 1999

By A Customer

This review is from: JDBC(TM) API Tutorial and Reference: Universal Data Access for the Java(TM) 2 Platform (2nd Edition) (Paperback)

The full database connectivity and usage of the Java language is covered. With excellent code samples that appeal to all levels of programmers. I have used it to develope an inhouse delivery system and I am not a professional programmer. Very up to date with coverage of all the latest features of the API and what is due soon. EXCELLENT.

21 of 22 people found the following review helpful:

5.0 out of 5 stars Highly Recommended, September 14, 1999

By A Customer

This review is from: JDBC(TM) API Tutorial and Reference: Universal Data Access for the Java(TM) 2 Platform (2nd Edition) (Paperback)

Despite the complexity of JDBC in general, this book gives it to you in a clear, concise format that even a first time programmer would understand.

Although this book provides coverage of SQL and Java, it wouldn't hurt to familiarize yourself with them before picking this book up.

24 of 28 people found the following review helpful:

4.0 out of 5 stars Recommended..., September 28, 1999

By A Customer

This review is from: JDBC(TM) API Tutorial and Reference: Universal Data Access for the Java(TM) 2 Platform (2nd Edition) (Paperback)

This book provides a lot of valuable background information and is complementary to the JDBC specification. This is a "must have" if you want to know more about the more complex topics of JDBC like scrollable result sets, datasources, connection pooling, etc.