这一讲讲述mybatis如何实现一对一关系映射。
我们这里以学生-地址 一对一关系来进行演示。
1.在数据库中新建一个表t_address:给这个表添加部分数据
2.修改表t_student,添加一个addressId字段,这个字段对应t_address表的主键:
对这两张表进行一对一关联:
这样我们就实现了这两个表的关联。
3.工程中新建类Address:
package com.test.model;
public class Address {
private Integer id;
private String sheng;
private String shi;
private String qu;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getSheng() {
return sheng;
}
public void setSheng(String sheng) {
this.sheng = sheng;
}
public String getShi() {
return shi;
}
public void setShi(String shi) {
this.shi = shi;
}
public String getQu() {
return qu;
}
public void setQu(String qu) {
this.qu = qu;
}
@Override
public String toString() {
return "Address [id=" + id + ", sheng=" + sheng + ", shi=" + shi + ", qu=" + qu + "]";
}
}
4.修改类Student,添加Address类对象:
package com.test.model;
public class Student {
private Integer id;
private String name;
private Integer age;
private Address address;
public Student(String name, Integer age) {
super();
this.name = name;
this.age = age;
}
public Student() {
super();
// TODO Auto-generated constructor stub
}
public Student(Integer id, String name, Integer age) {
super();
this.id = id;
this.name = name;
this.age = age;
}
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;
}
pub