mybatis mapper.xml中根据参数动态拼接多个where条件

king-hero

已于 2023-04-04 12:01:17 修改

阅读量1.4k

点赞数

文章标签： mybatis java mapper

于 2023-04-04 11:56:09 首次发布

本文链接：https://blog.csdn.net/weixin_41085114/article/details/129949701

版权

1.dao传参

    long commDeleteByConditions(@Param("tableName") String tableName, @Param("condition") Map conditions);

2. mapper.xml

<delete id="commDeleteByConditions">
        delete from ${tableName}
        <where>
            <foreach collection="condition.keys" item="k1" separator="and">
                <if test="@com.xxx.common.utils.SysUtils@isNotNullOrEmpty(condition[k1])">
                    <choose>
                        <when test="@com.xxx.common.utils.SysUtils@isCollection(condition[k1])">
                            ${k1} in
                            <foreach collection="condition[k1]" item="v" separator="," open="(" close=")">
                                #{v}
                            </foreach>
                        </when>
                        <otherwise>
                            ${k1} = #{condition[${k1}]}
                        </otherwise>
                    </choose>
                </if>
                <if test="@com.xxx.common.utils.SysUtils@isNullOrEmpty(condition[k1])">
                    (${k1} is null or ${k1} = '')
                </if>
            </foreach>
        </where>       
    </delete>