05-Mybatis-多对一的实现

mybatis多对一的实现（很多学生对应一个老师）

1. 创建两个表（1.学生表2.老师表）
   
   2.搭建环境（创建一个maven项目）
   
   3.创建学生和老师的实体类
   (1)学生实体类

package com.lty.pojo;

import lombok.Data;

@Data
public class Student {
  private int id;
  private String name;
  private Teacher teacher;
}

（2）老师的实体类

package com.lty.pojo;

import lombok.Data;

@Data
public class Teacher {
  private int id;
  private String name;
}

4.创建学生和老师对应的的接口
(1)学生的接口

package com.lty.dao;

import com.lty.pojo.Student;

import java.util.List;

public interface StudentMapper {
  List<Student> getStudent();
}

(2)老师的接口

package com.lty.dao;

import com.lty.pojo.Teacher;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface TeacherMapper {
  @Select("select * from teacher where id=#{tid}")
  Teacher getTeacher(@Param("tid") int id);
}

5.创键老师和学生接口对应的映射文件
（1）学生接口映射文件

<?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="com.lty.dao.StudentMapper">
  <select id="getStudent" resultMap="StudentTeacher">
    select s.id sid,s.name sname,t.name tname
    from student s,teacher t
    where s.tid=t.id
  </select>
  <resultMap id="StudentTeacher" type="Student">
    <result property="id" column="sid"/>
    <result property="name" column="sname"/>
    <association property="teacher" javaType="Teacher">
      <result property="name" column="tname"/>
    </association>
  </resultMap>

</mapper>

(2)学生接口对应的映射文件

<?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="com.lty.dao.TeacherMapper">

</mapper>

6.配置文件（mybatis-config.xml）

<?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"/>
  <settings>
    <setting name="logImpl" value="STDOUT_LOGGING"/>
  </settings>
  <typeAliases>
<!--    在实体类比较少的时候，比较适合使用，可以自动一别名-->
    <typeAlias type="com.lty.pojo.Teacher" alias="teacher"/>
    <typeAlias type="com.lty.pojo.Student" alias="student"/>

  </typeAliases>
  <environments default="development">
    <environment id="development">
      <transactionManager type="JDBC"/>
      <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 class="com.lty.dao.TeacherMapper"/>
   <mapper class="com.lty.dao.StudentMapper"/>
 </mappers>
</configuration>

7.测试

package com.lty.test;

import com.lty.dao.StudentMapper;
import com.lty.dao.TeacherMapper;
import com.lty.pojo.Student;
import com.lty.pojo.Teacher;
import com.lty.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.List;

public class MyTest {
  @Test
  public void test01(){
    SqlSession session = MybatisUtils.getSession();
    TeacherMapper mapper = session.getMapper(TeacherMapper.class);
    Teacher teacher = mapper.getTeacher(1);
    System.out.println(teacher);
    session.close();
  }
  @Test
  public void test02(){
    SqlSession session = MybatisUtils.getSession();
    StudentMapper mapper = session.getMapper(StudentMapper.class);
    List<Student> list = mapper.getStudent();
    for (Student student : list) {
      System.out.println(student);
    }
    session.close();

  }
}