JDBC pocket reference
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 memor...
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | Inglés |
| Published: |
Sebastopol, California :
O'Reilly
2003.
|
| Subjects: | |
| See on Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009655513906719 |
Table of Contents:
- Contents; JDBC Pocket Reference; Introduction; Acknowledgments; Conventions; The Big Picture; Import Statements; JDBC Drivers; Driver Types; Database URLs; Establishing a Connection; Using DriverManager; Loading a JDBC driver; Using JNDI; Examining DatabaseMetaData; 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 CharacteristicsSQL/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; Date; Time; Timestamp; Function; Outer join; SQL LIKE; Stored procedure; Transaction Management; The JDBC API; Methods
