유저가 여러개의 롤을 가지고 있을 때 한 번에 쿼리해서 가져오기 위하여 만들었다. <h3>UserMapper.xml</h3><pre style="background-color:#2b2b2b;color:#a9b7c6;font-family:'D2Coding',monospace;font-size:10.5pt;">&lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"&gt; &lt;mapper namespace="kr.hvy.auth.repository.UserMapper"&gt; &lt;resultMap type="User" id="userRoleMap"&gt; &lt;result property="id" column="ID"/&gt; &lt;result property="email" column="EMAIL"/&gt; &lt;result property="password" column="PASSWORD"/&gt; &lt;result property="refreshToken" column="REFRESH_TOKEN"/&gt; &lt;collection property="roles" ofType="Role"&gt; &lt;id property="id" column="ROLE_ID"/&gt; &lt;result property="name" column="ROLE_NAME"/&gt; &lt;/collection&gt; &lt;/resultMap&gt; &lt;select id="findByEmail" resultMap="userRoleMap"&gt; SELECT HEX(U.ID) AS ID , U.EMAIL , L.PASSWORD , HEX(R.ID) AS ROLE_ID , R.NAME AS ROLE_NAME , '' AS REFRESH_TOKEN FROM USER_INFO AS U JOIN USER_LOGIN AS L ON U.ID = L.FK_USER_INFO LEFT JOIN USER_ROLE_MAP AS M ON U.ID = M.USERID LEFT JOIN ROLE AS R ON R.ID = M.ROLEID WHERE U.EMAIL = #{email} &lt;/select&gt; &lt;/mapper&gt;</pre> <h3>UserMapper.java</h3><pre style="background-color:#2b2b2b;color:#a9b7c6;font-family:'D2Coding',monospace;font-size:10.5pt;">package kr.hvy.auth.repository; import kr.hvy.auth.model.User; import org.apache.ibatis.annotations.Mapper; import java.util.Map; import java.util.Optional; @Mapper public interface UserMapper { Optional&lt;User&gt; findByEmail(String email); } </pre> <h3>User.java</h3><pre style="background-color:#2b2b2b;color:#a9b7c6;font-family:'D2Coding',monospace;font-size:10.5pt;">package kr.hvy.auth.model; import com.fasterxml.jackson.annotation.JsonProperty; import lombok.*; import java.util.HashSet; import java.util.Set; @Getter @Setter public class User { private String id; private String email; @JsonProperty(access = JsonProperty.Access.WRITE_ONLY) private String password; private Set&lt;Role&gt; roles = new HashSet&lt;&gt;(); private String refreshToken; } </pre> <h3>Role.java</h3><pre style="background-color:#2b2b2b;color:#a9b7c6;font-family:'D2Coding',monospace;font-size:10.5pt;">package kr.hvy.auth.model; import lombok.*; @Getter @Setter public class Role { private String id; private String name; } </pre>

[Spring] MyBatis Join한 결과를 모델로 받아오기 Parent/Children