Mybatis一对多的处理

一对多

第一：写一个teache的javabean

package com.zzy.pojo;

import lombok.Data;

import java.util.List;

@Data
public class Teacher {
    private int id;
    private String name;
    //一个老师对应多个学生
    private List<Student> students;

}

注意：这里的student是一个集合类型 所以是一个复杂属性

第二：编写对象的teacherMapper

package com.zzy.dao;

import com.zzy.pojo.Teacher;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface TeacherMapper {
    Teacher getTeacher();
    List<Teacher> getTeacherById(@Param("tid") int id);


}

第三：编写对象的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.zzy.dao.TeacherMapper">
<select id="getTeacher" resultType="Teacher">
    select  *from teacher
</select>
    
    
    <resultMap id="TeacherStudent" type="Teacher">
        <result property="id" column="tid"/>
        <result property="name" column="tname"/>
<!--        实体类中有集合时  使用collection  property= 等于集合的里的类型名 ofType 是获取类的名字-->
        <collection property="students" ofType="Student">
            <result property="id" column="sid"/>
            <result property="name" column="sname"/>
            <result property="tid" column="tid"/>
        </collection>
    </resultMap>
    <select id="getTeacherById" 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>
</mapper>