How to use

delete

method

in

org.hswebframework.ezorm.rdb.executor.SqlExecutor

    .list();
for (HistoricActivityInstance historicActivityInstance : instance) {
  sqlExecutor.delete("delete from act_hi_actinst where id_= #{id}", historicActivityInstance);

  public SqlExecuteResult doExecute(SqlInfo sqlInfo) {
    SqlExecuteResult result = new SqlExecuteResult();
    Object executeResult = null;
    try {
      switch (sqlInfo.getType().toUpperCase()) {
        case "SELECT":
          QueryResultWrapper wrapper = new QueryResultWrapper();
          executor.list(sqlInfo.getSql(), wrapper);
          executeResult = wrapper.getResult();
          break;
        case "INSERT":
        case "UPDATE":
          executeResult = executor.update(sqlInfo.getSql());
          break;
        case "DELETE":
          executeResult = executor.delete(sqlInfo.getSql());
          break;
        default:
          executor.exec(sqlInfo.getSql());
      }
      result.setSuccess(true);
    } catch (SQLException e) {
      throw new SqlExecuteException(e.getMessage(), e, sqlInfo.getSql());
    }
    result.setResult(executeResult);
    result.setSqlInfo(sqlInfo);

    return result;
  }
}

default int delete(String sql, Object params) throws SQLException {
  return delete(new SimpleSQL(sql, params));
}

default int delete(String sql) throws SQLException {
  return delete(new SimpleSQL(sql));
}

default int delete(String sql) throws SQLException {
  return delete(new SimpleSQL(sql));
}

default int delete(String sql, Object params) throws SQLException {
  return delete(new SimpleSQL(sql, params));
}

@Override
public int exec() throws SQLException {
  Map<String, Object> context = null;
  boolean supportBefore = !triggerSkip && tableMetaData.triggerIsSupport(Trigger.delete_before);
  boolean supportDone = !triggerSkip && tableMetaData.triggerIsSupport(Trigger.delete_done);
  if (supportBefore || supportDone) {
    context = table.getDatabase().getTriggerContextRoot();
    context.put("table", table);
    context.put("database", table.getDatabase());
    context.put("param", param);
  }
  if (supportBefore) {
    tableMetaData.on(Trigger.delete_before, context);
  }
  SqlRender<Param> render = tableMetaData.getDatabaseMetaData().getRenderer(SqlRender.TYPE.DELETE);
  SQL sql = render.render(table.getMeta(), param);
  int size = sqlExecutor.delete(sql);
  if (supportDone) {
    context.put("total", size);
    tableMetaData.on(Trigger.delete_done, context);
  }
  return size;
}

@Override
public int exec() throws SQLException {
  Map<String, Object> context = null;
  boolean supportBefore = !triggerSkip && tableMetaData.triggerIsSupport(Trigger.delete_before);
  boolean supportDone = !triggerSkip && tableMetaData.triggerIsSupport(Trigger.delete_done);
  if (supportBefore || supportDone) {
    context = table.getDatabase().getTriggerContextRoot();
    context.put("table", table);
    context.put("database", table.getDatabase());
    context.put("param", param);
  }
  if (supportBefore) {
    tableMetaData.on(Trigger.delete_before, context);
  }
  SqlRender<Param> render = tableMetaData.getDatabaseMetaData().getRenderer(SqlRender.TYPE.DELETE);
  SQL sql = render.render(table.getMeta(), param);
  int size = sqlExecutor.delete(sql);
  if (supportDone) {
    context.put("total", size);
    tableMetaData.on(Trigger.delete_done, context);
  }
  return size;
}

    .list();
for (HistoricActivityInstance historicActivityInstance : instance) {
  sqlExecutor.delete("delete from act_hi_actinst where id_= #{id}", historicActivityInstance);

  public SqlExecuteResult doExecute(SqlInfo sqlInfo) {
    SqlExecuteResult result = new SqlExecuteResult();
    Object executeResult = null;
    try {
      switch (sqlInfo.getType().toUpperCase()) {
        case "SELECT":
          QueryResultWrapper wrapper = new QueryResultWrapper();
          executor.list(sqlInfo.getSql(), wrapper);
          executeResult = wrapper.getResult();
          break;
        case "INSERT":
        case "UPDATE":
          executeResult = executor.update(sqlInfo.getSql());
          break;
        case "DELETE":
          executeResult = executor.delete(sqlInfo.getSql());
          break;
        default:
          executor.exec(sqlInfo.getSql());
      }
      result.setSuccess(true);
    } catch (SQLException e) {
      throw new SqlExecuteException(e.getMessage(), e, sqlInfo.getSql());
    }
    result.setResult(executeResult);
    result.setSqlInfo(sqlInfo);

    return result;
  }
}