mybatis中多对一查询映射的两种方式

按照结果集嵌套处理

    <select id="getStudent2" resultMap="StudentTeacher2">
        select s.id sid,s.name sanme,t.name tname,t.id tid from student s,teacher t
        where s.tid=t.id;
    </select>

    <resultMap id="StudentTeacher2" type="Student">
        <result property="id" column="sid"/>
        <result property="name" column="sname"/>
        <association property="teacher" javaType="Teacher">
            <result property="name" column="tname"></result>
            <result property="id" column="tid"></result>
        </association>
    </resultMap>

按照查询嵌套处理

    <resultMap id="StudentTeacher" type="Student">
        <result property="id" column="id"/>
        <result property="name" column="name"/>
        
        <association property="teacher" column="tid" javaType="Teacher" select="getTeacherById"/>

    </resultMap>

    <select id="getStudent" resultMap="StudentTeacher">
    select * from mybatis.teacher t,mybatis.student s;
</select>

    <select id="getTeacherById" resultType="Teacher">
        select * from mybatis.teacher where id=#{tid}
    </select>

注意：

只能简单属性，复杂的单独处理

复杂的属性单独处理
对象：association
集合：collection