JSP ASSIGNMENT TO CREATE A web application

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.

REQUIRED FILES ARE FOUND AT : https://1drv.ms/f/s!Aq7fVo53uNoPatZsJnK9a2v6tLg

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

The final project should be run through netbeans and should look like the attached mp4 file