Books and Authors Java Web App

Objective

To develop skills to design and develop web applications which can interact with databases.

Problem

In Class5-2 Exercise, we developed a book-author database "bookauthordb" using MySQL localhost server and learned to develop java applications that can interact with the database. Using book-author database, develop a web application that can list the authors and books in the database.

Application View

The application view consists of 3 pages

• Index page
• List of Authors page
• List of Books page

The Index page

Index page should be an entry point for the application. It should have two links: list authors and list books. List-authors link should display first name and last name of each author in the database and list-books link should display title of the book, its author(s), and ISBN for each book in the database.

List of Authors page

List of Authors page should display first name and last name of each author in the database with column headers and proper formatting.

The page should have a link that takes back to the entry page of the application.

List of Books page

List of Books page should display title of the book, its author(s), and isbn for each book in the database with column headers and proper formatting.

The page should have a link that takes back to the entry page of the application.

Application Requirements Specification

• Use MVC design pattern to architect the application.
• Business logic classes to process author and book objects
• Database interaction classes to interact with the database
• Controller classes to process users requests.