Mybatis关联关系（一对多配置）

一对多

1.给两个实体类都定义一个vo类

package com.zhoujun.model.vo;

import com.zhoujun.model.Order;
import com.zhoujun.model.OrderItem;

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

/**
 * @author 小俊
 * @company 流弊公司董事长
 * @create  2020-10-28 16:01
 */
public class OrderVo extends Order {
   
    private List<OrderItem> orderItems=new ArrayList<>();

    public List<OrderItem> getOrderItems() {
   
        return orderItems;
    }

    public void setOrderItems(List<OrderItem> orderItems) {
   
        this.orderItems = orderItems;
    }
}

package com.zhoujun.model.vo;

import com.zhoujun.model.Order;
import com.zhoujun.model.OrderItem;

/**
 * @author 小俊
 * @company 流弊公司董事长
 * @create  2020-10-28 16:04
 */
public class OrderItemVo extends OrderItem {
   
    private Order order;

    public Order getOrder() {
   
        return order;
    }

    public void setOrder(Order order) {
   
        this.order = order;
    }
}

2.配对一对多关联关系

一的一方

sql语句

多的一方

sql语句

一方的源代码（OrderMapper.xml）

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.zhoujun.mapper.OrderMapper" >
  <resultMap id="BaseResultMap" type="com.zhoujun.model.Order" >
    <constructor >
      <idArg column="order_id" jdbcType="INTEGER" javaType="java.lang.Integer" />
      <arg column="order_no" jdbcType="VARCHAR" javaType="java.lang.String" />
    </constructor>
  </resultMap>

  <resultMap id="OrderVoMap" type="com.zhoujun.model.vo.OrderVo">
    <result property="orderId" column="order_id"></result>
    <result property="orderNo" column="order_no"></result>
<!--    <result property="orderItems" column="order_id"></result>-->
    <collection property="orderItems" ofType="com.zhoujun.model.OrderItem">
      <result property="orderItemId" column="order_item_id"></result>
      <result property="productId" column="product_id"></result>
      <result property="quantity" column="quantity"></result>
      <result property="oid" column="oid"></result>
    </collection>
  </resultMap>





  <sql id="Base_Column_List" >
    order_id, order_no
  </sql>
  <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
    select