MySQL and JSP Web Applications: Data-Driven Programming Using Tomcat and MySQL
JSP developers encounter unique problems when building web applications that require intense database connectivity. MySQL and JSP Web Applications addresses the challenges of building data-driven applications based on the JavaServer Pages development model. MySQL and JSP Web Applications begins with an overview of the core technologies required for JSP database development--JavaServer Pages, JDBC, and the database schema. The book then outlines and presents an Internet commerce application that demonstrates concepts such as receiving and processing user input, designing and implementing business rules, and balancing the user load on the server. Through the JDBC (Java DataBase Connector), the developer can communicate with most commercial databases, such as Oracle. The solutions presented in MySQL and JSP Web Applications center on the open source tools MySQL and Tomcat, allowing the reader an affordable way to test applications and experiment with the book's examples.
Table of Contents
An Introduction to Developing E-Commerce Applications with JSP.
I. JSP AND JDBC.
1. A JSP/JDBC Review.
2. Java Beans and JSP.
3. Using Servlet Functionality with JSP.
II. SAMPLE APPLICATION: FUNCTIONAL REQUIREMENTS.
4. The Sample Application Functional Requirements Document.
5. Developing ERDs and Use Cases.
6. the Database Schema and Populating Data.
III. SAMPLE APPLICATION: IMPLEMENTATION.
7. Setting Up an Application's Infrastructure.
8. Retrieving, Storing, and Verifying User Input.
9. Publishing Data from Database Sources.
10. Session Persistence and Complex Form Handling.
11. Intersession Persistence.
12. Implementing Business Logic.
13. Completing the Application.
IV. ADVANCED JSP TOPICS.
14. Integrating XML into E-Commerce Web Sites.
15. Using LDAP with JNDI.
16. The Struts Application Framework.
17. Enterprise JavaBeans.
18. Security, Load Balancing, Failover, and Other Considerations.
Appendix A. Getting and Installing JDK, Ant, and Tomcat.
Appendix B. Getting and Installing MySQL and JDBC for MySQL.
Appendix C. A Books for Geeks Quickstart.