You will finish an e-commerce web based application using Java and its related technologies. Please follow the instructions below for your final exam project. 1. Use MySQL as your database. You are provided with a console application that connects to an online MySQL server and queries the database with read and write operations. Adapt this your web based application. If you have any relational database system on your local machine, that should be fine to use. Or you can create an account on a free online database server (make sure it is relational). 2. Use Java Servlets as your controller (of the MVC model). 3. User should be able to login to your web based application. The credential should be checked against your MySQL user login info. 4. Successful login should create a session for the customer. The customer name should be displayed on pages as long as the session is going on. Once the user logs out the page should show the information "not logged in". 5. Customer's shopping cart should be created once the user logs in and his/her purchases should be saved in the shopping cart. 6. The products that you are selling should be stored in the database and listed once the user goes to the products page. 7. Clicking on an item (on the list of products page) should bring the details of the products (its image, name, description, quantity and price) where the customer can add this product to his/her shopping cart. 8. Any time the user should be able to go to his/her shopping cart and complete the purchase which updates the quantities of the products in the database. 9. You should use a listener and a filter for your application. 10. JSP should be used for views (MVC) which should contain NO Java code, that is, use only JSP expression language and standard tag library (and of course HTML) in your JSP pages. Deliverable: The screen shots and all your files. Should be a zip file. To finalize your final exam grade we will hold zoom meeting with each group. You will finish an e-commerce web based application using Java and its related technologies. Please follow the instructions below for your final exam project. 1. Use MySQL as your database. You are provided with a console application that connects to an online MySQL server and queries the database with read and write operations. Adapt this your web based application. If you have any relational database system on your local machine, that should be fine to use. Or you can create an account on a free online database server (make sure it is relational). 2. Use Java Servlets as your controller (of the MVC model). 3. User should be able to login to your web based application. The credential should be checked against your MySQL user login info. 4. Successful login should create a session for the customer. The customer name should be displayed on pages as long as the session is going on. Once the user logs out the page should show the information "not logged in". 5. Customer's shopping cart should be created once the user logs in and his/her purchases should be saved in the shopping cart. 6. The products that you are selling should be stored in the database and listed once the user goes to the products page. 7. Clicking on an item (on the list of products page) should bring the details of the products (its image, name, description, quantity and price) where the customer can add this product to his/her shopping cart. 8. Any time the user should be able to go to his/her shopping cart and complete the purchase which updates the quantities of the products in the database. 9. You should use a listener and a filter for your application. 10. JSP should be used for views (MVC) which should contain NO Java code, that is, use only JSP expression language and standard tag library (and of course HTML) in your JSP pages. Deliverable: The screen shots and all your files. Should be a zip file. To finalize your final exam grade we will hold zoom meeting with each group