多对一链表查询（mybatis）

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org/DTD Mapper 3.0"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.springhomework.dao.lianbiao">
<!--    多对一的查询-->
<select id="lianbiao" resultMap="Goods">
    select * from goods_stock
</select>
<!--    goods 起的别名 type必须是返回的实体类  与上面的resultmap相对应-->
    <resultMap id="Goods" type="Goods_stock">
         <result property="goods_id" column="goods_id"/>

<!-- 复杂的数据如实体类我们需要单独处理-->
<!--       对象使用association 集合使用collection-->
        <association property="OrderInfo" column="goods_id" javaType="Orderinfo" select="lianbiao2"/>
    </resultMap>
    <select id="lianbiao2" resultType="Orderinfo">
        select * from orderinfo where goods_id=#{goods_id}
    </select>




<!--    按照结果嵌套处理-->
    <select id="lianbiaozonghe" resultMap="goods2">
        SELECT * FROM
        goods_stock as g,orderinfo as o
        WHERE g.goods_id=o.goods_id
    </select>
    <resultMap id="goods2" type="Goods_stock">
        <result property="goods_id" column="goods_id"/>
        <association property="Order" javaType="OrderInfo">
            <result property="goods_id" column="goods_id"/>
        </association>
    </resultMap>
</mapper>