Mybatis:1.多对一处理；2.一对多处理

1.多对一处理

查询多个学生对应的老师
(1)创建数据库
<1>student表

添加数据

<2>teacher表

添加数据

(2)实体类创建
<1>Student类

@Data
@Getter
@Setter
@NoArgsConstructor
@AllArgsConstructor
public class Student {
    private int id;
    private String name;

    private Teacher teacher;
}

<2>Teacher类

@Data
@Getter
@Setter
@NoArgsConstructor
@AllArgsConstructor
public class Teacher {
    private int id;
    private String name;

}

(3)dao接口

//查询学生和对应老师的信息
    //按照查询嵌套处理
    List<Student> getStudent1();
    //按照结果嵌套处理
    List<Student> getStudent2();

(4)接口实现类及测试
<1>按照查询嵌套处理

    <select id="getStudent1" resultMap="StudentTeacher">
        select * from student ;
    </select>

    <resultMap id="StudentTeacher" type="pojo.Student">
        <!--复杂属性需要单独处理,对象使用association-->
        <association property="teacher" column="tid" javaType="pojo.Teacher" select="getTeacher"/>
    </resultMap>

    <select id="getTeacher" parameterType="int" resultType="pojo.Teacher">
        select  * from teacher where id=#{id};
    </select>

测试

@Test
    public void getStudent1() {
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);

        List<Student> studentList = mapper.getStudent1();

        for (Student student : studentList) {
            System.out.println(student);
        }

        sqlSession.close();
    }

结果

<2>按照结果嵌套处理

   <select id="getStudent2" 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="pojo.Student">
        <result property="id" column="sid"/>
        <result property="name" column="sname"/>
        <association property="teacher" javaType="pojo.Teacher">
            <result property="name" column="tname"/>
        </association>
    </resultMap>

测试：

@Test
    public void getStudent2() {
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);

        List<Student> studentList = mapper.getStudent1();

        for (Student student : studentList) {
            System.out.println(student);
        }

        sqlSession.close();
    }

结果

2.一对多处理

按照结果嵌套处理
<1>dao接口

//获取指定老师下的所有学生
    Teacher getTeacher(int tid);

<2>接口显示类

<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="pojo.Teacher">
        <result property="id" column="tid"/>
        <result property="name" column="tname"/>
        <!--集合：collection-->
        <collection property="students" ofType="pojo.Student">
            <result property="id" column="sid"/>
            <result property="name" column="sname"/>
        </collection>
    </resultMap>

<3>测试

@Test
    public void getTeacher() {
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        TeacherMapper mapper = sqlSession.getMapper(TeacherMapper.class);
        Teacher teacher = mapper.getTeacher(1);

        System.out.println(teacher);
        sqlSession.close();
    }

结果