Mybatis框架-13：多表操作之多对一

最新推荐文章于 2024-08-09 15:01:50 发布

qq_38198467

最新推荐文章于 2024-08-09 15:01:50 发布

阅读量167

点赞数

分类专栏： Mybatis 文章标签： mybatis

本文链接：https://blog.csdn.net/qq_38198467/article/details/90750001

版权

Mybatis 专栏收录该内容

27 篇文章 0 订阅

订阅专栏

第一步：建立两张表并建立外键联系

我这里是客户与订单的表进行举例

第二步：建立对应关系的映射类（domain）

customer类

@Data
public class Customer {
    private Integer cust_id;
    private String cust_name;
    private String cust_profession;
    private String cust_phone;
    private String email;

}

order类

@Data
public class Order {
    private Integer orderId;
    private String orderName;
    private String orderNum;
    private Customer customer;
}

第三步：编写mapper

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

第四步:编写mapper.xml

方式一：association（建议使用）

<resultMap id="orderMap" type="com.ctbu.domain.Order">
        <result property="orderId" column="orderId"/>
        <result property="orderName" column="orderName"/>
        <result property="orderNum" column="orderNum"/>

        <association property="customer" javaType="Customer">
            <id property="cust_id" column="cust_id"/>
            <result property="cust_name" column="cust_name"/>
            <result property="cust_phone" column="cust_phone"/>
            <result property="cust_profession" column="cust_profession"/>
            <result property="email" column="email"/>
        </association>
    </resultMap>

    <select id="getAllOrder" resultMap="orderMap">
        SELECT * from `order` as o LEFT JOIN `customer` as c ON o.orderCustId=c.cust_id;
    </select>

方式二：级联封装（一般不适用）

<resultMap id="orderMap" type="com.ctbu.domain.Order">
        <result property="orderId" column="orderId"/>
        <result property="orderName" column="orderName"/>
        <result property="orderNum" column="orderNum"/>

        <result property="customer.cust_id" column="cust_id"/>
        <result property="customer.cust_name" column="cust_name"/>
        <result property="customer.cust_phone" column="cust_phone"/>
        <result property="customer.cust_profession" column="cust_profession"/>
        <result property="customer.email" column="email"/>
    </resultMap>

    <select id="getAllOrder" resultMap="orderMap">
        SELECT * from `order` as o LEFT JOIN `customer` as c ON o.orderCustId=c.cust_id;
    </select>

第五步：测试程序

 @Test
    public void test4(){
        SqlSession session = MyUtils.openSession();
        OrderMapper mapper = session.getMapper(OrderMapper.class);
        List<Order> allOrder = mapper.getAllOrder();
        for (Order order : allOrder) {
            System.out.println(order);
        }
        session.close();
    }

结果：