mybatis动态批量insert

<insert id="batchSaveAllocate">
   <foreach collection="allocateList" separator=";" item="item" index="index">
      insert into ${tablePrifix}i_u_reimbursement_allocate
      <trim prefix="(" suffix=")" suffixOverrides=",">
         <if test="item.id != null and item.id != ''">id,</if>
         <if test="item.deptId != null and item.deptId != ''">dept_id,</if>
         <if test="item.allocateType != null and item.allocateType != ''">allocate_type,</if>
         <if test="item.rewardItems != null and item.rewardItems != ''">reward_items,</if>
         <if test="item.money != null and item.money != ''">money,</if>
         <if test="item.allocateEntryTime != null">allocate_entry_time,</if>
         <if test="item.createCode != null and item.createCode != ''">create_code,</if>
         <if test="item.creatreName != null and item.creatreName != ''">creatre_name,</if>
         <if test="item.createTime != null">create_time,</if>
         <if test="item.dType != null and item.dType != ''">d_type,</if>
      </trim>
      <trim prefix="values (" suffix=")" suffixOverrides=",">
         <if test="item.id != null and item.id != ''">#{item.id},</if>
         <if test="item.deptId != null and item.deptId != ''">#{item.deptId},</if>
         <if test="item.allocateType != null and item.allocateType != ''">#{item.allocateType},</if>
         <if test="item.rewardItems != null and item.rewardItems != ''">#{item.rewardItems},</if>
         <if test="item.money != null and item.money != ''">#{item.money},</if>
         <if test="item.allocateEntryTime != null">#{item.allocateEntryTime},</if>
         <if test="item.createCode != null and item.createCode != ''">#{item.createCode},</if>
         <if test="item.creatreName != null and item.creatreName != ''">#{item.creatreName},</if>
         <if test="item.createTime != null">#{item.createTime},</if>
         <if test="item.dType != null and item.dType != ''">#{item.dType},</if>
      </trim>
   </foreach>
</insert>
  • 1
    点赞
  • 4
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值