net.sf.jsqlparser.statement.delete.Delete.getTable()方法的使用及代码示例

x33g5p2x  于2022-01-18 转载在 其他  
字(8.1k)|赞(0)|评价(0)|浏览(208)

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

Delete.getTable介绍

暂无

代码示例

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

  1. /**
  2.  * delete 语句处理
  3.  */
  4. @Override
  5. public void processDelete(Delete delete) {
  6.   if (tenantHandler.doTableFilter(delete.getTable().getName())) {
  7.     // 过滤退出执行
  8.     return;
  9.   }
  10.   delete.setWhere(this.andExpression(delete.getTable(), delete.getWhere()));
  11. }

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

  1. public void deParse(Delete delete) {
  2.   buffer.append("DELETE");
  3.   if (delete.getTables() != null && delete.getTables().size() > 0) {
  4.     for (Table table : delete.getTables()) {
  5.       buffer.append(" ").append(table.getFullyQualifiedName());
  6.     }
  7.   }
  8.   buffer.append(" FROM ").append(delete.getTable().toString());
  9.   if (delete.getJoins() != null) {
  10.     for (Join join : delete.getJoins()) {
  11.       if (join.isSimple()) {
  12.         buffer.append(", ").append(join);
  13.       } else {
  14.         buffer.append(" ").append(join);
  15.       }
  16.     }
  17.   }
  18.   if (delete.getWhere() != null) {
  19.     buffer.append(" WHERE ");
  20.     delete.getWhere().accept(expressionVisitor);
  21.   }
  22.   if (delete.getOrderByElements() != null) {
  23.     new OrderByDeParser(expressionVisitor, buffer).deParse(delete.getOrderByElements());
  24.   }
  25.   if (delete.getLimit() != null) {
  26.     new LimitDeparser(buffer).deParse(delete.getLimit());
  27.   }
  28. }

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

  1. public void deParse(Delete delete) {
  2.   buffer.append("DELETE FROM " + delete.getTable().getWholeTableName());
  3.   if (delete.getWhere() != null) {
  4.     buffer.append(" WHERE ");
  5.     delete.getWhere().accept(expressionVisitor);
  6.   }
  7. }
  8. public ExpressionVisitor getExpressionVisitor() {

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

  1. delete.setTables(Collections.singletonList(delete.getTable()));

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

  1. @Override
  2. public void visit(Delete delete) {
  3.   visit(delete.getTable());
  4.   if (delete.getJoins() != null) {
  5.     for (Join join : delete.getJoins()) {
  6.       join.getRightItem().accept(this);
  7.     }
  8.   }
  9.   if (delete.getWhere() != null) {
  10.     delete.getWhere().accept(this);
  11.   }
  12. }

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

  1. public void deParse(Delete delete) {
  2.   buffer.append("DELETE");
  3.   if (delete.getTables() != null && delete.getTables().size() > 0) {
  4.     for (Table table : delete.getTables()) {
  5.       buffer.append(" ").append(table.getFullyQualifiedName());
  6.     }
  7.   }
  8.   buffer.append(" FROM ").append(delete.getTable().toString());
  9.   if (delete.getJoins() != null) {
  10.     for (Join join : delete.getJoins()) {
  11.       if (join.isSimple()) {
  12.         buffer.append(", ").append(join);
  13.       } else {
  14.         buffer.append(" ").append(join);
  15.       }
  16.     }
  17.   }
  18.   if (delete.getWhere() != null) {
  19.     buffer.append(" WHERE ");
  20.     delete.getWhere().accept(expressionVisitor);
  21.   }
  22.   if (delete.getOrderByElements() != null) {
  23.     new OrderByDeParser(expressionVisitor, buffer).deParse(delete.getOrderByElements());
  24.   }
  25.   if (delete.getLimit() != null) {
  26.     new LimitDeparser(buffer).deParse(delete.getLimit());
  27.   }
  28. }

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

  1. Delete delete = (Delete) statement;
  2. where = delete.getWhere();
  3. table = delete.getTable();
  4. joins = delete.getJoins();

代码示例来源：origin: vincentrussell/sql-to-mongo-db-query-converter

  1. public Builder setJSqlParser(CCJSqlParser jSqlParser) throws com.github.vincentrussell.query.mongodb.sql.converter.ParseException, ParseException {
  2.   final Statement statement = jSqlParser.Statement();
  3.   if (Select.class.isAssignableFrom(statement.getClass())) {
  4.     sqlCommandType = SQLCommandType.SELECT;
  5.     final PlainSelect plainSelect = (PlainSelect)(((Select)statement).getSelectBody());
  6.     SqlUtils.isTrue(plainSelect != null, "could not parseNaturalLanguageDate SELECT statement from query");
  7.     SqlUtils.isTrue(plainSelect.getFromItem()!=null,"could not find table to query.  Only one simple table name is supported.");
  8.     whereClause = plainSelect.getWhere();
  9.     isDistinct = (plainSelect.getDistinct() != null);
  10.     isCountAll = SqlUtils.isCountAll(plainSelect.getSelectItems());
  11.     SqlUtils.isTrue(plainSelect.getFromItem() != null, "could not find table to query.  Only one simple table name is supported.");
  12.     table = plainSelect.getFromItem().toString();
  13.     limit = SqlUtils.getLimit(plainSelect.getLimit());
  14.     orderByElements1 = plainSelect.getOrderByElements();
  15.     selectItems = plainSelect.getSelectItems();
  16.     joins = plainSelect.getJoins();
  17.     groupBys = SqlUtils.getGroupByColumnReferences(plainSelect);
  18.     SqlUtils.isTrue(plainSelect.getFromItem() != null, "could not find table to query.  Only one simple table name is supported.");
  19.   } else if (Delete.class.isAssignableFrom(statement.getClass())) {
  20.     sqlCommandType = SQLCommandType.DELETE;
  21.     Delete delete = (Delete)statement;
  22.     SqlUtils.isTrue(delete.getTables().size() == 0, "there should only be on table specified for deletes");
  23.     table = delete.getTable().toString();
  24.     whereClause = delete.getWhere();
  25.   }
  26.   return this;
  27. }

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

  1. public static List<String> name_delete_table(String sql) throws JSQLParserException {
  2.   net.sf.jsqlparser.statement.Statement statement = CCJSqlParserUtil.parse(sql);
  3.   Delete updateStatement = (Delete) statement;
  4.   Table update_table = updateStatement.getTable();
  5.   List<String> str_table = new ArrayList<>();
  6.   if (update_table != null) {
  7.     str_table.add(update_table.toString());
  8.   }
  9.   return str_table;
  10. }

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

  1. public void deParse(Delete aDelete) {
  2.   buffer
  3.       .append(aDelete.getComment() != null ? aDelete.getComment() + " " + ExpressionDeParser.LINE_SEPARATOR : "")
  4.       .append("Delete").append(aDelete.getFromComment() != null ? " " + aDelete.getFromComment() + ExpressionDeParser.LINE_SEPARATOR : "").append(" From ")
  5.       .append(aDelete.getTable().getComment() != null ? aDelete.getTable().getComment() + " " + ExpressionDeParser.LINE_SEPARATOR : "").append(aDelete.getTable().getWholeTableName());
  6.   if (aDelete.getWhere() != null) {
  7.     buffer.append(aDelete.getWhereComment() != null ? " " + aDelete.getWhereComment() : "").append(ExpressionDeParser.LINE_SEPARATOR).append(" Where ");
  8.     aDelete.getWhere().accept(expressionVisitor);
  9.   }
  10.   buffer.append(!"".equals(aDelete.getEndComment()) ? " " + aDelete.getEndComment() : "");
  11. }

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

  1. public void deParse(Delete delete) {
  2.   buffer.append("DELETE FROM " + delete.getTable().getWholeTableName());
  3.   if (delete.getWhere() != null) {
  4.     buffer.append(" WHERE ");
  5.     delete.getWhere().accept(expressionVisitor);
  6.   }
  7. }
  8. public ExpressionVisitor getExpressionVisitor() {

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

  1. /**
  2.  * <p>
  3.  * delete 语句处理
  4.  * </p>
  5.  */
  6. @Override
  7. public void processDelete(Delete delete) {
  8.   if (tenantHandler.doTableFilter(delete.getTable().getName())) {
  9.     // 过滤退出执行
  10.     return;
  11.   }
  12.   delete.setWhere(this.andExpression(delete.getTable(), delete.getWhere()));
  13. }

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

  1. @Override
  2. public void visit(Delete s) {
  3.   visit(s.getTable());
  4.   if (s.getOrderByElements() != null) {
  5.     s.getOrderByElements().forEach(o -> {
  6.       o.accept(this);
  7.     });
  8.   }
  9.   if (s.getWhere() != null) {
  10.     s.getWhere().accept(this);
  11.   }
  12. }

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

  1. } else if (statement instanceof Delete) {
  2.   Delete delete = (Delete) statement;
  3.   return Collections.singletonList(delete.getTable());

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

  1. } else if (statement instanceof Delete) {
  2.   Delete delete = (Delete) statement;
  3.   return Collections.singletonList(delete.getTable());

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

  1. @Override
  2. public void visit(Delete delete) {
  3.   visit(delete.getTable());
  4.   if (delete.getJoins() != null) {
  5.     for (Join join : delete.getJoins()) {
  6.       join.getRightItem().accept(this);
  7.     }
  8.   }
  9.   if (delete.getWhere() != null) {
  10.     delete.getWhere().accept(this);
  11.   }
  12. }

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

  1. public static Map<String, Table> getTablesMap(TO_CASE toCase, Statement aStatement, boolean aForTables) {
  2.   TablesFinder instance = new TablesFinder(toCase, aForTables);
  3.   if (aStatement instanceof Select) {
  4.     ((Select) aStatement).getSelectBody().accept(instance);
  5.   } else if (aStatement instanceof Delete) {
  6.     Table tbl = ((Delete) aStatement).getTable();
  7.     instance.visit(tbl);
  8.   } else if (aStatement instanceof Update) {
  9.     Table tbl = ((Update) aStatement).getTable();
  10.     instance.visit(tbl);
  11.   } else if (aStatement instanceof Insert) {
  12.     Table tbl = ((Insert) aStatement).getTable();
  13.     instance.visit(tbl);
  14.   }
  15.   return instance.tables;
  16. }

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

  1. Delete delete = (Delete) statement;
  2. where = delete.getWhere();
  3. table = delete.getTable();
  4. joins = delete.getJoins();

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

DELETE

相关文章

    查看更多

    热门标签

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

    最新文章

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