实现批量修改的sql语句,用List集合传值
<update id="studentBatchUpdate" parameterType="java.util.List">
<foreach item="item" index="index" collection="list" open="" separator=";" close="">
update student
<set>
studentNo = #{item.studentNo},
studentName = #{item.studentName},
studentAge = #{item.studentAge}
</set>
where id =#{item.id}
</foreach>
</update>
更多推荐
批量修改sql语句
发布评论