一对一关联
<resultMap type="order" id="order_user_map">
<id property="id" column="id"/>
<result property="userId" column="user_id"/>
<result property="number" column="number"/>
<result property="createtime" column="createtime"/>
<result property="note" column="note"/>
<!-- 配置一对一关系 -->
<association property="user" javaType="user">
<id property="id" column="id"/>
<result property="username" column="username"/>
<result property="birthday" column="birthday"/>
<result property="address" column="address"/>
<result property="sex" column="sex"/>
</association>
</resultMap>
<select id="getOrderUser" resultMap="order_user_map">
select
o.id,o.user_id,o.number,o.createtime,o.note,u.username,u.birthday,u.address,u.sex
from `order` o left join user u on o.user_id = u.id
</select>
一对多关联
<resultMap type="user" id="user_order_map">
<id property="id" column="id" />
<result property="username" column="username" />
<result property="address" column="address" />
<result property="birthday" column="birthday" />
<result property="sex" column="sex" />
<!-- 配置一对多 -->
<collection property="orders" ofType="order">
<id property="id" column="oid" />
<result property="userId" column="user_id" />
<result property="number" column="number" />
<result property="createtime" column="createtime" />
<result property="note" column="note" />
</collection>
</resultMap>
<select id="getUserOrderMap" resultMap="user_order_map">
select
u.username,u.id,u.address,u.birthday,u.sex,o.id
oid,o.number,o.createtime
from user u LEFT JOIN `order` o on
u.id=o.user_id
</select>