Hibernate Criteria

Criteria

 

기본

- Specification

public Specification<Member> memberNameLike(String mamberName) {
	return (root, query, cb) -> cb.equal(root.get(Member_.memberName), memberName);
}

- Finder

memberRepository.findAll(memberNameLike(memberName), pageable);

 

---

 

응용

 

public class QuerySupporter<T> {
	public Specifications<T> combineSpecifications(Specification<T>... specifications) {
		return combineSpecifications(Lists.newArrayList(specifications));
	}

	public Specifications<T> combineSpecifications(List<Specification<T>> specifications) {
		List<Specification<T>> specificationList = specifications.stream()
			.filter(trigger -> !isEmpty(trigger))
			.collect(Collectors.toList());

		return specificationList.isEmpty() ? null : combineSpecifications(specificationList.iterator());
	}

	public Specifications<T> combineSpecifications(Iterator<Specification<T>> iterator) {
		Specifications<T> where = Specifications.where(iterator.next());

		while (iterator.hasNext()) {
			where = where.and(iterator.next());
		}

		return where;
	}

	public Specification<T> equalLongSpecifications(SingularAttribute<T, Long> attribute, Long value) {
		return ObjectUtils.isEmpty(value) ? null : (root, query, cb) -> cb.equal(root.get(attribute), value);
	}

	public Specification<T> equalStringSpecifications(SingularAttribute<T, String> attribute, String value) {
		return ObjectUtils.isEmpty(value) ? null : (root, query, cb) -> cb.equal(root.get(attribute), value);
	}

	public Specification<T> equalBooleanSpecifications(SingularAttribute<T, Boolean> attribute, Boolean value) {
		return ObjectUtils.isEmpty(value) ? null : (root, query, cb) -> cb.equal(root.get(attribute), value);
	}

	public Specification<T> likeSpecifications(SingularAttribute<T, String> attribute, String value) {
		return Strings.isNullOrEmpty(value) ? null : (root, query, cb) -> cb.like(root.get(attribute), "%" + value + "%");
	}
}

---

 

public class MemberQuerySupporter extends QuerySupporter<Member> {
	public Specification<Member> searchSpecifications(Long memberId, String memberName) {
	    return combineSpecifications(memberIdEqual(memberId), memberNameLike(memberName));
	}

	public Specification<Member> memberIdEqual(Long memberId) {
		return equalLongSpecifications(Member_.memberId, memberId);
	}

	public Specification<Member> memberNameLike(String memberName) {
		return likeSpecifications(Member_.memberName, memberName);
	}
}