实现批量修改的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语句