Java Expression.accept方法代码示例

import net.sf.jsqlparser.expression.Expression; //导入方法依赖的package包/类
private void visitDeleteWhereClause(Expression where, DeleteKeyBuilder keyBuilder,
		boolean generateParameterMetaData) throws SQLException
{
	if (where != null)
	{
		DMLWhereClauseVisitor whereClauseVisitor = new DMLWhereClauseVisitor(getParameterStore())
		{

			@Override
			protected void visitExpression(Column col, Expression expression)
			{
				String columnName = unquoteIdentifier(col.getFullyQualifiedName());
				keyBuilder.set(columnName);
				expression.accept(
						new KeyBuilderExpressionVisitorAdapter(getParameterStore(), columnName, keyBuilder));
			}

		};
		where.accept(whereClauseVisitor);
		if (!generateParameterMetaData && !whereClauseVisitor.isValid())
		{
			throw new CloudSpannerSQLException(INVALID_WHERE_CLAUSE_DELETE_MESSAGE, Code.INVALID_ARGUMENT);
		}
	}
}
 

import net.sf.jsqlparser.expression.Expression; //导入方法依赖的package包/类
private boolean isSingleRowWhereClause(TableKeyMetaData table, Expression where)
{
	if (where != null)
	{
		SingleRowWhereClauseValidator validator = new SingleRowWhereClauseValidator(table);
		DMLWhereClauseVisitor whereClauseVisitor = new DMLWhereClauseVisitor(getParameterStore())
		{

			@Override
			protected void visitExpression(Column col, Expression expression)
			{
				String columnName = unquoteIdentifier(col.getFullyQualifiedName());
				validator.set(columnName);
				expression.accept(
						new SingleRowWhereClauseValidatorExpressionVisitorAdapter(getParameterStore(), validator));
			}

		};
		where.accept(whereClauseVisitor);
		return whereClauseVisitor.isValid() && validator.isValid();
	}
	return false;
}
 

import net.sf.jsqlparser.expression.Expression; //导入方法依赖的package包/类
@Override
public void visit(MultiExpressionList multiExprList) {
    buffer.append(" VALUES ");
    for (Iterator<ExpressionList> it = multiExprList.getExprList().iterator(); it.hasNext();) {
        buffer.append("(");
        for (Iterator<Expression> iter = it.next().getExpressions().iterator(); iter.hasNext();) {
            Expression expression = iter.next();
            expression.accept(expressionVisitor);
            if (iter.hasNext()) {
                buffer.append(", ");
            }
        }
        buffer.append(")");
        if (it.hasNext()) {
            buffer.append(", ");
        }
    }
}
 

import net.sf.jsqlparser.expression.Expression; //导入方法依赖的package包/类
@Override
public void visit(ExpressionList expressionList) {
    if (useBracketsInExprList) {
        buffer.append("(");
    }
    for (Iterator<Expression> iter = expressionList.getExpressions().iterator(); iter.hasNext();) {
        Expression expression = iter.next();
        expression.accept(this);
        if (iter.hasNext()) {
            buffer.append(", ");
        }
    }
    if (useBracketsInExprList) {
        buffer.append(")");
    }
}
 

import net.sf.jsqlparser.expression.Expression; //导入方法依赖的package包/类
@Override
public void visit(Update update) {
    for (Table table : update.getTables()) {
        tables.add(table.getName());
    }
    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);
    }
}
 

import net.sf.jsqlparser.expression.Expression; //导入方法依赖的package包/类
private void setWhereParameters(Expression where, com.google.cloud.spanner.Statement.Builder builder)
{
	if (where != null)
	{
		where.accept(new ExpressionVisitorAdapter()
		{
			private String currentCol = null;

			@Override
			public void visit(Column col)
			{
				currentCol = unquoteIdentifier(col.getFullyQualifiedName());
			}

			@Override
			public void visit(JdbcParameter parameter)
			{
				parameter.accept(new ValueBinderExpressionVisitorAdapter<>(getParameterStore(),
						builder.bind("p" + parameter.getIndex()), currentCol));
				currentCol = null;
			}

			@Override
			public void visit(SubSelect subSelect)
			{
				setSelectParameters(subSelect.getSelectBody(), builder);
			}

		});
	}
}
 

import net.sf.jsqlparser.expression.Expression; //导入方法依赖的package包/类
private void visitUpdateWhereClause(Expression where, WriteBuilder builder, boolean generateParameterMetaData)
		throws SQLException
{
	if (where != null)
	{
		DMLWhereClauseVisitor whereClauseVisitor = new DMLWhereClauseVisitor(getParameterStore())
		{

			@Override
			protected void visitExpression(Column col, Expression expression)
			{
				String columnName = unquoteIdentifier(col.getFullyQualifiedName());
				expression.accept(new ValueBinderExpressionVisitorAdapter<>(getParameterStore(),
						builder.set(columnName), columnName));
			}

		};
		where.accept(whereClauseVisitor);
		if (!generateParameterMetaData && !whereClauseVisitor.isValid())
		{
			throw new CloudSpannerSQLException(INVALID_WHERE_CLAUSE_UPDATE_MESSAGE, Code.INVALID_ARGUMENT);
		}
	}
	else
	{
		throw new SQLException(INVALID_WHERE_CLAUSE_UPDATE_MESSAGE);
	}
}
 

import net.sf.jsqlparser.expression.Expression; //导入方法依赖的package包/类
@Override
public void visit(ExpressionList expressionList) {
	buffer.append(" VALUES (");
	for (Iterator<Expression> iter = expressionList.getExpressions().iterator(); iter.hasNext();) {
		Expression expression = iter.next();
		expression.accept(expressionVisitor);
		if (iter.hasNext()) {
			buffer.append(", ");
		}
	}
	buffer.append(")");
}
 

import net.sf.jsqlparser.expression.Expression; //导入方法依赖的package包/类
/**
 * Main entry for this Tool class. A list of found tables is returned.
 *
 * @param update
 * @return
 */

public List<String> getTableList(Expression expr) {
    init();
    expr.accept(this);
    return tables;
}
 

import net.sf.jsqlparser.expression.Expression; //导入方法依赖的package包/类
@Override
public void visit(ExpressionList expressionList) {
    for (Iterator<?> iter = expressionList.getExpressions().iterator();iter.hasNext();) {
        Expression expression = (Expression) iter.next();
        expression.accept(this);
    }
}
 

import net.sf.jsqlparser.expression.Expression; //导入方法依赖的package包/类
/**
 * The constraints in the WHERE clause might reference
 * fields that are not retrieved in the SELECT.
 * Therefore, we need to add them, otherwise it
 * would not be possible to calculate any heuristics
 *
 * @param select the string containing the SQL SELECT command
 * @return  the modified SQL SELECT
 */
public static String addFieldsToSelect(String select) {

    Select stmt = asStatement(select);

    SelectBody selectBody = stmt.getSelectBody();
    if (selectBody instanceof PlainSelect) {
        PlainSelect plainSelect = (PlainSelect) selectBody;

        Expression where = plainSelect.getWhere();
        if (where == null) {
            //nothing to do
            return select;
        }

        List<SelectItem> fields = plainSelect.getSelectItems();

        where.accept(new ExpressionVisitorAdapter() {
            @Override
            public void visit(Column column) {

                String target = column.toString();

                boolean found = false;
                for (SelectItem si : fields) {
                    SelectExpressionItem field = (SelectExpressionItem) si;
                    String exp = field.getExpression().toString();
                    if (target.equals(exp)) {
                        found = true;
                        break;
                    }
                }
                if (!found) {
                    SelectExpressionItem item = new SelectExpressionItem();
                    item.setExpression(column);
                    fields.add(item);
                }
            }
        });
    }

    return stmt.toString();
}