一对多
<resultMap id="UserOrderResultMap" type="user" autoMapping="true">
<id property="id" column="id"></id>
<collection property="orders" javaType="list" ofType="order" autoMapping="true">
<id column="oid" property="id"></id>
<result property="userId" column="id"></result>
</collection>
</resultMap>
<select id="queryUserOrders" resultMap="UserOrderResultMap">
SELECT
u.id,
u.username,
u.birthday,
u.sex,
u.address,
o.id oid,
o.number,
o.createtime,
o.note
FROM
`user` u
LEFT JOIN `order` o ON u.id = o.user_id
</select>
一对一
<resultMap id="orderUserMap" type="order" autoMapping="true">
<!-- id:声明主键,表示user_id是关联查询对象的唯一标识-->
<id column="id" property="id"></id>
<result column="user_id" property="userId"></result>
<association property="user" javaType="user" autoMapping="true">
<id column="user_id" property="id"></id>
</association>
</resultMap>
<select id="queryOrderAndUser2" resultMap="orderUserMap">
SELECT o.id,user_id,number,createtime,note , username , address FROM `order` o LEFT JOIN `user` u ON o.user_id = u.id;
</select>