Mysql批量新增和批量修改

本文只介绍了Mysql批量新增和批量修改核心代码。

1、批量新增的方式

<insert id="insertDemo" parameterType="com.syngo.supervision.basic.domain.Demo" useGeneratedKeys="true" keyProperty="id">
        insert into demo
        <trim prefix="(" suffix=")" suffixOverrides=",">
            id, no, name,type,score,status,
        </trim>
        <foreach collection="scoreList" open="values (" close=")" item="item" separator="),(">
            <trim suffixOverrides=",">
                #{item.id},#{item.no}, #{item.name}, #{item.type},#{item.score}, #{item.status},
            </trim>
        </foreach>
</insert>

2、批量修改的方式

<update id="updateDemo" parameterType="com.syngo.supervision.basic.domain.Demo