Java CreateIndex类代码示例

import net.sf.jsqlparser.statement.create.index.CreateIndex; //导入依赖的package包/类
public void deParse(CreateIndex createIndex) {
	Index index = createIndex.getIndex();

	buffer.append("CREATE ");

	if (index.getType() != null) {
		buffer.append(index.getType());
		buffer.append(" ");
	}

	buffer.append("INDEX ");
	buffer.append(index.getName());
	buffer.append(" ON ");
	buffer.append(createIndex.getTable().getFullyQualifiedName());

	if (index.getColumnsNames() != null) {
		buffer.append(" (");
		for (Iterator iter = index.getColumnsNames().iterator(); iter.hasNext();) {
			String columnName = (String)iter.next();
			buffer.append(columnName);

			if (iter.hasNext()) {
				buffer.append(", ");
			}
		}
		buffer.append(")");
	}
}
 

import net.sf.jsqlparser.statement.create.index.CreateIndex; //导入依赖的package包/类
@Override
public ExecutionPlan plan(String defaultTableSpace, net.sf.jsqlparser.statement.Statement stmt,
    boolean scan, boolean returnValues, int maxRows) {
    verifyJdbcParametersIndexes(stmt);
    ExecutionPlan result;
    if (stmt instanceof CreateTable) {
        result = ExecutionPlan.simple(buildCreateTableStatement(defaultTableSpace, (CreateTable) stmt));
    } else if (stmt instanceof CreateIndex) {
        result = ExecutionPlan.simple(buildCreateIndexStatement(defaultTableSpace, (CreateIndex) stmt));
    } else if (stmt instanceof Insert) {
        result = buildInsertStatement(defaultTableSpace, (Insert) stmt, returnValues);
    } else if (stmt instanceof Delete) {
        result = buildDeleteStatement(defaultTableSpace, (Delete) stmt, returnValues);
    } else if (stmt instanceof Update) {
        result = buildUpdateStatement(defaultTableSpace, (Update) stmt, returnValues);
    } else if (stmt instanceof Select) {
        result = buildSelectStatement(defaultTableSpace, (Select) stmt, scan, maxRows);
    } else if (stmt instanceof Execute) {
        result = ExecutionPlan.simple(buildExecuteStatement(defaultTableSpace, (Execute) stmt));
    } else if (stmt instanceof Alter) {
        result = ExecutionPlan.simple(buildAlterStatement(defaultTableSpace, (Alter) stmt));
    } else if (stmt instanceof Drop) {
        result = ExecutionPlan.simple(buildDropStatement(defaultTableSpace, (Drop) stmt));
    } else if (stmt instanceof Truncate) {
        result = ExecutionPlan.simple(buildTruncateStatement(defaultTableSpace, (Truncate) stmt));
    } else {
        return null;
    }
    return result;
}
 

import net.sf.jsqlparser.statement.create.index.CreateIndex; //导入依赖的package包/类
private Statement buildCreateIndexStatement(String defaultTableSpace, CreateIndex s) throws StatementExecutionException {
    try {
        String tableSpace = s.getTable().getSchemaName();
        if (tableSpace == null) {
            tableSpace = defaultTableSpace;
        }
        String tableName = s.getTable().getName();

        String indexName = s.getIndex().getName().toLowerCase();
        String indexType = convertIndexType(s.getIndex().getType());

        herddb.model.Index.Builder builder = herddb.model.Index
            .builder()
            .name(indexName)
            .uuid(UUID.randomUUID().toString())
            .type(indexType)
            .table(tableName)
            .tablespace(tableSpace);

        AbstractTableManager tableDefinition = manager.getTableSpaceManager(tableSpace).getTableManager(tableName);
        if (tableDefinition == null) {
            throw new TableDoesNotExistException("no such table " + tableName + " in tablespace " + tableSpace);
        }
        for (String columnName : s.getIndex().getColumnsNames()) {
            columnName = columnName.toLowerCase();
            Column column = tableDefinition.getTable().getColumn(columnName);
            if (column == null) {
                throw new StatementExecutionException("no such column " + columnName + " on table " + tableName + " in tablespace " + tableSpace);
            }
            builder.column(column.name, column.type);
        }

        CreateIndexStatement statement = new CreateIndexStatement(builder.build());
        return statement;
    } catch (IllegalArgumentException err) {
        throw new StatementExecutionException("bad index definition: " + err.getMessage(), err);
    }
}
 

import net.sf.jsqlparser.statement.create.index.CreateIndex; //导入依赖的package包/类
@Override
public void visit(CreateIndex createIndex) {
    visit(createIndex.getTable());
    Index index = createIndex.getIndex();
    visit(index);

}
 

import net.sf.jsqlparser.statement.create.index.CreateIndex; //导入依赖的package包/类
@Override
public void visit(CreateIndex createIndex) {
    CreateIndexDeParser createIndexDeParser = new CreateIndexDeParser(buffer);
    createIndexDeParser.deParse(createIndex);
}
 

import net.sf.jsqlparser.statement.create.index.CreateIndex; //导入依赖的package包/类
@Override
public void visit(CreateIndex createIndex) {
    throw new UnsupportedOperationException(NOT_SUPPORTED_YET);
}
 

import net.sf.jsqlparser.statement.create.index.CreateIndex; //导入依赖的package包/类
public void visit(CreateIndex createIndex) {
    throw new UnsupportedSQLFeatureException("Feature CreateIndex not supported");
}
 

import net.sf.jsqlparser.statement.create.index.CreateIndex; //导入依赖的package包/类
@Override
public void visit(CreateIndex createIndex) {
    throw new UnsupportedOperationException(NOT_SUPPORTED_YET); //To change body of generated methods, choose Tools | Templates.
}
 

import net.sf.jsqlparser.statement.create.index.CreateIndex; //导入依赖的package包/类
@Override
public void visit(CreateIndex createIndex) 
{
    throw new UnsupportedOperationException("Not supported yet."); 
}
 

import net.sf.jsqlparser.statement.create.index.CreateIndex; //导入依赖的package包/类
@Override
public void visit(CreateIndex createIndex) {

}
 

import net.sf.jsqlparser.statement.create.index.CreateIndex; //导入依赖的package包/类
@Override
public void visit(CreateIndex createIndex) throws Exception {

}
 

import net.sf.jsqlparser.statement.create.index.CreateIndex; //导入依赖的package包/类
void visit(CreateIndex createIndex);