Name the project as Bookstore: Remember to choose Target runtime as Apache Tomcat v8.0 and Dynamic web module version as 3.1 (this is the Java servlet version). Then convert this project to a Maven project by right click on the project, select Configure As you can see, the dependencies here are for Servlet, JSP, JSTL and My SQL connector Java (a JDBC driver for My SQL). The following is code of the object will be passed from a servlet which we will create later.And remember to create a Java package for the project, here we use the package name As you can see, this class has 4 fields according to 4 columns in the table book in database: id, title, author and price. On running, this page looks something like this: As you can see, on this page we have two hyperlinks at the top menu for creating a new book (Add New Book) and showing all books (List All Books). Http Servlet Response; /** * Controller * This servlet acts as a page controller for the application, handling all * requests from the user.Second changes is the do Get() in Controller Servlet.java1.
The application looks something like this: You will learn to how to build this application using the following technologies: CREATE DATABASE 'Bookstore'; USE Bookstore; CREATE TABLE `book` ( `book_id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(128) NOT NULL, `author` varchar(45) NOT NULL, `price` float NOT NULL, PRIMARY KEY (`book_id`), UNIQUE KEY `book_id_UNIQUE` (`book_id`), UNIQUE KEY `title_UNIQUE` (`title`) ) ENGINE=Inno DB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 Dynamic Web Project to create a new Java dynamic web project. Next, create a JSP page for displaying all books from the database. Http Servlet Response;import *; /** * @author Vishal.