MyBatis一对一关联查询

*1,创建表和数据*
创建一张教师表和一张班级表,一个老师负责一个班级,那么他们之间的关系就是一对一的关系。

  CREATE TABLE teacher(
      t_id INT PRIMARY KEY AUTO_INCREMENT, 
      t_name VARCHAR(20)
  );
  CREATE TABLE class(
      c_id INT PRIMARY KEY AUTO_INCREMENT, 
      c_name VARCHAR(20), 
      teacher_id INT
  );
 ALTER TABLE class ADD CONSTRAINT fk_teacher_id FOREIGN KEY (teacher_id) REFERENCES teacher(t_id);    

 INSERT INTO teacher(t_name) VALUES('teacher1');
 INSERT INTO teacher(t_name) VALUES('teacher2');

 INSERT INTO class(c_name, teacher_id) VALUES('class_a', 1);
 INSERT INTO class(c_name, teacher_id) VALUES('class_b', 2);

表之间的关系就是:

2,定义实体类

package me.gacl.domain;

/**
 * @author gacl
 * 定义teacher表对应的实体类
 */
public class Teacher {
   
    //定义实体类的属性，与teacher表中的字段对应
    private int id;            //id===>t_id
    private String name;    //name===>t_name
    public int getId() {
        return id;
    }
    public void setId(int id) {