List of Listings

Chapter 3: Integrating Databases with JDBC

Listing 3-1: An Example of a JDBC Program

Chapter 6: Database Connectivity, Step by Step

Listing 6-1: A Typical Package Tree

Listing 6-2: Opening a Connection

Listing 6-3: Closing a Connection

Listing 6-4: Adjusting Connection Properties

Listing 6-5: A Do-Nothing Client

Listing 6-6: The JDBC Log Stream

Listing 6-7: Creating a Statement

Listing 6-8: Native SQL Translation

Listing 6-9: Executing a Query

Listing 6-10: Performing an Update

Listing 6-11: Data Truncation on Write

Listing 6-12: Setting a Statement Time-out

Listing 6-13: Executing a Statement

Listing 6-14: Scanning a Result Set

Listing 6-15: Getting the Number and Label of Columns

Listing 6-16: Using Column Indexes

Listing 6-17: Using Column Names

Listing 6-18: Discovering the Result Type

Listing 6-19: Handling Multiple Result Types

Listing 6-20: Canceling Unwanted Results

Listing 6-21: Type Conversion of DATE to String

Listing 6-22: Retrieving BLOBs

Listing 6-23: Managing Data Truncation on Reads

Listing 6-24: Limiting the Number of Rows Returned by a Query

Listing 6-25: Examining the Columns of a Result Set

Listing 6-26: Retrieving Results

Listing 6-27: Catching SQLExceptions

Listing 6-28: Checking SQLWarnings

Listing 6-29: Catching a Data Truncation Exception

Chapter 7: Refining JDBC Queries and Updates

Listing 7-1: Getting Information about the Driver

Listing 7-2: Customized Type Mapping

Listing 7-3: Setting the Map

Listing 7-4: Accessing Data Using a Type Map

Listing 7-5: An Example of SQL DELETEs Grouped in a Transaction

Listing 7-6: Using Transaction Savepoints

Listing 7-7: Distributed Transactions

Listing 7-8: Updating a ResultSet without Using Cursors

Listing 7-9: A Positioned Delete

Listing 7-10: A Positioned Update

Listing 7-11: Performing Batch Updates

Chapter 8: Advanced Techniques

Listing 8-1: Dealing with Stored Procedure Parameters

Listing 8-2: Dealing with Prepared Statement Parameters

Listing 8-3: Sending Very Large Parameters to the Database

Listing 8-4: Using RowSets

Listing 8-5: Using Auto-generated Keys

Chapter 9: Accessing Database Metadata

Listing 9-1: Obtaining Information with DatabaseMetaData Methods

Listing 9-2: A Metadata Method for Discovering the ANSI Compliance Level

Listing 9-3: Metadata about Database Objects

Listing 9-4: ResultSetMetaData: Getting Column Characteristics

Listing 9-5: ParameterMetaData: Getting Column Labels

Listing 9-6: Accessing Parameters of CallableStatements

Chapter 10: Accessing Databases with Enterprise JavaBeans

Listing 10-1: A Stateless Session Bean

Listing 10-2: A Stateless Session Bean Client

Listing 10-3: A Stateful Session Bean

Listing 10-4: Entity Bean with Container-Managed Persistence

Listing 10-5: Entity Bean with Bean-Managed Persistence

Chapter 11: Examples of Java Applications

Listing 11-1: Simple Java ISQL

Listing 11-2: An Interactive SQL Client

Listing 11-3: An Interactive SQL Applet

Listing 11-4: txblob.java

Listing 11-5: Batch Command

Listing 11-6: rxblob.java

Listing 11-7: Airplet.java

Listing 11-8: Airport.java

Listing 11-9: AirportChoice.java

Listing 11-10: ColumnLayout.java

Listing 11-11: Flight.java

Listing 11-12: FlightsPanel.java

Listing 11-13: FlightsVector.java

Listing 11-14: ImageCanvas.java

Listing 11-15: MapCanvas.java

Listing 11-16: MapInfo.java

Listing 11-17: MultilineLabel.java

Listing 11-18: Account.java

Listing 11-19: NetBank.java

Listing 11-20: TimeT.java

Listing 11-21: DDL to Create the Tables for the Bank of Java Applet

Chapter 12: Complex Examples of Java Applications

Listing 12-1: connections.properties

Listing 12-2: AboutBox.java

Listing 12-3: ConnectionBox.java

Listing 12-4: DatabaseConnection.java

Listing 12-5: ErrorBox.java

Listing 12-6: HelpBox.java

Listing 12-7: JDBCExplorer.java

Listing 12-8: Mainframe.java

Listing 12-9: Navigator.java

Listing 12-10: SQLCommandBox.java

Listing 12-11: Car.java

Listing 12-12: CarImpl.java

Listing 12-13: CarFactory.java

Listing 12-14: CarFactoryImpl.java

Listing 12-15: CarSales.java

Listing 12-16: CarSupplierServer.java