Day 7: Steps to Continue

5. Revise Top-Down (Tester → DAO → Entity → DB):

• Tester: Entry point to test CRUD operations, invoking DAO methods.
• DAO: Contains business logic, interacts with Hibernate Session to perform database operations.
• Entity: Represents database tables with JPA annotations (e.g., @Entity, @Table, @Id).
• DB: Configured via hibernate.cfg.xml (update password, URL, etc.).
• Trace flow: Tester calls DAO methods → DAO uses Session to interact with entities → Entities map to DB tables.

6. Create Entity, DAO, and Tester:

• Example: For Product (detailed in Day 8), create the entity, DAO, and testers as described below.

Day 8: Mandatory Assignment - CRUD Operations on Product

6.1 Continue with hibernate_template_project

• Ensure the project is imported and updated (Steps 1–3 already done).
• Verify Maven dependencies (e.g., Hibernate, MySQL connector) in pom.xml.

6.2 Edit DB Settings

• Update hibernate.cfg.xml:

  <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/your_db</property>
  <property name="hibernate.connection.username">your_username</property>
  <property name="hibernate.connection.password">your_password</property>
  
  

6.3 Create HibernateUtils Class

• Utility class to manage SessionFactory:

  import org.hibernate.SessionFactory;
  import org.hibernate.cfg.Configuration;
  
  public class HibernateUtils {
      private static final SessionFactory sessionFactory;
  
      static {
          try {
              sessionFactory = new Configuration().configure().buildSessionFactory();
          } catch (Exception e) {
              throw new ExceptionInInitializerError(e);
          }
      }
  
      public static SessionFactory getSessionFactory() {
          return sessionFactory;
      }
  
      public static void shutdown() {
          getSessionFactory().close();
      }
  }
  
  

6.4 Create Product Entity

• Product Details:
  • id: Long (auto-increment)
  • name: String (unique, varchar(20))
  • description: String (varchar(300))
  • manufactureDate: LocalDate
  • price: double
  • availableQuantity: int
  • category: Enum (STATIONARY, SHOES, GRAINS, OIL)