MyBatis实现一对一，一对多关联查询

CREATE TABLE classes (

c_id int(11) NOT NULL AUTO_INCREMENT COMMENT ‘班级id’,

c_name varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘班级名’,

teacher_id int(11) NULL DEFAULT NULL COMMENT ‘老师id’,

PRIMARY KEY (c_id) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic COMMENT ‘班级表’;

---

– Records of classes

---

INSERT INTO classes VALUES (1, ‘高三2班’, 1);

INSERT INTO classes VALUES (2, ‘高一4班’, 2);

---

– Table structure for teacher

---

DROP TABLE IF EXISTS teacher;

CREATE TABLE teacher (

t_id int(11) NOT NULL AUTO_INCREMENT COMMENT ‘老师id’,

t_name varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘老师姓名’,

PRIMARY KEY (t_id) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic COMMENT ‘老师表’;

---

– Records of teacher

---

INSERT INTO teacher VALUES (1, ‘老师张三’);

INSERT INTO teacher VALUES (2, ‘老师李四’);

SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;

---

– Table structure for student

---

DROP TABLE IF EXISTS student;

CREATE TABLE student (

s_id int(11) NOT NULL AUTO_INCREMENT COMMENT ‘学生id’,

s_name varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘学生姓名’,

class_id int(11) NULL DEFAULT NULL COMMENT ‘班级id’,

PRIMARY KEY (s_id) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic COMMENT ‘学生表’;

---

– Records of student

<