mybatis动态sql-----foreach

最新推荐文章于 2022-12-05 14:41:56 发布

回忆是昨天里的海

最新推荐文章于 2022-12-05 14:41:56 发布

阅读量138

点赞数

分类专栏：开发二三事

本文链接：https://blog.csdn.net/qq_43318174/article/details/117521814

版权

开发二三事专栏收录该内容

12 篇文章 1 订阅

订阅专栏

 <sql id="WhereCondition">
        <where>
            <if test="recommenderIds != null and recommenderIds.size > 0">
                AND
                recommenderId IN
                <foreach collection="recommenderIds" open="(" close=")" separator="," item="recommenderId"
                         index="index">
                    #{recommenderId,jdbcType=BIGINT}
                </foreach>
            </if>
            <if test="bankCardIds != null and bankCardIds.size > 0">
                AND
                bankCardId IN
                <foreach collection="bankCardIds" open="(" close=")" separator="," item="bankCardId"
                         index="index">
                    #{bankCardId,jdbcType=BIGINT}
                </foreach>
            </if>
            <if test="approveStatus != null">
                AND
                approveStatus = #{approveStatus,jdbcType=INTEGER}
            </if>
            <if test="frozenStatus != null">
                AND
                frozenStatus = #{frozenStatus,jdbcType=BIT}
            </if>
            <if test="startTime != null and startTime > 0">
                AND
                gmtCreate &gt;= #{startTime,jdbcType=BIGINT}
            </if>
            <if test="endTime != null and endTime > 0">
                AND
                gmtCreate &lt; #{endTime,jdbcType=BIGINT}
            </if>
        </where>
    </sql>

 <update id="updateApproveStatusBatch"
            parameterType="com.wscar.xny.recommender.domain.dto.DaoUpdateApproveStatusBatchDTO">
        <if test="ids != null and ids.size > 0">
            UPDATE
            withdrawrecord
            SET
            `approver` = #{approver,jdbcType=BIGINT},
            `approveTime` = #{approveTime,jdbcType=BIGINT},
            `approveStatus` = #{approveStatus,jdbcType=BIT},
            `gmtModified` = #{gmtModified,jdbcType=BIGINT},
            `updater` = #{updater,jdbcType=BIGINT}
            WHERE
            `id` IN
            <foreach collection="ids" open="(" close=")" separator="," item="id" index="index">
                #{id,jdbcType=BIGINT}
            </foreach>
        </if>
    </update>