Sun Java Solaris Communities My SDN Account Join SDN
 
Books & Authors

JDBC API Tutorial and Reference, Third Edition

 
Cover of JDBC book The JDBC(TM) API makes it possible to access databases and other data sources from the Java(TM) programming language. This book, which updates and expands previous editions, presents the definitive description of the complete JDBC(TM) 3.0 API. The 3.0 version of the JDBC API incorporates all previous versions and adds new features to round out the technology.

Containing in-depth explanations that go beyond the specification, this third edition is a complete resource that pairs a step-by-step tutorial with a comprehensive reference to all of the JDBC 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. It then proceeds to more advanced topics, such as using scrollable and updatable result sets, batch updates, SQL99 data types, custom mapping, pooled connections, distributed transactions, pooled statements, automatically generated keys, savepoints, and more.

You will also find thorough but easy-to-follow explanations of the JDBC metadata interfaces. Example code demonstrates how to use these interfaces to get information about databases, result sets, and parameters to stored procedures.

As a bonus, the book includes a preview of the upcoming standard implementations of rowsets, the technology that lets you handle data from any tabular data source as a JavaBeans(TM) component.

From Array to XADataSource, a useful alphabectical reference provides concise but complete information on every class and interface in the JDBC API. Each entry includes an overview of how the class or interface is used plus a full explanation of its methods and fields.

Other valuable features are a chapter on the mapping between SQL types and types in the Java programming language, an appendix for driver writers, an appendix summarizing the API added in each version of the JDBC API, a glossary, and an index.

Maydene Fisher is a technical writer specializing in object-oriented programming languages. A native of San Jose, California, she has worked on both coasts, documenting complex financial models on Wall Street and various Java technologies in Silicon Valley. Jon Ellis, who has worked with databases for ten years, is the architect for the JDBC 3.0 specification. Currently based in Tokyo, Japan, he is leading several Java Community Process specifications in the wireless space. Jonathan Bruce, a transplant from Ireland, where he worked on the JNDI API, is now based in Santa Clara, California. In addition to working on the JDBC 3.0 API, he has contributed to developing the subset of the JDBC API for mobile devices and the standard implementations for rowsets.

Order this book through
amazon.com
informit.com
Content Errata
Minor Errata
Table of Contents

JDBC API TUTORIAL AND REFERENCE, SECOND EDITION

Cover of book This book provides the definitive description of the JDBC API, the technology that enables universal data access for the Java 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 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.

Contents of Book
Content errata
Minor errata
Mail us comments and errata
Order this book through
DigitalGuru
amazon.com
Download code samples used in the book

JDBC DATABASE ACCESS WITH JAVA

Cover of JDBC Database Access with Java

JDBC Database Access with Java: A Tutorial and Annotated Reference , by Graham Hamilton, Rick Cattell, and Maydene Fisher, is the definitive reference manual for JDBC. Current through JDK1.1, it features a tutorial with examples that walk you through the basic API and demonstrates how easy it is to use. Written in clear, understandable English, this book is indispensable for anyone who uses databases with Java.

Contents of Book
What is JDBC? Excerpts from Chapter 1
Content errata
Minor errata
Mail us comments and errata
Order this book through
DigitalGuru
amazon.com
Download code samples used in the book

Oracle is reviewing the Sun product roadmap and will provide guidance to customers in accordance with Oracle's standard product communication policies. Any resulting features and timing of release of such features as determined by Oracle's review of roadmaps, are at the sole discretion of Oracle. All product roadmap information, whether communicated by Sun Microsystems or by Oracle, does not represent a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. It is intended for information purposes only, and may not be incorporated into any contract.