批量插入
<insert id="insertBatch" >
insert into table ( <include refid="Base_Column_List" /> )
values
<foreach collection="list" item="i" index="index" separator=",">
(#{i.id},#{i.userId},#{i.name})
</foreach>
</insert>
批量更新
通过 case when语句变相的进行批量更新
<update id="updateBatchById" parameterType="list">
update table
<trim prefix="set" suffixOverrides=",">
<trim prefix="user_mobile =case" suffix="end,">
<foreach collection="list" item="i" index="index">
<if test="i.userMobile!=null">
when id=#{i.Id} then #{i.userMobile}