Untitled

mail@pastecode.io avatarunknown
plain_text
2 months ago
733 B
4
Indexable
Never
public Employee findEmployeeByPostalCode(EntityManager entityManager, String postalCode) {
    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery<Employee> criteriaQuery = criteriaBuilder.createQuery(Employee.class);
    
    Root<Address> addressRoot = criteriaQuery.from(Address.class);
    criteriaQuery.select(addressRoot.get("employee"));
    criteriaQuery.where(criteriaBuilder.equal(addressRoot.get("postalCode"), postalCode));
    
    TypedQuery<Employee> query = entityManager.createQuery(criteriaQuery);
    List<Employee> employees = query.getResultList();
    
    if (!employees.isEmpty()) {
        return employees.get(0);
    } else {
        return null;
    }
}