Jdbc Database Access With Java: A Tutorial and Annotated Reference (Java Series) - Softcover

Hamilton, Graham; Cattell, Rick; Fisher, Maydene

Softcover

ISBN 10: 0201309955 ISBN 13: 9780201309959

Publisher: Addison-Wesley, 1997

Synopsis

Provides explanations of JDBC and Java fundamentals, a step-by-step tutorial to bring you up tp speed, and an extensively annotated reference to all JDBC classes and interfaces. Paper.

About this title

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

Edition details

• Publisher: Addison-Wesley
• Publication date: 1997
• ISBN 10: 0201309955
• ISBN 13: 9780201309959
• Binding: Paperback
• Language: English
• Number of pages: 462