* JPQL vs Querydsl
@Test
public void startJPQL() {
//member1을 찾아라
Member findMember = em.createQuery("select m from Member m where m.username = :username", Member.class)
.setParameter("username", "member1")
.getSingleResult();
assertThat(findMember.getUsername()).isEqualTo("member1");
}
@Test
public void startQuerydsl() {
Member find = queryFactory
.select(member)
.from(member)
.where(member.username.eq("member1")) //파라미터 바인딩 처리
.fetchOne();
assertThat(find.getUsername()).isEqualTo("member1");
}
* where 절 and 비교
@Test
public void search() {
queryFactory.selectFrom(member)
.where(member.username.eq("member1").and(member.age.eq(10)))
.fetchOne();
}
@Test
public void searchAndParam() {
queryFactory.selectFrom(member)
.where(member.username.eq("member1"), member.age.eq(10))
.fetchOne();
}
: 둘다 같음 , 아무거나 쓰면 됨
밑에껀 위에껄 , 로 풀어씀
'Web > QueryDSL' 카테고리의 다른 글
결과 조회, 정렬, 페이징 (0) | 2020.02.19 |
---|---|
Querydsl 환경설정 (0) | 2020.02.18 |