• one2one


    多表连接

    <mapper namespace="com.abc.dao.IHusbandDao">
    
        <!-- 多表连接查询 -->
    
        <!-- 定义结果映射关系 -->
        <resultMap type="Husband" id="husbandMap">
            <id column="hid" property="hid" />
            <result column="hname" property="hname" />
            <association property="wife" javaType="Wife">
                <id column="wid" property="wid" />
                <result column="wname" property="wname" />
            </association>
        </resultMap>
    
        <select id="selectHusbandById" resultMap="husbandMap">
            select hid,hname,wid,wname
            from husband,wife
            where wid=wifeId and hid=#{xxx}
        </select>
    
    </mapper>

    多表单独

    <mapper namespace="com.abc.dao.IHusbandDao">
    
        <!-- 多表单独查询 -->
    
        <select id="selectWifeByHusband" resultType="Wife">
            select wid,wname from wife where wid=#{jjj}
        </select>
    
        <!-- 定义结果映射关系 -->
        <resultMap type="Husband" id="husbandMap">
            <id column="hid" property="hid" />
            <result column="hname" property="hname" />
            <association property="wife" 
                         javaType="Wife"
                         select="selectWifeByHusband"
                         column="wifeId"/>
        </resultMap>
    
        <select id="selectHusbandById" resultMap="husbandMap">
            select hid,hname,wifeId from husband where hid=#{xxx}
        </select>
    
    </mapper>

    多表连接2

        <!-- 多表连接查询 -->
    
        <!-- 定义结果映射关系 -->
        <resultMap type="Husband" id="husbandMap">
            <id column="hid" property="hid" />
            <result column="hname" property="hname" />
            <association property="wife" javaType="Wife">
                <id column="wid" property="wid" />
                <result column="wname" property="wname" />
            </association>
        </resultMap>
    
        <select id="selectHusbandById" resultMap="husbandMap">
            select hid,hname,wid,wname
            from husband,wife
            where wid=hid and hid=#{xxx}
        </select>

    多表单独2

    <mapper namespace="com.abc.dao.IHusbandDao">
    
        <!-- 多表单独查询 -->
    
        <select id="selectWifeByHusband" resultType="Wife">
            select wid,wname from wife where wid=#{jjj}
        </select>
    
        <!-- 定义结果映射关系 -->
        <resultMap type="Husband" id="husbandMap">
            <id column="hid" property="hid" />
            <result column="hname" property="hname" />
            <association property="wife" 
                         javaType="Wife"
                         select="selectWifeByHusband"
                         column="hid"/>
        </resultMap>
    
        <select id="selectHusbandById" resultMap="husbandMap">
            select hid,hname from husband where hid=#{xxx}
        </select>
    
    </mapper>
  • 相关阅读:
    JavaScript-4(循环语句)
    JavaScript-3
    JavaScript-2(基本运算)
    JavaScript-1
    HTML基础-3(框架、表单与表格等)
    HTML基础-2(内容容器等)
    HTML基础-1(b,i,u命令等)
    【CSP-S2019模拟】10.07比赛总结
    JZOJ6380. 【NOIP2019模拟2019.10.06】小w与最长路(path)
    【CSP-S2019模拟】10.06比赛总结
  • 原文地址:https://www.cnblogs.com/csslcww/p/9912340.html
Copyright © 2020-2023  润新知