10-Mybatis-一对多

1-环境搭建

与多对一相对应的是一对多

1.1-实体类

• Student

  package config.pojo;
  
  import lombok.Data;
  
  @Data
  public class Student {
      private int id;
      private String name;
      private int tid;
  }
  

• Teacher

  package config.pojo;
  
  import lombok.Data;
  
  import java.util.List;
  
  @Data
  public class Teacher {
      private int id;
      private String name;
      private List<Student> students;
  }
  

1.2-接口

• TeacherMapper

  package config.dao;
  
  import config.pojo.Student;
  import config.pojo.Teacher;
  import org.apache.ibatis.annotations.Param;
  import org.apache.ibatis.annotations.Select;
  
  import java.util.List;
  
  public interface TeacherMapper {
  
      public List<Teacher> getTeacher();
  }
  

1.3-Mapper文件

• TeacherMapper.xml

  <?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="config.dao.TeacherMapper">
      <select id="getTeacher" resultType="config.pojo.Teacher">
          select *
          from mybatis.teacher;
      </select>
      
      <resultMap id="TeacherStudent" type="config.pojo.Teacher">
          <result property="id" column="tid"></result>
          <result property="name" column="tname"></result>
          <collection property="students" ofType="config.pojo.Student">
              <result property="id" column="sid"></result>
              <result property="name" column="sname"></result>
              <result property="tid" column="tid"></result>
          </collection>
      </resultMap>
      <select id="getTeacherStudent" 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 = #{teacherId}
      </select>
  </mapper>
  

1.4-核心配置文件

<?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>
    <properties resource="db.properties"></properties>
    <settings>
        <setting name="logImpl" value="STDOUT_LOGGING"/>
    </settings>
    <environments default="default">
        <environment id="default">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="${driver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${username}"/>
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>
    </environments>

    <mappers>
        <mapper resource="config/dao/TeacherMapper.xml"></mapper>
    </mappers>

</configuration>

1.5-测试文件

import config.dao.TeacherMapper;
import config.pojo.Teacher;
import config.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.List;

public class MyTest {
    @Test
    public void test() {
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        TeacherMapper mapper = sqlSession.getMapper(TeacherMapper.class);
        List<Teacher> teacherList = mapper.getTeacher();
        for (Teacher teacher : teacherList) {
            System.out.println(teacher);
        }
        sqlSession.close();
    }

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

2-代码分析

• test()参考 10-多对一.md 3.1

• TeacherStudentTest()参考 10-多对一.md 3.2.2

  不同之处：由于Teacher实体类中的students属性是一个集合，在resultMap映射中，该属性要用<collection>，其中指定类型应该用ofType