//新增示例
<insert id="batchInsert" keyColumn="id" keyProperty="id" parameterType="com.miller.bigdata.activity.entity.ActivityInfoEntity" useGeneratedKeys="false">
insert into user(activityId, activity_name, activity_status, publish_status,
start_time,end_time) values
<foreach collection="list" item="item" index="index" separator="," >
(
#{item.activityId},
#{item.activityName},
#{item.activityStatus},
#{item.publishStatus},
#{item.startTime},
#{item.endTime}
)
</foreach>
</insert>
<update id="batchUpdateActivityInfo" parameterType="java.util.List">
<foreach collection="activityInfoEntityList" item="activityInfoEntity" index="index" open="" close="" separator=";">
UPDATE user
<set>
activity_name = #{activityInfoEntity.activityName},
activity_status=#{activityInfoEntity.activityStatus},
publish_status=#{activityInfoEntity.publishStatus},
start_time = #{activityInfoEntity.startTime},
end_time = #{activityInfoEntity.endTime},
update_time=#{activityInfoEntity.updateTime}
</set>
<where>
activity_id=#{activityInfoEntity.activityId}
</where>
</foreach>
</update>
注意:批量操作需在url路径增加属性
allowMultiQueries=true