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

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

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

Update.getColumns介绍

[英]The net.sf.jsqlparser.schema.Columns in this update (as col1 and col2 in UPDATE col1='a', col2='b')
[中]网。旧金山。jsqlparser。模式。此更新中的列（如更新col1='a'，col2='b'中的col1和col2）

代码示例

代码示例来源：origin: alibaba/mdrill

public void deParse(Update update) {
  buffer.append("UPDATE " + update.getTable().getWholeTableName() + " SET ");
  for (int i = 0; i < update.getColumns().size(); i++) {
    Column column = (Column) update.getColumns().get(i);
    buffer.append(column.getWholeColumnName() + "=");
    Expression expression = (Expression) update.getExpressions().get(i);
    expression.accept(expressionVisitor);
    if (i < update.getColumns().size() - 1) {
      buffer.append(", ");
    }
  }
  
  if (update.getWhere() != null) {
    buffer.append(" WHERE ");
    update.getWhere().accept(expressionVisitor);
  }
}

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

for (int i = 0; i < getColumns().size(); i++) {
  if (i != 0) {
    b.append(", ");
  b.append("(");
for (int i = 0; i < getColumns().size(); i++) {
  if (i != 0) {
    b.append(", ");

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

for (int i = 0; i < update.getColumns().size(); i++) {
  Column column = update.getColumns().get(i);
  column.accept(expressionVisitor);
  if (i < update.getColumns().size() - 1) {
    buffer.append(", ");
  buffer.append("(");
for (int i = 0; i < update.getColumns().size(); i++) {
  if (i != 0) {
    buffer.append(", ");
  Column column = update.getColumns().get(i);
  column.accept(expressionVisitor);

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

List<String> columns = new ArrayList<>(update.getColumns().size());
List<String> primaryKeys = new ArrayList<>(3);
List<String> tables = new ArrayList<>(update.getTables().size());
update.getColumns().forEach(column -> {
  column.setTable(update.getTables().get(0));
  columns.add(column.getFullyQualifiedName());

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

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

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

private void updateValue(String updateDateColumnName, String currentDate, Update update) {
  // 添加列
  update.getColumns().add(new Column(updateDateColumnName));
  update.getExpressions().add(new QuotationTimestampValue(currentDate));
}

代码示例来源：origin: org.opencadc/cadc-jsqlparser-compat

public void deParse(Update update) {
  buffer.append("UPDATE " + update.getTable().getWholeTableName() + " SET ");
  for (int i = 0; i < update.getColumns().size(); i++) {
    Column column = (Column) update.getColumns().get(i);
    buffer.append(column.getWholeColumnName() + "=");
    Expression expression = (Expression) update.getExpressions().get(i);
    expression.accept(expressionVisitor);
    if (i < update.getColumns().size() - 1) {
      buffer.append(", ");
    }
  }
  
  if (update.getWhere() != null) {
    buffer.append(" WHERE ");
    update.getWhere().accept(expressionVisitor);
  }
}

代码示例来源：origin: com.eas.platypus/platypus-js-sql-parser

@Override
public String toString() {
  String sql = getComment() != null ? getComment() + " " : "";
  sql += "UPDATE ";
  sql += getTable() + (getCommentSet() != null ? " " + getCommentSet() : "") + " SET ";
  for (int i = 0; i < getColumns().size(); i++) {
    sql += getColumns().get(i) + (!commentsEqaulas.get(i).toString().isEmpty() ? " " + commentsEqaulas.get(i) : "")
        + " = " + getExpressions().get(i);
    if (i < getColumns().size() - 1) {
      sql += (!commentsComma.get(i).toString().isEmpty() ? " " + commentsComma.get(i) : "") + ", ";
    }
  }
  sql += (getCommentWhere() != null ? " " + getCommentWhere() : "") + " WHERE " + getWhere();
  sql += !"".equals(getEndComment()) ? " " + getEndComment() : "";
  return sql;
}

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

for (int i = 0; i < getColumns().size(); i++) {
  if (i != 0) {
    b.append(", ");
  b.append("(");
for (int i = 0; i < getColumns().size(); i++) {
  if (i != 0) {
    b.append(", ");

代码示例来源：origin: com.eas.platypus/platypus-js-sql-parser

public void deParse(Update aUpdate) {
  buffer.append(aUpdate.getComment() != null ? aUpdate.getComment() + " " + ExpressionDeParser.LINE_SEPARATOR : "").append("Update ").append(ExpressionDeParser.LINE_SEPARATOR)
      .append(aUpdate.getTable().getComment() != null ? aUpdate.getTable().getComment() + " " + ExpressionDeParser.LINE_SEPARATOR : "").append(aUpdate.getTable().getWholeTableName()).append(ExpressionDeParser.LINE_SEPARATOR)
      .append(aUpdate.getCommentSet() != null ? " " + aUpdate.getCommentSet() + ExpressionDeParser.LINE_SEPARATOR : "").append(" set ");
  int columnsCounter = 0;
  for (int i = 0, s = aUpdate.getColumns().size(); i < s; i++) {
    Column column = (Column) aUpdate.getColumns().get(i);
    buffer.append(column.getComment() != null ? column.getComment() + " " + ExpressionDeParser.LINE_SEPARATOR : "").append(column.getWholeColumnName())
        .append(!aUpdate.getCommentsEqaulas().get(i).toString().isEmpty() ? " " + aUpdate.getCommentsEqaulas().get(i) + ExpressionDeParser.LINE_SEPARATOR : "").append(" = ");
    Expression expression = (Expression) aUpdate.getExpressions().get(i);
    expression.accept(expressionVisitor);
    if (i < aUpdate.getColumns().size() - 1) {
      buffer.append(!aUpdate.getCommentsComma().get(i).toString().isEmpty() ? " " + aUpdate.getCommentsComma().get(i) + " " : "");
      if (columnsCounter++ == 2) {
        columnsCounter = 0;
        buffer.append(ExpressionDeParser.LINE_SEPARATOR).append(", ");
      } else {
        buffer.append(", ");
      }
    }
  }
  if (aUpdate.getWhere() != null) {
    buffer.append(aUpdate.getCommentWhere() != null ? " " + aUpdate.getCommentWhere() : "")
        .append(ExpressionDeParser.LINE_SEPARATOR).append(" Where ");
    aUpdate.getWhere().accept(expressionVisitor);
  }
  buffer.append(!"".equals(aUpdate.getEndComment()) ? " " + aUpdate.getEndComment() : "");
}

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

for (int i = 0; i < update.getColumns().size(); i++) {
  Column column = update.getColumns().get(i);
  column.accept(expressionVisitor);
  if (i < update.getColumns().size() - 1) {
    buffer.append(", ");
  buffer.append("(");
for (int i = 0; i < update.getColumns().size(); i++) {
  if (i != 0) {
    buffer.append(", ");
  Column column = update.getColumns().get(i);
  column.accept(expressionVisitor);

代码示例来源：origin: erdemcer/kafka-connect-oracle

for (Column c : update.getColumns()){
 dataMap.put(cleanString(c.getColumnName()), null);

代码示例来源：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: yidasanqian/dynamic-add-date

boolean isContainsModifyDateColumn = false;
int modifyDateColumnIndex = 0;
for (int i = 0; i < update.getColumns().size(); i++) {
  Column column = update.getColumns().get(i);
  if (column.getColumnName().equals(updateDateColumnName)) {
    isContainsModifyDateColumn = true;

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

Update

相关文章

    查看更多
    微信公众号

    热门标签

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

    最新文章

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