<insert id="insertData" parameterType="java.util.List"> insert into app_database.app_user values <foreach item="item" collection="list" separator="," index="index"> ( #{item.id}, #{item.account}, #{item.password}, #{item.account_name}, #{item.is_enable} ) </foreach> ON DUPLICATE KEY UPDATE id = VALUES(id); </insert>
原文:https://www.cnblogs.com/KdeS/p/13331618.html