遍历生成多数据同时插入SQL

最新推荐文章于 2024-07-12 10:22:10 发布

秋天霸霸

最新推荐文章于 2024-07-12 10:22:10 发布

阅读量180

点赞数 3

文章标签： sql 数据库 spring boot

本文链接：https://blog.csdn.net/weixin_41701989/article/details/136627391

版权

dao层方法：

Integer inserFrequencyCarRelation(@Param("list")List<FrequencyCarRelation> list);

mapperXml:

<insert id="inserFrequencyCarRelation"
            parameterType="list">
        insert into frequency_car_relation
        (
        car_id,
        plate_number,
        seats,
        driver_name,
        driver_phone,
        company,
        model,
        card_picture,
        checked_ticket,
        car_status,
        version,
        frequency_id,
        frequency_tag
        )
        VALUES
        <foreach collection="list" item="fcr" open="" close="" separator=",">
            (
            #{fcr.carId},
            #{fcr.plateNumber},
            #{fcr.seats},
            #{fcr.driverName},
            #{fcr.driverPhone},
            #{fcr.company},
            #{fcr.model},
            #{fcr.cardPicture},
            #{fcr.checkedTicket},
            #{fcr.carStatus},
            #{fcr.version},
            #{fcr.frequencyId},
            #{fcr.frequencyTag}
            )
        </foreach>
    </insert>