mapper.xml-where应用场景: curd-条件语句

mapper.java

 int deleteRelationsByRoleids(@Param("roleIds") Integer[] roleIds);

mapper.xml

<delete id="deleteRelationsByRoleids">
        DELETE FROM user_role
        <where>
        <if test="null != roleIds and roleIds.size() > 0" >
               role_id in
        <foreach collection="roleIds" item="item" index="index" open="(" separator="," close=")">
            #{item,jdbcType=INTEGER}
        </foreach>
           </if>
        </where>
    </delete>