Developing a Category Hierarchy View Applet

We will now develop a tree view for viewing all the categories in the Web site. These categories are stored within the database, and you can reuse the GetCategoryHierarchyCommand to retrieve all the Category instances.

There are problems, however, with using the command bean or even a JDBC statement within an applet. An applet is executed on the client's machine, and the URL used for making the JDBC connection within the command bean, jdbc:odbc: AUCTION or jdbc:db2:AUCTION, may not be valid. The reason for this could be either that there is no jdbc:odbc:AUCTION connection configured in the ODBC user data source or the database server is not visible from the machine.

There are several approaches ...

Get Java Server Pages from scratch now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.