mybatis中mapper.xmlsql语句

(1)批量插入更新（入参为数组）

public int delFailExcelOrderByIds(Long[] ids);

mapper.xml

  <update id="delFailExcelOrderByIds" parameterType="Long" >
     UPDATE
      tf_o_tax_import_data_fail
        <set>
            DELETE_FLAG = 1
        </set>
        WHERE
        ID IN
        <foreach collection="array" item="items" index="index" open="(" close=")" separator="," >
            #{items}
        </foreach>
    </update>