mybatis批量插入数据:
INSERT INTO PAY_APPLY_INFO (ID,BILL_NO,CREATE_DATE)
select SEQ_CBIL_PAY_APPLY_INFO.NEXTVAL,A.* from(<foreach collection="list" item="item" index="index" separator="union all">
select
#{item.billNo,jdbcType=VARCHAR},
SYSDATE
from dual
</foreach>) A