一对多，多对一 Mapper.xml

一对多

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--namespace绑定一个对应的Dao/Mapper接口-->
<mapper namespace="org.example.dao.TeacherMapper">
    <!--  查询语句  -->
    <!--  id=“xxx”  TeacherMapper中对jdbc执行的方法  -->
    <!--  resultType 返回结果集类型  -->
    <resultMap id="getTeacherStudent" type="Teacher">
        <result property="id" column="tid"/>
        <result property="name" column="tname"/>
        <!--   collection处理集合  ofType 用来指定映射到List或者集中的pojo类型，泛型中的约束类型   -->
        <collection property="student" ofType="Student">
            <result property="id" column="sid"/>
            <result property="name" column="sname"/>
            <result property="tid" column="tid"/>
        </collection>
    </resultMap>


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

</mapper>

多对一

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--namespace绑定一个对应的Dao/Mapper接口-->
<mapper namespace="org.example.dao.StudentMapper">
    <!--  查询语句  -->
    <!--  resultType 返回结果集类型  -->
    <resultMap id="StudentTeacher" type="Student">
            <result column="sid" property="id" />
            <result column="sname" property="name"/>
			<!-- 关联-association 多对一，javaType 用来指定实体类中属性的类型 -->
            <association property="teacher"  javaType="Teacher" >
                <result column="tid" property="id"/>
                <result column="tname" property="name"/>
            </association>
        </resultMap>

        <select id="getStudent" resultMap="StudentTeacher">
            select s.id sid,s.name sname,t.id tid,t.name tname
            from student s,teacher t
            where s.tid = t.id;
        </select>

</mapper>