Initial Setup (Already Completed)

1. Copy hibernate_template_project under your workspace folder.
2. From IDE:
   • Click on File –> Import –> Maven –> Existing Maven Project
   • Browse and select hibernate_template_project
   • Click Finish
3. Update the project:
   • Right-click on the project
   • Select Maven –> Update Project
   • Select Force update checkbox
   • Click Finish
4. Edit DB password in hibernate.cfg.xml, as per your DB settings.

Review Tasks

1. Revise in top-down manner, from Tester -> DAO -> Entity layer -> DB

   Testers to be reviewed (trace from Tester -> DAO and Entities):

   • UserRegistration.java
   • GetUserDetailsById.java
   • DisplayAllUserDetails.java
   • DisplayUsersByRoleAndDate.java
   • DisplayLastNamesByRole.java
   • DisplayNameAndDobByRole.java
   • ChangePassword.java
   • ApplyDiscount.java
   • DeleteUserDetailsById.java

Mandatory Assignment

CRUD Operations on Product Entity

Product Details Specification:

• product id: Long (auto increment)
• name: string (unique) - varchar(20)
• product description: string - varchar(300)
• manufacture date: LocalDate
• price: double
• available quantity: int
• category: enum (STATIONARY, SHOES, GRAINS, OIL…)

Development Steps:

1. Continue with hibernate_template_project.
2. Edit DB settings if needed.