|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||
public interface ResultSetMetaData
This interface provides a mechanism for obtaining information about
the columns that are present in a ResultSet.
Note that in this class column indices start at 1, not 0.
| Field Summary | |
|---|---|
static int |
columnNoNulls
The column does not allow NULL's. |
static int |
columnNullable
The column allows NULL's. |
static int |
columnNullableUnknown
It is unknown whether or not the column allows NULL's. |
| Method Summary | |
|---|---|
String |
getCatalogName(int columnIndex)
This method returns the name of the catalog containing the specified column. |
String |
getColumnClassName(int columnIndex)
This method returns the name of the Java class which will be used to create objects representing the data in this column. |
int |
getColumnCount()
This method returns the number of columns in the result set. |
int |
getColumnDisplaySize(int columnIndex)
This method returns the maximum number of characters that can be used to display a value in this column. |
String |
getColumnLabel(int columnIndex)
This method returns a string that should be used as a caption for this column for user display purposes. |
String |
getColumnName(int columnIndex)
This method returns the name of the specified column. |
int |
getColumnType(int columnIndex)
This method returns the SQL type of the specified column. |
String |
getColumnTypeName(int columnIndex)
This method returns the name of the SQL type for this column. |
int |
getPrecision(int columnIndex)
This method returns the precision of the specified column, which is the number of decimal digits it contains. |
int |
getScale(int columnIndex)
This method returns the scale of the specified column, which is the number of digits to the right of the decimal point. |
String |
getSchemaName(int columnIndex)
This method returns the name of the schema that contains the specified column. |
String |
getTableName(int columnIndex)
This method returns the name of the table containing the specified column. |
boolean |
isAutoIncrement(int columnIndex)
This method test whether or not the column is an auto-increment column. |
boolean |
isCaseSensitive(int columnIndex)
This method tests whether or not a column is case sensitive in its values. |
boolean |
isCurrency(int columnIndex)
This method tests whether or not the column stores a monetary value. |
boolean |
isDefinitelyWritable(int columnIndex)
This method tests whether or not the column is writable. |
int |
isNullable(int columnIndex)
This method returns a value indicating whether or not the specified column may contain a NULL value. |
boolean |
isReadOnly(int columnIndex)
This method tests whether or not the specified column is read only. |
boolean |
isSearchable(int columnIndex)
This method tests whether not the specified column can be used in a WHERE clause. |
boolean |
isSigned(int columnIndex)
This method tests whether or not the value of the specified column is signed or unsigned. |
boolean |
isWritable(int columnIndex)
This method tests whether or not the column may be writable. |
| Field Detail |
|---|
static final int columnNoNulls
static final int columnNullable
static final int columnNullableUnknown
| Method Detail |
|---|
int getColumnCount()
throws SQLException
SQLException - If an error occurs.
boolean isAutoIncrement(int columnIndex)
throws SQLException
columnIndex - The index of the column to test.
true if the column is auto-increment, false
otherwise.
SQLException - If an error occurs.
boolean isCaseSensitive(int columnIndex)
throws SQLException
columnIndex - The index of the column to test.
true if the column value is case sensitive,
false otherwise.
SQLException - If an error occurs.
boolean isSearchable(int columnIndex)
throws SQLException
columnIndex - The index of the column to test.
true if the column may be used in a WHERE clause,
false otherwise.
SQLException - If an error occurs.
boolean isCurrency(int columnIndex)
throws SQLException
columnIndex - The index of the column to test.
true if the column contains a monetary value,
false otherwise.
SQLException - If an error occurs.
int isNullable(int columnIndex)
throws SQLException
columnIndex - The index of the column to test.
columnNoNulls,
columnNullable, or columnNullableUnknown.
SQLException - If an error occurs.
boolean isSigned(int columnIndex)
throws SQLException
columnIndex - The index of the column to test.
true if the column value is signed, false
otherwise.
SQLException - If an error occurs.
int getColumnDisplaySize(int columnIndex)
throws SQLException
columnIndex - The index of the column to check.
SQLException - If an error occurs.
String getColumnLabel(int columnIndex)
throws SQLException
columnIndex - The index of the column to check.
SQLException - If an error occurs.
String getColumnName(int columnIndex)
throws SQLException
columnIndex - The index of the column to return the name of.
SQLException - If an error occurs.
String getSchemaName(int columnIndex)
throws SQLException
columnIndex - The index of the column to check the schema name for.
SQLException - If an error occurs.
int getPrecision(int columnIndex)
throws SQLException
columnIndex - The index of the column to check the precision on.
SQLException - If an error occurs.
int getScale(int columnIndex)
throws SQLException
columnIndex - The index column to check the scale of.
SQLException - If an error occurs.
String getTableName(int columnIndex)
throws SQLException
columnIndex - The index of the column to check the table name for.
SQLException - If an error occurs.
String getCatalogName(int columnIndex)
throws SQLException
columnIndex - The index of the column to check the catalog name for.
SQLException - If an error occurs.
int getColumnType(int columnIndex)
throws SQLException
Types.
columnIndex - The index of the column to check the SQL type of.
SQLException - If an error occurs.Types
String getColumnTypeName(int columnIndex)
throws SQLException
columnIndex - The index of the column to check the SQL type name for.
SQLException - If an error occurs.
boolean isReadOnly(int columnIndex)
throws SQLException
columnIndex - The index of the column to check.
true if the column is read only, false
otherwise.
SQLException - If an error occurs.
boolean isWritable(int columnIndex)
throws SQLException
columnIndex - The index of the column to check for writability.
true if the column may be writable,
false otherwise.
SQLException - If an error occurs.
boolean isDefinitelyWritable(int columnIndex)
throws SQLException
columnIndex - The index of the column to check for writability.
true if the column is writable,
false otherwise.
SQLException - If an error occurs.
String getColumnClassName(int columnIndex)
throws SQLException
columnIndex - The index of the column to check.
SQLException - If an error occurs.
|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||