[Querydsl] 6. Querydsl Where절

[Querydsl] 1. Querydsl 설정하기

[Querydsl] 2. H2 Database

[Querydsl] 3. JPA yml 설정

[Querydsl] 4. 예제용 도메인 생성

[Querydsl] 5. JPQL vs Querydsl 비교

 

안녕하세요
이전 포스팅에 이어
Querydsl where절에 대해 알아보겠습니다.

@Test

public  void  search() throws Exception {

// given

Member  findMember = queryFactory.selectFrom(member)

.where(member.username.eq("member1")

.and(member.age.eq(10)))

.fetchOne();


assertThat(findMember.getUsername()).isEqualTo("member1");

}

where(안에서 .and() 대신 ,(comma)로 넣으면 같은 기능을 한다.)

.where(member.username.eq("member1"),member.age.eq(10))

다양한 검색조건

member.username.eq("member1") // username = 'member1'   
member.username.ne("member1") //username != 'member1'  
member.username.eq("member1").not() // username != 'member1'
member.username.isNotNull() //이름이 is not null   
member.age.in(10, 20) // age in (10,20)  
member.age.notIn(10, 20) // age not in (10, 20)   
member.age.between(10,30) //between 10, 30
member.age.goe(30) // age >= 30 
member.age.gt(30) // age > 30   
member.age.loe(30) // age <= 30 
member.age.lt(30) // age < 30
member.username.like("member%") //like 검색 
member.username.contains("member") // like ‘%member%’ 검색 
member.username.startsWith("member") //like ‘member%’ 검색

Querydsl where절 조건을 알아봤습니다.
감사합니다

참고

www.inflearn.com/course/Querydsl-%EC%8B%A4%EC%A0%84#