JDBC Pocket Reference

Donald Bales

  • 出版商: O'Reilly
  • 出版日期: 2003-02-18
  • 售價: $500
  • 貴賓價: 9.5$475
  • 語言: 英文
  • 頁數: 152
  • 裝訂: Paperback
  • ISBN: 0596004575
  • ISBN-13: 9780596004576





JDBC--the Java Database Connectivity specification--is a complex set of application programming interfaces (APIs) that developers need to understand if they want their Java applications to work with databases. JDBC is so complex that even the most experienced developers need to refresh their memories from time to time on specific methods and details. But, practically speaking, who wants to stop and thumb through a weighty tutorial volume each time a question arises? The answer is the JDBC Pocket Reference, a data-packed quick reference that is both a time-saver and a lifesaver.

The JDBC Pocket Reference offers quick look-ups for all methods of the standard JDBC classes. These include concise reviews of the procedures for common JDBC tasks such as connecting to a database, executing stored procedures, executing DDL and the like. You'll find documentation of the connect string formats for the most common databases, including Oracle, SQL-Server, and PostgreSQL. You'll even find information on working with large objects, and on using SQL99 user defined datatypes to work with object-relational data. Searching for this sort of material through large tutorials is frustrating and a waste of time, but this pocket-sized book is easy to take anywhere and makes finding the information you need a snap.

O'Reilly's Pocket References have become a favorite among developers everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. When you've reached a sticking point and need to get to the answer quickly, the new JDBC Pocket Reference is the book you'll want close at hand.

Table of Contents


Import Statements

JDBC Drivers
     Driver Types
     Database URLs

Establishing a Connection
     Using DriverManager
     Using JNDI

Examining Database MetaData

Executing Dynamic SQL
     Executing DDL
     Executing INSERT, UPDATE, or DELETE Statements
     Executing SELECT Statements

Executing Precompiled SQL

Executing a Stored Procedure

Retrieving Query Results
     Navigating a Result Set
     Accessing Column Values
     Inserting, Updating, and Deleting Rows in a ResultSet
     Dynamically Determining Result Set Characteristics

SQL/Java Data Type Mapping

Handling NULL Values
     Detecting NULL Values with wasNull( )
     Detecting NULL Values with BigDecimal
     Setting a Column to a NULL Value

Batching Inserts and Updates

Working with Large Objects
     Inserting a BLOB
     Retrieving a BLOB

User-Defined Data Types
     Creating a Java Class for a UDT
     Updating a Type Map
     Inserting a UDT
     Selecting a UDT

Row Sets

Escape Syntax

Transaction Management