<insert id="save" parameterType="java.util.List">
<foreach collection="list" item="s" index="index" separator=";">
IF EXISTS(SELECT * FROM student WHERE id= #{s.id})
BEGIN
UPDATE student SET
name = #{s.name},
class = #{s.class}
WHERE id= #{s.id}
END
ELSE
BEGIN
INSERT INTO student (
name,
class
)VALUES (
#{s.name},
#{s.class}
)
END
</foreach>
</insert>
sql server 数据库有值执行update,没有则执行insert语句
最新推荐文章于 2024-04-01 11:10:22 发布