MyBatis的xml配置文件---删除一个用户和删除用户数组

<delete id="delete"
            parameterType="java.util.HashMap">
        <![CDATA[
            delete from
                users
        ]]>
        <where>
            <if test="id != null">
                and id=#{id}
            </if>

        </where>
    </delete>
   

 <delete id="deleteusers">
        <![CDATA[
             delete from
                users
        ]]>
        <where>
            <if test="array != null">
                id in
                <foreach collection="array" index="index" item="item" open="(" separator="," close=")">
                    #{item}
                </foreach>
            </if>
        </where>
    </delete>

 批量删除也可以用list

 具体做法是将array换成list即可

转载于:https://www.cnblogs.com/lingear/archive/2013/01/05/2846076.html