基于Mapper接口的开发规范
1、 mapper接口的全限定名要和mapper映射文件的namespace的值相同。
2、 mapper接口的方法名称要和mapper映射文件中的statement的id相同;
3、 mapper接口的方法参数只能有一个,且类型要和mapper映射文件中statement的parameterType的值保持一致。
4、 mapper接口的返回值类型要和mapper映射文件中statement的resultType值或resultMap中的type值保持一致;
5、 mapper.xml命名遵守(接口名+Mapper.xml) CourseMapper.java与CourseMapper.xml
resultType
新建一个pojo存放查询信息
resultMap
在已存在的类中添加关联信息
基于xml关联映射的实例
pojo层
1. Student.java
package cn.edu.scnu.association.xml.po;
public class Student {
private Integer id;
private String name;
private Integer age;
private Integer sch_id;
//resultMap添加关联信息
private School school;
public School getSchool() {
return school;
}
public void setSchool(School school) {
this.school = school;
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
public Integer getSch_id() {
return sch_id;
}
public void setSch_id(Integer sch_id) {
this.sch_id = sch_id;
}
@Override
public String toString() {
return "Student{" +
"id=" + id +
", name='" + name + '\'' +
", age=" + age +
", sch_id=" + sch_id +
", school=" + school +
'}';
}
}
- School.java
package cn.edu.scnu.association.xml.po;
import java.util.List;
public class School {
private Integer id;
private String name;
private List<Student> students;
public List<Student> getStudents() {
return students;
}
public void setStudents(List<Student> students) {
this.students = students;
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String