mybatis的批量插入删除

mybatis中的批量插入和删除操作执行：

批量插入：

mapper.xml:

<insert id="saveDishesCategory" parameterType="java.util.List">
    <selectKey keyProperty="id" order="BEFORE" resultType="java.lang.String">
      SELECT UUID()
    </selectKey>
    insert into dishes_category_value_tbl (id, category_id, dishes_all_id, 
      is_del, create_time, last_modify_time)   
    values  
    <foreach collection="list" item="item" index="index" separator="," >  
        (#{item.id},#{item.categoryId},#{item.dishesAllId},#{item.isDel},#{item.createTime},#{item.lastModifyTime})  
    </foreach>
</insert>

mapper.java:

void saveDishesCategory(List<DishesCategoryValueTbl> dishesCategoryValueTbls);

批量删除：

mapper.xml:

 <delete id = "deleteDishesCategory" parameterType = "java.util.List">  
    delete from dishes_category_value_tbl where id in  
    <foreach collection="list" item = "item" open="(" separator="," close=")">
  		#{item}
    </foreach> 
  </delete> 

mapper.java:

void deleteDishesCategory(List<String> ids);

传入的参数是集合类型的话collection是list

传入的参数是数组的话collection是array