Query DSL

QueryDSL

 

기본

- user define repository interface

public interface MemberRepositoryCustom {
    Member search(String memberName);
}

 

- user define repository interface implement

public class MemberRepositoryImpl implements MemberRepositoryCustom {
	@PersistenceContext(unitName = "jpaPractice")
	private EntityManager entityManager;
 	
    public Member findOne(String memberName) {
    	JPAQuery jpaQuery = new JPAQuery(entityManager);
 		QMember member = QMember.member;

 		BooleanBuilder condition = new BooleanBuilder();
 		condition.and(equal(member.name, memberName));

 		jpaQuery.from(member)
 			.where(condition);
 		
        return jpaQuery.singleResult(member);
 	}
}

 

- using user define repository interface

MemberRepository extend JpaRepository<Member, Long>, MemberRepositoryCustom

memberRepository.search("memberName");

---

 

응용

public interface OrderRepositoryCustom {
    List<Order> search(OrderSearch orderSearch);
}

public class OrderRepositoryImpl implements OrderRepositoryCustom {
	@PersistenceContext(unitName = "jpaPractice")
	private EntityManager entityManager;

 	@Override
 	public List<Order> search(OrderSearch orderSearch) {
 		JPAQuery jpaQuery = new JPAQuery(entityManager);
 		QOrder qOrder = QOrder.order;
 		QMember qMember = QMember.member;

 		jpaQuery.from(qOrder)
 			.innerJoin(qOrder.member, qMember)
 			.where(OrderPredicateConverter.convert(orderSearch));

 		return jpaQuery.list(qOrder);
	}
}

public class OrderPredicateConverter {
	public static Predicate convert(OrderSearch orderSearch) {
		QOrder qOrder = QOrder.order;
		QMember qMember = QMember.member;

 		BooleanBuilder condition = new BooleanBuilder();
 		condition.and(PredicateBuilder.equal(qOrder.status, orderSearch.getOrderStatus()));
 		condition.and(PredicateBuilder.equal(qMember.name, orderSearch.getMemberName()));

 		return condition;
	}
}