mybatis 批量插入,更新删除

批量插入:

insert into 表名(userName,userPwd) values (xx, yy), (xx1, yy1)...(对应下面xml)

<insert id="addUserBatch" parameterType="list" >
  insert into 表名(userName,userPwd) values
  <foreach collection="list" item="item" separator=",">
  (#{item.userName},#{item.userPwd})
</foreach>
</insert>

其中:

collection: 值类型 list和Array

批量更新:

 用下面这些方式更新

• • java bean (可以新建一个专门的bean来使用)
  • map (key, values)
  • list

例如:通过id批量更新用户名(参数类型:map)

update 表名 set userPwd=#{userPwd} where id in(xx, xxx, ....)

<update id="updateUserUserPwdBatch" parameterType="map" > 
          update  表名  set userPwd=#{userPwd} where id in 
          <foreach collection="map对应key" item="item"  open="(" separator="," close=")" >
			#{item}         
          </foreach>
</update>

批量删除(不推荐使用):

按id删除:

delete from 表名 where id in(xx, xxx, xxxx, ....)

<delete id="deleteUserBatch">
          delete from 表名 
          where id in 
          <foreach collection="array" item="item" open="(" separator="," close=")">
              #{item}
          </foreach>
</delete>