|
|||||||||
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 |