Skip to content

Instantly share code, notes, and snippets.

@ThangLeQuoc
Created November 9, 2018 17:08
Show Gist options
  • Save ThangLeQuoc/e872c39da5d65dc32f69d8a19544b732 to your computer and use it in GitHub Desktop.
Save ThangLeQuoc/e872c39da5d65dc32f69d8a19544b732 to your computer and use it in GitHub Desktop.
Spring JPA Criteria
CriteriaBuilder cb = entityManager.getCriteriaBuilder();
CriteriaQuery<Employee> q = cb.createQuery(Employee.class);
Root<Employee> root = q.from(Employee.class);
q.select(root);
List<String> parentList = Arrays.asList(new String[]{"John", "Raj"});
Expression<String> parentExpression = root.get(Employee_.Parent);
Predicate parentPredicate = parentExpression.in(parentList);
q.where(parentPredicate);
q.orderBy(cb.asc(root.get(Employee_.Parent));
q.getResultList();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment