022.OneToMany对象关联查询（多表级联查询）

1.班级（1）---> 学生 （n）  学生必须持有班级的外键
2.1对1  通过主键关联
3.多对多必须单独抽象出一张中间表

package com.imooc.mybatis.entity;

public class GoodsDetail {
    private Integer gdId;
    private Integer goodsId;
    private String gdPicUrl;
    private Integer gdOrder;


    public Integer getGdId() {
        return gdId;
    }

    public void setGdId(Integer gdId) {
        this.gdId = gdId;
    }

    public Integer getGoodsId() {
        return goodsId;
    }

    public void setGoodsId(Integer goodsId) {
        this.goodsId = goodsId;
    }

    public String getGdPicUrl() {
        return gdPicUrl;
    }

    public void setGdPicUrl(String gdPicUrl) {
        this.gdPicUrl = gdPicUrl;
    }

    public Integer getGdOrder() {
        return gdOrder;
    }

    public void setGdOrder(Integer gdOrder) {
        this.gdOrder = gdOrder;
    }

}

        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">


                resultType="com.imooc.mybatis.entity.GoodsDetail">
        select *
        from t_goods_detail
        where goods_id = #{value}
    

package com.imooc.mybatis.entity;

import java.util.List;

public class Goods
{
    private Integer goodsId;//商品编号
    private String title;//标题
    private String subTitle;//子标题
    private Float originalCost;//原始价格
    private Float currentPrice;//当前价格
    private Float discount;//折扣率
    private Integer isFreeDelivery;//是否包邮 ,1-包邮 0-不包邮
    private Integer categoryId;//分类编号
    private List goodsDetails;

    public List getGoodsDetails()
    {
        return goodsDetails;
    }

    public void setGoodsDetails(List goodsDetails)
    {
        this.goodsDetails = goodsDetails;
    }

    public Integer getGoodsId()
    {
        return goodsId;
    }

    public void setGoodsId(Integer goodsId)
    {
        this.goodsId = goodsId;
    }

    public String getTitle()
    {
        return title;
    }

    public void setTitle(String title)
    {
        this.title = title;
    }

    public String getSubTitle()
    {
        return subTitle;
    }

    public void setSubTitle(String subTitle)
    {
        this.subTitle = subTitle;
    }

    public Float getOriginalCost()
    {
        return originalCost;
    }

    public void setOriginalCost(Float originalCost)
    {
        this.originalCost = originalCost;
    }

    public Float getCurrentPrice()
    {
        return currentPrice;
    }

    public void setCurrentPrice(Float currentPrice)
    {
        this.currentPrice = currentPrice;
    }

    public Float getDiscount()
    {
        return discount;
    }

    public void setDiscount(Float discount)
    {
        this.discount = discount;
    }

    public Integer getIsFreeDelivery()
    {
        return isFreeDelivery;
    }

    public void setIsFreeDelivery(Integer isFreeDelivery)
    {
        this.isFreeDelivery = isFreeDelivery;
    }

    public Integer getCategoryId()
    {
        return categoryId;
    }

    public void setCategoryId(Integer categoryId)
    {
        this.categoryId = categoryId;
    }

}

    
        
        
        
                            column="goods_id"/>
    

    
        select * from t_goods limit 0,10
    

/**
     * 一对多对象关联查询
     * @throws Exception
     */
    @Test
    public void testOneToMany() throws Exception {
        SqlSession session = null;
        try {
            session = MyBatisUtils.openSession();
            List list = session.selectList("goods.selectOneToMany");
            for(Goods goods:list) {
                System.out.println(goods.getTitle() + ":" + goods.getGoodsDetails().size());
            }
        } catch (Exception e) {
            throw e;
        } finally {
            MyBatisUtils.closeSession(session);
        }
    }