mybatis针对oracle的批量插入

最新推荐文章于 2024-03-08 14:05:57 发布

原创最新推荐文章于 2024-03-08 14:05:57 发布 · 174 阅读

0 ·

CC 4.0 BY-SA版权

数据库同时被 2 个专栏收录

21 篇文章

订阅专栏

oracle

2 篇文章

订阅专栏

本文详细介绍如何使用MyBatis框架通过foreach标签实现批量插入工作车辆关系记录到数据库的方法。此技术适用于需要高效处理大量数据插入场景的开发人员。

    @Insert({"<script>",
            "INSERT INTO EV_OPT_WORK_CAR_RS (",
            "ID,",
            " CRT_USER_ID,",
            " CRT_TIME,",
            " WORK_ID,",
            " CAR_ID,",
            "  IS_DEL",
            ") ",
            " <foreach collection='workCarList' item='car' index='index' separator='UNION ALL'> ",
            " select ",
            " #{car.id},",
            " #{car.crtUserId}, ",
            " #{car.crtTime}, ",
            " #{car.workId}, ",
            " #{car.carId} ",
            "0",
            " from dual ",
            " </foreach>  ",
            "</script>"})