mybatis 使用collection标签实现一对多查询(普通使用使用)

Mapper:

<?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="OrderHeaderMapper">
    <resultMap id="OrderView_M" type="OrderView_M">
        <id column="order_id" property="orderID" jdbcType="INTEGER"/>
        <result column="order_number" property="orderNumber" jdbcType="VARCHAR"/>
        <collection property="orderDetail" ofType="OrderDetailView_M">
            <id column="order_detail_id" property="orderDetailID" jdbcType="INTEGER"/>
            <result column="product_name" property="productName" jdbcType="VARCHAR"/>
        </collection>
    </resultMap>
    <select id="getOrderListPage" resultMap="OrderView_M">
        SELECT
            oh.order_id,
            oh.order_number,
            od.order_detail_id,
            od.product_name
        FROM
            order_header oh
        LEFT JOIN order_detail od ON od.order_id = oh.order_id
        ORDER BY
            oh.order_date DESC
    </select>
</mapper> 


 
public class OrderView_M {  
    private Integer orderID;  
    private String orderNumber;   
    private List<OrderDetailView_M> orderDetail;  
  
    public Integer getOrderID() {  
        return orderID;  
    }  
  
    public void setOrderID(Integer orderID) {  
        this.orderID = orderID;  
    }  
  
    public String getOrderNumber() {  
        return orderNumber;  
    }  
  
    public void setOrderNumber(String orderNumber) {  
        this.orderNumber = orderNumber;  
    }  
  
    public List<OrderDetailView_M> getOrderDetail() {  
        return orderDetail;  
    }  
  
    public void setOrderDetail(List<OrderDetailView_M> orderDetail) {  
        this.orderDetail = orderDetail;  
    }  
}  

public class OrderDetailView_M {  
    private Integer orderDetailID;  
    private String productName;  
  
    public String getProductName() {  
        return productName;  
    }  
  
    public void setProductName(String productName) {  
        this.productName = productName;  
    }  

    public Integer getOrderDetailID() {  
        return orderDetailID;  
    }  
  
    public void setOrderDetailID(Integer orderDetailID) {  
        this.orderDetailID = orderDetailID;  
    }  
}  


  • 0
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值