mybatis 批量添加(oracle)
来源:互联网 发布:python 汉字编码 编辑:程序博客网 时间:2024/06/10 07:44
<insert id="insert" parameterType="java.util.List">
insert into ad_warn_detail
<trim prefix="(" suffix=")" suffixOverrides=",">
id,content,cr_time,
cr_date,
rule_type,merch_no,merchant_name,newest_time,ip,
</trim>
select S_AD_WARN_DETAIL.NEXTVAL,cd.* from(
<foreach collection="list" item="detail"
index="index" separator="union all">
<if test="detail != null">
select
<trim suffixOverrides=",">
#{detail.content,jdbcType=VARCHAR},
#{detail.crTime,jdbcType=VARCHAR},#{detail.crDate,jdbcType=VARCHAR},
#{detail.ruleType,jdbcType=VARCHAR},
#{detail.merchNo,jdbcType=VARCHAR},#{detail.merchantName,jdbcType=VARCHAR},
#{detail.newestTime,jdbcType=VARCHAR},#{detail.ip,jdbcType=VARCHAR},
</trim>
from dual
</if>
</foreach>
)cd
</insert>
insert into ad_warn_detail
<trim prefix="(" suffix=")" suffixOverrides=",">
id,content,cr_time,
cr_date,
rule_type,merch_no,merchant_name,newest_time,ip,
</trim>
select S_AD_WARN_DETAIL.NEXTVAL,cd.* from(
<foreach collection="list" item="detail"
index="index" separator="union all">
<if test="detail != null">
select
<trim suffixOverrides=",">
#{detail.content,jdbcType=VARCHAR},
#{detail.crTime,jdbcType=VARCHAR},#{detail.crDate,jdbcType=VARCHAR},
#{detail.ruleType,jdbcType=VARCHAR},
#{detail.merchNo,jdbcType=VARCHAR},#{detail.merchantName,jdbcType=VARCHAR},
#{detail.newestTime,jdbcType=VARCHAR},#{detail.ip,jdbcType=VARCHAR},
</trim>
from dual
</if>
</foreach>
)cd
</insert>
阅读全文
0 0
- mybatis oracle批量添加
- mybatis 批量添加(oracle)
- mybatis+oracle实现批量添加
- MyBatis批量添加
- Mybatis批量添加实现
- Mybatis批量添加数据
- Mybatis批量添加数据
- mybatis批量添加
- Mybatis批量添加
- mybatis 批量添加
- Mybatis批量查询,批量添加,批量删除
- Mybatis+oracle 批量导入
- myBatis 批量插入oracle
- mybatis oracle 批量插入
- Mybatis批量插入oracle
- mybatis批量更新(oracle)
- oracle mybatis批量插入
- MyBatis Oracle批量插入
- SpringBoot学习笔记(七):Log4j的配置
- Linux 互斥锁
- go语言学习----mysql的操作
- QFileInfo Class 用法
- Unity中itween插件官方Demo的学习笔记(一)
- mybatis 批量添加(oracle)
- Eclipse的下载和使用
- 转换数据以拟合模型
- adb start-server 失败的解决方法
- Codeforces 551C GukiZ hates Boxes(二分答案)
- Aspose.slides记录(一)
- 11_Qt的Dll、lib
- CMMI V2.0 时代即将来临
- sql中join问题