<!--批量添加邮件账户-->
<insert id="batchInsertEmailConfigRole" parameterType="java.util.List">
INSERT into TBL_EMAIL_CONFIG_ROLE (MAIL_CODE, RECIPIENT_TYPE, MAIL_REGION, ROLE_ID, USER_ID, EMAIL_INPUT_TYPE, EMAIL_FREE)
(
<foreach collection="list" index="" item="roleVo"
separator="union all">
select
#{roleVo.mailCode,jdbcType=DECIMAL}, #{roleVo.recipientType,jdbcType=VARCHAR},
#{roleVo.mailRegion,jdbcType=VARCHAR},
#{roleVo.roleId,jdbcType=DECIMAL}, #{roleVo.userId,jdbcType=VARCHAR},
#{roleVo.emailInputType,jdbcType=CHAR},
#{roleVo.emailFree,jdbcType=VARCHAR}
from dual
</foreach>
)
</insert>
mybatis批量添加oracle数据
最新推荐文章于 2024-03-08 14:05:57 发布