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