MemberMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper 
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 
"http://mybatis.org/dtd/mybatis-3-mapper.dtd" >

<mapper namespace="org.joonzis.mapper.MemberMapper">

	<resultMap type="org.joonzis.domain.MemberVO" id="memberMap">
		<result property="userid" column="userid"/>
		<result property="userpw" column="userpw"/>
		<result property="username" column="username"/>
		<result property="regdate" column="regdate"/>
		<result property="updatedate" column="updatedate"/>
		<collection property="authList" resultMap="authMap"></collection>
	</resultMap>
	
	<resultMap type="org.joonzis.domain.AuthVO" id="authMap">
		<result property="userid" column="userid"/>
		<result property="auth" column="auth"/>
	</resultMap>
	
	
	
	
	
	
	<select id="read" resultMap="memberMap">
	SELECT
    	mem.userid, userpw, username, enabled, regdate, updatedate, auth
	FROM
    	tbl_member mem LEFT JOIN tbl_member_auth auth ON mem.userid=auth.userid
	WHERE
    	mem.userid=#{userid}
	</select>
	
</mapper>