写法
@Update({
"<script>",
"<foreach collection='devicesList' item='item' index='index' separator=';'>",
"UPDATE track_devices SET ",
"battery=#{item.battery},case_number=#{item.caseNumber},gps_number=#{item.gpsNumber},",
" is_online=#{item.isOnline},location=#{item.location},",
" recently_update_time=#{item.recentlyUpdateTime},status=#{item.status},type=#{item.type} ",
"WHERE id=#{item.id}",
"</foreach>",
"</script>"
})
public void updateDevices(@Param("devicesList") List<TrackDevicesDto> devicesDtoList);
注意事项
数据库连接上要加
allowMultiQueries=true