当前页面: 在线文档首页 > JDK 5 Documentation v1.2.2, Java 2 SDK 英文文档

JDK 5 Documentation v1.2.2, Java 2 SDK 英文文档

Contents | Prev | Next

JDBC^TM Guide: Getting Started

March 6, 1997

Contents

1.1 What Is JDBC^TM?

: 1.1.1 What Does JDBC Do?
: 1.1.2 JDBC Is a Low-level API and a Base for Higher-level APIs
: 1.1.3 JDBC versus ODBC and other APIs
: 1.1.4 Two-tier and Three-tier Models
: 1.1.5 SQL Conformance

1.2 JDBC Products

: 1.2.1 JavaSoft Framework
: 1.2.2 JDBC Driver Types
: 1.2.3 Obtaining JDBC Drivers
: 1.2.4 Other Products

: 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

3 DriverManager

: 3.1.1 Keeping Track of Available Drivers
: 3.1.2 Establishing a Connection

: 4.1.1 Creating Statement Objects
: 4.1.2 Executing Statements Using Statement objects
: 4.1.3 Statement Completion
: 4.1.4 Closing Statement Objects
: 4.1.5 SQL Escape Syntax in Statement Objects
: 4.1.6 Using the Method execute

: 5.1.1 Rows and Cursors
: 5.1.2 Columns
: 5.1.3 Data Types and Conversions
: 5.1.4 Using Streams for Very Large Row Values
: 5.1.5 NULL Result Values
: 5.1.6 Optional or Multiple Result Sets

6 PreparedStatement

: 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

7 CallableStatement

: 7.1.1 Creating a CallableStatement Object
: 7.1.2 IN and OUT Parameters
: 7.1.3 INOUT Parameters
: 7.1.4 Retrieve OUT Parameters after Results
: 7.1.5 Retrieving NULL Values as OUT Parameters

8 Mapping SQL and Java Types

8.2 Mapping SQL Data Types into Java

: 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 Examples of Mapping

: 8.4.1 Simple SQL Statement
: 8.4.2 SQL Statement with IN Parameters
: 8.4.3 SQL Statement with INOUT Parameters

8.5 Dynamic Data Access

8.6 Tables for Data Type Mapping

: 8.6.1 JDBC Types Mapped to Java Types
: 8.6.2 Java Types Mapped to JDBC Types
: 8.6.3 JDBC Types Mapped to Java Object Types
: 8.6.4 Java Object Types Mapped to JDBC Types
: 8.6.5 Conversions by setObject
: 8.6.6 JDBC Types Retrieved by ResultSet.getXXX Methods

10 JDBC-ODBC Bridge Driver

10.1 JDBC-ODBC Bridge

: 10.1.1 What Is the JDBC-ODBC Bridge?
: 10.1.2 What Version of ODBC Is Supported?
: 10.1.3 The Bridge Implementation
: 10.1.4 Installation

10.2 Using the Bridge

: 10.2.1 Using the Bridge from an Applet
: 10.2.2 Most Browsers Do Not Support the Bridge
: 10.2.3 Tested Configurations
: 10.2.4 ODBC Drivers Known to Work with the Bridge
: 10.2.5 ODBC Driver Incompatibilities
: 10.2.6 What Is the JDBC URL Supported by the Bridge?
: 10.2.7 Debugging

10.3 General Notes

Contents | Prev | Next

jdbc@wombat.eng.sun.com or jdbc-odbc@wombat.eng.sun.com

Copyright © 1996, 1997 Sun Microsystems, Inc. All rights reserved.