Mybatis采坑

最新推荐文章于 2022-09-13 13:32:29 发布

一颗洛米

最新推荐文章于 2022-09-13 13:32:29 发布

阅读量207

点赞数

CC 4.0 BY-SA版权

分类专栏： Mybatis/Mybatis-plus 文章标签： mybatis

本文链接：https://blog.youkuaiyun.com/qq_30604989/article/details/80596579

Mybatis/Mybatis-plus 专栏收录该内容

13 篇文章

订阅专栏

本文通过一个具体的 MyBatis resultMap 配置示例，详细解释了如何在 resultMap 中定义 id 和 result 映射，以及如何处理集合类型的映射。特别关注了在配置集合时，需要为集合内部的对象 ID 定义别名的问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

collection中的id需要取别名与之对应，否则出错

<resultMap id="supplier" type="com.ch.cooker.tob.facade.pojo.dbo.SupplierOrgDbo">
    <id column="id" property="id"/>
    <result column="name" property="name"/>
    <result column="address" property="address"/>
    <result column="code" property="code"/>
    <result column="busi_name" property="busiName"/>
    <result column="handphone" property="handphone"/>
    <result column="org_a_id" property="salerId"/>

    <result column="licence" property="licence"/>
    <result column="permission" property="permission"/>
    <result column="status" property="status"/>

    <result column="date_start" property="contractDateStart"/>
    <result column="date_end" property="contractDateEnd"/>

    <collection property="goodsGroupVos" ofType="com.ch.cooker.tob.facade.pojo.dbo.GoodsGroupDbo" javaType="ArrayList">
        <id column="gid" property="id"/>
        <result column="group_name" property="groupName"/>
    </collection>
</resultMap>

<select id="getAllSupplier" resultMap="supplier">
    SELECT soe.id,soe.name,soe.address,soe.code,soe.busi_name,soe.handphone,soe.`enable`,
    soc.date_start,soc.date_end,soc.status,bs.licence,bs.permission,bgg.group_name,bgg.id gid
    FROM sys_org so
    LEFT JOIN sys_org_entity soe ON so.org_entity_id = soe.id
    LEFT JOIN sys_org_relation sor ON sor.org_b_id = so.id
    LEFT JOIN sys_org_contract soc ON soc.relation_id = sor.id
    LEFT JOIN busi_suppliers bs ON soe.id = bs.org_entity_id
    LEFT JOIN busi_goods_group bgg ON bgg.org_id = so.id
    <where> so.type=4
        <if test="supplier.orgId != null">
            AND so.id = #{supplier.orgId}
        </if>

        <if test="supplier.status != null">
            AND soe.enable = #{supplier.status}
        </if>
        <if test="supplier.name != null and supplier.name != ''">
            AND soe.name LIKE concat(concat('%',#{supplier.name}),'%')
        </if>
        <if test="supplier.salerId != null">
            AND sor.org_a_id = #{supplier.salerId}
        </if>
        <if test="current!=null">
            limit #{current},#{size}
        </if>
    </where>
</select>