Jdbc Database Access With Java: A Tutorial and Annotated Reference (Java Series) [Paperback]

Graham Hamilton (Author), Rick Cattell (Author), Maydene Fisher (Author)

Book Description

Series: Java Series | Publication Date: August 1997

Written by the developers of JDBC, a means of connecting Java with databases, and authorized by the Java Team at Sun, this book provides a description of the JDBC API. The book includes a tutorial to help readers learn how to use JDBC more quickly.

Editorial Reviews

Amazon.com Review

Although Java is touted for its simplicity, it also has its thornier sides, and Java Database Connectivity (JDBC)--Java's database class library--is certainly one of them. Thankfully, the creators of the JDBC specification at Sun Microsystems have brought out JDBC Database Access with Java, an authoritative guide to basic and advanced topics in JDBC. Though the book suffers from a bland writing style, it does include some indispensable information. The guide begins with a basic tutorial on Structured Query Language (SQL) and teaches the rudiments of using Java as a programming language. It then provides instructions for performing basic database operations in JDBC, from simple topics such as joins, updates, and queries with result sets to more advanced topics such as transactions and stored procedures. The section on how to use MetaData classes, which allow programmers to read and manipulate table structures, is quite valuable. In addition, all basic database problems include short sample code.

The second half of JDBC Database Access with Java contains a useful reference to the dozen-and-a-half classes in the JDBC library. Each section provides a general overview of the class and a guide to all APIs. This portion of the book also includes a guide to data types in JDBC and all of today's major SQL server platforms. The final chapter recounts how the JDBC specification was created. Appendices offer short tips for developers who are writing JDBC drivers (who will absolutely want this book on their shelves). Although most Java developers will want to write to a higher level of classes, those new solutions will rely on JDBC, an effective tool for writing database-independent code in Java.

From the Back Cover

JDBC (Java Database Connectivity), the powerful API that is a standard part of the Java Class Libraries (JDK 1.1), represents one of the most exciting and fertile areas for Java development. Offering SQL compatibility and sophisticated database development capabilities, JDBC allows Java programmers access to MIS and Legacy systems.

From the creators of the JDBC API at JavaSoft, here is the definitive guide to this vital new technology. Appropriate for Java programmers of all skill levels, this book provides explanations of JDBC and Java fundamentals, a step-by-step tutorial to bring you up to speed, and an extensively annotated reference to all JDBC classes and interfaces.

Overviews of Java and the JDBC API explain how JDBC fits into the world of SQL and relational databases. The tutorial walks you through JDBC, demonstrating how to execute common tasks with numerous examples. For those interested in writing applications that access various database systems, the JDBC Metadata API is also introduced.

The alphabetically arranged reference section is comprehensive and detailed, containing class and interface definitions along with a wealth of in-depth information on methods and fields. Also included is important information on mapping Java and SQL types, a look at the rationale behind JDBC's design, and a glimpse into JDBC's future.

Anyone interested in pursuing the many development opportunities made possible by JDBC will find this book an indispensable resource.

0201309955B04062001

See all Editorial Reviews

Product Details

• Paperback: 462 pages
• Publisher: Addison-Wesley (C) (August 1997)
• Language: English
• ISBN-10: 0201309955
• ISBN-13: 978-0201309959
• Product Dimensions: 9.1 x 7.3 x 0.9 inches
• Shipping Weight: 1.8 pounds
• Average Customer Review: 4.2 out of 5 stars  See all reviews (8 customer reviews)
• Amazon Best Sellers Rank: #1,888,240 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

7 of 7 people found the following review helpful:

4.0 out of 5 stars Very good book for Database Programming using Java, July 16, 1998

By A Customer

This review is from: Jdbc Database Access With Java: A Tutorial and Annotated Reference (Java Series) (Paperback)

Excellent book for starters in either Java/DB. Can be used by expert prorammers to write their own APIs. My favorite in this book is metadata explanation. A must reference for everyone whose working with JAVA/JDBC.

8 of 9 people found the following review helpful:

3.0 out of 5 stars good coverage, not much depth., September 12, 1998

By 

Greg Munger - See all my reviews

Amazon Verified Purchase

This review is from: Jdbc Database Access With Java: A Tutorial and Annotated Reference (Java Series) (Paperback)

I am an experienced Java programmer who bought this book in the middle of implementing a JDBC based application. After staring at the opaque JDBC documentation from Sun, I hoped to find in this book an in depth examination of design and performance issues. The examples here do not go very far. My feeling is that this book covers the subject adequately, but in the end it is not a very complex subject. The hard issues are often implementation specific, and I suppose an in depth look at the details of conformance and performance is not really possible in a book format (e.g. which databases require that resultsets read every column and only once). Now I wish I had purchased a more general book with one good chapter on JDBC, though I do appreciate the reference section in the back and still refer to it.

4 of 4 people found the following review helpful:

5.0 out of 5 stars Excellent book for anyone who wants to learn JDBC and more, July 27, 1998

By A Customer

This review is from: Jdbc Database Access With Java: A Tutorial and Annotated Reference (Java Series) (Paperback)

This book is well-written and has examples on using the SQL select, insert, delete and update commands. In addition, the topics on metadata is thorough. This is the best of the bunch, you won't be disappointed. It covers everything about database transactions - stored procedures, rollbacks and more.