Advertisement
Guest User

Untitled

a guest
Mar 27th, 2017
40
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. //JPQL
  2. TypedQuery<Cat> queryJpql = em.createQuery(
  3. "SELECT c FROM Cat c JOIN c.owner o WHERE o.name=:ownerName", Cat.class);
  4. queryJpql.setParameter("ownerName", "Bill");
  5. List<Cat> catsJpql = queryJpql.getResultList();
  6. catsJpql.forEach(System.out::println);
  7.  
  8. //Querydsl
  9. JPAQuery queryFactory = new JPAQuery(em);
  10. QCat cat = QCat.cat;
  11. QOwner owner = QOwner.owner;
  12. List<Cat> catsQdsl = queryFactory.from(cat)
  13. .join(cat.owner, owner)
  14. .where(owner.name.eq("Bill"))
  15. .list(cat);
  16. catsQdsl.forEach(System.out::println);
  17.  
  18. //Criteria Query
  19. CriteriaBuilder cb = em.getCriteriaBuilder();
  20. CriteriaQuery<Cat> criteriaQuery = cb.createQuery(Cat.class);
  21. Root<Cat> catQ = criteriaQuery.from(Cat.class);
  22. Join<Cat, Owner> ownerQ = catQ.join(Cat_.owner);
  23. criteriaQuery.where(cb.equal(ownerQ.get(Owner_.name), "Bill"));
  24. TypedQuery<Cat> query = em.createQuery(criteriaQuery);
  25. List<Cat> catsCrQ = query.getResultList();
  26. catsCrQ.forEach(System.out::println);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement