Skip to content

Instantly share code, notes, and snippets.

@wmuron
Created October 20, 2016 13:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save wmuron/04478ae851bec6f7121966f0bf33bcc6 to your computer and use it in GitHub Desktop.
Save wmuron/04478ae851bec6f7121966f0bf33bcc6 to your computer and use it in GitHub Desktop.
CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
CriteriaQuery<User> criteriaQuery = criteriaBuilder.createQuery(User.class);
Root<User> userRoot = criteriaQuery.from(User.class);
//Specification<User> specs = (root, query, cb) ->
// cb.equal(root.get("createdAt"), utcDate);
String paramName = "pn";
Specification<User> specs = (root, query, cb) ->
cb.equal(root.get("createdAt"), cb.parameter(Date.class, paramName));
Predicate predicate = specs.toPredicate(userRoot, criteriaQuery, criteriaBuilder);
criteriaQuery.where(predicate);
//TypedQuery<User> typedQuery = entityManager.createQuery(criteriaQuery);
typedQuery.setParameter(paramName, utcDate);
List<User> results = typedQuery.getResultList();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment