Java PlainSelect类代码示例

import net.sf.jsqlparser.statement.select.PlainSelect; //导入依赖的package包/类
private void setSelectParameters(SelectBody body, com.google.cloud.spanner.Statement.Builder builder)
{
	if (body instanceof PlainSelect)
	{
		setPlainSelectParameters((PlainSelect) body, builder);
	}
	else
	{
		body.accept(new SelectVisitorAdapter()
		{
			@Override
			public void visit(PlainSelect plainSelect)
			{
				setPlainSelectParameters(plainSelect, builder);
			}
		});
	}
}
 

import net.sf.jsqlparser.statement.select.PlainSelect; //导入依赖的package包/类
@Override
public String toString() {
    StringBuilder b = new StringBuilder();
    b.append("GROUP_CONCAT(");
    if (isDistinct()) {
        b.append("DISTINCT ");
    }
    b.append(PlainSelect.getStringList(expressionList.getExpressions(), true, false));
    if (orderByElements != null && !orderByElements.isEmpty()) {
        b.append(" ORDER BY ");
        for (int i = 0; i < orderByElements.size(); i++) {
            if (i > 0) {
                b.append(", ");
            }
            b.append(orderByElements.get(i).toString());
        }
    }
    if (separator != null) {
        b.append(" SEPARATOR ").append(separator);
    }
    b.append(")");
    return b.toString();
}
 

import net.sf.jsqlparser.statement.select.PlainSelect; //导入依赖的package包/类
@Override
public String toString() {
	StringBuilder sql = new StringBuilder("CREATE ");
	if (isOrReplace()) {
		sql.append("OR REPLACE ");
	}
	if (isMaterialized()) {
		sql.append("MATERIALIZED ");
	}
	sql.append("VIEW ");
	sql.append(view);
	if (columnNames != null) {
		sql.append(PlainSelect.getStringList(columnNames, true, true));
	}
	sql.append(" AS ").append(selectBody);
	return sql.toString();
}
 

import net.sf.jsqlparser.statement.select.PlainSelect; //导入依赖的package包/类
@Override
public void visit(PlainSelect plainSelect) {
	for (SelectItem item : plainSelect.getSelectItems()) {
		item.accept(this);
	}

	if (itemsExpr.size() > 1) {
		BinaryExpression binExpr = createBinaryExpression();
		binExpr.setLeftExpression(itemsExpr.get(0).getExpression());
		for (int i = 1; i < itemsExpr.size() - 1; i++) {
			binExpr.setRightExpression(itemsExpr.get(i).getExpression());
			BinaryExpression binExpr2 = createBinaryExpression();
			binExpr2.setLeftExpression(binExpr);
			binExpr = binExpr2;
		}
		binExpr.setRightExpression(itemsExpr.get(itemsExpr.size() - 1).getExpression());

		SelectExpressionItem sei = new SelectExpressionItem();
		sei.setExpression(binExpr);

		plainSelect.getSelectItems().clear();
		plainSelect.getSelectItems().add(sei);
	}

	((SelectExpressionItem) plainSelect.getSelectItems().get(0)).setAlias(new Alias(alias));
}
 

import net.sf.jsqlparser.statement.select.PlainSelect; //导入依赖的package包/类
@Override
public void visit(PivotXml pivot) {
    List<Column> forColumns = pivot.getForColumns();
    buffer.append(" PIVOT XML (")
            .append(PlainSelect.getStringList(pivot.getFunctionItems()))
            .append(" FOR ")
            .append(PlainSelect.getStringList(forColumns, true, forColumns != null && forColumns.size() > 1))
            .append(" IN (");
    if (pivot.isInAny()) {
        buffer.append("ANY");
    } else if (pivot.getInSelect() != null) {
        buffer.append(pivot.getInSelect());
    } else {
        buffer.append(PlainSelect.getStringList(pivot.getInItems()));
    }
    buffer.append("))");
}
 

import net.sf.jsqlparser.statement.select.PlainSelect; //导入依赖的package包/类
public void deParse(CreateView createView) {
	buffer.append("CREATE ");
	if (createView.isOrReplace()) {
		buffer.append("OR REPLACE ");
	}
	if (createView.isMaterialized()) {
		buffer.append("MATERIALIZED ");
	}
	buffer.append("VIEW ").append(createView.getView().getFullyQualifiedName());
	if (createView.getColumnNames() != null) {
		buffer.append(PlainSelect.getStringList(createView.getColumnNames(), true, true));
	}
	buffer.append(" AS ");
       
       createView.getSelectBody().accept(selectVisitor);
}
 

import net.sf.jsqlparser.statement.select.PlainSelect; //导入依赖的package包/类
/**
 * Adds an expression to select statements. E.g. a simple column is an
 * expression.
 *
 * @param select
 * @param expr
 */
public static void addExpression(Select select, final Expression expr) {
	select.getSelectBody().accept(new SelectVisitor() {

		@Override
		public void visit(PlainSelect plainSelect) {
			plainSelect.getSelectItems().add(new SelectExpressionItem(expr));
		}

		@Override
		public void visit(SetOperationList setOpList) {
			throw new UnsupportedOperationException(NOT_SUPPORTED_YET);
		}

		@Override
		public void visit(WithItem withItem) {
			throw new UnsupportedOperationException(NOT_SUPPORTED_YET);
		}
	});
}
 

import net.sf.jsqlparser.statement.select.PlainSelect; //导入依赖的package包/类
/**
 * Adds a simple join to a select statement. The introduced join is returned for
 * more configuration settings on it (e.g. left join, right join).
 * @param select
 * @param table
 * @param onExpression
 * @return 
 */
public static Join addJoin(Select select, final Table table, final Expression onExpression) {
	if (select.getSelectBody() instanceof PlainSelect) {
		PlainSelect plainSelect = (PlainSelect) select.getSelectBody();
		List<Join> joins = plainSelect.getJoins();
		if (joins == null) {
			joins = new ArrayList<Join>();
			plainSelect.setJoins(joins);
		}
		Join join = new Join();
		join.setRightItem(table);
		join.setOnExpression(onExpression);
		joins.add(join);
		return join;
	}
	throw new UnsupportedOperationException(NOT_SUPPORTED_YET);
}
 

import net.sf.jsqlparser.statement.select.PlainSelect; //导入依赖的package包/类
/**
   * Adds group by to a plain select statement.
   * @param select
   * @param expr 
   */
  public static void addGroupBy(Select select, final Expression expr) {
      select.getSelectBody().accept(new SelectVisitor() {

	@Override
	public void visit(PlainSelect plainSelect) {
              plainSelect.addGroupByColumnReference(expr);
	}

	@Override
	public void visit(SetOperationList setOpList) {
		throw new UnsupportedOperationException(NOT_SUPPORTED_YET);
	}

	@Override
	public void visit(WithItem withItem) {
		throw new UnsupportedOperationException(NOT_SUPPORTED_YET);
	}
});
  }
 

import net.sf.jsqlparser.statement.select.PlainSelect; //导入依赖的package包/类
@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.getOracleHierarchical() != null) {
        plainSelect.getOracleHierarchical().accept(this);
    }
}
 

import net.sf.jsqlparser.statement.select.PlainSelect; //导入依赖的package包/类
public List<DataAccessor> executeSubquery(PlainSelect select) throws StatementExecutionException {
    List<DataAccessor> cached = subqueryCache.get(select);
    if (cached != null) {
        return cached;
    }
    LOGGER.log(Level.SEVERE, "executing subquery {0}", select);
    ExecutionPlan plan = compileSubplan(select);
    try (ScanResult result = (ScanResult) manager.executePlan(plan, this, transactionContext);) {
        List<DataAccessor> fullResult = result.dataScanner.consume();
        LOGGER.log(Level.SEVERE, "executing subquery " + select + " -> " + fullResult);
        subqueryCache.put(select, fullResult);
        return fullResult;
    } catch (DataScannerException error) {
        throw new StatementExecutionException(error);
    }
}
 

import net.sf.jsqlparser.statement.select.PlainSelect; //导入依赖的package包/类
public CompiledInExpression(boolean not, CompiledSQLExpression left,
        List<CompiledSQLExpression> inExpressions, SubSelect inSubSelect) {
    this.left = left;
    this.not = not;
    this.inExpressions = inExpressions;
    if (inSubSelect != null) {
        if (inSubSelect.getSelectBody() instanceof PlainSelect) {
            this.inSubSelectPlain = (PlainSelect) inSubSelect.getSelectBody();
        } else {
            throw new StatementExecutionException("unsupported operand \"IN\""
                    + " with subquery of type " + inSubSelect.getSelectBody().getClass()
                    + "(" + inSubSelect.getSelectBody() + ")");
        }
    } else {
        this.inSubSelectPlain = null;
    }
}
 

import net.sf.jsqlparser.statement.select.PlainSelect; //导入依赖的package包/类
/**
 * select 语句处理
 */
@Override
public void processSelectBody(SelectBody selectBody) {
    if (selectBody instanceof PlainSelect) {
        processPlainSelect((PlainSelect) selectBody);
    } else if (selectBody instanceof WithItem) {
        WithItem withItem = (WithItem) selectBody;
        if (withItem.getSelectBody() != null) {
            processSelectBody(withItem.getSelectBody());
        }
    } else {
        SetOperationList operationList = (SetOperationList) selectBody;
        if (operationList.getSelects() != null && operationList.getSelects().size() > 0) {
            List<SelectBody> plainSelects = operationList.getSelects();
            for (SelectBody plainSelect : plainSelects) {
                processSelectBody(plainSelect);
            }
        }
    }
}
 

import net.sf.jsqlparser.statement.select.PlainSelect; //导入依赖的package包/类
/**
 * <p>
 * insert 语句处理
 * </p>
 */
@Override
public void processInsert(Insert insert) {
    if (this.tenantHandler.doTableFilter(insert.getTable().getName())) {
        // 过滤退出执行
        return;
    }
    insert.getColumns().add(new Column(this.tenantHandler.getTenantIdColumn()));
    if (insert.getSelect() != null) {
        processPlainSelect((PlainSelect) insert.getSelect().getSelectBody(), true);
    } else if (insert.getItemsList() != null) {
        ((ExpressionList) insert.getItemsList()).getExpressions().add(tenantHandler.getTenantId());
    } else {
        throw new MybatisPlusException("Failed to process multiple-table update, please exclude the tableName or statementId");
    }
}
 

import net.sf.jsqlparser.statement.select.PlainSelect; //导入依赖的package包/类
/**
 * <p>
 * 处理 PlainSelect
 * </p>
 *
 * @param plainSelect
 * @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 (this.tenantHandler.doTableFilter(fromTable.getName())) {
            // 过滤退出执行
            return;
        }
        plainSelect.setWhere(builderExpression(plainSelect.getWhere(), fromTable));
        if (addColumn) {
            plainSelect.getSelectItems().add(new SelectExpressionItem(new Column(this.tenantHandler.getTenantIdColumn())));
        }
    } else {
        processFromItem(fromItem);
    }
    List<Join> joins = plainSelect.getJoins();
    if (joins != null && joins.size() > 0) {
        for (Join join : joins) {
            processJoin(join);
            processFromItem(join.getRightItem());
        }
    }
}