多表聯查,一對一

妻子和丈夫一對一關系

mapper.xml檔案代碼:

<?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.dao.WifeDao">

    <select id="findallwife" resultMap="com.qiangfeng.result.wi">
        select * from wife w,husband h where w.wifeid=h.wid
    </select>


    <select id="findallhus" resultMap="com.qiangfeng.result.hu">
        select * from wife w,husband h where w.wifeid=h.wid
    </select>
</mapper>
           

resultmapper.xml檔案代碼:

妻子:

<resultMap id="wi" type="wife">
        <id column="wifeid" property="wifeid"></id>
        <result column="wifename" property="wifename"></result>
        <association property="hus" javaType="husband">
            <id property="husid" column="husid"></id>
            <result column="husname" property="husname"></result>
        </association>
    </resultMap>
           

丈夫:

<resultMap id="hu" type="husband">
        <id property="husid" column="husid"></id>
        <result column="husname" property="husname"></result>
        <association property="wife" javaType="wife">
            <id column="wifeid" property="wifeid"></id>
            <result column="wifename" property="wifename"></result>
        </association>
    </resultMap>
           

測試

主查丈夫:

public static void main(String[] args) {
        SqlSession session = SessionUtil.getsession();
        WifeDao dao = (WifeDao)session.getMapper(WifeDao.class);
        List<Husband> hus = dao.findallhus();
        Iterator var4 = hus.iterator();

        while(var4.hasNext()) {
            Husband h = (Husband)var4.next();
            System.out.println(h.getHusname() + "," + h.getWife().getWifename());
        }

        session.close();
    }