mybatis批量增删改查操作:
批量添加
<insert id="batchInsert" parameterType="java.util.List">
insert into sys_users (id, username, password,
salt, locked)
values
<foreach collection="list" item="item" index="index" separator=",">
(#{item.id}, #{item.username}, #{item.password},#{item.salt}, #{item.locked})
</foreach>
</insert>
批量查询
<select id="batchSelect" resultMap="BaseResultMap">
select
<include refid="Base_Column_List" />
from sys_users
where id IN
<foreach collection="list" index="index" item="item" open="(" separator="," close=")">
#{item}
</foreach>
</select>
批量删除
<delete id="batchDelete" parameterType="java.util.List">
delete from sys_users
where id IN
<foreach collection="list" index="index" item="item" open="(" separator="," close=")">
#{item}
</foreach>
</delete>