mybatis + MySQL问题总结

一、批量增删改

（1）insert

（2）delete

	<delete id="deleteMultipleSIMs" parameterType="int">
        delete from supplier_sim where id in
        <foreach item="eachId" collection="array" open="(" separator="," close=")">
            #{eachId}
        </foreach>
    </delete>

（3）update

	<update id ="setLocations" parameterType="java.util.List">
		<foreach collection = "list" item = "item" index="index" open="" close="" separator="">
			update location
			<set>
				lat = #{item.lat}, lng = #{item.lng}
			</set>
			where place = #{item.place};
		</foreach>
	</update>