<insert id="insertBatchOrder" parameterType="rechargePojo">
insert into order(id, phone, parvalue, cp_userid, fileName,
province, operator,orderid, real_filename)
select
yjf_user_order_seq.nextval,t.a,t.b,t.c,t.d,t.e, t.f,t.g,t.h from(
<foreach collection="list" item="val" separator="union all">
select
${val.phone} as a, ${val.parvalue} as b, ${val.cp_userid} as c,
${val.fileName} as d , ${val.province} as e, ${val.operator} as
f,${val.orderId} as g,${val.realFileName} as h
from dual
</foreach>
) t
</insert>
insert into order(id, phone, parvalue, cp_userid, fileName,
province, operator,orderid, real_filename)
select
yjf_user_order_seq.nextval,t.a,t.b,t.c,t.d,t.e, t.f,t.g,t.h from(
<foreach collection="list" item="val" separator="union all">
select
${val.phone} as a, ${val.parvalue} as b, ${val.cp_userid} as c,
${val.fileName} as d , ${val.province} as e, ${val.operator} as
f,${val.orderId} as g,${val.realFileName} as h
from dual
</foreach>
) t
</insert>
1574
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
