<insert id="saveExceptionInfo" parameterType="java.util.List">
insert into tb_jk_exp_log(EXP_NAME,EXP_TIME,CREATE_TIME)
<foreach collection="list" item="item" index="index" separator="union all" >
select
#{item.exceptionName}, #{item.exceptionCreateTime,jdbcType=TIMESTAMP}, #{item.exceptionDbTime,jdbcType=TIMESTAMP}
from dual
</foreach>
</insert>
oracle下mybatis批量新增
最新推荐文章于 2024-03-29 10:53:53 发布