一对多的理解:
一个老师拥有多个学生
如果对于老师这边,就是一个一对多的现象,即从一个老师下面拥有一群学生(集合)!
1.实体类编写
Student 类
package com.lyh.pojo;
public class Student {
private String name;
private int id;
private int tid;
public Student(String name, int id, int tid) {
this.name = name;
this.id = id;
this.tid = tid;
}
public Student() {
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public int getTid() {
return tid;
}
public void setTid(int tid) {
this.tid = tid;
}
@Override
public String toString() {
return "Student{" +
"name='" + name + '\'' +
", id=" + id +
", tid=" + tid +
'}';
}
}
Teacher 类
package com.lyh.pojo;
import java.util.List;
public class Teacher {
private int id;
private String name;
//一个老师有多个学生
private List<Student> students;
public Teacher() {
}
public Teacher(int id, String name, List<Student> students) {
this.id = id;
this.name = name;
this.students = students;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public List<Student> getStudents() {
return students;
}
public void setStudents(List<Student> students) {
this.students = students;
}
@Override
public String toString() {
return "Teacher{" +
"id=" + id +
", name='" + name + '\'' +
", students=" + students +
'}';
}
}
按结果嵌套处理
1、TeacherMapper接口编写方法
List<Teacher> getTeacher2(int id);
2、编写接口对应的Mapper配置文件
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lyh.dao.TeacherMapper">
<!--
思路:
1. 从学生表和老师表中查出学生id,学生姓名,老师姓名
2. 对查询出来的操作做结果集映射
1. 集合的话,使用collection!
JavaType和ofType都是用来指定对象类型的
JavaType是用来指定pojo中属性的类型
ofType指定的是映射到list集合属性中pojo的类型。
-->
<select id="getTeacher" resultType="Teacher">
select * from teacher ;
</select>
<select id="getTeacher2" resultMap="studebtteacher">
select s.name sname,s.id sid,t.name tname ,t.id tid
from teacher t,student s where t.id=s.tid and t.id=#{id};
</select>
<resultMap id="studebtteacher" type="teacher">
<result property="id" column="tid"/>
<result property="name" column="tname"/>
<collection property="students" ofType="Student">
<result property="id" column="sid"/>
<result property="name" column="sname"/>
<result property="tid" column="tid"/>
</collection>
</resultMap>
3、将Mapper文件注册到MyBatis-config文件中
<mappers>
<mapper resource="mapper/TeacherMapper.xml"/>
</mappers>
4、测试
@Test
public void getTeacher2() {
SqlSession sqlSession = MybatisUtils.getSqlSession();
TeacherMapper teacherMapper = sqlSession.getMapper(TeacherMapper.class);
List<Teacher> st = teacherMapper.getTeacher2(1);
for (Teacher stt : st) {
System.out.println(stt);
}
sqlSession.close();
}
5.结果
按查询嵌套处理
1、TeacherMapper接口编写方法
Teacher getTeacher3(int id);
2、编写接口对应的Mapper配置文件
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lyh.dao.TeacherMapper">
<select id="getTeacher3" resultMap="studentteacher1">
select * from teacher where id=#{id};
</select>
<resultMap id="studentteacher1" type="Teacher">
<collection property="students" javaType="ArrayList" ofType="Student" select="getstudent" column="id"/>
</resultMap>
<select id="getstudent" resultType="Student">
select * from student where tid=#{id};
</select>
</mapper>
3、将Mapper文件注册到MyBatis-config文件中
4、测试
@Test
public void getTeacher3() {
SqlSession sqlSession = MybatisUtils.getSqlSession();
TeacherMapper teacherMapper = sqlSession.getMapper(TeacherMapper.class);
Teacher teachers = teacherMapper.getTeacher3(1);
System.out.println(teachers.getName());
System.out.println(teachers.getStudents());
sqlSession.close();
}
- 结果
——————————————————————————————————————————————————————————————
小结
1、关联-association
2、集合-collection
3、所以association是用于一对一和多对一,而collection是用于一对多的关系
4、JavaType和ofType都是用来指定对象类型的
JavaType是用来指定pojo中属性的类型
ofType指定的是映射到list集合属性中pojo的类型。
注意说明:
1、保证SQL的可读性,尽量通俗易懂
2、根据实际要求,尽量编写性能更高的SQL语句
3、注意属性名和字段不一致的问题
4、注意一对多和多对一 中:字段和属性对应的问题
5、尽量使用Log4j,通过日志来查看自己的错误