java.sql
public interface ResultSetMetaData
ResultSet
.
Note that in this class column indices start at 1, not 0.
Modifier and Type | Field and Description |
---|---|
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.
|
Modifier and Type | Method and Description |
---|---|
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.
|
static final int columnNoNulls
static final int columnNullable
static final int columnNullableUnknown
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.