| |
| |
| Acknowledgments | |
| |
| |
| |
| |
| |
| |
| Introduction | |
| |
| |
| |
| What the JDBC 3.0 API Includes | |
| |
| |
| |
| Conventions Used in This Book | |
| |
| |
| |
| Contents of the Book | |
| |
| |
| |
| What Is the JDBC API? | |
| |
| |
| |
| The JDBC API and the Java Platforms | |
| |
| |
| |
| Java Overview | |
| |
| |
| |
| Relational Database Overview | |
| |
| |
| |
| Basic Tutorial | |
| |
| |
| |
| Getting Started | |
| |
| |
| |
| Setting Up a Database | |
| |
| |
| |
| Establishing a Connection | |
| |
| |
| |
| Setting Up Tables | |
| |
| |
| |
| Getting Data from a Table | |
| |
| |
| |
| Retrieving Values from Result Sets | |
| |
| |
| |
| Updating Tables | |
| |
| |
| |
| Milestone: The Basics of JDBC | |
| |
| |
| |
| Using Prepared Statements | |
| |
| |
| |
| Using Joins | |
| |
| |
| |
| Using Transactions | |
| |
| |
| |
| Stored Procedures | |
| |
| |
| |
| Creating Complete JDBC Applications | |
| |
| |
| |
| Running the Sample Applications | |
| |
| |
| |
| Sample Code | |
| |
| |
| |
| Creating an Applet from an Application | |
| |
| |
| |
| Stored Procedures Using SQLJ and the JDBC API | |
| |
| |
| |
| Advanced Tutorial | |
| |
| |
| |
| Getting Set Up to Use the JDBC 2.0 and 3.0 API | |
| |
| |
| |
| Moving the Cursor in Scrollable Result Sets | |
| |
| |
| |
| Making Updates to Updatable Result Sets | |
| |
| |
| |
| Making Batch Updates | |
| |
| |
| |
| SQL99 Data Types | |
| |
| |
| |
| Using Custom Mapping | |
| |
| |
| |
| Using a DataSource Object | |
| |
| |
| |
| JDBC 3.0 Functionality | |
| |
| |
| |
| MetaData Tutorial | |
| |
| |
| |
| Using a ResultSetMetaData Object | |
| |
| |
| |
| Using a DatabaseMetaData Object | |
| |
| |
| |
| Methods Added in the JDBC 2.0 Core API | |
| |
| |
| |
| Methods Added in the JDBC 3.0 API | |
| |
| |
| |
| Using a ParameterMetaData Object | |
| |
| |
| |
| Generic Applications | |
| |
| |
| |
| Rowset Tutorial | |
| |
| |
| |
| Types and Uses of Rowsets | |
| |
| |
| |
| Using a Rowset | |
| |
| |
| |
| An EJB Example | |
| |
| |
| |
| |
| |
| |
| Array | |
| |
| |
| |
| Array Overview | |
| |
| |
| |
| Array Interface Definition | |
| |
| |
| |
| Array Methods | |
| |
| |
| |
| BatchUpdateException | |
| |
| |
| |
| BatchUpdateException Overview | |
| |
| |
| |
| BatchUpdateException Class Definition | |
| |
| |
| |
| BatchUpdateException Constructors | |
| |
| |
| |
| BatchUpdateException Methods | |
| |
| |
| |
| Blob | |
| |
| |
| |
| Blob Overview | |
| |
| |
| |
| Blob Interface Definition | |
| |
| |
| |
| Blob Methods | |
| |
| |
| |
| CallableStatement | |
| |
| |
| |
| CallableStatement Overview | |
| |
| |
| |
| CallableStatement Definition | |
| |
| |
| |
| CallableStatement Methods | |
| |
| |
| |
| Clob | |
| |
| |
| |
| Clob Overview | |
| |
| |
| |
| Clob Interface Definition | |
| |
| |
| |
| Clob Methods | |
| |
| |
| |
| Connection | |
| |
| |
| |
| Connection Overview | |
| |
| |
| |
| Connection Interface Definition | |
| |
| |
| |
| Connection Methods | |
| |
| |
| |
| Connection Fields | |
| |
| |
| |
| ConnectionEvent | |
| |
| |
| |
| ConnectionEvent Overview | |
| |
| |
| |
| ConnectionEvent Interface Definition | |
| |
| |
| |
| ConnectionEvent Constructors | |
| |
| |
| |
| ConnectionEvent Methods | |
| |
| |
| |
| ConnectionEventListener | |
| |
| |
| |
| ConnectionEventListener Overview | |
| |
| |
| |
| ConnectionEventListener Interface Definition | |
| |
| |
| |
| ConnectionEventListener Methods | |
| |
| |
| |
| ConnectionPoolDataSource | |
| |
| |
| |
| ConnectionPoolDataSource Overview | |
| |
| |
| |
| ConnectionPoolDataSource Interface Definition | |
| |
| |
| |
| ConnectionPoolDataSource Methods | |
| |
| |
| |
| DatabaseMetaData | |
| |
| |
| |
| DatabaseMetaData Overview | |
| |
| |
| |
| DatabaseMetaData Interface Definition | |
| |
| |
| |
| DatabaseMetaData Methods | |
| |
| |
| |
| DatabaseMetaData Fields | |
| |
| |
| |
| DataSource | |
| |
| |
| |
| DataSource Overview | |
| |
| |
| |
| DataSource Interface Definition | |
| |
| |
| |
| DataSource Methods | |
| |
| |
| |
| DataTruncation | |
| |
| |
| |
| DataTruncation Overview | |
| |
| |
| |
| DataTruncation Class Definition | |
| |
| |
| |
| DataTruncation Constructor | |
| |
| |
| |
| DataTruncation Methods | |
| |
| |
| |
| Date | |
| |
| |
| |
| Date Overview | |
| |
| |
| |
| Date Class Definition | |
| |
| |
| |
| Date Constructors | |
| |
| |
| |
| Date Methods | |
| |
| |
| |
| Distinct Types | |
| |
| |
| |
| Distinct Types Overview | |
| |
| |
| |
| Driver | |
| |
| |
| |
| Driver Overview | |
| |
| |
| |
| Driver Interface Definition | |
| |
| |
| |
| Driver Methods | |
| |
| |
| |
| DriverManager | |
| |
| |
| |
| DriverManager Overview | |
| |
| |
| |
| DriverManager Class Definition | |
| |
| |
| |
| DriverManager Methods | |
| |
| |
| |
| DriverPropertyInfo | |
| |
| |
| |
| DriverPropertyInfo Overview | |
| |
| |
| |
| DriverPropertyInfo Class Definition | |
| |
| |
| |
| DriverPropertyInfo Constructor | |
| |
| |
| |
| DriverPropertyInfo Fields | |
| |
| |
| |
| ParameterMetaData | |
| |
| |
| |
| ParameterMetaData Overview | |
| |
| |
| |
| ParameterMetaData Interface Definition | |
| |
| |
| |
| ParameterMetaData Methods | |
| |
| |
| |
| ParameterMetaData Fields | |
| |
| |
| |
| PooledConnection | |
| |
| |
| |
| PooledConnection Overview | |
| |
| |
| |
| PooledConnection Interface Definition | |
| |
| |
| |
| PooledConnection Methods | |
| |
| |
| |
| PreparedStatement | |
| |
| |
| |
| PreparedStatement Overview | |
| |
| |
| |
| PreparedStatement Interface Definition | |
| |
| |
| |
| PreparedStatement Methods | |
| |
| |
| |
| Ref | |
| |
| |
| |
| Ref Overview | |
| |
| |
| |
| Ref Interface Definition | |
| |
| |
| |
| Ref Methods | |
| |
| |
| |
| ResultSet | |
| |
| |
| |
| ResultSet Overview | |
| |
| |
| |
| ResultSet Interface Definition | |
| |
| |
| |
| ResultSet Methods | |
| |
| |
| |
| ResultSet Fields | |
| |
| |
| |
| ResultSetMetaData | |
| |
| |
| |
| ResultSetMetaData Overview | |
| |
| |
| |
| ResultSetMetaData Interface Definition | |
| |
| |
| |
| ResultSetMetaData Methods | |
| |
| |
| |
| ResultSetMetaData Fields | |
| |
| |
| |
| RowSet | |
| |
| |
| |
| RowSet Overview | |
| |
| |
| |
| Standard Implementations | |
| |
| |
| |
| RowSet Interface Definition | |
| |
| |
| |
| RowSet Methods | |
| |
| |
| |
| RowSet Fields | |
| |
| |
| |
| RowSetEvent | |
| |
| |
| |
| RowSetEvent Overview | |
| |
| |
| |
| RowSetEvent Interface Definition | |
| |
| |
| |
| RowSetEvent Constructor | |
| |
| |
| |
| RowSetEvent Methods | |
| |
| |
| |
| RowSetInternal | |
| |
| |
| |
| RowSetInternal Overview | |
| |
| |
| |
| RowSetInternal Interface Definition | |
| |
| |
| |
| RowSetInternal Methods | |
| |
| |
| |
| RowSetListener | |
| |
| |
| |
| RowSetListener Overview | |
| |
| |
| |
| RowSetListener Interface Definition | |
| |
| |
| |
| RowSetListener Methods | |
| |
| |
| |
| RowSetMetaData | |
| |
| |
| |
| RowSetMetaData Overview | |
| |
| |
| |
| RowSetMetaData Interface Definition | |
| |
| |
| |
| RowSetMetaData Methods | |
| |
| |
| |
| RowSetMetaData Fields | |
| |
| |
| |
| RowSetReader | |
| |
| |
| |
| RowSetReader Overview | |
| |
| |
| |
| RowSetReader Interface Definition | |
| |
| |
| |
| RowSetReader Methods | |
| |
| |
| |
| RowSetWriter | |
| |
| |
| |
| RowSetWriter Overview | |
| |
| |
| |
| RowSetWriter Interface Definition | |
| |
| |
| |
| RowSetWriter Methods | |
| |
| |
| |
| Savepoint | |
| |
| |
| |
| Savepoint Overview | |
| |
| |
| |
| Savepoint Interface Definition | |
| |
| |
| |
| Savepoint Methods | |
| |
| |
| |
| SQLData | |
| |
| |
| |
| SQLData Overview | |
| |
| |
| |
| SQLData Interface Definition | |
| |
| |
| |
| SQLData Methods | |
| |
| |
| |
| SQLException | |
| |
| |
| |
| SQLException Overview | |
| |
| |
| |
| SQLException Class Definition | |
| |
| |
| |
| SQLException Constructors | |
| |
| |
| |
| SQLException Methods | |
| |
| |
| |
| SQLInput | |
| |
| |
| |
| SQLInput Overview | |
| |
| |
| |
| SQLInput Interface Definition | |
| |
| |
| |
| SQLInput Methods | |
| |
| |
| |
| SQLOutput | |
| |
| |
| |
| SQLOutput Overview | |
| |
| |
| |
| SQLOutput Interface Definition | |
| |
| |
| |
| SQLOutput Methods | |
| |
| |
| |
| SQLPermission | |
| |
| |
| |
| SQLPermission Overview | |
| |
| |
| |
| SQLPermission Class Definition | |
| |
| |
| |
| SQLPermission Constructors | |
| |
| |
| |
| SQLWarning | |
| |
| |
| |
| SQLWarning | |
| |
| |
| |
| SQLWarning Overview | |
| |
| |
| |
| SQLWarning Class Definition | |
| |
| |
| |
| SQLWarning Constructors | |
| |
| |
| |
| SQLWarning Methods | |
| |
| |
| |
| Statement | |
| |
| |
| |
| Statement Overview | |
| |
| |
| |
| Statement Interface Definition | |
| |
| |
| |
| Statement Methods | |
| |
| |
| |
| Statement Fields | |
| |
| |
| |
| Struct | |
| |
| |
| |
| Struct Overview | |
| |
| |
| |
| Struct Interface Definition | |
| |
| |
| |
| Struct Methods | |
| |
| |
| |
| Time | |
| |
| |
| |
| Time Overview | |
| |
| |
| |
| Time Class Definition | |
| |
| |
| |
| Time Constructors | |
| |
| |
| |
| Time Methods | |
| |
| |
| |
| Timestamp | |
| |
| |
| |
| Timestamp Overview | |
| |
| |
| |
| Timestamp Class Definition | |
| |
| |
| |
| Timestamp Constructors | |
| |
| |
| |
| Timestamp Methods | |
| |
| |
| |
| Types | |
| |
| |
| |
| Overview of Class Types | |
| |
| |
| |
| Types Class Definition | |
| |
| |
| |
| XAConnection | |
| |
| |
| |
| XAConnection Overview | |
| |
| |
| |
| XAConnection Interface Definition | |
| |
| |
| |
| XAConnection Methods | |
| |
| |
| |
| XADataSource | |
| |
| |
| |
| XADataSource Overview | |
| |
| |
| |
| XADataSource Interface Definition | |
| |
| |
| |
| XADataSource Methods | |
| |
| |
| |
| Mapping SQL and Java Types | |
| |
| |
| |
| Mapping Overview | |
| |
| |
| |
| Mapping SQL Types to Java Types | |
| |
| |
| |
| Basic JDBC Types | |
| |
| |
| |
| Advanced JDBC Data Types | |
| |
| |
| |
| JDBC Types Added in the JDBC 3.0 API | |
| |
| |
| |
| Examples of Mapping | |
| |
| |
| |
| Custom Mapping | |
| |
| |
| |
| Dynamic Data Access | |
| |
| |
| |
| Storing Java Objects in a Database | |
| |
| |
| |
| Tables for Type Mapping | |
| |
| |
| |
| For Driver Writers | |
| |
| |
| |
| Requirements for All Drivers | |
| |
| |
| |
| Requirements for JDBC 1.0 API Compliance | |
| |
| |
| |
| Requirements for JDBC 2.0 API Compliance | |
| |
| |
| |
| Requirements for JDBC 3.0 API Compliance | |
| |
| |
| |
| API That Is Already Implemented | |
| |
| |
| |
| Additional Requirements | |
| |
| |
| |
| Permitted Variants | |
| |
| |
| |
| Security Responsibilities of Drivers | |
| |
| |
| |
| Use SQLException for Exceptions | |
| |
| |
| |
| Implementation Suggestions | |
| |
| |
| |
| Connection and Statement Pooling Implementations | |
| |
| |
| |
| JDBC Test Suite | |
| |
| |
| |
| Connectors | |
| |
| |
| |
| Summary of Changes | |
| |
| |
| |
| Overview of JDBC 3.0 API Changes | |
| |
| |
| |
| Summary of New Functionality | |
| |
| |
| |
| Complete List of JDBC 3.0 API Changes | |
| |
| |
| |
| Overview of JDBC 2.0 Core API Changes | |
| |
| |
| |
| Summary of New Functionality | |
| |
| |
| |
| JDBC 2.0 Core API Changes | |
| |
| |
| |
| JDBC Optional Package Features | |
| |
| |
| |
| Complete List of Optional Package API | |
| |
| |
| |
| Post JDBC 1.0 API Changes | |
| |
| |
| |
| Early Design Decisions | |
| |
| |
| |
| Where to Send Suggestions | |
| |
| |
| Glossary | |
| |
| |
| Index | |