...

• Query all records related to the DAO object in use: .findAll ();

  Code Block
  language java theme Confluence
  List<Customer> allCustomers = new CustomerDAO().findAll(); for (Customer customer : allCustomers) { ... }

  
  

• Query a particular object by using the primary key: .find(Object primaryKey).

  Code Block
  language java theme Confluence
  Customer specificCustomer = new CustomerDAO().find("SHG"); String contactname = specificCustomer.getContactname();

  
  

• Return a list of objects that fit the given example - .findByExample(Class entity, Object example)
  ATTENTION: Even the 0 or "" (empty string) default values are tested. Therefore, all values should be filled with the null value at a minimum.

  Code Block
  language java theme Confluence
  Customer exampleCustomer = new Customer(); exampleCustomer.setCity("Musterhausen"); exampleCustomer.setContacttitle("Herr"); List<Customer> findByExample = new CustomerDAO().findByExample(Customer.class, exampleCustomer);

  
  

• Manually abort the transaction with subsequent rollback: .rollback ().

  Code Block
  language java theme Confluence
  new CustomerDAO().rollback();

  
  

• Save the created entities: .save (Object entity).

  Code Block
  language java theme Confluence
  Customer exampleCustomer = new Customer(); exampleCustomer.setCity("Musterhausen"); exampleCustomer.setContacttitle("Herr"); Customer savedCustomer = new CustomerDAO().save(exampleCustomer);

  or

  Code Block
  language java theme Confluence
  Customer exampleCustomer2 = new Customer(); exampleCustomer2.setCity("Musterhausen2"); Customer exampleCustomer3 = new Customer(); exampleCustomer3.setCity("Musterhausen3"); Customer exampleCustomer4 = new Customer(); exampleCustomer4.setCity("Musterhausen4"); Customer savedCustomer = new CustomerDAO().save(exampleCustomer2, exampleCustomer3, exampleCustomer4);

  
  

Custom queries

• JPA-SQL
• Natvie Native SQL Strings
• Hibernate Queries
  • Hibernate Query Language (HQL)
  • Hibernate Criteria API