MyBatis批量插入数据---批量更新的坑 - firemail

<insert id ="insertCodeBatchSql" parameterType="map" >
<selectKey keyProperty="id" order="AFTER" resultType="java.lang.Integer">
SELECT LAST_INSERT_ID()
</selectKey>
insert into v_out_redeem_code(provider_id, member_type_id, code, code_password,status,expire_time, create_time)
values
<foreach collection ="list" item="reddemCode" index= "index" separator =",">
(
#{reddemCode.providerId}, #{reddemCode.memberTypeId},
#{reddemCode.code},
#{reddemCode.codePassword},
#{reddemCode.status}, #{reddemCode.expireTime},#{reddemCode.createTime}
)
</foreach >
</insert >

复制代码

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



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

            update test

            <set>

               test=${item.test}+1

            </set>

            where id = ${item.id}

      </foreach>



</update>
复制代码