net.sf.jabb.util.db

Class ColumnMetaData

java.lang.Object

net.sf.jabb.util.db.ColumnMetaData

public class ColumnMetaData
extends Object

This class encapsulates all the column related metadata you can get from ResultSetMetaData, and in additional, some fields are added such as index, labelOrName propertyName.

Author:

james.hu

Constructor Summary

Constructors

Constructor and Description
ColumnMetaData(ResultSetMetaData m, int column) Construct an instance with result set metadata and column index

Method Summary

Modifier and Type	Method and Description
static List<ColumnMetaData>	createList(ResultSetMetaData m) Get all the column meta data and put them into a list in their default order
static Map<String,ColumnMetaData>	createMapByLabelOrName(ResultSetMetaData m) Get all the column meta data and put them into a map keyed by column label or name
String	getCatalogName()
String	getClassName()
int	getDisplaySize()
int	getIndex()
String	getLabel()
String	getLabelOrName()
String	getName()
int	getNullable()
int	getPrecision()
String	getPropertyName()
int	getScale()
String	getSchemaName()
String	getTableName()
int	getType()
String	getTypeName()
boolean	isAutoIncrement()
boolean	isCaseSensitive()
boolean	isDefinitelyWritable()
boolean	isReadOnly()
boolean	isSearchable()
boolean	isSigned()
boolean	isWritable()
void	setAutoIncrement(boolean autoIncrement)
void	setCaseSensitive(boolean caseSensitive)
void	setCatalogName(String catalogName)
void	setClassName(String className)
void	setDefinitelyWritable(boolean definitelyWritable)
void	setDisplaySize(int displaySize)
void	setIndex(int index)
void	setLabel(String label)
void	setLabelOrName(String labelOrName)
void	setName(String name)
void	setNullable(int nullable)
void	setPrecision(int precision)
void	setPropertyName(String propertyName)
void	setReadOnly(boolean readOnly)
void	setScale(int scale)
void	setSchemaName(String schemaName)
void	setSearchable(boolean searchable)
void	setSigned(boolean signed)
void	setTableName(String tableName)
void	setType(int type)
void	setTypeName(String typeName)
void	setWritable(boolean writable)

Methods inherited from class java.lang.Object

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

Constructor Detail

ColumnMetaData

public ColumnMetaData(ResultSetMetaData m,
                      int column)
               throws SQLException

Construct an instance with result set metadata and column index

Parameters:

m - result set metadata

column - index. the first column has the index of 1

Throws:

SQLException

Method Detail

createMapByLabelOrName

public static Map<String,ColumnMetaData> createMapByLabelOrName(ResultSetMetaData m)
                                                         throws SQLException

Get all the column meta data and put them into a map keyed by column label or name

Parameters:

m - the result set meta data

Returns:

Throws:

SQLException

createList

public static List<ColumnMetaData> createList(ResultSetMetaData m)
                                       throws SQLException

Get all the column meta data and put them into a list in their default order

Parameters:

m - the result set meta data

Returns:

Throws:

SQLException

getCatalogName

public String getCatalogName()

setCatalogName

public void setCatalogName(String catalogName)

getClassName

public String getClassName()

setClassName

public void setClassName(String className)

getDisplaySize

public int getDisplaySize()

setDisplaySize

public void setDisplaySize(int displaySize)

getLabel

public String getLabel()

setLabel

public void setLabel(String label)

getName

public String getName()

setName

public void setName(String name)

getType

public int getType()

setType

public void setType(int type)

getTypeName

public String getTypeName()

setTypeName

public void setTypeName(String typeName)

getPrecision

public int getPrecision()

setPrecision

public void setPrecision(int precision)

getScale

public int getScale()

setScale

public void setScale(int scale)

getSchemaName

public String getSchemaName()

setSchemaName

public void setSchemaName(String schemaName)

getTableName

public String getTableName()

setTableName

public void setTableName(String tableName)

isAutoIncrement

public boolean isAutoIncrement()

setAutoIncrement

public void setAutoIncrement(boolean autoIncrement)

isCaseSensitive

public boolean isCaseSensitive()

setCaseSensitive

public void setCaseSensitive(boolean caseSensitive)

isDefinitelyWritable

public boolean isDefinitelyWritable()

setDefinitelyWritable

public void setDefinitelyWritable(boolean definitelyWritable)

getNullable

public int getNullable()

setNullable

public void setNullable(int nullable)

isReadOnly

public boolean isReadOnly()

setReadOnly

public void setReadOnly(boolean readOnly)

isSearchable

public boolean isSearchable()

setSearchable

public void setSearchable(boolean searchable)

isSigned

public boolean isSigned()

setSigned

public void setSigned(boolean signed)

isWritable

public boolean isWritable()

setWritable

public void setWritable(boolean writable)

getIndex

public int getIndex()

setIndex

public void setIndex(int index)

getPropertyName

public String getPropertyName()

setPropertyName

public void setPropertyName(String propertyName)

getLabelOrName

public String getLabelOrName()

setLabelOrName

public void setLabelOrName(String labelOrName)