Recreate Programming Project as JSP pages instead of as a stand-alone application. One JSP...

Recreate Programming Project as JSP pages instead of as a stand-alone application. One JSP page should create the database, tables, and populate the tables with data. Create an HTML form that allows the user to enter the name of an author. The form should invoke another JSP page that displays all titles written by the specified author that are stored in the database.

Programming Project

Visit www.myprogramminglab.com to complete select exercises online and get instant feedback.

Exercise

The program in Display 1 creates a database with the Names table from Display 2. Modify this program so it also creates the Titles and BooksAuthors tables with identical data entries as shown in Display 2. Next, create a separate program that prompts the user to input the name of an author and then outputs all book titles written by that author.

Display 1 Creating a Derby Embedded Database and Table (part 1 of 2)

Display 1 Creating a Derby Embedded Database and Table (part 2 of 2)

Display 2 Relational Database Tables