mybatis关联查询

最新推荐文章于 2023-12-29 16:00:35 发布

不穿西服的程序员

最新推荐文章于 2023-12-29 16:00:35 发布

阅读量122

点赞数

分类专栏： JAVA程序员晋级之路

本文链接：https://blog.csdn.net/qq_27817327/article/details/82498693

版权

JAVA程序员晋级之路专栏收录该内容

29 篇文章 0 订阅

订阅专栏

<!-- 一对一关联查询 以订单为中心返回用户
    public List<Orders> selectOrders();注意关联查询映射不能少写全都得自己写-->
    <resultMap id="order" type="pojo.Orders">
        <id column="id" property="id"/>
        <result column="user_id" property="userId"/>
        <result column="number" property="number"/>
        <result column="createtime" property="createtime"/>
        <!--一对一-->
        <association property="user" javaType="pojo.User">
            <id column="user_id" property="id"/>
            <result column="username" property="username"></result>
        </association>
    </resultMap>
    <select id="selectOrders" resultMap="order">
        select
        o.id,
        o.user_id,
        o.number,
        o.createtime,
        u.username
        From orders o
        left join user u
        on o.user_id=u.id
    </select>

<!--一对多关联  以用户为中心返回订单
    public List<User> selectUsers();-->
    <resultMap id="user" type="pojo.User">
        <id column="user_id" property="id"></id>
        <result column="username" property="username"></result>
        <collection property="ordersList" ofType="pojo.Orders">
            <id column="id" property="id"/>
            <result column="user_id" property="userId"/>
            <result column="number" property="number"/>
            <result column="createtime" property="createtime"/>
        </collection>
    </resultMap>
    <select id="selectUsers" resultMap="user">
        select
        o.id,
        o.user_id,
        o.number,
        o.createtime,
        u.username
        From user u
        left join orders o
        on o.user_id=u.id
    </select>