JDBC(TM) API Tutorial and Reference: Universal Data Access for the Java(TM) 2 Platform (2nd Edition)
by By Hamilton, Graham, Cattell, Rick, Fisher, Maydene, White, Seth (EDT), and Hapner, Mark
Category: Computers , Databases , General

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, this 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, 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.