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>

Logo

为开发者提供学习成长、分享交流、生态实践、资源工具等服务,帮助开发者快速成长。

更多推荐