同Hibernate一样,Mybatis在进行关联操作时,使用也是极为方便的。本文仅就一对一关联查询及添加进行讲解,update和delete没什么差别。
先来看看关联查询,假设有丈夫(Husband)和妻子(Wife),属于一对一,如果看官觉得可行,也可以一对多,我无甚意见。
Husband:
public class Husband implements Serializable{
int id;
String name;
Wife wifeId;
getter....
setter....
}
Wife:
public class Wife implements Serializable{
int id;
String name;
getter...
setter...
}
级联查询时:当查询Husband时,会将对应的Wife保存到wifeId中。
com.sdj.dao.map.HusbandMapper:
@Select("SELECT * FROM husband where id=#{id}")
@Results(value={
@Result(property="id",column="id"),
@Result(property="name",column="name"),
@Result(property="wifeId",column="wifeId",javaType=Wife.class,
one=@One(select="com.sdj.dao.map.WifeMapper.getWifeById")) })
public Husband getHusbandById(int id);
com.sdj.dao.map.WifeMapper:
@Select("select * from wife where id = #{id}")
public Wife getWifeById(int id)
注意上面的one=@One(select=""),这个会调用WifeMapper中的getWifeById()方法把对应的Wife查询出来绑定到Husband对象中。
级联添加时:当添加Husband时,会将对应的Wife也添加到数据库中。
com.sdj.dao.map.HusbandMapper:
@Insert("insert into husband(name,wifeId) values(#{name},#{wifeId.id})")
public void addHusband(Husband husband);
注意上门的#{wifeId.id},这个地方类似于Struts的OGNL表达式,Mybatis映射时,会去调用husband.getWifeId().getId(),从而将对应的wifeId值获取到,插入到对应的数据库中。