Daily Assignments: Days 7 to 17

Day 7

Steps Already Completed

1. Copy hibernate_template_project under your workspace folder.
2. From IDE
   • Click on File --> import --> Maven --> Existing Maven Project --> Browse n select hibernate_template_project --> Finish.
3. Update the project.
   • R click on the project --> Maven --> Update Project -->select Force update checkbox -->Finish
4. Edit DB password from hibernate.cfg.xml , as per your DB settings.

Next Steps

• Start from here.
• Refer to your notes OR "day7_data\day7_help\day7-sequence.rtf"

1. Revise in top down manner, from
   • Tester -DAO- Entity layer - DB
2. Create Entity , DAO n test it with Tester.

Day 8

Testers to Be Revised

• You have to trace it from Tester -> DAO n 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

• Typical product details -
  • 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

6.1 Continue with hibernate_template_project.

6.2 Edit DB settings