mybatis 一对一，一对多，多对多映射开发

一、一对一映射查询

例：一个订单对应一个用户。
对应的sql语句：select * from orders o,user u where o.uid=u.id;

1、实体类

public class Order {
   
    private int id;
    private Date ordertime;
    private double total;
    //代表当前订单从属于哪一个客户
    private User user;
}

public class User {
   
    private int id;
    private String username;
    private String password;
    private Date birthday;
}

2、mapper接口，OrderMapper

public interface OrderMapper {
   
    List<Order> findAll();
}

3、mapper配置，OrderMapper.xml

<mapper namespace="com.lagou.mapper.OrderMapper">
    <resultMap id="orderMap" type="com.lagou.domain.Order">
        <result column="uid" property="user.id"></result>
        <result column="username" property="user.username"></result>
        <result column="password" property="user.password"></result>
        <result column="birthday" property="user.birthday"></result>
    </resultMap>
    <select id="findAll" resultMap="orderMap">
        select * from orders o,user u where o.uid=u.id
    </select>
</mapper>

又或者这样配置 resultMap：

<resultMap id="orderMap" type="com.lagou.domain.Order">
    <result property="id" column="id"></result>
    <result property="ordertime" column="ordertime"></result>
    <result property="total" column="total"></result>
    <association property="user" javaType="com.lagou.domain.User">
        <result column=