- ホーム
- > 洋書
- > 英文書
- > Internet / Web Programming
Full Description
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. This 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 SQL 99 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.
Contents
Introduction 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