Objective: To build a partial functionality of $$Online Bookstore$$ using Java Server Pages $($JSP$).$ Thus, you

are required to create a web application where users can browse and search for books. You need to full

fill the following requirements:

Phase $2$: In this phase, you are required to complete the Backend Functionality enhancements that

fulfill:

$$ Java Servlet & JDBC classes.

$$ Allow users to search for books by title, author, or category.

The Backend Functionality contains the full backend functionality that utilizes JDBC with Oracle DBMS

and Java EE servlets.

$$ Implement a Java Servlet to handle book search requests i$.$e$.$ to fetch a list of books from a

database.

$$ Notes:

$$ Include Javadoc and documentation explaining the functionality of all components such as JSP

pages or classes.

$$ Enforce or utilize the implementation of some design patterns.

$$ Include the SQL script for creating the tables and inserting a couple of records into the DB table.

$$ Provide instructions or a Readme file on how to deploy the application to Apache Tomcat

servlet container.