MyBatis多表查询

1、一对多

//Bean类 Teachers

public class Teachers {
    //老师有多个学生
    private int id;
    private String name;
    private List<Students> students;
}   


    <select id="getTeacher" resultMap="studentteacher">
       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="studentteacher" type="teacher">
        <result property="id" column="tid"></result>
        <result property="name" column="tname"></result>
        <collection property="students" ofType="student">
            <result property="id" column="sid"></result>
            <result property="name" column="sname"></result>
        </collection>
    </resultMap>

2、多对一

//Bean类Student
    
public class Students {
    private int id;
    private String name;

    //学生要关联一个老师
    private Teachers teachers;
}


    <select id="getStudents2" resultMap="StudentTeacher2">
        select s.id sid,s.name sname,t.name tname
        from student s,teacher t
        where s.tid=t.id;
    </select>
    <resultMap id="StudentTeacher2" type="student">
        <result property="id" column="sid"></result>
        <result property="name" column="sname"></result>
        <association property="teachers" javaType="teacher">
            <result property="name" column="tname"></result>
        </association>
    </resultMap>