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.
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.
I. JSP AND JDBC.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.2. Java Beans and JSP.
Bean Basics. Bean Persistence. Application-Scoped Object and Singleton Classes. Wrapping Up Beans.3. Using Servlet Functionality with JSP.
Moving from CGI to Servlets. Looking at an Example Servlet. The End of the Beginning.
II. SAMPLE APPLICATION: FUNCTIONAL REQUIREMENTS.4. The Sample Application Functional Requirements Document.
Welcome to Books for Geeks. A High-Level View. Diving into Design. Summary.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.6. the Database Schema and Populating Data.
The Fading Role of the DBA. Building a Database Schema. The Database from 20,000 Feet. Summary.
III. SAMPLE APPLICATION: IMPLEMENTATION.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.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.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.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.11. Intersession Persistence.
Filling and Spilling. The Address Book. Credit Cards and the Wallet. Time to Get Down to Business.12. Implementing Business Logic.
Today Only! Buy One, Get One Free! Implementing Promotions.
The author has set up an errata page on his web site at www.blackbear.com/errata.html.