mybatis传入List动态添加,主键存在则修改
时间:2020-07-17 22:15:48
收藏:0
阅读:45
<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
评论(0)