Mybatis一对一关联查询

Mybatis一对一关联查询

有两张表，老师表teacher和班级表class，一个class班级对应一个teacher，一个teacher对应一个class

需求是根据班级id查询班级信息(带老师的信息)

创建teacher和class表：

    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('LS1');
    INSERT INTO teacher(t_name) VALUES('LS2');
    INSERT INTO class(c_name, teach