mybatis列表循环入库sql2种写法

最新推荐文章于 2024-08-23 15:58:03 发布

lvhy踩坑之路

最新推荐文章于 2024-08-23 15:58:03 发布

阅读量301

点赞数

文章标签： java

本文链接：https://blog.youkuaiyun.com/weixin_44722978/article/details/121747306

版权

`第一种`

 Long insertList(@Param("list") List<Image> list);

 <insert id="insertList" parameterType="java.util.List">
        INSERT INTO IMAGE (
        ID,URL
        )VALUES
        <foreach collection="list" item="item" separator=",">
            (
            #{item.id},
            #{item.url}
            )
        </foreach>
    </insert>

`第二种`

@Insert("<script>" +
            "insert into driver_account_appeal_photo (appeal_id,appeal_photo_path) values\n" +
            "<foreach collection=\"photoList\" item=\"item\" index=\"index\" separator=\",\">\n" +
            "\t(#{appealId},#{item})\n" +
            "</foreach>" +
            "</script>")
//@Insert("insert into driver_account_appeal_photo (appeal_id,appeal_photo_path) values(#{appealId},#{appealPhotoPath})")
void addAppealPhoto(AppealPhoto appealPhoto);