net.sf.jsqlparser.statement.update.Update.getTables()方法的使用及代码示例

x33g5p2x  于2022-02-01 转载在 其他  
字(6.9k)|赞(0)|评价(0)|浏览(576)

本文整理了Java中net.sf.jsqlparser.statement.update.Update.getTables()方法的一些代码示例，展示了Update.getTables()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。Update.getTables()方法的具体详情如下：
包路径：net.sf.jsqlparser.statement.update.Update
类名称：Update
方法名：getTables

Update.getTables介绍

暂无

代码示例

代码示例来源：origin: baomidou/mybatis-plus

/**
 * update 语句处理
 */
@Override
public void processUpdate(Update update) {
  List<Table> tableList = update.getTables();
  Assert.isTrue(null != tableList && tableList.size() < 2,
    "Failed to process multiple-table update, please exclude the statementId");
  Table table = tableList.get(0);
  if (tenantHandler.doTableFilter(table.getName())) {
    // 过滤退出执行
    return;
  }
  update.setWhere(this.andExpression(table, update.getWhere()));
}

代码示例来源：origin: JSQLParser/JSqlParser

@Override
public String toString() {
  StringBuilder b = new StringBuilder("UPDATE ");
  b.append(PlainSelect.getStringList(getTables(), true, false)).append(" SET ");

代码示例来源：origin: codingapi/tx-lcn

List<String> tables = new ArrayList<>(update.getTables().size());
update.getColumns().forEach(column -> {
  column.setTable(update.getTables().get(0));
  columns.add(column.getFullyQualifiedName());
});
for (Table table : update.getTables()) {
  tables.add(table.getName());
  TableStruct tableStruct = tableStructAnalyser.analyse(connection, table.getName());

代码示例来源：origin: JSQLParser/JSqlParser

public void deParse(Update update) {
  buffer.append("UPDATE ").append(PlainSelect.getStringList(update.getTables(), true, false)).
      append(" SET ");

代码示例来源：origin: baomidou/mybatis-plus

Update update = (Update) statement;
  where = update.getWhere();
  table = update.getTables().get(0);
  joins = update.getJoins();
} else if (statement instanceof Delete) {

代码示例来源：origin: JSQLParser/JSqlParser

@Override
public void visit(Update update) {
  for (Table table : update.getTables()) {
    visit(table);
  }
  if (update.getExpressions() != null) {
    for (Expression expression : update.getExpressions()) {
      expression.accept(this);
    }
  }
  if (update.getFromItem() != null) {
    update.getFromItem().accept(this);
  }
  if (update.getJoins() != null) {
    for (Join join : update.getJoins()) {
      join.getRightItem().accept(this);
    }
  }
  if (update.getWhere() != null) {
    update.getWhere().accept(this);
  }
}

代码示例来源：origin: wxbty/meepo

public static List<String> name_update_table(String sql) throws JSQLParserException {
  net.sf.jsqlparser.statement.Statement statement = CCJSqlParserUtil.parse(sql);
  Update updateStatement = (Update) statement;
  List<Table> update_table = updateStatement.getTables();
  List<String> str_table = new ArrayList<>();
  if (update_table != null) {
    for (int i = 0; i < update_table.size(); i++) {
      str_table.add(update_table.get(i).toString());
    }
  }
  return str_table;
}

代码示例来源：origin: com.github.jsqlparser/jsqlparser

@Override
public String toString() {
  StringBuilder b = new StringBuilder("UPDATE ");
  b.append(PlainSelect.getStringList(getTables(), true, false)).append(" SET ");

代码示例来源：origin: com.baomidou/mybatis-plus-extension

/**
 * <p>
 * update 语句处理
 * </p>
 */
@Override
public void processUpdate(Update update) {
  List<Table> tableList = update.getTables();
  Assert.isTrue(null != tableList && tableList.size() < 2,
    "Failed to process multiple-table update, please exclude the statementId");
  Table table = tableList.get(0);
  if (tenantHandler.doTableFilter(table.getName())) {
    // 过滤退出执行
    return;
  }
  update.setWhere(this.andExpression(table, update.getWhere()));
}

代码示例来源：origin: stackoverflow.com

"  WHERE AGE IN (SELECT AGE FROM CUSTOMERS_BKP WHERE AGE >= 27 )");
finder = new TablesNamesFinderExt();
System.out.println("UPDATE - " + update.getTables());
finder.getTableList(update);
System.out.println("SELECT - " + finder.getSelectTableList());
      "WHERE AGE IN (SELECT AGE FROM CUSTOMERS WHERE AGE >= 27 )");
finder = new TablesNamesFinderExt();
System.out.println("UPDATE - " + update.getTables());
finder.getTableList(update);
System.out.println("SELECT - " + finder.getSelectTableList());

代码示例来源：origin: com.blazebit/blaze-persistence-testsuite-base-jpa

} else if (statement instanceof Update) {
  Update update = (Update) statement;
  return new ArrayList<>(update.getTables());
} else if (statement instanceof Delete) {
  Delete delete = (Delete) statement;

代码示例来源：origin: com.github.jsqlparser/jsqlparser

public void deParse(Update update) {
  buffer.append("UPDATE ").append(PlainSelect.getStringList(update.getTables(), true, false)).
      append(" SET ");

代码示例来源：origin: Blazebit/blaze-persistence

} else if (statement instanceof Update) {
  Update update = (Update) statement;
  return new ArrayList<>(update.getTables());
} else if (statement instanceof Delete) {
  Delete delete = (Delete) statement;

代码示例来源：origin: diennea/herddb

@Override
public void visit(Update s) {
  for (Table table : s.getTables()) {
    visit(table);
  }
  if (s.getColumns() != null) {
    s.getColumns().forEach(c -> {
      c.accept(this);
    });
  }
  if (s.getExpressions() != null) {
    s.getExpressions().forEach(e -> e.accept(this));
  }
  if (s.getOrderByElements() != null) {
    s.getOrderByElements().forEach(o -> {
      o.accept(this);
    });
  }
  if (s.getWhere() != null) {
    s.getWhere().accept(this);
  }
  if (s.getReturningExpressionList() != null) {
    s.getReturningExpressionList().forEach(o -> {
      o.accept(this);
    });
  }
}

代码示例来源：origin: diennea/herddb

public String getTableSpace(Statement statement) throws ScriptException {
  String tableName = null;
  if (statement instanceof Insert) {
    Insert st = (Insert) statement;
    tableName = st.getTable().getFullyQualifiedName();
  } else if (statement instanceof Update) {
    Update st = (Update) statement;
    tableName = st.getTables().get(0).getFullyQualifiedName();
  } else if (statement instanceof Delete) {
    Delete st = (Delete) statement;
    tableName = st.getTables().get(0).getFullyQualifiedName();
  } else if (statement instanceof Truncate) {
    Truncate st = (Truncate) statement;
    tableName = st.getTable().getFullyQualifiedName();
  } else if (statement instanceof Drop) {
    Drop st = (Drop) statement;
    tableName = st.getName().getFullyQualifiedName();
  } else if (statement instanceof CreateTable) {
    CreateTable st = (CreateTable) statement;
    tableName = st.getTable().getFullyQualifiedName();
  } else if (statement instanceof Alter) {
    Alter st = (Alter) statement;
    tableName = st.getTable().getFullyQualifiedName();
  } else {
    return null;
  }
  return mapTableNameToSchema(tableName);
}

代码示例来源：origin: yidasanqian/dynamic-add-date

List<Table> tableList = update.getTables();
for (Table table : tableList) {
  if (!matchesIgnoreTables(table.getName())) {
List<Table> tableList = update.getTables();
for (Table table : tableList) {
  if (!matchesIgnoreTables(table.getName())) {

代码示例来源：origin: com.github.jsqlparser/jsqlparser

@Override
public void visit(Update update) {
  for (Table table : update.getTables()) {
    visit(table);
  }
  if (update.getExpressions() != null) {
    for (Expression expression : update.getExpressions()) {
      expression.accept(this);
    }
  }
  if (update.getFromItem() != null) {
    update.getFromItem().accept(this);
  }
  if (update.getJoins() != null) {
    for (Join join : update.getJoins()) {
      join.getRightItem().accept(this);
    }
  }
  if (update.getWhere() != null) {
    update.getWhere().accept(this);
  }
}

代码示例来源：origin: com.baomidou/mybatis-plus-extension

Update update = (Update) statement;
  where = update.getWhere();
  table = update.getTables().get(0);
  joins = update.getJoins();
} else if (statement instanceof Delete) {

内容来源于网络，如有侵权，请联系作者删除！

Update

相关文章

    查看更多
    微信公众号

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com