日志模块删除

Dao:

    // 基于id删除
    int deleteObjects(Integer ... ids);

Mapper:

    <!--基于条件删除 方式2-->

    <!--
        <choose> 选择语句
        <when>  类似于if
        <otherwise> 类似于else

    -->
    <delete id="deleteObjects">
        delete from  sys_logs
        <where>
        <choose>
              <when test="ids !=null and ids.length>0">
                  id in
                  <foreach collection="ids" open="(" close=")" 
                  item="id" separator=",">#{id}
                  </foreach>
              </when>
              <otherwise>
                  1=2
              </otherwise>
        </choose>
        </where>

    </delete>





    <!--基于条件删除 方式1-->
    <!--
    <delete id="deleteObjects">
        delete from  sys_logs
        <where>
        <if test="ids != null and ids.length>0">
         id in
        <foreach collection="ids" open="(" close=")" separator="," item="id"> #{id}

        </foreach>
        </if>
        or 1=2
        </where>
    </delete>
    -->

测试 参数为空时:

测试 参数不为空时: