Wednesday, February 16, 2011

ResultSetMetaData

I was looking for a way to determine the number of columns in a ResultSet object when I encountered ResultSetMetaData. With this class I only need to call on the getColumnCount() method


String getCatalogName(int column) Gets the designated column's table's catalog name.
String getColumnClassName(int column) Returns the fully-qualified name of the Java class whose instances are manufactured if the method ResultSet.getObject is called to retrieve a value from the column.
int getColumnCount() Returns the number of columns in this ResultSet object.
int  getColumnDisplaySize(int column) Indicates the designated column's normal maximum width in characters.
String getColumnLabel(int column) Gets the designated column's suggested title for use in printouts and displays.
String getColumnName(int column) Get the designated column's name.
int getColumnType(int column) Retrieves the designated column's SQL type.
String getColumnTypeName(int column) Retrieves the designated column's database-specific type name.
int getPrecision(int column) Get the designated column's number of decimal digits.
int getScale(int column) Gets the designated column's number of digits to right of the decimal point.
String getSchemaName(int column) Get the designated column's table's schema.
String getTableName(int column) Gets the designated column's table name.
boolean isAutoIncrement(int column) Indicates whether the designated column is automatically numbered, thus read-only.
boolean isCaseSensitive(int column) Indicates whether a column's case matters.
boolean isCurrency(int column) Indicates whether the designated column is a cash value.
boolean isDefinitelyWritable(int column) Indicates whether a write on the designated column will definitely succeed.
int isNullable(int column) Indicates the nullability of values in the designated column.
boolean isReadOnly(int column) Indicates whether the designated column is definitely not writable.
boolean isSearchable(int column) Indicates whether the designated column can be used in a where clause.
boolean isSigned(int column) Indicates whether values in the designated column are signed numbers.
boolean isWritable(int column) Indicates whether it is possible for a write on the designated column to succeed.

No comments:

Post a Comment