mybatis一对多映射

一个班级有多个学生（一对多），一个学生只属于一个班级（多对一）。

准备数据库表：

create table tb_class(
c_id int primary key auto_increment,
c_name varchar(20));

insert into tb_class(c_name) values('Class One');

create table tb_student(
s_id int primary key auto_increment,
s_name varchar(20),
s_sex varchar(10),
s_age int,
s_c_id int,
foreign key(s_c_id) references tb_class(c_id));

insert into tb_student(s_name,s_sex,s_age,s_c_id) values('Tom','male',18,1);
insert into tb_student(s_name,s_sex,s_age,s_c_id) values('Jack','male',19,1);
insert into tb_student(s_name,s_sex,s_age,s_c_id) values('Rose','female',18,1);

准备连个实体类：
Classes.java

package xyz.fengqing11.hellomybatis.domain;

import java.util.List;

public class Classes {
    private Integer id;
    private String name;
    private HeadTeacher teacher;
    private List<Student> students;


    public Classes() {

    }

    public Classes(Integer id, String name, HeadTeacher teacher) {
        this.id = id;
        this.name = name;
        this.teacher = teacher;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public HeadTeacher getTeacher() {
        return teacher;
    }

    public void setTeacher(HeadTeacher teacher) {
        this.teacher = teacher;
    }

    public List<Student> getStudents() {
        return students;
    }

    public void setStudents(List<Student> students) {
        this.students = students;
    }

    @Override
    public String toString() {
        return "Classes{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", teacher=" + teacher +
                '}';
    }
}

Student.java

package xyz.fengqing11.hellomybatis.domain;

public class Student {
    private Integer id;
    private String name;
    private String sex;
    private Integer age;

    public Student() {

    }

    public Student(Integer id, String name, String sex, Integer age) {
        this.id = id;
        this.name = name;
        this.sex = sex;
        this.age = age;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    @Override
    public String toString() {
        return "Student{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", sex='" + sex + '\'' +
                ", age=" + age +
                '}';
    }
}

创建接口类：
IClassesDao.java

package xyz.fengqing11.hellomybatis.dao;

import xyz.fengqing11.hellomybatis.domain.Classes;

/**
 * 班级持久层接口
 */
public interface IClasserDao {
    /**
     * 查询班级，根据id查询班级
     * @param id
     * @return
     * @throws Exception
     */
    Classes selectClassById(Integer id) throws Exception;

    /**
     * 查询班级和它的学生，根据id查询某个班级的学生
     * @param id
     * @return
     * @throws Exception
     */
    Classes selectClassAndStudentsById(Integer id) throws Exception;
}

映射文件：
IClassesDao.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="xyz.fengqing11.hellomybatis.dao.IClasserDao">
    <select id="selectClassById" parameterType="int" resultMap="classmap">
        select * from tb_class c, tb_head_teacher t  where c.c_ht_id = t.ht_id and c.c_id=#{id}
    </select>
    <!--<resultMap id="classmap" type="xyz.fengqing11.hellomybatis.domain.Classes">
        <id property="id" column="c_id"/>
        <result property="name" column="c_name"/>
        <association property="teacher" javaType="xyz.fengqing11.hellomybatis.domain.HeadTeacher">
            <id property="id" column="ht_id"/>
            <result property="name" column="ht_name"/>
            <result property="age" column="ht_age"/>
        </association>
    </resultMap>-->

    <resultMap id="teachermap" type="xyz.fengqing11.hellomybatis.domain.HeadTeacher">
        <id property="id" column="ht_id"/>
        <result property="name" column="ht_name"/>
        <result property="age" column="ht_age"/>
    </resultMap>
    <resultMap id="classmap" type="xyz.fengqing11.hellomybatis.domain.Classes">
        <id property="id" column="c_id"/>
        <result property="name" column="c_name"/>
        <association property="teacher" column="c_ht_id" javaType="xyz.fengqing11.hellomybatis.domain.HeadTeacher"
                     resultMap="teachermap"/>
    </resultMap>


    <select id="selectClassAndStudentsById" parameterType="int" resultMap="classmap1">
         select c.c_id,c.c_name,s.s_id,s.s_name,s.s_sex,s.s_age from tb_class c left outer join tb_student s on c.c_id = s.s_c_id where c.c_id=#{id}
    </select>
    <resultMap id="classmap1" type="xyz.fengqing11.hellomybatis.domain.Classes">
        <id property="id" column="c_id"/>
        <result property="name" column="c_name"/>
        <collection property="students" ofType="xyz.fengqing11.hellomybatis.domain.Student">
            <id property="id" column="s_id"/>
            <result property="name" column="s_name"/>
            <result property="sex" column="s_sex"/>
            <result property="age" column="s_age"/>
        </collection>
    </resultMap>
</mapper>

---

-end-