Where
-
10. Querydsl Dynamic Query (동적쿼리)BackEnd/Querydsl 2021. 7. 29. 20:37
[전체소스코드] 1. BooleanBuilder private List searchMember1(String usernameCond, Integer ageCond) { BooleanBuilder builder = new BooleanBuilder(); if (usernameCond != null) { builder.and(member.username.eq(usernameCond)); } if (ageCond != null) { builder.and(member.age.eq(ageCond)); } return queryFactory .selectFrom(member) .where(builder) .fetch(); } 2. Where 다중 파라미터 > where 조건에 null 값은 무시된다. > 메서드를 ..
-
03. Querydsl 기본 문법BackEnd/Querydsl 2021. 7. 17. 15:36
1. Querydsl 기본 문법 package com.spring.querydsl; import com.querydsl.jpa.impl.JPAQueryFactory; import org.junit.jupiter.api.BeforeEach; import org.junit.jupiter.api.Test; import org.springframework.boot.test.context.SpringBootTest; import org.springframework.transaction.annotation.Transactional; import com.spring.querydsl.entity.Member; import com.spring.querydsl.entity.QMember; import com.spring...