某张表中插入一组List数据

往eccOrderLog表中插入多条数据
public void saveEccOrderLogAAList(List<EccPayDetail> eccPayDetails , String flag, String userId , String newStatus ){

     StringBuilder qlSB = new StringBuilder(" insert into ecc_order_log (seq_no , order_no , order_action , old_order_status ,"
      + " new_order_status , update_user , update_time , note ) " );
          for (int i = 0; i < eccPayDetails.size(); i++) {
              EccPayDetail eccPayDetail = eccPayDetails.get(i);
              Long orderLogNo = SequenceUtil.getOrderLogSeq();
              String note = null ; 
              switch (flag) {
              case "01":note = "订单生成";  break;
              case "02":note = "订单更新";  break;
              case "03":note = "订单删除";  break;
              }
              qlSB.append(" select ");
              qlSB.append(orderLogNo + ", ");
             addString(qlSB , eccPayDetail.getSubOrderNo());
             addString(qlSB , flag);
             addString(qlSB , eccPayDetail.getStatus());
             addString(qlSB , newStatus);
             addString(qlSB , userId);
             qlSB.append(" sysdate ,") ;
             qlSB.append(" '" + note + "' ");
              
              
              qlSB.append(" from dual union") ;
              
          }
          String qlString = qlSB.substring(0, qlSB.length()-5);
          System.out.println(qlString);
          eccOrderLogDao.executeUpdateQuery(qlString);
 }