JSP Assignment Library catalog Create a web application using JSP, MySQL, and the regular front-end technology stack (HTML, CSS, JavaScript) to allow patrons to interact with your local librarys catalog online. Your application can include client-side JavaScript to make the interface more user-friendly, but it should always perform the necessary server-side validations to protect the integrity of the librarys catalog and inventory. Requirements The librarian has given you the following requirements: The web application should include a log in and sign up page. o Log in page should use a username and password. o Sign up page should require the following fields: first name, last name, username, password, and password confirmation. o There should be a JSP session running to keep track of whether the user is logged in or not. Any user can browse the catalog, regardless of whether theyve signed up or logged in. In other words, there should be no session check on the page that allows browsing of the catalog. o The user should be able to select from a list of topics that filters the books visible on the browsing screen. Filtering by a different topic than the one currently selected should fire off a query to the server - filtering should not be happening in the browser / JavaScript. o If no topic is selected, the page should show all books. o The following information should be shown at a minimum: Book title, book author, whether its available for checkout, and a way to reserve a copy. When they are logged in, users should be able to reserve a copy of their favorite available books from the browse catalog page. If not logged in, the user should still see the button to reserve the copy which will take them to the log in page upon click. There should be a page which allows logged in users to show their list of reserved books. If not logged in, trying to navigate to this page (even via a direct URL) should require the user to log in first. Database structure There is one SQL file attached with the assignment to create the database library_catalog with the following structure:

authors table

Column Name Data Type Required Description

author_id int (10) yes Author ID, primary key

author_name varchar (100) yes Author full name

books table Column Name Data Type Required Description

book_id int (10) yes Book ID, Primary key

subject_id int (10) yes Subject ID

book_name varchar (100) yes Book name

author_id int (10) yes Author ID

is_available tinyint (1) Yes If the book is available or not

reservations table Column Name Data Type Required Description

user_id int (10) yes User ID

book_id Int (10) yes Book ID

topics table Column Name Data Type Required Description

topic_id int (10) yes Topic ID, Primary key

topic_name varchar (200) yes Topic name

users table

Column Name Data Type Required Description

user_id int (10) yes User ID, Primary key

fname varchar (50) yes User first name

lname varchar (50) yes User Last name

username varchar (50) yes Username

password varchar (50) Yes Password