MyBatis一对多

知道一个老师的信息，查询他所有学生的信息

• 编写老师的实体类Teacher.class

@Data
public class Teacher {
    private int id;
    private String name;
    private List<Student> students;
}

• 编写学生实体类Student.class

@Data
public class Student {
    private int id;
    private String name;
    private int tid;
}

• mybatis核心配置文件、mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
        <!DOCTYPE configuration
                PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
                "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!--引入外部配置文件-->
<properties resource="database.properties"/>

<!--设置日志类型-->
<settings>
    <setting name="logImpl" value="LOG4J"/>
</settings>

<typeAliases>
    <package name="com.ljq.pojo"/>
</typeAliases>

<environments default="development">
    <environment id="development">
        <transactionManager type="JDBC"/>
        <dataSource type="POOLED">
            <property name="driver" value="${driver}"/>
            <property name="url" value="${url}"/>
            <property name="username" value="${username}"/>
            <property name="password" value="${password}"/>
        </dataSource>
    </environment>
</environments>
<!--绑定接口-->
<mappers>
    <mapper class="com.ljq.dao.StudentMapper"/>
    <mapper class="com.ljq.dao.TeacherMapper"/>
</mappers>
</configuration>

• 编写TeacherMapper.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">
<mapper namespace="com.ljq.dao.TeacherMapper">

    <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>
</mapper>

• 测试

 @Test
    public void StudentTeachert() throws IOException {
        //获取配置文件
        InputStream in= Resources.getResourceAsStream("mybatis-config.xml");
        //创建工厂代理
        SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(in);
        //
        SqlSession sqlSession=sqlSessionFactory.openSession();
        TeacherMapper teacherMapper=sqlSession.getMapper(TeacherMapper.class);
        List<Teacher> teachers=teacherMapper.getTeacher(1);
        for (Teacher teacher : teachers) {
            System.out.println(teacher);
        }
    }