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.

User review
The Worst Technical Book I've Ever Bought
This is without a doubt the worst technical book I have ever bought.

Some of the problems stem from the fact that most of the packages used are now out of date. Case in point: the book walks through the installation & configuration of Turbine (which is used for connection pooling), unfortunately the connection pooling part of Turbine has now been branched off into another project (and Tomcat now includes standard J2EE connection pooling anyway).

The other major problem is that a nearly every instance of example code is either sloppy and badly edited, or in some cases plainly doesn't even work without serious debugging.

If you must buy this book, don't even think about trying to follow the core example application without first downloading the source-code from the authors website. You WILL be needing it, even if only to 'fill in the blanks' from the poor instructions, and to help find the coding errors.

In conclusion, I would never recommend this book to anyone - even another experienced programmer trying to add JSP/Servlets to their repertoire.

Do yourself a favour, buy Murach's book instead.

User review
Why would anyone give this book 5 stars
I have read this book from cover to cover and used many of the examples in some of my development. There are errors in the editing to be sure. For the most part most are minor e.g. links that end with .htm instead of .html will not work or if you create the database in mySQL, in my case on a Linux platform there are errors you will run into. These errors are limited to making sure you observe the case of the letters in creating and quering your database. This book is not for the beginner. It teaches a systematic approach to building an ecommerce web site using jsp's and mysql. The reason for the 5 star rating is this book makes you go out of the box to learn ant, turbine and other opensource packages to build a working e-commmerce web site. Personally I do not like to put java code int an html page = jsp's ,,. but this book offers sound eamples and good advice. One of the better practical but certainly not perfect books I've bought.

User review
Poorly edited
I was encouraged when I first started reading this book, but soon I grew disappointed. The book is peppered with useful tips here and there, but in general it's too linear, as an earlier review mentioned. The book is more of a recipe for a web app than a general guide, and it wastes too much space on design process. But worse than that, it is fraught with errors, as if edited by someone who didn't understand the material. Letters have been dropped from words, referenced figures don't show what the referencing text says, there are errors in XML examples. A funny example is on the `In This Chapter` sidebar on the opening page of Chapter 2 where one of the bullet items is `Bean Resistence`. More power to the beans! He meant `Bean Persistence`, but hey, if you're going to get it wrong, at least spell it right. :)

User review
Some valid information but stays strict to Turbine
I picked up this book as a reference for integrating our PHP and MySQL designs with JSP pages. However the author sticks to a single fundamental method of JSP development for MySQL which is using Apache's Jakarta Turbine classes. No information is given as to the other mechanisms available to utilize MySQL with Java such as MySQL Connector/J or Resin JDBC. I believe this book is a very shortsighted approach to the many tools available in the Java and JSP world. I think the Turbine approach is fine, but should maybe have been a later chapter not most of the book. We developed our entire web site without the use of Turbine.

Some discussion is given to strategies with JNDI and LDAP, as well as EJB. There is also a healthy discussion of XML which I believe would be better suited for an XML book, but serves as nothing more than filler here, which could have been used to expand upon the other methods of JDBC.

I would have given this book three stars, but several errors in the code examples always bring down quality by at least one star. I expect a book written by a developer for the purpose of instruction to be error free in all code examples.

All in all the book appears to be a step by step tutorial to building a program according to the developer's linear scheme, rather than a comprehensive discussion of all the options available to a JSP/Servlet developer integrating with MySQL. Sadly this really is the only book available on the subject at this time.

User review
What the Doctor Ordered!
If you are using the Tomcat, MySQL, JSP configuration, this book is the absolute perfect marriage of these technologies. It covers every aspect of the implementation. It is required, however, that you do have a little background in 1 or more of these technologies. The examples are excellent and at times the book is a lighthearted read. Kudos to the author.