MyBatis-批量插入

最新推荐文章于 2024-08-01 14:35:06 发布

Baikal Loch

最新推荐文章于 2024-08-01 14:35:06 发布

阅读量211

点赞数

分类专栏： MyBatis 文章标签： SQL 批量插入 MyBatis

本文链接：https://blog.csdn.net/kemp_zuo/article/details/79974731

版权

MyBatis 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

一、MySql

<!-- 批量插入 -->
  <insert id="batchInsert" parameterType="java.util.List">
      insert into sd_survey_vs_insure
      values  
      <foreach collection="list" item="surveyVsInsure" separator="," index="index">
               (#{surveyVsInsure.id},#{surveyVsInsure.insuranceTypeId},#{surveyVsInsure.surveyId})
      </foreach>
  </insert>

二、Oracle

<!-- 批量添加 -->
<insert id="batchInsert" parameterType="java.util.List">

  INSERT INTO EC_ECUSER_ROLE(ECER_ID,ECER_ECCU_ID,ECER_ECRO_ID)
  SELECT
  SEQ_EC_ECUSER_ROLE.NEXTVAL AS ECERID,ECERECCUID,ECERECROID
  FROM (
    <foreach collection="list" item="ecerItem" separator=" UNION ALL ">
      SELECT #{ecerItem.ecerEccuId} AS ECERECCUID,#{ecerItem.ecerEcroId} AS ECERECROID FROM DUAL
    </foreach>
  )
</insert>