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



JDBC 3. 0. JAVA Database Connectivity
JDBC 3: Java Database Connectivity
ISBN: 0764548751
EAN: 2147483647
Year: 2002
Pages: 148

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net