Пример #1
0
  public int update(LinkModel model) throws SQLException {
    String sql = null;
    String updateString = "";
    ArrayList strList = new ArrayList();
    ArrayList valList = new ArrayList();

    if (model.getNameModifyFlag()) {
      StringUtil.makeDynaParam("NAME = ", convertSQL(model.getName()), strList, valList);
    }
    if (model.getDescriptionModifyFlag()) {
      StringUtil.makeDynaParam(
          "DESCRIPTION = ", convertSQL(model.getDescription()), strList, valList);
    }

    if (model.getLinkTypeModifyFlag()) {
      StringUtil.makeDynaParam("LINK_TYPE = ", convertSQL(model.getLinkType()), strList, valList);
    }
    if (model.getTemplateIdModifyFlag()) {
      StringUtil.makeDynaParam("TEMPLATE_ID = ", model.getTemplateId(), strList, valList);
    }

    if (model.getCurrentNodeIdModifyFlag()) {
      StringUtil.makeDynaParam("CURRENT_NODE_ID = ", model.getCurrentNodeId(), strList, valList);
    }
    if (model.getNextNodeIdModifyFlag()) {
      StringUtil.makeDynaParam("NEXT_NODE_ID = ", model.getNextNodeId(), strList, valList);
    }
    if (model.getExecutorRelationModifyFlag()) {
      StringUtil.makeDynaParam(
          "EXECUTOR_RELATION = ", convertSQL(model.getExecutorRelation()), strList, valList);
    }
    if (model.getExecutorsMethodModifyFlag()) {
      StringUtil.makeDynaParam(
          "EXECUTORS_METHOD = ", convertSQL(model.getExecutorsMethod()), strList, valList);
    }
    if (model.getNumberOrPercentModifyFlag()) {
      StringUtil.makeDynaParam(
          "NUMBER_OR_PERCENT = ", convertSQL(model.getNumberOrPercent()), strList, valList);
    }
    if (model.getPassValueModifyFlag()) {
      StringUtil.makeDynaParam("PASS_VALUE = ", model.getPassValue(), strList, valList);
    }
    if (model.getExpressionModifyFlag()) {
      StringUtil.makeDynaParam(
          "EXPRESSION = ", convertSQL(model.getExpression()), strList, valList);
    }
    if (model.getDefaultPathModifyFlag()) {
      StringUtil.makeDynaParam(
          "DEFAULT_PATH = ", convertSQL(model.getDefaultPath()), strList, valList);
    }
    if (model.getActionNameModifyFlag()) {
      StringUtil.makeDynaParam(
          "ACTION_NAME = ", convertSQL(model.getActionName()), strList, valList);
    }
    if (strList.size() == 0) return 0;
    valList.add(model.getNodeLinkId());
    int length = strList.size();
    if (length == 0) {
      updateString = null;
    } else {
      for (int i = 0; i <= length - 1; i++) {
        updateString += strList.get(i) + "?,";
      }
      updateString = updateString.substring(0, updateString.length() - 1);
    }
    sql = "update WF_LINK set " + updateString + " where NODE_LINK_ID= ?";
    DBHelper.executeUpdate(sql, valList.toArray());
    logger.info(sql);
    return 1;
  }
Пример #2
0
 public int insert(LinkModel model) throws SQLException {
   String sql = null;
   ArrayList strList = new ArrayList();
   ArrayList valList = new ArrayList();
   if (model.getNodeLinkIdModifyFlag()) {
     StringUtil.makeDynaParam("NODE_LINK_ID", model.getNodeLinkId(), strList, valList);
   }
   if (model.getNameModifyFlag()) {
     StringUtil.makeDynaParam("NAME", convertSQL(model.getName()), strList, valList);
   }
   if (model.getDescriptionModifyFlag()) {
     StringUtil.makeDynaParam("DESCRIPTION", convertSQL(model.getDescription()), strList, valList);
   }
   if (model.getLinkTypeModifyFlag()) {
     StringUtil.makeDynaParam("LINK_TYPE", convertSQL(model.getLinkType()), strList, valList);
   }
   if (model.getTemplateIdModifyFlag()) {
     StringUtil.makeDynaParam("TEMPLATE_ID", model.getTemplateId(), strList, valList);
   }
   if (model.getCurrentNodeIdModifyFlag()) {
     StringUtil.makeDynaParam("CURRENT_NODE_ID", model.getCurrentNodeId(), strList, valList);
   }
   if (model.getNextNodeIdModifyFlag()) {
     StringUtil.makeDynaParam("NEXT_NODE_ID", model.getNextNodeId(), strList, valList);
   }
   if (model.getExecutorRelationModifyFlag()) {
     StringUtil.makeDynaParam(
         "EXECUTOR_RELATION", convertSQL(model.getExecutorRelation()), strList, valList);
   }
   if (model.getExecutorsMethodModifyFlag()) {
     StringUtil.makeDynaParam(
         "EXECUTORS_METHOD", convertSQL(model.getExecutorsMethod()), strList, valList);
   }
   if (model.getNumberOrPercentModifyFlag()) {
     StringUtil.makeDynaParam(
         "NUMBER_OR_PERCENT", convertSQL(model.getNumberOrPercent()), strList, valList);
   }
   if (model.getPassValueModifyFlag()) {
     StringUtil.makeDynaParam("PASS_VALUE", model.getPassValue(), strList, valList);
   }
   if (model.getExpressionModifyFlag()) {
     StringUtil.makeDynaParam("EXPRESSION", convertSQL(model.getExpression()), strList, valList);
   }
   if (model.getDefaultPathModifyFlag()) {
     StringUtil.makeDynaParam(
         "DEFAULT_PATH", convertSQL(model.getDefaultPath()), strList, valList);
   }
   if (model.getActionNameModifyFlag()) {
     StringUtil.makeDynaParam("ACTION_NAME", convertSQL(model.getActionName()), strList, valList);
   }
   String insertString = "";
   String valsString = "";
   int length = strList.size();
   if (length == 0) {
     insertString = null;
     valsString = null;
   } else {
     for (int i = 0; i <= length - 1; i++) {
       insertString += strList.get(i) + ",";
       valsString += "?,";
     }
     insertString = insertString.substring(0, insertString.length() - 1);
     valsString = valsString.substring(0, valsString.length() - 1);
   }
   sql = "insert into WF_LINK(" + insertString + ") values(" + valsString + ")";
   DBHelper.executeUpdate(sql, valList.toArray());
   logger.info(sql);
   return 1;
 }