mybatis+db2批量插入与删除

mapper.xml修改：

//批量插入

<insert id="insertList" parameterType="java.util.List">  
    insert into demo_table (ID, NAME) 
      values
    <foreach collection="list" item="item" index="index" separator="," >
      (#{item.id,jdbcType=VARCHAR}, #{item.name,jdbcType=VARCHAR})
    </foreach>
  </insert> 

dao修改

int insertList(List<Student> list);

 

//批量删除

int deleteBathById(List<String> list);

<delete id="deleteBathById" parameterType="java.lang.String">
      delete from demo_table where id in 
      <foreach item="item" index="index" collection="list" open="(" separator="," close=")">
      #{item}
    </foreach>
  </delete>

dao修改

////////////////////