본문 바로가기

Web/QueryDSL

기본 문법

*  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