<insert id="addOtherPrescriptions" parameterType="com.supervision.sync.object.OtherPrescriptionsDO">
begin
<foreach collection="list" item="demo" index="index">
insert into TB_MZ_QTCFMX
(uuid,yljgdm,cfmxid,jzlsh,grbsh,cfzid,yzxh,yzzh,zlxmlbbm,xmbm,xmmc,xmflbm,xmflmc,zxpl,cjfx,cjbb,jcbw,mzfs,cfkssj,cftzsj,zxksbm,zxksmc,cfzxsj,jzjgmc,bz,grbslx,qtyxcz,mj,zzbz,zxrxm,czjh,zxrbh,kfcszd,xgbz,zwt,wsfwyq,jkwtpg,last_update_dtime,data_version,data_code)
values
(#{demo.uuid},
#{demo.yljgdm},
#{demo.cfmxid},
#{demo.jzlsh},
#{demo.grbsh},
#{demo.cfzid},
#{demo.yzxh},
#{demo.yzzh},
#{demo.zlxmlbbm},
#{demo.xmbm},
#{demo.xmmc},
#{demo.xmflbm},
#{demo.xmflmc},
#{demo.zxpl},
#{demo.cjfx},
#{demo.cjbb},
#{demo.jcbw},
#{demo.mzfs},
#{demo.cfkssj},
#{demo.cftzsj},
#{demo.zxksbm},
#{demo.zxksmc},
#{demo.cfzxsj},
#{demo.jzjgmc},
#{demo.bz},
#{demo.grbslx},
#{demo.qtyxcz},
#{demo.mj},
#{demo.zzbz},
#{demo.zxrxm},
#{demo.czjh},
#{demo.zxrbh},
#{demo.kfcszd},
#{demo.xgbz},
#{demo.zwt},
#{demo.wsfwyq},
#{demo.jkwtpg},
#{demo.last_update_dtime},
#{demo.version},
#{demo.data_code});
</foreach>
end
</insert>
oracle批量插入(springboot中使用xml格式)
最新推荐文章于 2024-05-16 14:29:54 发布