BookShopWeb

A Java Web project to build an online Bookstore

(1)	(2)	(3)

A. Set up the BookShopWeb project

1. Load images

Create the directory C:/var/webapp/images and extract all images from the file var-webapp-images.zip into this folder.

2. Create the database

Open MySQL Workbench → Open SQL Script → Execute bookshopdb.sql.

3. Load the project into IDEA

Open IntelliJ IDEA → Get from VCS (on the Welcome screen) or File | New | Project from Version Control (in the main screen) → Clone project using the URL: https://github.com/hoangquan2002/BookShopManagement.git.

4. Configure Tomcat

• Go to [Add Configuration...] → [+] Tomcat Server Local.
• Click [Fix] → Select BookShopWeb:war exploded.

5. Run (Shift+F10)

B. Configure utils.ConstantUtils

• Default values: DB_NAME is bookshopdb, DB_USERNAME is root, and DB_PASSWORD is 12345.
• These can be changed if different credentials are used.

Database Design

Sample Data

Table	Number of sample records
user	5
product	100
product_review	150
category	15
product_category	100
cart	2
cart_item	5
orders	25
order_item	60
wishlist_item	30

Software Used

• IntelliJ IDEA 2022.1.2
• MySQL Workbench 8.0.25
• Tomcat 9.0.48

Installing Tomcat 9.0.48

• Download from: https://archive.apache.org/dist/tomcat/tomcat-9/v9.0.48/bin/ (apache-tomcat-9.0.48.zip for Windows and apache-tomcat-9.0.48.tar.gz for Mac).
• Open IntelliJ IDEA and add it via File | Settings | Build, Execution, Deployment | Application Servers > [+] Tomcat Server (set Tomcat Home to the Tomcat directory, e.g., apache-tomcat-9.0.48).