Table of content

I l @ ve RuBoard

	Table of Contents
	Index

MySQL and JSP Web Applications: Data-Driven Programming Using Tomcat and MySQL
By James  Turner
Publisher	: Sams Publishing
Pub Date	: March 27, 2002
ISBN	: 0-672-32309-5
Pages	: 400

		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 ResultSet s
				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

I l @ ve RuBoard