JDBC API Tutorial and Reference

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

Table of contents

Part One

1: Introduction
2: Basic Tutorial
3: Advanced Tutorial
4: MetaData Tutorial
5: Rowset Tutorial

Part Two

6: Array
7: BatchUpdateException
8: Blob
9: CallableStatement
10: Clob
11: Connection
12: ConnectionEvent
13: ConnectionEventListener
14: ConnectionPoolDataSource
15: DatabaseMetaData
16: DataSource
17: DataTruncation
18: Date
19: Distinct Types
20: Driver
21: DriverManager
22: DriverPropertyInfo
23: PooledConnection
24: PreparedStatement
25: Ref
26: ResultSet
27: ResultSetMetaData
28: RowSet
29: RowSetEvent
30: RowSetInternal
31: RowSetListener
32: RowSetMetaData
33: RowSetReader
34: RowSetWriter
35: SQLData
36: SQLException
37: SQLInput
38: SQLOutput
39: SQLWarning
40: Statement
41: Struct
42: Time
43: Timestamp
44: Types
45: XAConnection
46: XADataSource
47: Mapping SQL and Java Types

• Appendix A: For Driver Writers
  
• Appendix B: Summary of Changes
  
• Glossary
  
• Index
  

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.