ccc-shop-backend

Backend for online shopping system CCC Shop of database systems course.

How to Run ?

Install Mariadb

Download mariadb and set username and password to root

or you can run mariadb with docker

docker run --name mariadb -p 3306:3306 -e MARIADB_USER=root MARIADB_ROOT_PASSWORD=root -v /data/mariadb/data:/var/lib/mysql -d mariadb

Create database and add initial value

run create_table.sql and initial_value.sql under src/query in your database

Install IntelliJ IDEA

Download Path

Open project with IntelliJ IDEA

Add project SDK

• Add openjdk-17 in "File -> Project Structure"

Run application

• Right click on CccShopApplication
• Run CccShopApplication
  

Done!

Demo video for different scenario

youtube channel: https://www.youtube.com/playlist?list=PLuIs3VbIw0SmLry-_GpOQhUIGmaYZIKfI

visitor scenario: https://youtu.be/_eldVc57jGM

customer scenario: https://youtu.be/QkzACw5h_xQ

staff scenario: https://youtu.be/pY14iRMhgj4

admin scenario: https://youtu.be/El9QJEijaSo