mybatis传入List动态添加,主键存在则修改

    <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