net.sf.jsqlparser.statement.select.Join.getRightItem()方法的使用及代码示例

x33g5p2x  于2022-01-21 转载在 其他  
字(7.2k)|赞(0)|评价(0)|浏览(224)

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

Join.getRightItem介绍

[英]Returns the right item of the join
[中]返回联接的正确项

代码示例

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

/**
 * 如果SQL用了 left Join，验证是否有or、not等等，并且验证是否使用了索引
 *
 * @param joins ignore
 * @param table ignore
 * @param connection ignore
 */
private static void validJoins(List<Join> joins, Table table, Connection connection) {
  //允许执行join，验证jion是否使用索引等等
  if (joins != null) {
    for (Join join : joins) {
      Table rightTable = (Table) join.getRightItem();
      Expression expression = join.getOnExpression();
      validWhere(expression, table, rightTable, connection);
    }
  }
}

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

/**
 * 处理联接语句
 */
protected void processJoin(Join join) {
  if (join.getRightItem() instanceof Table) {
    Table fromTable = (Table) join.getRightItem();
    if (this.tenantHandler.doTableFilter(fromTable.getName())) {
      // 过滤退出执行
      return;
    }
    join.setOnExpression(builderExpression(join.getOnExpression(), fromTable));
  }
}

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

@Override
public void visit(SubJoin subjoin) {
  subjoin.getLeft().accept(this);
  for (Join join : subjoin.getJoinList()) {
    join.getRightItem().accept(this);
  }
}

代码示例来源：origin: pagehelper/Mybatis-PageHelper

/**
 * 处理PlainSelect类型的selectBody
 *
 * @param plainSelect
 */
public void processPlainSelect(PlainSelect plainSelect) {
  if (!orderByHashParameters(plainSelect.getOrderByElements())) {
    plainSelect.setOrderByElements(null);
  }
  if (plainSelect.getFromItem() != null) {
    processFromItem(plainSelect.getFromItem());
  }
  if (plainSelect.getJoins() != null && plainSelect.getJoins().size() > 0) {
    List<Join> joins = plainSelect.getJoins();
    for (Join join : joins) {
      if (join.getRightItem() != null) {
        processFromItem(join.getRightItem());
      }
    }
  }
}

代码示例来源：origin: scouter-project/scouter

public void visit(SubJoin subjoin) {
  subjoin.getLeft().accept(this);
  subjoin.getJoin().getRightItem().accept(this);
}

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

FromItem fromItem = join.getRightItem();
fromItem.accept(this);
if (join.getOnExpression() != null) {

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

FromItem fromItem = join.getRightItem();
fromItem.accept(this);
if (join.isWindowJoin()) {

代码示例来源：origin: pagehelper/Mybatis-PageHelper

/**
 * 处理PlainSelect类型的selectBody
 *
 * @param plainSelect
 */
protected void processPlainSelect(PlainSelect plainSelect, int level) {
  if (level > 1) {
    if (isNotEmptyList(plainSelect.getOrderByElements())) {
      if (plainSelect.getTop() == null) {
        plainSelect.setTop(TOP100_PERCENT);
      }
    }
  }
  if (plainSelect.getFromItem() != null) {
    processFromItem(plainSelect.getFromItem(), level + 1);
  }
  if (plainSelect.getJoins() != null && plainSelect.getJoins().size() > 0) {
    List<Join> joins = plainSelect.getJoins();
    for (Join join : joins) {
      if (join.getRightItem() != null) {
        processFromItem(join.getRightItem(), level + 1);
      }
    }
  }
}

代码示例来源：origin: scouter-project/scouter

public void visit(PlainSelect plainSelect) {
  List<SelectItem> cols = plainSelect.getSelectItems();
  for(SelectItem col : cols){
    col.accept(this);
  }
  if(plainSelect.getFromItem()!=null){
    plainSelect.getFromItem().accept(this);
  }
  if (plainSelect.getJoins() != null) {
    for (Iterator joinsIt = plainSelect.getJoins().iterator(); joinsIt.hasNext();) {
      Join join = (Join) joinsIt.next();
      join.getRightItem().accept(this);
    }
  }
  if (plainSelect.getWhere() != null)
    plainSelect.getWhere().accept(this);
}

代码示例来源：origin: pagehelper/Mybatis-PageHelper

if (subJoin.getJoinList() != null && subJoin.getJoinList().size() > 0) {
  for (Join join : subJoin.getJoinList()) {
    if (join.getRightItem() != null) {
      processFromItem(join.getRightItem(), level + 1);

代码示例来源：origin: pagehelper/Mybatis-PageHelper

if (subJoin.getJoinList() != null && subJoin.getJoinList().size() > 0) {
  for (Join join : subJoin.getJoinList()) {
    if (join.getRightItem() != null) {
      processFromItem(join.getRightItem());

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

@Override
public void visit(Delete delete) {
  visit(delete.getTable());
  if (delete.getJoins() != null) {
    for (Join join : delete.getJoins()) {
      join.getRightItem().accept(this);
    }
  }
  if (delete.getWhere() != null) {
    delete.getWhere().accept(this);
  }
}

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

/**
 * 处理 PlainSelect
 *
 * @param plainSelect ignore
 * @param addColumn   是否添加租户列,insert into select语句中需要
 */
protected void processPlainSelect(PlainSelect plainSelect, boolean addColumn) {
  FromItem fromItem = plainSelect.getFromItem();
  if (fromItem instanceof Table) {
    Table fromTable = (Table) fromItem;
    if (tenantHandler.doTableFilter(fromTable.getName())) {
      // 过滤退出执行
      return;
    }
    plainSelect.setWhere(builderExpression(plainSelect.getWhere(), fromTable));
    if (addColumn) {
      plainSelect.getSelectItems().add(new SelectExpressionItem(new Column(tenantHandler.getTenantIdColumn())));
    }
  } else {
    processFromItem(fromItem);
  }
  List<Join> joins = plainSelect.getJoins();
  if (joins != null && joins.size() > 0) {
    joins.forEach(j -> {
      processJoin(j);
      processFromItem(j.getRightItem());
    });
  }
}

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

for (Join join : plainSelect.getJoins()) {
  if (join.isSimple()) {
    TableStruct rightTableStruct = tableStructAnalyser.analyse(connection, join.getRightItem().toString());
    rightTableStruct.getPrimaryKeys().forEach(primaryKey -> {
      Column column = new Column((Table) join.getRightItem(), primaryKey);
      selectItems.add(new SelectExpressionItem(column));
      primaryKeys.add(column.getFullyQualifiedName());

代码示例来源：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: JSQLParser/JSqlParser

@Override
public void visit(PlainSelect plainSelect) {
  if (plainSelect.getSelectItems() != null) {
    for (SelectItem item : plainSelect.getSelectItems()) {
      item.accept(this);
    }
  }
  if (plainSelect.getFromItem() != null) {
    plainSelect.getFromItem().accept(this);
  }
  if (plainSelect.getJoins() != null) {
    for (Join join : plainSelect.getJoins()) {
      join.getRightItem().accept(this);
    }
  }
  if (plainSelect.getWhere() != null) {
    plainSelect.getWhere().accept(this);
  }
  if (plainSelect.getHaving() != null) {
    plainSelect.getHaving().accept(this);
  }
  if (plainSelect.getOracleHierarchical() != null) {
    plainSelect.getOracleHierarchical().accept(this);
  }
}

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

@Override
public void visit(SubJoin subjoin) {
  subjoin.getLeft().accept(this);
  for (Join join : subjoin.getJoinList()) {
    join.getRightItem().accept(this);
  }
}

代码示例来源：origin: it.unibz.inf.ontop/ontop-mapping-sql-core

@Override
public void visit(SubJoin subjoin) {
  subjoin.getLeft().accept(this);
  subjoin.getJoin().getRightItem().accept(this);
}

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

@Override
public void visit(Delete delete) {
  visit(delete.getTable());
  if (delete.getJoins() != null) {
    for (Join join : delete.getJoins()) {
      join.getRightItem().accept(this);
    }
  }
  if (delete.getWhere() != null) {
    delete.getWhere().accept(this);
  }
}

代码示例来源：origin: ontop/ontop

@Override
public void visit(PlainSelect plainSelect) {
  plainSelect.getFromItem().accept(fromItemVisitor);
  if (plainSelect.getJoins() != null)
    for (Join join : plainSelect.getJoins())
      join.getRightItem().accept(fromItemVisitor);
  if (plainSelect.getWhere() != null)
    plainSelect.getWhere().accept(expressionVisitor);
  for (SelectItem expr : plainSelect.getSelectItems())
    expr.accept(selectItemVisitor);
}

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

Join

相关文章

    查看更多

    热门标签

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

    最新文章

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