[Top] [Prev] [Next]
Getting Started with the JDBC API
September 1999
1 Introduction
- 1.1 What the JDBC 2.0 API Includes
- 1.2 What Is the JDBC API?
- 1.2.1 What Does the JDBC API Do?
- 1.2.2 A Base for Other APIs
- 1.2.3 The JDBC API Versus ODBC and UDA
- 1.2.4 Two-tier and Three-tier Models
- 1.2.5 SQL Conformance
- 1.2.6 JDBC Products
- 1.2.7 Java Software Framework
- 1.2.8 JDBC Driver Types
- 1.2.9 Obtaining JDBC Drivers
- 1.2.10 Java-relational DBMSs
- 1.2.11 Other Products
2 Connection
- 2.1 Connection Overview
- 2.1.1 Opening a Connection
- 2.1.2 URLs in General Use
- 2.1.3 JDBC URLs
- 2.1.4 The odbc Subprotocol
- 2.1.5 Registering Subprotocols
- 2.1.6 Sending SQL Statements
- 2.1.7 Transactions
- 2.1.8 Transaction Isolation Levels
- 2.1.9 Freeing DBMS Resources
- 2.1.10 Using Type Maps
3 DriverManager
- 3.1 DriverManager Overview
- 3.1.1 Keeping Track of Available Drivers
- 3.1.2 Establishing a Connection
- 3.1.3 DriverManager Methods Are Static
4 Statement
- 4.1 Statement Overview
- 4.1.1 Creating Statement Objects
- 4.1.2 Executing Statements Using Statement Objects
- 4.1.3 Statement Completion
- 4.1.4 Closing Statements
- 4.1.5 SQL Escape Syntax in Statements
- 4.1.6 Sending Batch Updates
- 4.1.7 Giving Performance Hints
- 4.1.8 Executing Special Kinds of Statements
5 ResultSet
- 5.1 ResultSet Overview
- 5.1.1 Rows and Columns
- 5.1.2 Cursors
- 5.1.3 Cursor Movement Examples
- 5.1.4 Determining the Number of Rows in a Result Set
- 5.1.5 Retrieving Column Values
- 5.1.6 Which getXXX Method to Use
- 5.1.7 Types of Result Sets
- 5.1.8 Concurrency Types
- 5.1.9 Providing Performance Hints
- 5.1.10 Creating Different Types of Result Sets
- 5.1.11 Using a Prepared Statement to Create Result Sets
- 5.1.12 Requesting Features That Are Not Supported
- 5.1.13 Using updateXXX Methods
- 5.1.14 Deleting a Row
- 5.1.15 Inserting Rows
- 5.1.16 Positioned Updates
- 5.1.17 Queries That Produce Updatable Result Sets
- 5.1.18 Using Streams for Very Large Row Values
- 5.1.19 NULL Result Values
- 5.1.20 Closing a ResultSet Object
- 5.1.21 JDBC Compliance
6 PreparedStatement
- 6.1 PreparedStatement Overview
- 6.1.1 Creating PreparedStatement Objects
- 6.1.2 Passing IN Parameters
- 6.1.3 Data Type Conformance on IN Parameters
- 6.1.4 Using setObject
- 6.1.5 Sending JDBC NULL as an IN parameter
- 6.1.6 Sending Very Large IN Parameters
- 6.1.7 Using PreparedStatement Objects in Batch Updates
7 CallableStatement
- 7.1 CallableStatement Overview
- 7.1.1 Creating a CallableStatement Object
- 7.1.2 IN Parameters
- 7.1.3 Making Batch Updates
- 7.1.4 OUT Parameters
- 7.1.5 Numbering of Parameters
- 7.1.6 INOUT Parameters
- 7.1.7 Retrieve OUT Parameters after Results
- 7.1.8 Retrieving NULL Values as OUT Parameters
8 Mapping SQL and Java Types
- 8.1 Mapping Overview
- 8.2 Mapping SQL Types to Java Types
- 8.3 Basic JDBC Types
- 8.3.1 CHAR, VARCHAR, and LONGVARCHAR
- 8.3.2 BINARY, VARBINARY, and LONGVARBINARY
- 8.3.3 BIT
- 8.3.4 TINYINT
- 8.3.5 SMALLINT
- 8.3.6 INTEGER
- 8.3.7 BIGINT
- 8.3.8 REAL
- 8.3.9 DOUBLE
- 8.3.10 FLOAT
- 8.3.11 DECIMAL and NUMERIC
- 8.3.12 DATE, TIME, and TIMESTAMP
- 8.4 Advanced JDBC Data Types
- 8.4.1 BLOB
- 8.4.2 CLOB
- 8.4.3 ARRAY
- 8.4.4 DISTINCT
- 8.4.5 STRUCT
- 8.4.6 REF
- 8.4.7 JAVA_OBJECT
- 8.5 Examples of Mapping
- 8.5.1 Simple SQL Statement
- 8.5.2 SQL Statement with IN Parameters
- 8.5.3 SQL Statement with INOUT Parameters
- 8.6 Custom Mapping
- 8.7 Dynamic Data Access
- 8.8 Storing Java Objects in a Database
- 8.9 Tables for Type Mapping
- 8.9.1 JDBC Types Mapped to Java Types
- 8.9.2 Java Types Mapped to JDBC Types
- 8.9.3 JDBC Types Mapped to Java Object Types
- 8.9.4 Java Object Types Mapped to JDBC Types
- 8.9.5 Conversions by setObject
- 8.9.6 Conversions by ResultSet.getXXX Methods
- 8.9.7 JDBC Types Mapped to Database-specific SQL Types
9 JDBC-ODBC Bridge Driver
- 9.1 Obtaining a JDBC Driver
- 9.2 JDBC-ODBC Bridge
- 9.2.1 What is the JDBC-ODBC Bridge?
- 9.2.2 ODBC Compatibility and ODBC Versions Supported
- 9.2.3 The Bridge Implementation
- 9.2.4 Installation
- 9.3 Using the Bridge
- 9.3.1 Using the Bridge from an Applet
- 9.3.2 Most Browsers Do Not Support the Bridge
- 9.3.3 Tested Configurations
- 9.3.4 ODBC Drivers Known to Work with the Bridge
- 9.3.5 What is the JDBC URL Supported by the Bridge?
- 9.3.6 Debugging
- 9.4 New JDBC 2.0 API Features Supported by the Bridge
Appendix A: Summary of New Features
- A.2 Summary of New Functionality
- A.2.1 Scrollable Result Sets
- A.2.2 Batch Updates
- A.2.3 Programmatic Updates
- A.2.4 Other New Features
- A.3 Support for Advanced Data Types
- A.3.1 What Are the SQL3 Data Types?
- A.3.2 Summary of Support for the SQL3 Data Types
- A.3.3 Mapping of the New SQL3 Types
- A.3.4 SQL Locators
- A.3.5 Support for Storing Java Objects
Appendix B: Sample Code
[Top] [Prev] [Next]
Copyright © 1999, Sun Microsystems, Inc. All rights
reserved.