MySQL and JSP Web Applications - Data-Driven Programming Using Tomcat and MySQL - James Turner

MySQL and JSP Web Applications - Data-Driven Programming Using Tomcat and MySQL - James Turner - 2002.
   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.


Copyright
About the Authors
Acknowledgments
Tell Us What You Think!
An Introduction to Developing E-Commerce Applications with JSP
Who Are You and Why Are You Reading This Book?
So What Is JSP All About?
An Overview of JSP Platforms
Why Do We Need Databases?
MySQL
Putting Tomcat and MySQL Together
A Roadmap to E-Commerce Development
The Next 17 Chapters

Part I.  JSP and JDBC
Chapter 1.  A JSP/JDBC Review
How Does JSP Work
Running Tomcat
Finding the Java Sources
A Quick Look at JDBC and MySQL
Working with ResultSets
Using PreparedStatement
Inserting, Deleting, and Updating
Using Cursors
Summary

Chapter 2.  Java Beans and JSP
Bean Basics
Bean Persistence
Application-Scoped Object and Singleton Classes
Wrapping Up Beans

Chapter 3.  Using Servlet Functionality with JSP
Moving from CGI to Servlets
Looking at an Example Servlet
The End of the Beginning


Part II.  Sample Application: Functional Requirements
Chapter 4.  The Sample Application Functional Requirements Document
Welcome to Books for Geeks
A High-Level View
Diving into Design
Summary

Chapter 5.  Developing ERDs and Use Cases
The Entity Relation Diagram
Mining High-Level Use Cases Descriptions for Objects
The User Class
The Product Class
The Shopping Cart and Order Classes
Use Cases
Moving Ahead
Summary

Chapter 6.  Creating the Database Schema and Populating Data
The Fading Role of the DBA
Building a Database Schema
The Database from 20,000 Feet
Summary


Part III.  Sample Application: Implementation
Chapter 7.  Setting Up an Application's Infrastructure
Build Management
Logging and Database Connection Pooling
Configuring Turbine
Using Turbine Connection Pooling
Using Log4J
Customizing Log4J
Getting Ready to Code
Summary

Chapter 8.  Retrieving, Storing, and Verifying User Input
The Customer Class
Reading and Writing Customers from the Database
Cleaning Up the Code
Accessing the Customer Class from JSP
Field Validation
Handling Forgotten Passwords
Using Cookies to Store Login
Moving On

Chapter 9.  Publishing Data from Database Sources
Looking at the Default Document Structure
The Document Structure in Practice
The Product and Category Classes
The Author Object
The Category Class
Cleaning Things Up
Summary

Chapter 10.  Session Persistence and Complex Form Handling
Implementing the Shopping Cart
Buying More Than One Thing at Once
Displaying and Editing the Shopping Cart
Loose Ends
The Next Step: Filling and Spilling

Chapter 11.  Intersession Persistence
Filling and Spilling
The Address Book
Credit Cards and the Wallet
Time to Get Down to Business

Chapter 12.  Implementing Business Logic
Today Only! Buy One, Get One Free!
Implementing Promotions
Stubbing Out Taxes and Shipping
Finalizing the Order
Final Confirmation
The Last Mile

Chapter 13.  Completing the Application
Charging the Credit Card
About Credit Cards
Completing the Order
Order History
In Retrospect
Next Steps for the Site
Dotting the I's and Crossing the T's
Making It Turn-Key
Resetting to a Clean State
Summary, and on to the Advanced Stuff


Part IV.  Advanced JSP Topics
Chapter 14.  Integrating XML into e-Commerce Web Sites
The Benefits of XML
The Xerces XML Package
A DTD for Products
Writing a SAX Parser
Writing a DOM Parser
Generating XML
Summary

Chapter 15.  Using LDAP with JNDI
The World of LDAP
The LDAP Schema
Getting LDAP'ed
JNDI
Testing LDAP Reading
Testing LDAP Creation
Trying Out LDAP Modification
Running a Search Against LDAP
Creating Your Own Schemas
Summary

Chapter 16.  The Struts Application Framework
The MVC Pattern
A First Look at Struts
Setting Up Struts
The struts-config.xml File
The ActionForm
The Action
The Address Editing Page
Two-Step Forms
Configuring the Web Application Descriptor
Summary

Chapter 17.  Enterprise JavaBeans
The Pros and Cons of EJB
EJB in 30 Seconds
Stateless, Stateful, and Entity Beans
Setting Up JBoss
Creating a Stateless Session Bean
Being Stateful
Talking to MySQL with Entity Beans
A Final Goodbye to EJB

Chapter 18.  Security, Load Balancing, Failover, and Other Considerations
Security, Part 1
Integrating with Apache
Load Balancing
Writing Applications for Multimachine Service
The Failover Fallacy
Database Tuning
Security, Part 2 (SSL)
The End of the Book


Part V.  Appendixes
Appendix A.  Getting and Installing JDK, Ant, and Tomcat
Installing JDK Under Windows
Installing JDK Under Linux
Installing Ant Under Windows
Installing Ant Under Linux
Installing Tomcat Under Windows
Installing Tomcat Under Linux

Appendix B.  Getting and Installing MySQL and JDBC for MySQL
Installing MySQL on Windows
Installing MySQL Under Linux
Permissions and Security Under MySQL
Installing JDBC Support for Tomcat

Appendix C.  A Books for Geeks Quickstart
Installing the Books for Geeks Example in Windows
Installing the Books for Geeks Example in Linux
Index