반응형
dynamic query
-
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 값은 무시된다. > 메서드를 ..