<?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>
