多对一
多个学生,对应一个老师
对于学生这边而言, 关联 … 多个学生,关联一个老师 【多对一】
对于老师而言, 集合 , 一个老师,有很多学生 【一对多】
创建SQL
CREATE TABLE `teacher` (
`id` INT(10) NOT NULL,
`name` VARCHAR(30) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8
INSERT INTO teacher(`id`, `name`) VALUES (1, '秦老师');
CREATE TABLE `student` (
`id` INT(10) NOT NULL,
`name` VARCHAR(30) DEFAULT NULL,
`tid` INT(10) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fktid` (`tid`),
CONSTRAINT `fktid` FOREIGN KEY (`tid`) REFERENCES `teacher` (`id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8
INSERT INTO `student` (`id`, `name`, `tid`) VALUES ('1', '小明', '1');
INSERT INTO `student` (`id`, `name`, `tid`) VALUES ('2', '小红', '1');
INSERT INTO `student` (`id`, `name`, `tid`) VALUES ('3', '小张', '1');
INSERT INTO `student` (`id`, `name`, `tid`) VALUES ('4', '小李', '1');
INSERT INTO `student` (`id`, `name`, `tid`) VALUES ('5', '小王', '1');
测试环境搭建
- 导入lombok
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.12</version>
</dependency>
- 新建实体类 Teacher,Student
import lombok.Data;
import java.util.List;
@Data
public class Teacher {
private int id;
private String name;
}
import lombok.Data;
@Data
public class Student {
private int id;
private String name;
//private int tid;
private Teacher teacher;
}
- 建立Mapper接口
import com.yang.pojo.Student;
import java.util.List;
public interface StudentMapper {
List<Student> getStudents();
}
- 建立Mapper.XML文件
<mapper namespace="com.yang.mapper.StudentMapper">
<resultMap id="StudentTeacher" type="Student">
<id property="id" column="sid"/>
<result property="name" column="sname"/>
<!--association关联,这个对象是什么类型的-->
<association property="teacher" javaType="Teacher">
<result property="name" column="tname"/>
</association>
</resultMap>
<select id="getStudents" resultMap="StudentTeacher">
SELECT s.id sid,s.name sname,t.name tname
FROM student s,teacher t
WHERE s.tid=t.id
</select>
</mapper>
- 在核心配置文件中绑定注册我们的Mapper接口或者文件!【方式很多,随心选】
<mappers>