Mybatis 多表关联查询(2) one-to-many关系
本文中未说明的都在多表关联查询(1)中有说明。
基础文件
- 在mybatis- config.xml文件加入两个映射文件
<mapper resource="com/adoken/mapper/ClassesMapper.xml"/>
<mapper resource="com/adoken/mapper/StudentMapper.xml"/>
- one2many.sql(数据库脚本)
1个班级N个学生
DROP TABLE IF EXISTS STUDENT;
DROP TABLE IF EXISTS CLASSES;
CREATE TABLE CLASSES(
ID INT PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(20) NOT NULL
) ;
INSERT INTO CLASSES (NAME) VALUES ("JAVA班");
INSERT INTO CLASSES (NAME) VALUES ("IOS班");
CREATE TABLE STUDENT(
ID INT PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(20) NOT NULL,
C_ID INT NOT NULL,
FOREIGN KEY(C_ID) REFERENCES CLASSES(ID)
);
INSERT INTO STUDENT (NAME,C_ID) VALUES ("张三","1");
INSERT INTO STUDENT (NAME,C_ID) VALUES ("李四",