Shopping Cart Application

Alton and Dave have teamed up to create an online store.

Your assignment

Your job is to find ten products for them to sell. Create a database for those products.

Next, create a dynamic web application using JPA to serve as a shopping cart for their online store.

Your application should allow the user to view a list of products. Pictures are recommended. If you include pictures then include just the filename or url in the database and not the binary image.

The user should be able to select a product and add it to the shopping cart.

Each product should contain a name, description and price and any other information you want to add. The products must be stored in the database.

After the application is complete you will be adding a new product and removing a product from the database. This change should not break your application.

The user should be able to browse the list, see product details and add the product to their cart. Then the user can go back to the list and shop more. Or the user can go to the cart to checkout.

You should have the following pages:

• Product List Page
• Product Details Page
• Shopping Cart Page that shows all the items in the shopping cart
• Order Confirmation that shows the total amount of the items ordered

The order confirmation page should display a summary of the order.

Consider what code you can reuse from your previous project.

Be sure to include the sql scripts in your project. Another user should be able to clone your application from GitHub. The included sql scripts should create the tables and test data.