Java Reference
In-Depth Information
Figure 11-2:
Structure of Web site developed in Chapters 11-16
The member login and registration process involves displaying HTML forms and processing their input.
The examples use both servlet and Java Server Page approaches using JavaBeans to encapsulate
logic functions. In addition to handling simple text-based forms,
Chapter 14
shows you how to upload
images from a browser page and store them in a database.
Having reviewed the functional requirements of the application, you are ready to design the database.
The design of the database for this application is discussed in the
next section
.
Cross-
Reference
The theoretical aspects of database design, are discussed in
Part I
. It is
particularly important to understand the use of primary anf foreign keys, as
well as the Normal Forms. Both of these topics are discussed in
Chapter 2
.
Designing the Database
As a catalog site, the sample application has to support the basic functionality common to most
commercial catalog sites. The primary functions supported include the following:
Handling member logins
Member registration
Data entry
Site search, with a summary display capability
Detailed display of database items
Database-driven e-mail using the JavaMail API
The examples don't get into secure sockets and payment handling because those topics are not really
database related. The subject of this chapter is the overall design of the Web site and the underlying
database.
Handling Member Logins
Users are first required to respond to a login-request form, with the usual user name and password
combination. There are three possible outcomes to a login attempt:
Successful login with the correct username and password, permitting site access
Failed login attempt with a valid user name but an invalid password
Failed login attempt with an invalid user name
