Java Reference
In-Depth Information
Part II: Using JDBC and SQL in a
Two-Tier Client/Server Application
Chapter List
Chapter 5
: Creating a Table with JDBC and SQL
Chapter 6
: Inserting, Updating, and Deleting Data
Chapter 7
: Retrieving Data with SQL Queries
Chapter 8
: Organizing Search Results and Using Indexes
Chapter 9
: Joins and Compound Queries
Chapter 10
: Building a Client/Server Application
Part Overview
Part II
expands the overviews of
Part I
by presenting a series of application examples that cover two
major topics in depth: The JDBC core API and SQL basics. These topics are covered in the context of
a series of Swing-based desktop applications. Each chapter starts with a detailed discussion of a
major element of the SQL language, followed by a presentation of a JDBC application using the SQL
commands discussed.
Individual chapters are dedicated to using basic SQL commands to create, populate, and query
databases, as well as to using the various SQL operators to build more complex queries. The Java
examples use the JDBC core API to connect to a database and execute the SQL commands.
Another chapter is devoted to showing how to perform SQL joins and compound queries. Inner and
outer joins, self-joins, and unions are discussed, as are ordering and grouping the results of these
joins.
The final chapter in
Part II
brings together the examples in the previous chapters to create a Swing GUI
that can be used as a control panel for any database system. This chapter goes on to explain how
JDBC can be used with any RDBMS system by simply plugging in the appropriate drivers. The
examples compare the effects on performance of plugging in a commercial pure Java driver in place of
Sun's JDBC-ODBC bridge.
