这里讲一下使用注解方式实现mybatis的关系映射(一对一映射和一对多映射)
一、一对一映射
1.新建类Address(直接从前面讲使用xml配置方式实现关系映射的工程中复制即可):
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 + "]";
}
}
2.新建AddressMapper接口:这里使用注解的方式实现通过id查找地址信息
package com.test.mappers;
import com.test.model.Address;
public interface AddressMapper {
@Select("select * from t_address where id=#{id}")
public Address findById(Integer id);
}
3.表t_student中添加字段addressId,并其与t_address关联