oracle实现批量插入

一、Dao层(增加@Parm参数)

    void insert(@Param("list") List<TicketInfo> ticketInfos);

二、Mapper层(加入条件判断值是否为空)

insert all<foreach collection="list" item="item" index="index">into 表名<trim prefix="(" suffix=")" suffixOverrides=","><if test="item.billNo != null">BILLNO,</if><if test="item.recSn != null">rec_sn,</if><if test="item.tranAmt != null">tran_amt</if></trim><trim prefix="values (" suffix=")" suffixOverrides=","><if test="item.billNo != null">#{item.billNo,jdbcType=VARCHAR},</if><if test="item.recSn != null">#{item.recSn,jdbcType=VARCHAR},</if><if test="item.tranAmt != null">#{item.tranAmt,jdbcType=VARCHAR}</if></trim></foreach>select 1 from dual</insert>