sf.database.dbinfo

Class Index

java.lang.Object

sf.database.dbinfo.Index

public class Index
extends Object

数据库中查到的索引信息

Author:

Administrator

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	Index.IndexItem

Constructor Summary

Constructors

Constructor and Description
Index()
Index(String indexName)

Method Summary

Modifier and Type	Method and Description
void	addColumn(String column, Boolean isAsc) 添加一个列，在最后的位置
void	addColumn(String column, Boolean isAsc, int seq) 添加一个列
String	generateName()
String[]	getColumnNames() 得到索引中的所有列
List<Index.IndexItem>	getColumns()
String	getFilterCondition()
String	getIndexName() 获得索引名称
String	getIndexQualifier()
String	getTableName() 获得索引所在的表名
String	getTableSchema()
String	getTableWithSchem()
int	getType() 索引类型，有以下几类 tableIndexStatistic(0) - this identifies table statistics that are returned in conjuction with a table's index descriptions tableIndexClustered(1) - this is a clustered index tableIndexHashed (2) - this is a hashed index tableIndexOther (3) - this is some other style of index
String	getUserDefinition()
boolean	isOnSingleColumn(String columnName)
boolean	isUnique() 该索引是否唯一约束
boolean	removeColumn(Index.IndexItem column) 删除一个列
void	setFilterCondition(String filterCondition)
void	setIndexName(String indexName) 设置索引名称
void	setIndexQualifier(String indexQualifier)
void	setTableName(String tableName) 设置索引所在的表名
void	setTableSchema(String tableSchema)
void	setType(int type) 设置索引类型
void	setUnique(boolean unique) 设置该索引是否有唯一约束
void	setUserDefinition(String userDefinition)
String	toCreateSql()
String	toString()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

Index

public Index(String indexName)

Index

public Index()

Method Detail

toString

public String toString()

Overrides:

toString in class Object

getType

public int getType()

索引类型，有以下几类

• tableIndexStatistic(0) - this identifies table statistics that are returned in conjuction with a table's index descriptions
• tableIndexClustered(1) - this is a clustered index
• tableIndexHashed (2) - this is a hashed index
• tableIndexOther (3) - this is some other style of index

Returns:

索引类型

setType

public void setType(int type)

设置索引类型

Parameters:

type - 索引类型

getColumnNames

public String[] getColumnNames()

得到索引中的所有列

Returns:

所有列名

addColumn

public void addColumn(String column,
                      Boolean isAsc)

添加一个列，在最后的位置

Parameters:

column - 列名称

addColumn

public void addColumn(String column,
                      Boolean isAsc,
                      int seq)

添加一个列

removeColumn

public boolean removeColumn(Index.IndexItem column)

删除一个列

Parameters:

column - 列名

Returns:

getIndexName

public String getIndexName()

获得索引名称

Returns:

索引名称

setIndexName

public void setIndexName(String indexName)

设置索引名称

Parameters:

indexName - 索引名称

isUnique

public boolean isUnique()

该索引是否唯一约束

Returns:

如有唯一约束返回true

setUnique

public void setUnique(boolean unique)

设置该索引是否有唯一约束

Parameters:

unique - 是否有唯一约束

getColumns

public List<Index.IndexItem> getColumns()

getTableName

public String getTableName()

获得索引所在的表名

Returns:

索引所在的表名

setTableName

public void setTableName(String tableName)

设置索引所在的表名

Parameters:

tableName - 索引所在的表名

getTableSchema

public String getTableSchema()

setTableSchema

public void setTableSchema(String tableSchema)

getIndexQualifier

public String getIndexQualifier()

setIndexQualifier

public void setIndexQualifier(String indexQualifier)

getFilterCondition

public String getFilterCondition()

setFilterCondition

public void setFilterCondition(String filterCondition)

getUserDefinition

public String getUserDefinition()

setUserDefinition

public void setUserDefinition(String userDefinition)

toCreateSql

public String toCreateSql()

generateName

public String generateName()

getTableWithSchem

public String getTableWithSchem()

isOnSingleColumn

public boolean isOnSingleColumn(String columnName)