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
<include refid="Base_Column_List" />
from t_hibernate_order
where order_id = #