Mybatis面对一对多如何查询

方法一：按照结果查询

<select id = "getTeacher" resultMap = "TeacherStudent">
    select s.id sid, s.name sname, t.name tname, t.id tid
    from student s, teacher t
    where s.tid = t.id and t.id = #{tid}
</select>

<resultMap id = "TeacherStudent" type = "Teacher">
    <result property = "id" column = "tid"/>
    <result property= "name" column = "tname"/>
    <!--复杂的属性，我们需要单独处理 对象:association 集合:collection
    javaType=""指定属性的类型!
    集合中的泛型信息，我们使用ofType获取
    -->
    <collection property = "students" ofType = "Student">
        <result property = "id" column = "sid"/>
        <result property = "name" column = "sname"/>
        <result property = "tid" column = "tid"/>
    </collection> 
</resultMap>

方法二：按照查询嵌套处理

<select id= "getTeacher" resultMap = "Teacherstudent">
    select * from mybatis.teacher where id= #{tid}
</select>

<resultMap id = "Teacherstudent" type = "Teacher">
    <collection property = "students" javaType = "ArrayList" ofType = "student"     
    select = "getstudent" column = "id"/>
</resultMap>

<select id = "getstudent" resultType = "Student">
    select * from mybatis.student where tid = #{tid}
</select>