JDBC API Tutorial and Reference, Third Edition

1345 Pages·2003·5.27 MB·English

• Table of Contents
• Index
JDBC™ API Tutorial and Reference, Third Edition
By Maydene Fisher, Jon Ellis, Jonathan Bruce

Publisher: Addison Wesley
Pub Date: June 13, 2003
ISBN: 0-321-17384-8
Pages: 1280
Slots: 2
This book provides the definitive tutorial and reference to 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 the entire JDBC 3.0 API, including the java.sql package and the
javax.sql package, 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 every class and interface.
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 the creation of 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 then turns to more advanced topics,
focusing on features such as scrollable and updatable result sets, batch updates, SQL99 data types,
custom mapping, savepoints, statement pooling, automatically generated keys, and more.
In addition to in-depth coverage of the JDBC metadata API, the book gives you the latest information
on rowsets, the technology that makes it possible to handle data sets as JavaBeans(TM) components.
As an added bonus, you get a preview of the standard implementations for JdbcRowSet,
CachedRowSet, WebRowSet, JoinRowSet, and FilteredRowSet objects.
From Array to XADataSource, an easy-to-use alphabetical reference provides concise but complete
information on each class and interface in the JDBC API. Each entry includes an overview with usage
examples as well as a comprehensive explanation of the methods and fields.
A chapter on mapping SQL types and types in the Java programming language, an appendix for
driver writers, a summary of the new features in the JDBC 2.0 and 3.0 APIs, and a glossary complete
this indispensable resource for all database programmers.
The Java(TM) Series is supported, endorsed, and authored by the creators of the Java technology at
Sun Microsystems, Inc. It is the official place to go for complete, expert, and definitive information on
Java technology. The books in this Series provide the inside information you need to build effective,
robust, and portable applications and applets. The Series is an indispensable resource for anyone
targeting the Java(TM) 2 platform.
• Table of Contents
• Index
JDBC™ API Tutorial and Reference, Third Edition
By Maydene Fisher, Jon Ellis, Jonathan Bruce

Publisher: Addison Wesley
Pub Date: June 13, 2003
ISBN: 0-321-17384-8
Pages: 1280
Slots: 2
Copyright
The Java™ Series
The Jini™ Technology Series
The Java™ Series, Enterprise Edition
Acknowledgments
Part One
Chapter 1. Introduction
Section 1.1. What the JDBC 3.0 API Includes
Section 1.2. Conventions Used in This Book
Section 1.3. Contents of the Book
Section 1.4. What Is the JDBC API?
Section 1.5. The JDBC API and the Java Platforms
Section 1.6. Java Overview
Section 1.7. Relational Database Overview
Chapter 2. Basic Tutorial
Section 2.1. Getting Started
Section 2.2. Setting Up a Database
Section 2.3. Establishing a Connection
Section 2.4. Setting Up Tables
Section 2.5. Getting Data from a Table
Section 2.6. Retrieving Values from Result Sets
Section 2.7. Updating Tables
Section 2.8. Milestone: The Basics of JDBC
Section 2.9. Using Prepared Statements
Section 2.10. Using Joins
Section 2.11. Using Transactions
Section 2.12. Stored Procedures
Section 2.13. Creating Complete JDBC Applications
Section 2.14. Running the Sample Applications
Section 2.15. Sample Code
Section 2.16. Creating an Applet from an Application
Section 2.17. Stored Procedures Using SQLJ and the JDBC API
Chapter 3. Advanced Tutorial
Section 3.1. Getting Set Up to Use the JDBC 2.0 and 3.0 API

Section 3.2. Moving the Cursor in Scrollable Result Sets

Section 3.3. Making Updates to Updatable Result Sets

Section 3.4. Making Batch Updates

Section 3.5. SQL99 Data Types

Section 3.6. Using Custom Mapping

Section 3.7. Using a Object
DataSource

Section 3.8. JDBC 3.0 Functionality
Chapter 4. MetaData Tutorial
Section 4.1. Using a Object
ResultSetMetaData
Section 4.2. Using a Object
DatabaseMetaData
Section 4.3. Methods Added in the JDBC 2.0 Core API
Section 4.4. Methods Added in the JDBC 3.0 API

Section 4.5. Using a Object
ParameterMetaData
Section 4.6. Generic Applications
Chapter 5. Rowset Tutorial
Section 5.1. Types and Uses of Rowsets
Section 5.2. Using a Rowset
Section 5.3. An EJB Example
Part Two

Chapter 6. Array
Section 6.1. Overview
Array

Section 6.2. Interface Definition
Array
Section 6.3. Methods
Array

Chapter 7. BatchUpdateException
Section 7.1. Overview
BatchUpdateException

Section 7.2. Class Definition
BatchUpdateException
Section 7.3. Constructors
BatchUpdateException
Section 7.4. Methods
BatchUpdateException

Chapter 8. Blob
Section 8.1. Overview
Blob
Section 8.2. Interface Definition
Blob
Section 8.3. Methods
Blob
Chapter 9. CallableStatement
Section 9.1. Overview
CallableStatement
Section 9.2. Definition
CallableStatement
Section 9.3. Methods
CallableStatement

Chapter 10. Clob
Section 10.1. Overview
Clob
Section 10.2. Interface Definition
Clob
Section 10.3. Methods
Clob
Chapter 11. Connection
Section 11.1. Overview
Connection
Section 11.2. Interface Definition
Connection
Section 11.3. Methods
Connection
Section 11.4. Fields
Connection

Chapter 12. ConnectionEvent
Section 12.1. Overview
ConnectionEvent

Section 12.2. Interface Definition
ConnectionEvent
Section 12.3. Constructors
ConnectionEvent
Section 12.4. Methods
ConnectionEvent

Chapter 13. ConnectionEventListener
Section 13.1. Overview
ConnectionEventListener

Section 13.2. Interface Definition
ConnectionEventListener
Section 13.3. Methods
ConnectionEventListener

Chapter 14. ConnectionPoolDataSource
Section 14.1. Overview
ConnectionPoolDataSource

Section 14.2. Interface Definition
ConnectionPoolDataSource
Section 14.3. Methods
ConnectionPoolDataSource
Chapter 15. DatabaseMetaData
Section 15.1. Overview
DatabaseMetaData
Section 15.2. Interface Definition
DatabaseMetaData
Section 15.3. Methods
DatabaseMetaData
Section 15.4. Fields
DatabaseMetaData

Chapter 16. DataSource
Section 16.1. Overview
DataSource

Section 16.2. Interface Definition
DataSource
Section 16.3. Methods
DataSource
Chapter 17. DataTruncation
Section 17.1. Overview
DataTruncation
Section 17.2. Class Definition
DataTruncation
Section 17.3. Constructor
DataTruncation
Section 17.4. Methods
DataTruncation
Chapter 18. Date
Section 18.1. Overview
Date
Section 18.2. Class Definition
Date
Section 18.3. Constructors
Date
Section 18.4. Methods
Date

Chapter 19. Distinct Types
Section 19.1. Distinct Types Overview
Chapter 20. Driver
Section 20.1. Overview
Driver
Section 20.2. Interface Definition
Driver
Section 20.3. Methods
Driver
Chapter 21. DriverManager
Section 21.1. Overview
DriverManager
Section 21.2. Class Definition
DriverManager
Section 21.3. Methods
DriverManager
Chapter 22. DriverPropertyInfo
Section 22.1. Overview
DriverPropertyInfo
Section 22.2. Class Definition
DriverPropertyInfo
Section 22.3. Constructor
DriverPropertyInfo
Section 22.4. Fields
DriverPropertyInfo

Chapter 23. ParameterMetaData
Section 23.1. Overview
ParameterMetaData

Section 23.2. Interface Definition
ParameterMetaData
Section 23.3. Methods
ParameterMetaData
Section 23.4. Fields
ParameterMetaData

Chapter 24. PooledConnection
Section 24.1. Overview
PooledConnection

Section 24.2. Interface Definition
PooledConnection
Section 24.3. Methods
PooledConnection
Chapter 25. PreparedStatement
Section 25.1. Overview
PreparedStatement
Section 25.2. Interface Definition
PreparedStatement
Section 25.3. Methods
PreparedStatement

Chapter 26. Ref
Section 26.1. Overview
Ref
Section 26.2. Interface Definition
Ref
Section 26.3. Methods
Ref
Chapter 27. ResultSet
Section 27.1. Overview
ResultSet
Section 27.2. Interface Definition
ResultSet
Section 27.3. Methods
ResultSet
Section 27.4. Fields
ResultSet
Chapter 28. ResultSetMetaData
Section 28.1. Overview
ResultSetMetaData
Section 28.2. Interface Definition
ResultSetMetaData
Section 28.3. Methods
ResultSetMetaData
Section 28.4. Fields
ResultSetMetaData

Chapter 29. RowSet
Section 29.1. Overview
RowSet
Section 29.2. Standard Implementations

Section 29.3. Interface Definition
RowSet
Section 29.4. Methods
RowSet

Section 29.5. Fields
RowSet

Chapter 30. RowSetEvent
Section 30.1. Overview
RowSetEvent

Section 30.2. Interface Definition
RowSetEvent
Section 30.3. Constructor
RowSetEvent
Section 30.4. Methods
RowSetEvent

Chapter 31. RowSetInternal
Section 31.1. Overview
RowSetInternal

Section 31.2. Interface Definition
RowSetInternal
Section 31.3. Methods
RowSetInternal

Chapter 32. RowSetListener
Section 32.1. Overview
RowSetListener

Section 32.2. Interface Definition
RowSetListener
Section 32.3. Methods
RowSetListener

Chapter 33. RowSetMetaData
Section 33.1. Overview
RowSetMetaData

Section 33.2. Interface Definition
RowSetMetaData
Section 33.3. Methods
RowSetMetaData
Section 33.4. Fields
RowSetMetaData

Chapter 34. RowSetReader
Section 34.1. Overview
RowSetReader

Section 34.2. Interface Definition
RowSetReader
Section 34.3. Methods
RowSetReader

Chapter 35. RowSetWriter
Section 35.1. Overview
RowSetWriter

Section 35.2. Interface Definition
RowSetWriter
Section 35.3. Methods
RowSetWriter

Chapter 36. Savepoint
Section 36.1. Overview
Savepoint

Section 36.2. Interface Definition
Savepoint
Section 36.3. Methods
Savepoint

Chapter 37. SQLData
Section 37.1. Overview
SQLData

Section 37.2. Interface Definition
SQLData
Section 37.3. Methods
SQLData
Chapter 38. SQLException
Section 38.1. Overview
SQLException
Section 38.2. Class Definition
SQLException
Section 38.3. Constructors
SQLException
Section 38.4. Methods
SQLException

Chapter 39. SQLInput
Section 39.1. Overview
SQLInput
Section 39.2. Interface Definition
SQLInput
Section 39.3. Methods
SQLInput

Chapter 40. SQLOutput
Section 40.1. Overview
SQLOutput
Section 40.2. Interface Definition
SQLOutput
Section 40.3. Methods
SQLOutput

Chapter 41. SQLPermission
Section 41.1. Overview
SQLPermission

Section 41.2. Class Definition
SQLPermission
Section 41.3. Constructors
SQLPermission
Chapter 42. SQLWarning
Section 42.1. Overview
SQLWarning
Section 42.2. Class Definition
SQLWarning
Section 42.3. Constructors
SQLWarning
Section 42.4. Methods
SQLWarning
Chapter 43. Statement
Section 43.1. Overview
Statement
Section 43.2. Interface Definition
Statement
Section 43.3. Methods
Statement
Section 43.4. Fields
Statement

Chapter 44. Struct
Section 44.1. > Overview
Struct

Section 44.2. Interface Definition
Struct
Section 44.3. Methods
Struct
Chapter 45. Time
Section 45.1. Overview
Time
Section 45.2. Class Definition
Time
Section 45.3. Constructors
Time
Section 45.4. Methods
Time
Chapter 46. Timestamp
Section 46.1. Overview
Timestamp
Section 46.2. Class Definition
Timestamp
Section 46.3. Constructors
Timestamp
Section 46.4. Methods
Timestamp
Chapter 47. Types
Section 47.1. Overview of Class
Types
Section 47.2. Class Definition
Types

Chapter 48. XAConnection
Section 48.1. Overview
XAConnection

Section 48.2. Interface Definition
XAConnection

Section 48.3. Methods
XAConnection

Chapter 49. XADataSource
Section 49.1. Overview
XADataSource

Section 49.2. Interface Definition
XADataSource
Section 49.3. Methods
XADataSource
Chapter 50. Mapping SQL and Java Types
Section 50.1. Mapping Overview
Section 50.2. Mapping SQL Types to Java Types
Section 50.3. Basic JDBC Types

Section 50.4. Advanced JDBC Data Types

Section 50.5. JDBC Types Added in the JDBC 3.0 API
Section 50.6. Examples of Mapping

Section 50.7. Custom Mapping
Section 50.8. Dynamic Data Access

Section 50.9. Storing Java Objects in a Database
Section 50.10. Tables for Type Mapping
Appendix A. For Driver Writers
Section A.1. Requirements for All Drivers
Section A.2. Requirements for JDBC 1.0 API Compliance
Section A.3. Requirements for JDBC 2.0 API Compliance
Section A.4. Requirements for JDBC 3.0 API Compliance
Section A.5. API That Is Already Implemented
Section A.6. Additional Requirements
Section A.7. Permitted Variants
Section A.8. Security Responsibilities of Drivers
Section A.9. Use for Exceptions
SQLException
Section A.10. Implementation Suggestions
Section A.11. Connection and Statement Pooling Implementations
Section A.12. JDBC Test Suite
Section A.13. Connectors
Appendix B. Summary of Changes

Section B.1. Overview of JDBC 3.0 API Changes

Section B.2. Summary of New Functionality
Section B.3. Complete List of JDBC 3.0 API Changes

Section B.4. Overview of JDBC 2.0 Core API Changes

Section B.5. Summary of New Functionality

Section B.6. JDBC 2.0 Core API Changes

Section B.7. JDBC Optional Package Features

Section B.8. Complete List of Optional Package API
Section B.9. Post JDBC 1.0 API Changes
Section B.10. Early Design Decisions
Section B.11. Where to Send Suggestions
Glossary
JDBC Quick Reference
Index