Create new query

1. Under Project Management > Data Access click the DAO with which you want to perform a database query, e.g. CustomerDAO.java.
2. Press Strg + Space and select query: create new query in the following autocomplete window.
   

3. Enter an appropriate method name for the generated method, e.g. findAllCustomer.

   findAllCustomer()
   {
   	select * from 
   }

4. After the keyword from, enter C, press Strg + Space and select Customer.
   
5. Click Save.

Result:

• Queries - JPA-SQL code.

  import com.company.test.entities.Customer
  
  findAllCustomer()
  {
  	select * from Customer
  }

• Java - Generated Java code based on JPA Criteria API. The necessary imports are generated based on the query method. 

  /**
   * @queryMethod Do not edit, method is generated by editor!
   */
  public List<Customer> findAllCustomer() {
  	EntityManager entityManager = em();
  
  	CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
  
  	CriteriaQuery<Customer> criteriaQuery = criteriaBuilder.createQuery(Customer.class);
  
  	Root<Customer> root = criteriaQuery.from(Customer.class);
  
  	TypedQuery<Customer> query = entityManager.createQuery(criteriaQuery);
  	return query.getResultList();
  }