List of Figures

Chapter 2: Database Fundamentals

Figure 2-1: The typical client/server architecture with a DBMS.

Figure 2-2: The two-tier architecture.

Figure 2-3: The three-tier architecture.

Figure 2-4: The four ODBC components.

Chapter 3: Integrating Databases with JDBC

Figure 3-1: Java clients running on different platforms.

Figure 3-2: JDBC is located on the client side.

Figure 3-3: The JDBC-ODBC Bridge driver.

Figure 3-4: Native API, partly Java drivers.

Figure 3-5: The Net driver.

Figure 3-6: Native-protocol, all-Java drivers.

Figure 3-7: The complete JDBC architecture.

Chapter 5: Getting Started with JDBC

Figure 5-1: The JDBC APIs.

Figure 5-2: Actions performed on the client and DBMS sides.

Figure 5-3: The relationship between the main JDBC interfaces.

Figure 5-4: An applet communicating with a server.

Figure 5-5: Three-tier design.

Figure 5-6: The parts of a standalone Java application.

Chapter 6: Database Connectivity, Step by Step

Figure 6-1: An overview of the connection.

Figure 6-2: JDBC mechanism to name a data source.

Figure 6-3: Overview: Building a SQL statement.

Figure 6-4: Sending a SQL statement.

Figure 6-5: An overview of sending a SQL statement.

Figure 6-6: An overview of getting the result set.

Figure 6-7: The next() method is used to scan a result set.

Figure 6-8: An overview of accessing columns.

Figure 6-9: Accessing columns with getXXX().

Figure 6-10: An overview of managing multiple result types.

Figure 6-11: An overview of all the steps for communicating with a database.

Chapter 7: Refining JDBC Queries and Updates

Figure 7-1: The cursor mechanism.

Chapter 8: Advanced Techniques

Figure 8-1: Invoking a stored procedure.

Figure 8-2: An overview of dealing with parameters.

Figure 8-3: Sending a static statement.

Figure 8-4: Sending parameters to a prepared statement.

Figure 8-5: An overview of prepared statements.

Chapter 9: Accessing Database Metadata

Figure 9-1: Processing methods that return a ResultSet.

Chapter 11: Examples of Java Applications

Figure 11-1: The ISQL standalone application.

Figure 11-2: The ISQL applet.

Figure 11-3: Executing SQL statements.

Figure 11-4: Connect Software’s JDBC Airlines applet.

Figure 11-5: The JavaBank applet login screen.

Figure 11-6: The JavaBank applet account balance.

Figure 11-7: The JavaBank applet transfer screen.

Figure 11-8: The JavaBank applet cash withdrawal.

Chapter 12: Complex Examples of Java Applications

Figure 12-1: The JDBCExplorer main window.

Figure 12-2: Supplying login data.

Figure 12-3: The main navigation control widget.

Figure 12-4: Database specifications.

Figure 12-5: Database catalog nodes.

Figure 12-6: Table objects.

Figure 12-7: Columns.

Figure 12-8: Primary keys.

Figure 12-9: An Interactive SQL tool.

Figure 12-10: A SQLException message window.

Figure 12-11: JDBCExplorer help.

Figure 12-12: The JDBCExplorer About box.

Figure 12-13: The three-tiered architecture of the car factory example.

Figure 12-14: The RMI client window.