MyBatis——小知识:resultMap_关联查询_环境搭建
首先我们必须创建两张表
employee表
CREATE TABLE employee(
id INTEGER PRIMARY KEY auto_increment,
lastName VARCHAR(30) NOT NULL,
email VARCHAR(30) NOT NULL,
gendar VARCHAR(30) NOT NULL,
d_id INTEGER
)
department表
CREATE TABLE department(
did INTEGER PRIMARY KEY auto_increment,
depName VARCHAR(30)
)
在employee表中添加外键did
ALTER TABLE employee ADD CONSTRAINT fk_amp_dep
FOREIGN KEY(d_id) REFERENCES department(did);
可得两张表
employee表
department表