Java Reference
In-Depth Information
The examples concentrate on the servlets and JSPs, and the JavaBeans encapsulating the business
logic. These examples also illustrate various aspects of the JDBC Extension API.
Cross-
Reference
One of the strengths of JDBC is that it is designed to plug and play with
virtually any relational database management system with a minimum of
effort. The use of different relational database management systems is
discussed in
Part II
, with extensive examples in
Chapter 10
.
The first step in designing the Web site is to define the functionality of the site and to design the
underlying database. Designing the database around the Web pages it supports makes the Java code
simpler and faster to implement. The functional requirements of the membership Web site application
are discussed in the
next section
.
Functional Requirements
The following chapters describe a membership web site that allows members to auction their vehicles
over the Internet. The main reason for choosing this theme is to exploit the opportunities it provides to
discuss the following important JDBC topics in the context of practical examples:
HTML form handling with servlets, JSP, and JDBC
Using scrollable
ResultSets
in a search engine
Using updatable
ResultSets
to allow a member to call up and modify his or her profile
Handling image upload, storage, and retrieval using HTML forms and blobs
Using the JavaMail API with JDBC to send and receive e-mail
The use of XML and XSLT to create different Web pages from the same
ResultSet
is also discussed
in the context of using updateable
ResultSets
to display data in one format and edit it in another
format. The examples in
Part IV
discuss the use of XML with JDBC in more detail.
The sample application supports the functionality common to most commercial catalog sites as well as
the normal features of a membership site. These include the following:
Member login
New member registration
Member data entry
Upload and storage of large objects such as images
Site search
Summary page display, with thumbnail photos
Links from the summary pages to detail pages
Automated email support
The best way to understand the logical structure of the Web site is to use a block diagram. The logical
structure of the Web site discussed in Chapters 11 through 16 is illustrated in
Figure 11-2
.