<update id="updateBaseDataFid" parameterType="java.util.List">
update sp_farm_base
<trim prefix="set" suffixOverrides=",">
<trim prefix=" sirefid =case" suffix="end,">
<foreach collection="list" item="item" index="index">
<if test="item.sirefid!=null">
when animal=#{item.animal} then #{item.sirefid}
</if>
</foreach>
</trim>
<trim prefix=" damfid =case" suffix="end,">
<foreach collection="list" item="item" index="index">
<if test="item.damfid!=null">
when animal=#{item.animal} then #{item.damfid}
</if>
</foreach>
</trim>
</trim>
where
<foreach collection="list" separator="or" item="item" index="index" >
animal=#{item.animal}
</foreach>
</update>
mybatis批量更新
最新推荐文章于 2022-05-25 14:42:21 发布