mybatis batch insert

https://www.programcreek.com/java-api-examples/?api=org.apache.ibatis.annotations.Insert

https://stackoverflow.com/questions/34305082/mybatis-batch-insert-update-using-annotations

    <script>
    INSERT INTO app_order_staging(id,order_id,order_no,period,plan_repayment_money,plan_repaymnet_time,plan_repaymnet_time_text,principal,interest,actual_repayment_money,actual_repayment_time,actual_repayment_time_text,overdue_days,overdue_fee,status)
     VALUES
      <foreach collection="appOrderStagingList" item="item" index="index" separator="," open="" close="" >
         (#{item.orderId}, #{item.orderNo}, #{item.period}, #{item.planRepaymentMoney}, #{item.planRepaymnetTime}, #{item.planRepaymnetTimeText}, #{item.principal}, #{item.interest}, #{item.actualRepaymentMoney}, #{item.actualRepaymentTime}, #{item.actualRepaymentTimeText}, #{item.overdueDays}, #{item.overdueFee}, #{item.status})
          </foreach>

          on duplicate key update plan_repayment_money=values(plan_repayment_money);

          </script>

    /*


    <script>
    INSERT INTO app_order_staging(id,order_id,order_no,period,plan_repayment_money,plan_repaymnet_time,plan_repaymnet_time_text,principal,interest,actual_repayment_money,actual_repayment_time,actual_repayment_time_text,overdue_days,overdue_fee,status)
     VALUES
      <foreach collection="appOrderStagingList" item="item" index="index" separator="," open="" close="" >
         (#{item.orderId}, #{item.orderNo}, #{item.period}, #{item.planRepaymentMoney}, #{item.planRepaymnetTime}, #{item.planRepaymnetTimeText}, #{item.principal}, #{item.interest}, #{item.actualRepaymentMoney}, #{item.actualRepaymentTime}, #{item.actualRepaymentTimeText}, #{item.overdueDays}, #{item.overdueFee}, #{item.status})
          </foreach>

          on duplicate key update plan_repayment_money=values(plan_repayment_money);

          </script>



    */

<foreach collection="appOrderStagingList" item="item" index="index" separator="," open="" close="" >

open="" close=""
""表示啥也没有