Mybatis的一些语句

1.数组循环删除：

mapper接口：

int delete(@Param("cidList") Integer[] cidList);

XML：

<delete id="delete"  >
  delete from g_work_schedule_car where cid in(
  <foreach collection="cidList" item="cid" separator=",">
    #{cid}
  </foreach>)
</delete>