Bookshop

E-Commerce Project using Spring boot, Hibernate, Thymeleaf & MySQL

TECHNOLOGIES:

• Java
• Spring framework (Sping boot, Spring MVC, Hibernate, Spring Security)
• MySQL
• Thymeleaf
• Bootstrap
• jQuery

FUNCTIONALITY/FEATURES:

• User register/login with role based authorization.
• Admin portal for CRUD operations on products (only accessible by admin user).
• Admin portal for CRUD operation on categories and products.
• Store: display all products, filter products by category, order results by different criteria or filter by search input.
• Purchasing: view details of product, add to shopping cart, checkout.
• Responsive design.

STEPS TO COMPILE

• Run your project
• Run following querties in your database:
  • INSERT INTO bookshopdb2.roles (id, name) VALUES ('1', 'ROLE_ADMIN');
  • INSERT INTO bookshopdb2.roles (id, name) VALUES ('2', 'ROLE_USER');
• For admin role, register as a normal user, note the user id from the users table and run the following query with the id:
  • INSERT INTO user_role (USER_ID,ROLE_ID) values (user_id_number, 1);

TO-DO

• Mail security
• Edit user profile
• View order history
• Place order with shipping address and payment info

SCREENSHOTS

• Admin-portal

• User-portal