mybatis 批量插入和删除

1.
<!-- 批量删除 -->
 public abstract void deleteByIds(@Param("ids")String ids);
<!-- 批量删除  -->
<delete id="deleteByIds" parameterType="java.lang.String" >
  update wn_team_info
  set lxdh  = "1"
  where ID in (${ids})
</delete>
2.
<!-- 批量插入  -->
public Integer batchInsert(@Param("list") List<WnTeamInfo> list);
<!-- 批量插入  -->
<insert id="batchInsert" parameterType="java.util.List">
  insert into wn_team_info (id, tddm, cydm,
  cymc, sfzh, lxdh, ssjgmc
  )
  <foreach collection="list" item="item" index="index" separator="union all">
    select
    #{item.id,jdbcType=INTEGER}, #{item.tddm,jdbcType=VARCHAR}, #{item.cydm,jdbcType=VARCHAR},
    #{item.cymc,jdbcType=VARCHAR}, #{item.sfzh,jdbcType=VARCHAR}, #{item.lxdh,jdbcType=VARCHAR}, #{item.ssjgmc,jdbcType=VARCHAR}
    from dual
  </foreach>
</insert>

3.数组格式的参数

int updateByIds(@Param("ids")String[] ids);

<foreach item="item" index="index" collection="ids" open="("
   separator="," close=")">
   ${item}
</foreach>

4.LIST格式的参数

int batchUpdateStatus(@Param("list") List<Lxxxx> list); 

<foreach collection="list" separator="or" item="i" index="index" >  
    (id=#{i.id})  
</foreach>