Mybatis批量插入oracle,mysql
oracle

<insert id="addUserData" parameterType="java.util.List">INSERT INTO T_P_USER_DATA (USER_ID, DEPART_ID)<foreach collection="list" item="item" index="index" separator=" UNION ALL ">      SELECT #{item.userId}, #{item.departId} FROM DUAL</foreach>  </insert>

<insert id="addUserData" parameterType="java.util.List">INSERT INTO T_P_USER_DATA (USER_ID, DEPART_ID)VALUES <foreach collection="list" item="item" index="index"      separator=",">      ( #{item.userId}, #{item.departId})  </foreach>  </insert>