public List<Order> findAllByCriteria(OrderSearch orderSearch) {
CriteriaBuilder cb = em.getCriteriaBuilder();
 CriteriaQuery<Order> cq = cb.createQuery(Order.class);
 Root<Order> o = cq.from(Order.class);
 Join<Order, Member> m = o.join("member", JoinType.INNER);
 List<Predicate> criteria = new ArrayList<>();

 if (orderSearch.getOrderStatus() != null) {
Predicate status = cb.equal(o.get("status"),
 orderSearch.getOrderStatus());
 criteria.add(status);
 }

if (StringUtils.hasText(orderSearch.getMemberName())) {
Predicate name =
cb.like(m.<String>get("name"), "%" +
orderSearch.getMemberName() + "%");
 criteria.add(name);
 }
cq.where(cb.and(criteria.toArray(new Predicate[criteria.size()])));
 TypedQuery<Order> query = em.createQuery(cq).setMaxResults(1000);
 return query.getResultList();
}


이게 어딜봐서 쿼리문이지


가슴이 웅장해진다..