Question: Create a shopping cart application The application must do the following: List products for sale User can add products to a shopping cart (We can

 Create a shopping cart application The application must do the following:
List products for sale User can add products to a shopping cart
(We can hardcode the user, no need for Spring Security) A User
can update quantities of a particular object in their shopping cart A

Create a shopping cart application

The application must do the following:

List products for sale

User can add products to a shopping cart (We can hardcode the user, no need for Spring Security)

A User can update quantities of a particular object in their shopping cart

A User can checkout (which will turn a shopping cart into an order and associated order items).

A user can view their shopping cart

A user can view previous orders

A user can view a particular order and see its order items.

An Admin can add products (since there is no actual security, simply put admin functions behind the /admin url. An example might be /admin/productsew).

An Admin can delete products

An admin can update products

An admin canadd product tvpes

An admin can view all orders in the system.

Main Data Types create table countries (

id int auto increment primary key, name varchar (60)

create table users (

id bigint auto increment primary key, first name varchar (60) last name varchar (60) , username varchar (60) , email varchar (80), password varchar (20) , country_ id bigint

create table product types (

id bigint auto increment primary key, type name varchar (40)

create table products (

id biaint auto increment primary key, sku varchar (30), name varchar (60) ,

description varchar (255), product_type _id bigint, price numeric

create table shopping cart (

id bigint auto increment primary key, product id bigint, quantity int, customer id bigint

create table orders (

id bigint auto increment primary key, order date datetime,

credit card last four varchar (4), customer id bigint, order amount numeric, tax numeric, shipping numeric

create table order items (

id bigint auto increment primary key order id bigint, product id bigint, quantity int, price numeric

Notes

Use the H2 in Memory Database. Go ahead and pre-populate some of the database tables like Users, Products, Product Types, old Orders and associated order items.

Use a simple web interface with either Thymeleaf or JSPs. It doesn't have to be fancy or use sophisticated JavaScript.

User can checkout (which will turn a shopping cart into an order
and associated order items). A user can view their shopping cart A
user can view previous orders A user can view a particular order
and see its order items. An Admin can add products (since there
is no actual security, simply put admin functions behind the /admin url.

Tre usplatest nuatdo ise Maxein: Litpraducts ferme A tho Griak ther shopare ant. A me unas pedon vas An ianin sas aute prodest An abrin catidaute protiati An adain can wew sil ersers in the powten. Haie fale iveien Fioges. sophatieate: iavalariyt. Crecte ashossire cart aosication litpotentiferin zwe an ikw phista e dari Awe canse panicar wer assint b ote ares Ae Adrin can dibtepatan Bait Bale tian awen Create a shopping cart application The application must do the following: List products for sale User can add products to a shopping cart (We can hardcode the user, no need for Spring Security) A User can update quantities of a particular object in their shopping cart A User can checkout (which will turn a shopping cart into an order and associated order items). A user can view their shopping cart A user can view previous orders A user can view a particular order and see its order items. An Admin can add products (since there is no actual security, simply put admin functions behind the /admin url. An example might be /admin/productsew). An Admin can delete products An admin can update products An admin canadd product types An admin can view all orders in the system. Main Data Types Notes Use the H2 in Memory Database. Goahead and pre-populate some of the database tables like Users, Products, Product Types, old Orders and associated order items. Use a simple web interface with either Thymeleaf or JSPs. It doesn't have to be fancy or use sophisticated JavaScript. Create a shopping cart application The application must do the following: List products for sale User can add products to a shopping cart (We can hardcode the user, no need for Spring Security) A User can update quantities of a particular object in their shopping cart A User can checkout (which will turn a shopping cart into an order and associated order items). A user can view their shopping cart A user can view previous orders A user can view a particular order and see its order items. An Admin can add products (since there is no actual security, simply put admin functions behind the /admin url. An example might be /admin/productsew). An Admin can delete products An admin can update products An admin can add product types An admin can view all orders in the system. Main Data Types sku varchar (30), name varchar (60), description varchar (255), product type id bigint, price numeric ;: create table shopping cart, ( id bigint auto increment primary key, product id bigint, quantity int, customer id bigint Notes Use the H2 in Memory Database. Go ahead and pre-populate some of the database tables like Users, Products, Product Types, old Orders and associated order items. Use a simple web interface with either Thymeleaf or JSPs. It doesn't have to be fancy or use sophisticated JavaScript. Tre usplatest nuatdo ise Maxein: Litpraducts ferme A tho Griak ther shopare ant. A me unas pedon vas An ianin sas aute prodest An abrin catidaute protiati An adain can wew sil ersers in the powten. Haie fale iveien Fioges. sophatieate: iavalariyt. Crecte ashossire cart aosication litpotentiferin zwe an ikw phista e dari Awe canse panicar wer assint b ote ares Ae Adrin can dibtepatan Bait Bale tian awen Create a shopping cart application The application must do the following: List products for sale User can add products to a shopping cart (We can hardcode the user, no need for Spring Security) A User can update quantities of a particular object in their shopping cart A User can checkout (which will turn a shopping cart into an order and associated order items). A user can view their shopping cart A user can view previous orders A user can view a particular order and see its order items. An Admin can add products (since there is no actual security, simply put admin functions behind the /admin url. An example might be /admin/productsew). An Admin can delete products An admin can update products An admin canadd product types An admin can view all orders in the system. Main Data Types Notes Use the H2 in Memory Database. Goahead and pre-populate some of the database tables like Users, Products, Product Types, old Orders and associated order items. Use a simple web interface with either Thymeleaf or JSPs. It doesn't have to be fancy or use sophisticated JavaScript. Create a shopping cart application The application must do the following: List products for sale User can add products to a shopping cart (We can hardcode the user, no need for Spring Security) A User can update quantities of a particular object in their shopping cart A User can checkout (which will turn a shopping cart into an order and associated order items). A user can view their shopping cart A user can view previous orders A user can view a particular order and see its order items. An Admin can add products (since there is no actual security, simply put admin functions behind the /admin url. An example might be /admin/productsew). An Admin can delete products An admin can update products An admin can add product types An admin can view all orders in the system. Main Data Types sku varchar (30), name varchar (60), description varchar (255), product type id bigint, price numeric ;: create table shopping cart, ( id bigint auto increment primary key, product id bigint, quantity int, customer id bigint Notes Use the H2 in Memory Database. Go ahead and pre-populate some of the database tables like Users, Products, Product Types, old Orders and associated order items. Use a simple web interface with either Thymeleaf or JSPs. It doesn't have to be fancy or use sophisticated JavaScript

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!