一对多的理解:
-
一个老师拥有多个学生
-
如果对于老师这边,就是一个一对多的现象,即从一个老师下面拥有一群学生(集合)!
10.1、环境搭建
实体类:
@Data
public class Student {
private int id;
private String name;
private int tid;
}
@Data
public class Teacher {
private int id;
private String name;
private List<Student> student;
}
10.2、按照查询嵌套处理
<select id="GetTeacher" resultMap="TeacherStudent">
select t.id tid,t.name tname,s.id sid,s.name sname
from teacher t join student s on t.id = s.tid
where t.id=#{id}
</select>
<resultMap id="TeacherStudent" type="Teacher">
<result property="id" column="tid"/>
<result property="name" column="tname"/>
<collection property="student" ofType="Student">
<result property="id" column="sid"/>
<result property="name" column="sname"/>
<result property="tid" column="tid"/>
</collection>
</resultMap>
10.3、按照结果嵌套处理
<select id="GetTeacher" resultMap="TeacherStudent">
select t.id,t.name
from teacher t where id=#{id}
</select>
<resultMap id="TeacherStudent" type="Teacher">
<result property="id" column="id"/>
<result property="name" column="name"/>
<collection property="student" column="id" javaType="ArrayList" ofType="Student" select="student"/>
</resultMap>
<select id="student" resultType="Student">
select * from student where tid=#{id}
</select>
测试:
public class MyTest {
public static void main(String[] args) {
SqlSession sqlSession = MybatisUtils.getSqlSession();
TeacherMapper mapper = sqlSession.getMapper(TeacherMapper.class);
List<Teacher> teachers = mapper.GetTeacherList();
for (Teacher teacher : teachers) {
System.out.println(teacher);
}
sqlSession.close();
}
@Test
public void test(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
TeacherMapper mapper = sqlSession.getMapper(TeacherMapper.class);
Teacher teacher = mapper.GetTeacher(1);
System.out.println(teacher);
sqlSession.close();
}
@Test
public void test1(){
System.out.println(idutils.getid());
System.out.println(idutils.getid());
System.out.println(idutils.getid());
}
}
10.4、小结
1、关联-association【多对一】
2、集合-collection【一对多】
3、association是用于一对一和多对一,而collection只用于一对多的关系
4、JavaType和ofType都是用来指定对象类型的
-
JavaType是用来指定pojo中属性的类型
-
ofType指定的是映射到list集合属性中pojo的类型。
注意说明:
1、保证SQL的可读性,尽量通俗易懂
2、根据实际要求,尽量编写性能更高的SQL语句
3、注意属性名和字段不一致的问题
4、注意一对多和多对一 中:字段和属性对应的问题
5、尽量使用Log4j,通过日志来查看自己的错误