关联关系映射

什么是关联关系映射？

关联关系是指类之间的引用关系，如果类A与类B关联，那么类A将被定义成类B的属性。

例如：

public class Address{
   private String name;
}

public class B{
   private String sid;
   private Float score;
   private Address address;   
}

关联关系的分类：一对一，一对多，多对一，多对多

一对多：一本书对应多种书本类型，例如：西游记 -> 神话、古典、名著

多对一：一种书本类型对应多本数，例如：神话 -> 西游记、山海经、聊斋志异

多对多：永远视为两个一对多

一个人负责多个项目开发，例如：张三负责 A B C
一个项目由多个人来开发，例如：A项目由张三、李四、王五来开发

案例：

修改Customer、Order实体类

1）实现序列化接口

2）建立实体映射关联关系（一对多、多对一）

一对多：一个客户对应多个订单

package com.zking.ssm.book.model;

import java.util.ArrayList;
import java.util.List;

/*
* 简历实体层面的关联关系：
* 1对多：一个客户对应多个订单
* */
public class Customer {
    private Integer customerId;

    private String customerName;

    private List<Order> orders=new ArrayList<>();

    public Customer(Integer customerId, String customerName) {
        this.customerId = customerId;
        this.customerName = customerName;
    }

    public Customer() {
        super();
    }

    public Integer getCustomerId() {
        return customerId;
    }

    public void setCustomerId(Integer customerId) {
        this.customerId = customerId;
    }

    public String getCustomerName() {
        return customerName;
    }

    public void setCustomerName(String customerName) {
        this.customerName = customerName;
    }

    public List<Order> getOrders() {
        return orders;
    }

    public void setOrders(List<Order> orders) {
        this.orders = orders;
    }

    @Override
    public String toString() {
        return "Customer{" +
                "customerId=" + customerId +
                ", customerName='" + customerName + '\'' +
                ", orders=" + orders +
                '}';
    }
}

  property: 指的是集合属性的值, ofType：指的是集合中元素的类型

  <resultMap id="OneToMany" type="com.zking.ssm.book.model.Customer">
    <id property="customerId" javaType="java.lang.Integer" column="customer_id"></id>
    <result property="customerName" javaType="java.lang.String" column="customer_name"></result>
    <collection property="orders" ofType="com.zking.ssm.book.model.Order">
      <id property="orderId" javaType="java.lang.Integer" column="order_id"></id>
      <result property="cid" javaType="java.lang.Integer" column="cid"></result>
      <result property="orderNo" javaType="java.lang.String" column="order_no"></result>
    </collection>
  </resultMap>

  <select id="queryCustomer"  resultMap="OneToMany">
    select * from t_customer c left join t_order o on c.customer_id= o.cid
  </select>

 结果如下：

多对一

package com.zking.ssm.book.model;

public class Order {
    private Integer orderId;

    private String orderNo;

    private Integer cid;

    private Customer customer;

    public Customer getCustomer() {
        return customer;
    }

    public void setCustomer(Customer customer) {
        this.customer = customer;
    }

    public Order(Integer orderId, String orderNo, Integer cid) {
        this.orderId = orderId;
        this.orderNo = orderNo;
        this.cid = cid;
    }

    public Order() {
        super();
    }

    public Integer getOrderId() {
        return orderId;
    }

    public void setOrderId(Integer orderId) {
        this.orderId = orderId;
    }

    public String getOrderNo() {
        return orderNo;
    }

    public void setOrderNo(String orderNo) {
        this.orderNo = orderNo;
    }

    public Integer getCid() {
        return cid;
    }

    public void setCid(Integer cid) {
        this.cid = cid;
    }

    @Override
    public String toString() {
        return "Order{" +
                "orderId=" + orderId +
                ", orderNo='" + orderNo + '\'' +
                ", cid=" + cid +
                '}';
    }
}

  <resultMap id="ManyToOne" type="com.zking.ssm.book.model.Order">
    <id property="orderId" javaType="java.lang.Integer" column="order_id"></id>
    <result property="orderNo" javaType="java.lang.String" column="order_no"></result>
    <result property="cid" javaType="java.lang.Integer" column="cid"></result>
    <association property="customer" javaType="com.zking.ssm.book.model.Customer">
      <id property="customerId" javaType="java.lang.Integer" column="customer_id"></id>
      <result property="customerName" javaType="java.lang.String" column="customer_name"></result>
    </association>
  </resultMap>

 <select id="queryCustomerByCid" resultMap="ManyToOne">
     select * from t_customer c inner
    join t_order o  on o.cid=c.customer_id where o.order_id=#{cid}
  </select>

输出如下：