Untitled
unknown
plain_text
2 years ago
733 B
14
Indexable
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;
}
}Editor is loading...