使用mybatis实现一对多的关联

下面是我的目录

首先建立数据库：

teacher表：

student表：

class表：

然后再建立实体类：

Classes类：（注意：里面没有手动生成构造器，为什么呢？谁回答一下？）

package com.wfl.mybatis.bean5;

import java.util.List;

public class Classes {

 private int id;
 private String name;
 private Teacher teacher;
 private List<Student> students;
 public int getId() {
  return id;
 }
 public void setId(int id) {
  this.id = id;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public Teacher getTeacher() {
  return teacher;
 }
 public void setTeacher(Teacher 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 + ", students=" + students + "]";
 }
 
}

Student实体类：

package com.wfl.mybatis.bean5;

public class Student {

 private int id;
 private String name;
 public int getId() {
  return id;
 }
 public void setId(int id) {
  this.id = id;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }

 @Override
 public String toString() {
  return "Student [id=" + id + ", name=" + name + "]";
 }
 
}

Teacher实体类：

package com.wfl.mybatis.bean5;

public class Teacher {

 private int id;
 private String name;
 public int getId() {
  return id;
 }
 public void setId(int id) {
  this.id = id;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 @Override
 public String toString() {
  return "Teacher [id=" + id + ", name=" + name + "]";
 }
   
 
}

在创建一个工具类：

package com.myUtil5;

import java.io.InputStream;

import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

public class myUtil {
 public static SqlSession getSqlSession() {//getFactory
  String resource="conf.xml";
  // //加载mybatis 的配置文件（它也加载关联的映射文件）
  InputStream is=myUtil.class.getClassLoader().getResourceAsStream(resource);
  SqlSessionFactory factory=new SqlSessionFactoryBuilder().build(is);
  SqlSession sqlsession=factory.openSession();
  return sqlsession;
 }
}

下面是重点，创建映射文件：

<?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.wfl.mybatis.service5.classMapper">
    <!-- 方式一：嵌套结果：使用嵌套结果映射来处理重复的联合结果的子集
    select * from class c ,teacher t,student s where c.teacher_id=t.t_id and c.c_id=s.class_id and c.c_id=1  -->
  
    <select id="getClass3" parameterType="int" resultMap="classResultMap3">
      select * from class c,teacher t,student s where c.teacher_id=t.t_id and c.c_id=s.class_id and c.c_id=#{id}
    </select>
    <resultMap type="_Classes" id="classResultMap3">
      <id property="id" column="c_id"/>
      <result property="name" column="c_name"/>
      <!-- 用teacher_id 关联teacher表 ;javaType表示返回的类型是：-->
      <association property="teacher" column="teacher_id" javaType="_Teacher">
        <id property="id" column="t_id"/>
        <result property="name" column="t_name"/>
      </association>
      <!-- ofType指定student集合中的对象类型；一个班级对应多个学生用collection； -->
      <collection property="students" ofType="_Student">
        <id property="id" column="s_id"/>
        <result property="name" column="s_name"/>
      </collection>
    </resultMap>
    <!-- 方法二：嵌套查询，通过执行另外一个SQL映射语句来返回预期的复杂类型
       SELECT * FROM class WHERE c_id=1;
       SELECT * FROM teacher WHERE t_id=1 //1 是上一个查询得到的teacher_id 的值
       SELECT * FROM student WHERE class_id=1 //1 是第一个查询得到的c_id 字段的值
    -->
   <!--  <select id="getClass4" parameterType="int" resultMap="classResultMap4">
      select * from class where c_id=#{id}
    </select>
    <resultMap id="classResultMap4" type="_Class">
      <id property="id" column="c_id"/>
      <result property="name" column="c_name"/>
      关联Teacher类中的属性teacher
      <association property="teacher" column="t_id" javaType="_Teacher" select="getTeacher2"></association>
      <collection property="students" column="s_id"> ofType="_Student" select="getStudent2"></collection>
    </resultMap>
    <select id="getTeacher2" parameterType="int" resultType="_Teacher">
        select t_id id,t_name name from teacher where t_id=#{id}
    </select>
    <select id="getStudent2" parameterType="int" resultType="_Student">
      select s_id id,s_name name from student where class_id=#{id}
    </select>  -->
  </mapper>
 （其中方法二描黑的语句老是报错，不知道为神魔）

然后到配置文件去注册：

<?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>
   <typeAliases>
    <typeAlias alias="_Classes" type="com.wfl.mybatis.bean5.Classes"/>
     <typeAlias alias="_Teacher" type="com.wfl.mybatis.bean5.Teacher"/>
     <typeAlias alias="_Student" type="com.wfl.mybatis.bean5.Student"/> 
  </typeAliases>
  <environments default="development">
    <environment id="development">
       <transactionManager type="JDBC"/>
       <dataSource type="POOLED">
         <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
         <property name="url" value="jdbc:mysql://localhost:3306/mybatis"/>
         <property name="username" value="root"/>
         <property name="password" value="123456"/>
       </dataSource>
     </environment>
   </environments>
    <mappers>
     <mapper resource="com/wfl/mybatis/service5/classMapper.xml"/>
   </mappers>
 </configuration>