mybatis中一对多关系

一对多

一个老师对应多个学生,对于老师而言,就是一对多的关系.

实体类

package com.lx.pojo;


import lombok.Data;

import java.util.List;

@Data
public class Teacher {

    private int id;
    private String name;

    //一个老师拥有多名学生
    private List<Student> students;
}

package com.lx.pojo;


import lombok.Data;

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

}

接口定义方法

package com.lx.dao;

import com.lx.pojo.Teacher;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface TeacherMapper {

    //获取所有老师
    List<Teacher> getTeachers();

    //获取指定老师下的所有学生及老师信息
    Teacher getTeacherStudentsById(@Param("tid")  int id);

    Teacher getTeacherStudentsById2(@Param("tid") int id);

}

接口绑定的Mapper配置文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.lx.dao.TeacherMapper">


    <select id="getTeachers" resultType="com.lx.pojo.Teacher">
        select * from teacher ;
    </select>





<!--    =============================================================================-->
<!--    按照结果嵌套查询-->



    <select id="getTeacherStudentsById"  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="com.lx.pojo.Teacher" >
        <result column="tid" property="id"/>
        <result column="tname" property="name"/>

        <!--复杂的属性，我们需要单独处理 对象： association 集合： collection
        javaType="" 指定属性的类型！
        集合中的泛型信息，我们使用ofType获取
        -->

        <collection property="students" ofType="com.lx.pojo.Student" >
            <result property="id" column="sid"/>
            <result property="name" column="sname"/>
            <result property="tid" column="tid"/>
        </collection>

    </resultMap>



<!--    ===========================================================================-->



<!--    按照子查询-->
    <select id="getTeacherStudentsById2" resultMap="TeacherStudent2">
        select * from teacher where id = #{tid}
    </select>

    <resultMap id="TeacherStudent2" type="com.lx.pojo.Teacher">
        <collection property="students" javaType="ArrayList" ofType="com.lx.pojo.Student" select="getStudentByTeacherId" column="id"/>
    </resultMap>

    <select id="getStudentByTeacherId" resultType="com.lx.pojo.Student">
        select * from student where tid = #{tid}
    </select>




</mapper>

测试单元及结果:

 @Test
    public void test2(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        TeacherMapper mapper = sqlSession.getMapper(TeacherMapper.class);
        Teacher teacher = mapper.getTeacherStudentsById(1);
        System.out.println(teacher);
        sqlSession.close();

        /*
         输出结果
         Teacher(id=1, name=吴老师,
         students=[
         Student(id=1, name=张三, tid=1),
         Student(id=2, name=李四, tid=1),
         Student(id=3, name=王五, tid=1),
         Student(id=4, name=马六, tid=1),
         Student(id=5, name=陈七, tid=1),
         Student(id=111, name=luxin, tid=1)
         ])

         */


    }


    @Test
    public void test3(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        TeacherMapper mapper = sqlSession.getMapper(TeacherMapper.class);
        Teacher teacher = mapper.getTeacherStudentsById(2);
        System.out.println(teacher);

        sqlSession.close();


        /*
        Teacher(id=2, name=李老师,
        students=[
        Student(id=6, name=张华, tid=2),
        Student(id=7, name=李萍, tid=2),
        Student(id=8, name=我, tid=2)
        ])
         */
    }

1. 关联-association
2. 集合-collection
3. 所以association是用于一对一和多对一，而collection是用于一对多的关系
4. JavaType和ofType都是用来指定对象类型的
   JavaType是用来指定pojo中属性的类型
   ofType指定的是映射到list集合属性中pojo的类型。
   注意说明：
5. 保证SQL的可读性，尽量通俗易懂
6. 根据实际要求，尽量编写性能更高的SQL语句
7. 注意属性名和字段不一致的问题
8. 注意一对多和多对一 中：字段和属性对应的问题
9. 尽量使用Log4j，通过日志来查看自己的错误

对应文件:
mybatis-07