This webshop project was developed to get practice with

1. Java Servlets
2. Tomcat
3. JDBC
4. CSS
5. database interaction

In this project I implemented

So, this shop works only with Authenticated users (Authentication is implemented via filter). After user is registered it has 'USER' role by default. Authorization is also implemented via filter. In sample case our project has two roles: USER and ADMIN.

can see all of the products, that exist in the shop (but not deleted, soft deleting is implemented), every USER has one shopping cart, can add product to cart and then complete order, can see all of its orders and details of them.

role, set by system administrator, can delete user, see all users, see all orders, delete order, add product, delete product. Admin does not have a cart and can not create order.

If you want to enter as Admin, there's address /injectData which will add new user with Admin's role

But first of all, there's file init_db.sql which holds sql script for creating appropriate DB. So run this code in MySQL on your machine first. Also, your database should have UTC time zone.

To run this project you need to install the following on your computer:

• Java
• Apache
• Tomcat
• MySQL

This project was tested with the following software:

• Intellij IDEA Ultimate Edition
• Apache Tomcat 9.0.37
• MySQL 8.0.20