某张表中插入一组List数据

最新推荐文章于 2022-06-22 16:43:11 发布

sophylyzz

最新推荐文章于 2022-06-22 16:43:11 发布

阅读量232

点赞数

分类专栏：数据库 Java

本文链接：https://blog.csdn.net/sophylyzz/article/details/84752246

版权

Java 同时被 2 个专栏收录

8 篇文章 0 订阅

订阅专栏

数据库

5 篇文章 0 订阅

订阅专栏

往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);
 }