Verizon Interview -
Context: Online book store which can insert, update, delete and display data in the Front end Web application.
Process steps :
Create a MYSQL Database Bookstore with a table Book: Bookstore.sql in the repo gives the syntax. Create a Book Class file in java that defines the entity Create a Data Access Layer Which is BookDAO in this case. Create a supporting JSP files BookForm, BookList and Error are created here.
Files uploaded :
Actual Project files. War Files. a zip file for convenient download and run in an Eclipse IDE
Requirements for windows :
- MySQL Database : https://dev.mysql.com/downloads/installer/
- Eclipse Neon for J2EE : http://www.eclipse.org/downloads/download.php?file=/technology/epp/downloads/release/neon/R/eclipse-jee-neon-R-win32-x86_64.zip
- Apache Tomcat Server V8.0 : https://tomcat.apache.org/download-80.cgi
- Maven Dependencies : -javax.servlet-api-3.1.0.jar -javax.servlet.jsp-api-2.3.1.jar -jstl-1.2.jar -mysql-connector-java-5.1.30.jar
Run the project on Tomcat server - Thats it - Welcome to the book store.