MySQL and JSP Web Applications: Data-Driven Programming Using Tomcat and MySQL

Overview

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 ...

See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (16) from $1.99   
  • New (5) from $24.99   
  • Used (11) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$24.99
Seller since 2009

Feedback rating:

(10832)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
New Book. Shipped from UK within 10 to 14 business days. Established seller since 2000.

Ships from: Secaucus, NJ

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$28.83
Seller since 2008

Feedback rating:

(18036)

Condition: New
Brand New, Perfect Condition, Please allow 4-14 business days for delivery. 100% Money Back Guarantee, Over 1,000,000 customers served.

Ships from: Westminster, MD

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
$28.84
Seller since 2007

Feedback rating:

(23698)

Condition: New
BRAND NEW

Ships from: Avenel, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
$52.85
Seller since 2014

Feedback rating:

(6)

Condition: New
New

Ships from: Idyllwild, CA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$57.00
Seller since 2010

Feedback rating:

(11)

Condition: New
3-27-02 other 1 BRAND NEW! ONLY Expedited orders are shipped with tracking number! *WE DO NOT SHIP TO PO BOX* Please allow up to 14 days delivery for order with standard ... shipping. SHIPPED FROM MULTIPLE LOCATIONS. Read more Show Less

Ships from: San Jose, CA

Usually ships in 1-2 business days

  • Canadian
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

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.

Read More Show Less

Product Details

  • ISBN-13: 9780672323096
  • Publisher: Sams
  • Publication date: 4/28/2002
  • Series: Kaleidoscope Series
  • Pages: 560
  • Product dimensions: 7.32 (w) x 9.05 (h) x 1.26 (d)

Meet the Author

James Turner is the manager of Black Bear Software, LLC. He has more than 22 years of experience in the computer field and has worked for organizations that include MIT, Xerox, Solbourne Computer, BBN Planet, and Interleaf. He has spent the last seven years managing and implementing e-commerce Web sites for companies including CVS, The Christian Science Monitor, and Woolworths UK.

Mr. Turner is also a well-published freelance journalist and technology writer who has written for publications including The Christian Science Monitor, WIRED, and Web Developers Journal. He lives in Derry, New Hampshire, in a 200-year-old colonial farmhouse along with his wife and son.

Read More Show Less

Table of Contents

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. Stubbing Out Taxes and Shipping. Finalizing the Order. Final Confirmation. The Last Mile.

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.

IV. ADVANCED JSP TOPICS.

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.

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.

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.

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.

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.

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.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)