Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //JPQL
- TypedQuery<Cat> queryJpql = em.createQuery(
- "SELECT c FROM Cat c JOIN c.owner o WHERE o.name=:ownerName", Cat.class);
- queryJpql.setParameter("ownerName", "Bill");
- List<Cat> catsJpql = queryJpql.getResultList();
- catsJpql.forEach(System.out::println);
- //Querydsl
- JPAQuery queryFactory = new JPAQuery(em);
- QCat cat = QCat.cat;
- QOwner owner = QOwner.owner;
- List<Cat> catsQdsl = queryFactory.from(cat)
- .join(cat.owner, owner)
- .where(owner.name.eq("Bill"))
- .list(cat);
- catsQdsl.forEach(System.out::println);
- //Criteria Query
- CriteriaBuilder cb = em.getCriteriaBuilder();
- CriteriaQuery<Cat> criteriaQuery = cb.createQuery(Cat.class);
- Root<Cat> catQ = criteriaQuery.from(Cat.class);
- Join<Cat, Owner> ownerQ = catQ.join(Cat_.owner);
- criteriaQuery.where(cb.equal(ownerQ.get(Owner_.name), "Bill"));
- TypedQuery<Cat> query = em.createQuery(criteriaQuery);
- List<Cat> catsCrQ = query.getResultList();
- catsCrQ.forEach(System.out::println);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement