<insert id="saveBatch" parameterType="java.util.List">
insert into DY_AIRMONITOR(ID, QN, ST, CN, PW, MN, DATATIME, A01001, A01002, A01006, A01007, A01008, A06001,
B03, FLOW, VOLUME, PM10, PM25, TSP, LATI, LONGI, ALTI, FLAG,CREATETIME)
select SEQ_DY_AIRMONITOR.NEXTVAL, A.* from(
<foreach collection="list" item="item" index="index" separator="UNION">
SELECT
#{item.qn, jdbcType=VARCHAR},
#{item.st, jdbcType=VARCHAR},
#{item.cn, jdbcType=VARCHAR},
#{item.pw, jdbcType=VARCHAR},
#{item.mn, jdbcType=VARCHAR},
to_date(#{item.datatime},'yyyy-mm-dd hh24:mi:ss'),
#{item.a01001, jdbcType=DECIMAL},
#{item.a01002, jdbcType=DECIMAL},
#{item.a01006, jdbcType=DECIMAL},
#{item.a01007, jdbcType=DECIMAL},
#{item.a01008, jdbcType=DECIMAL},
#{item.a06001, jdbcType=DECIMAL},
#{item.b03, jdbcType=DECIMAL},
#{item.flow, jdbcType=DECIMAL},
#{item.volume, jdbcType=DECIMAL},
#{item.pm10, jdbcType=DECIMAL},
#{item.pm25, jdbcType=DECIMAL},
#{item.tsp, jdbcType=DECIMAL},
#{item.lati, jdbcType=DECIMAL},
#{item.longi, jdbcType=DECIMAL},
#{item.alti, jdbcType=DECIMAL},
#{item.flag, jdbcType=VARCHAR},
sysdate
from dual
</foreach>
) A
</insert>
【Java】mybatis下的oracle批量操作语句
最新推荐文章于 2023-05-21 12:03:36 发布