parameterType:传过来的数据类型;
collection:类型,如list;
item:对象形参名;
DELETE Code:
<delete id="deleteCameraSync" parameterType="java.util.List">
DELETE FROM camera where id in
<foreach collection="list" item="list" index="index" open="("
separator="," close=")">
#{list.id}
</foreach>
</delete>
延伸批量插入
INSERT:
<insert id="insertAuthor" useGeneratedKeys="true"
keyProperty="id">
insert into Author (username, password, email, bio) values
<foreach item="item" collection="list" separator=",">
(#{item.username}, #{item.password}, #{item.email}, #{item.bio})
</foreach>
</insert>