mybatis批量操作

一、批量插入

<insertid="insertData" parameterType="java.util.List">
	insert into t_fee_sourcedata (tag_name,time,data) 
    values
	<foreach collection="list" item="item" index="index" separator=",">
			(
				#{item.tag_name},
				#{item.time},
				#{item.data}
			)
	</foreach>
</insert>

二、批量更新

<foreach collection="list" item="item" index="index" separator=";">
    update 
        daypdata
    set 
        edata=#{item.sdata},
        data=#{item.sdata}-sdata
    where
        sname=#{item.sname}
    and 
        date=DATE_SUB(#{item.date},INTERVAL 1 day)
</foreach>

 

三、批量删除

<deleteid="deleteData" parameterType="java.util.List">
	delete from t_fee_sourcedata
    where
	<foreach collection