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.