MyBatis批量增删改查

	<!-- 批量增加 -->  
    <insert id="insertUsersBatch" parameterType="java.util.List">  
        insert into user(userName,password) values  
        <foreach collection="list" item="item" index="index" separator=",">  
            (#{item.userName},#{item.password})  
        </foreach>  
    </insert>  
	<!-- 批量删除 -->  
    <delete id="deleteUsersBatch" parameterType="java.util.List">  
        delete from user where id in  
        <foreach collection="list" index="index" item="item" open="(" close=")" separator=",">  
            #{item}  
        </foreach>  
    </delete>  
	<!-- 批量查询 -->  
    <select id="selectUsersBatch" resultType="User">  
        select *  
        from user where id in  
        <foreach collection="list" index="index" item="item" open="(" separator="," close=")">  
        #{item}  
        </foreach>  
    </select>  
	<!-- 批量更新 --> 
	<update id="updateUsersBatch" parameterType="java.util.List">  
        <foreach collection="list" item="item" index="index" open="begin" close=";end;" separator=";" >   
            update user   
            <set>         
                userName = #{item.userName}, password = #{item.password}  
            </set>  
            where id = #{item.id}  
        </foreach>  
    </update>