Java Reference
In-Depth Information
Database-Driven E-mail
The detail page includes a text area that allows the user to send an e-mail to the owner of the vehicle.
E-mails are handled through a JavaMail application, which obtains the sender and recipient information
from the database and forwards the message.
The final chapter of
Part III
of this topic illustrates the use of JDBC with the JavaMail API. The
combination of JDBC and JavaMail lets you send e-mails to members automatically. It also allows you
to receive e-mails and save them directly to a database.
Summary
This chapter provides an overview of the design of a three-tier, database-driven Web site application.
The object of the chapter is to review practical aspects of the application in terms of the way the
database tables relate to the pages the user views. In addition, the chapter looks at the following topics:
Using primary and foreign keys
Using indexes for better performance
Chapter 12
discusses Java servlets and JSP pages and how to use them to handle HTML forms.
Subsequent chapters expand this base to discuss much of the JDBC Extension API.