oracle 批量更新xml

最新推荐文章于 2023-07-26 13:46:06 发布

qq_57398284

最新推荐文章于 2023-07-26 13:46:06 发布

阅读量586

点赞数

文章标签： oracle sql 数据库

本文链接：https://blog.csdn.net/qq_57398284/article/details/124271986

版权

Mapper层参数改改即可

service和controller 直接传个list 可用，

@Insert({"<script>" ,
            "INSERT ALL ",
            "<foreach collection='list' item='element' index='index' separator=''>" ,
            "INTO T_CW_XSJF_CWZFT(id,projectId,projectName,userId,userName,amount,payAmount,overTime) ",
            "VALUES(",
            "#{element.id},",
            "#{element.projectId},",
            "#{element.projectName},",
            "#{element.userId},",
            "#{element.userName},",
            "#{element.amount},",
            "#{element.payAmount},",
            "#{element.overTime,jdbcType=DATE})",
            "</foreach>",
            "SELECT * FROM dual",
            "</script>"})
    boolean saveBatchList(@Param("list") List<DhuYxDataStudentPay> list);