<!--Iaccount实体类包含Iuser-->
<resultMap id="accountUserMap" type="com.jieqing.domain.Iaccount">
<id property="id" column="id"></id>
<result property="uid" column="uid"></result>
<result property="money" column="money"></result>
<!--association中的property属性值与Iaccount实体类引入Iuser时一对一的值-->
<association property="user" column="id" javaType="com.jieqing.domain.Iuser">
<id property="id" column="id"></id>
<result property="username" column="username"></result>
<result property="birthday" column="birthday"></result>
<result property="sex" column="sex"></result>
<result property="address" column="address"></result>
</association>
</resultMap>
<!--使用resultMap引用上面映射-->
<select id="findAll" resultMap="accountUserMap">
SELECT a.*,u.`username` FROM account a,USER u WHERE a.uid=u.id
</select>