mybatis 一对多 和 一对一

一对多

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