Task 2. Implement Database (2.5 points)
1.3 (1.5 points) Create a database schema using Spring Data JPA
1.4 (1.0 point) Insert data into the database (the data provided in the PE_HSF302_FA25_260925_Note file)
Task 3. Implement CRUD actions with GUI (5.0 points)
3.1 (1.0 point) Authentication function:
If a user with an Admin role or Staff role logs in successfully (using email, password for the login process),
save this information to the session. All CRUD actions require authentication. In case of an unsuccessful
login, redirect to an error page with the flowing content: "You don't have permission to access this
function!"
3.2 (1.0 point) List All Rice Products
If the login is successful with an Admin role or Staff role, list all Rice Products (includes rice_id,
rice_name, price, created_at, supplier_name obtained by joining with suppliers table)
3.3 (0.5 point) Delete Rice Product
If the login is successful with an Admin role, delete the selected rice product and then update the product
list.
3.4 (1.5 points) Add New Rice Product
If the login is successful with an Admin role, add a new rice with the following requirements
.
All fields are required (Not null and Not Blank)
The value of price should be greater than or equal to $50 (price >= $50)
The value for rice_name is between 3 and 100 characters (3< length <100)
The created_at field should be automatically set to current datetime
3.5 (1.0 point) Update Existing Rice Product
If the login is successful with an Admin role, provide functionality to update an existing rice product. For
the update function, apply the same validation requirements as the Add function.
Note: You can use a different page or utilize the current table for this update function (update by rice_id).
Zoom
- FUO
+ 100%
Close
