Description
Book SynopsisThe Java Database Connectivity (JDBC) specification is a complex set of application program interfaces (APIs) that developers need to understand if they want their Java applications to work with databases. This reference offers quick look-ups for all methods of the standard JDBC classes.
Table of ContentsIntroduction 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 The JDBC API