批量更新/插入

批量更新

<update id="batchUpdate" parameterType="java.util.List">

<foreach collection="list" item="item" index="index" separator=";">

UPDATE cart_item SET count = #{item.count,jdbcType=INTEGER}

oper_time =NOW()

WHERE id = #{item.id,jdbcType=BIGINT};

</foreach>

</update>

批量插入

<insert id="insertList" parameterType="java.util.List"useGeneratedKeys="false">

   insert into group_config(store_id,switch_type, oper_id, create_time) values

      <foreach collection="list" item="item" separator="," close=";">

         (#{item.storeId},#{item.switchType}, #{item.operId}, #{item.createTime}) </foreach>

</insert>

批量修改

Updategroup_config set name = ‘zhangsan’,age = 1 where id in(2,3,4)