【拼接sql语句，输入不能被识别。 _spring 】

拼接sql语句，输入不能被识别。
我也踩过这个坑( 1 )
已统计您的踩坑,无需重复点击
回答(0)
spring
详细描述
源码
    <!--批量更新-->
    <update id="updateCustomers" parameterType="java.util.List">
        /* UPDATE TABLE set
        name =
        case
        WHEN id=#{id} THEN #{list.name}
        tel =
        case
        WHEN id=#{id} THEN #{list.tel}
        address =
        case
        WHEN id=#{id} THEN #{list.address}
        email =
        case
        WHEN id=#{id} THEN #{list.email}
        WHERE id IN
        (list.id)*/
        /*SET以及id in中的内容通过foreach遍历传入的list取得*/
        UPDATE customer SET
        customer.name=
        <foreach collection="list" item="item" index="index" open="case id" separator=" " close="end">
            <if test="item.name != null and item.name != ''">
                when #{item.id} then #{item.name}
            </if>
            <if test="item.name == null or item.name ==''">
                when =#{item.id} then customer.name
            </if>
        </foreach>
        ,customer.tel=
        <foreach collection="list" item="item" index="index" open="case id" separator=" " close="end">
            <if test="item.tel != null and item.tel != ''">
                when #{item.id} then #{item.tel}
            </if>
            <if test="item.tel == null or item.tel ==''">
                when #{item.id} then customer.tel
            </if>
        </foreach>
        ,customer.address=
        <foreach collection="list" item="item" index="index" open="case id" separator=" " close="end">
            <if test="item.address != null and item.address != ''">
                when #{item.id} then #{item.address}
            </if>
            <if test="item.address == null or item.address ==''">
                when #{item.id} then customer.address
            </if>
        </foreach>
        ,customer.email
        <foreach collection="list" item="item" index="index" open="case id" separator=" " close="end">
            <if test="item.email != null and item.email != ''">
                when #{item.id} then #{item.name}
            </if>
            <if test="item.email == null or item.email ==''">
                when #{item.id} then customer.email
            </if>
        </foreach>
        WHERE customer.id IN
        <foreach collection="list" item="item" index="index" open="(" close=")" separator=",">
            <if test="item.id != null">
                #{item.id}
            </if>
            <if test="item.id == null">
                1
            </if>
        </foreach>
    </update>
编辑于2024-11-09