Java SQLName类代码示例

import com.alibaba.druid.sql.ast.SQLName; //导入依赖的package包/类
public boolean visit(MySqlDeleteStatement x) {
    setAliasMap();

    setMode(x, Mode.Delete);

    accept(x.getFrom());
    accept(x.getUsing());
    x.getTableSource().accept(this);

    if (x.getTableSource() instanceof SQLExprTableSource) {
        SQLName tableName = (SQLName) ((SQLExprTableSource) x.getTableSource()).getExpr();
        String ident = tableName.toString();
        setCurrentTable(x, ident);

        TableStat stat = this.getTableStat(ident,ident);
        stat.incrementDeleteCount();
    }

    accept(x.getWhere());

    accept(x.getOrderBy());
    accept(x.getLimit());

    return false;
}
 

import com.alibaba.druid.sql.ast.SQLName; //导入依赖的package包/类
public boolean applyColumnRename(SQLName columnName, SQLName to) {
    for (SQLSelectOrderByItem orderByItem : columns) {
        SQLExpr expr = orderByItem.getExpr();
        if (expr instanceof SQLName
                && SQLUtils.nameEquals((SQLName) expr, columnName)) {
            orderByItem.setExpr(to.clone());
            return true;
        }
    }
    return false;
}
 

import com.alibaba.druid.sql.ast.SQLName; //导入依赖的package包/类
public String computeName() {
    if (tableSource == null) {
        return null;
    }

    SQLExpr expr = tableSource.getExpr();
    if (expr instanceof SQLName) {
        String name = ((SQLName) expr).getSimpleName();
        return SQLUtils.normalize(name);
    }

    return null;
}
 

import com.alibaba.druid.sql.ast.SQLName; //导入依赖的package包/类
@Override
public boolean visit(MySqlInsertStatement x) {
    SQLName sqlName = x.getTableName();
    if (sqlName != null) {
        setCurrentTable(sqlName.toString());
    }
    return false;
}
 

import com.alibaba.druid.sql.ast.SQLName; //导入依赖的package包/类
@Override
public SQLName getReferencedTableName() {
    if (referencedTable == null) {
        return null;
    }
    return referencedTable.getName();
}
 

import com.alibaba.druid.sql.ast.SQLName; //导入依赖的package包/类
public void setDatabase(SQLName database) {
    if (database != null) {
        database.setParent(this);
    }

    this.database = database;
}
 

import com.alibaba.druid.sql.ast.SQLName; //导入依赖的package包/类
public SQLName getToName() {
    if (to == null) {
        return null;
    }

    SQLExpr expr = to.expr;

    if (expr instanceof SQLName) {
        return (SQLName) expr;
    }

    return null;
}
 

import com.alibaba.druid.sql.ast.SQLName; //导入依赖的package包/类
public SQLExpr primaryRest(SQLExpr expr) {
    if (lexer.token() == Token.DOTDOT) {
        expr = nameRest((SQLName) expr);
    }

    return super.primaryRest(expr);
}
 

import com.alibaba.druid.sql.ast.SQLName; //导入依赖的package包/类
public SQLName getObject() {
    return object;
}
 

import com.alibaba.druid.sql.ast.SQLName; //导入依赖的package包/类
private String[] buildGroupByCols(List<SQLExpr> groupByItems,Map<String, String> aliaColumns) {
	String[] groupByCols = new String[groupByItems.size()]; 
	for(int i= 0; i < groupByItems.size(); i++) {
           SQLExpr sqlExpr = groupByItems.get(i);
           String column = null;
           if(sqlExpr instanceof SQLIdentifierExpr )
           {
               column=((SQLIdentifierExpr) sqlExpr).getName();
           } else if(sqlExpr instanceof SQLMethodInvokeExpr){
			column = ((SQLMethodInvokeExpr) sqlExpr).toString();
		} else if(sqlExpr instanceof MySqlOrderingExpr){
               //todo czn
               SQLExpr expr = ((MySqlOrderingExpr) sqlExpr).getExpr();

               if (expr instanceof SQLName)
               {
                   column = StringUtil.removeBackquote(((SQLName) expr).getSimpleName());//不要转大写 2015-2-10 sohudo StringUtil.removeBackquote(expr.getSimpleName().toUpperCase());
               } else
               {
                   column = StringUtil.removeBackquote(expr.toString());
               }
           } else if(sqlExpr instanceof SQLPropertyExpr){
			/**
			 * 针对子查询别名，例如select id from (select h.id from hotnews h  union select h.title from hotnews h ) as t1 group by t1.id;
			 */
			column = sqlExpr.toString();
		}
		if(column == null){
			column = sqlExpr.toString();
		}
		int dotIndex=column.indexOf(".") ;
		int bracketIndex=column.indexOf("(") ;
		//通过判断含有括号来决定是否为函数列
		if(dotIndex!=-1&&bracketIndex==-1)
		{
			//此步骤得到的column必须是不带.的，有别名的用别名，无别名的用字段名
			column=column.substring(dotIndex+1) ;
		}
		groupByCols[i] = getAliaColumn(aliaColumns,column);//column;
	}
	return groupByCols;
}
 

import com.alibaba.druid.sql.ast.SQLName; //导入依赖的package包/类
public void setLabel(SQLName label) {
    this.label = label;
}
 

import com.alibaba.druid.sql.ast.SQLName; //导入依赖的package包/类
public List<SQLName> getPartitions() {
    return partitions;
}
 

import com.alibaba.druid.sql.ast.SQLName; //导入依赖的package包/类
public void addPartition(SQLName partition) {
    if (partition != null) {
        partition.setParent(this);
    }
    this.partitions.add(partition);
}
 

import com.alibaba.druid.sql.ast.SQLName; //导入依赖的package包/类
public void setTable(SQLName table) {
    this.setTable(new SQLExprTableSource(table));
}
 

import com.alibaba.druid.sql.ast.SQLName; //导入依赖的package包/类
public SQLName getName() {
    return name;
}