![](https://img1.daumcdn.net/thumb/R750x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdn%2FbtkbMJ%2FbtsHghmPvYD%2FUQ1FgIxdk4LWGzPOf0rwqK%2Fimg.png)
[MyBatis] Java에서 쿼리문 만들기 [SQL Builder 클래스를 활용한 동적쿼리 작성]
·
▣ Framework/MyBatis🐣
- Java에서 쿼리문 만들기@SelectProvider(type = UserSqlBuilder.class, method = "buildGetUsersByName")List getUsersByName(String name);class UserSqlBuilder { public static String buildGetUsersByName(final String name) { return new SQL(){{ SELECT("*"); FROM("users"); if (name != null) { WHERE("name like #{value} || '%'"); } ORDER_BY("id"); }}.toString(); }}@SelectPro..