java相关:mybatis 一对一、一对多和多对多查询实例代码
发布于 2020-8-14|
复制链接
摘记: 关键字:association 一对一映射(一个班级只有一个班主任)
```java
select * from class c,teacher t where c.teacher_id= ..
关键字:association 一对一映射(一个班级只有一个班主任)
```java
select * from class c,teacher t where c.teacher_id=t.t_id and c.c_id=#{id}
```
关键字:collection 一对多映射(一个老师有多个学生)
```java
SELECT
t.id,
t.NAME,
t.class_name
FROM
teacher t
select
s.id,
s. NAME,
s.class_name as className
from student s
where teacher_id = #{id}
```
关键字:association 多对一映射(多个人属于一个国家) 多对一相当于一对多,也可以使用collection
```java
select cid,cname from country where cid=#{ooo}
select pid,pname,countryId from people where pid = #{xxx}
```