mybatis中如下:
<insert id="importExcelDB" parameterType="java.util.List" useGeneratedKeys="false" >
insert into test_entity (id,CARDNO,SALETIME )
<foreach collection="list" item="item" index="index" separator="UNION ALL" >
( select #{item.id}, #{item.cardno},#{item.saleTime} from dual)
</foreach>
</insert>
数据库写法如下:
insert into test_entity (id,CARDNO,SALETIME )
((select 1, 'ykp', sysdate from dual) union
(select 2, 'ykp', sysdate from dual) union
(select 3, 'ykp', sysdate from dual) union
(select 4, 'ykp', sysdate from dual));