ResultSet object.
The following code fragment creates the ResultSet object rs,
creates the ResultSetMetaData object rsmd, and uses rsmd
to find out how many columns rs has and whether the first column in rs
can be used in a WHERE clause.
ResultSet rs = stmt.executeQuery("SELECT a, b, c FROM TABLE2");
ResultSetMetaData rsmd = rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount();
boolean b = rsmd.isSearchable(1);
| Modifier and Type | Field and Description |
|---|---|
| public static final int | columnNoNulls
The constant indicating that a
column does not allow |
| public static final int | columnNullable
The constant indicating that a
column allows |
| public static final int | columnNullableUnknown
The constant indicating that the nullability of a column's values is unknown. |
| Modifier and Type | Method and Description |
|---|---|
| public String | Returns: the name of the catalog for the table in which the given column appears or "" if not applicablethe first column is 1, the second is 2, ... column)Gets the designated column's table's catalog name. |
| public String | Returns: the fully-qualified name of the class in the Java programming language that would be used by the methodResultSet.getObject to retrieve the value in the specified
column. This is the class name used for custom mapping.the first column is 1, the second is 2, ... column)Returns the fully-qualified name of the Java class whose instances
are manufactured if the method |
| public int | Returns: the number of columnsReturns the number of columns in this |
| public int | Returns: the normal maximum number of characters allowed as the width of the designated columnthe first column is 1, the second is 2, ... column)Indicates the designated column's normal maximum width in characters. |
| public String | Returns: the suggested column titlethe first column is 1, the second is 2, ... column)Gets the designated column's suggested title for use in printouts and displays. |
| public String | Returns: column namethe first column is 1, the second is 2, ... column)Get the designated column's name. |
| public int | Returns: SQL type from java.sql.Typesthe first column is 1, the second is 2, ... column)Retrieves the designated column's SQL type. |
| public String | Returns: type name used by the database. If the column type is a user-defined type, then a fully-qualified type name is returned.the first column is 1, the second is 2, ... column)Retrieves the designated column's database-specific type name. |
| public int | Returns: precisionthe first column is 1, the second is 2, ... column)Get the designated column's specified column size. |
| public int | Returns: scalethe first column is 1, the second is 2, ... column)Gets the designated column's number of digits to right of the decimal point. |
| public String | Returns: schema name or "" if not applicablethe first column is 1, the second is 2, ... column)Get the designated column's table's schema. |
| public String | Returns: table name or "" if not applicablethe first column is 1, the second is 2, ... column)Gets the designated column's table name. |
| public boolean | Returns: true if so; false otherwisethe first column is 1, the second is 2, ... column)Indicates whether the designated column is automatically numbered. |
| public boolean | Returns: true if so; false otherwisethe first column is 1, the second is 2, ... column)Indicates whether a column's case matters. |
| public boolean | Returns: true if so; false otherwisethe first column is 1, the second is 2, ... column)Indicates whether the designated column is a cash value. |
| public boolean | Returns: true if so; false otherwisethe first column is 1, the second is 2, ... column)Indicates whether a write on the designated column will definitely succeed. |
| public int | Returns: the nullability status of the given column; one ofcolumnNoNulls,
columnNullable or columnNullableUnknownthe first column is 1, the second is 2, ... column)Indicates the nullability of values in the designated column. |
| public boolean | Returns: true if so; false otherwisethe first column is 1, the second is 2, ... column)Indicates whether the designated column is definitely not writable. |
| public boolean | Returns: true if so; false otherwisethe first column is 1, the second is 2, ... column)Indicates whether the designated column can be used in a where clause. |
| public boolean | Returns: true if so; false otherwisethe first column is 1, the second is 2, ... column)Indicates whether values in the designated column are signed numbers. |
| public boolean | Returns: true if so; false otherwisethe first column is 1, the second is 2, ... column)Indicates whether it is possible for a write on the designated column to succeed. |
| columnNoNulls | back to summary |
|---|---|
| public static final int columnNoNulls The constant indicating that a
column does not allow | |
| columnNullable | back to summary |
|---|---|
| public static final int columnNullable The constant indicating that a
column allows | |
| columnNullableUnknown | back to summary |
|---|---|
| public static final int columnNullableUnknown The constant indicating that the nullability of a column's values is unknown. | |
| getCatalogName | back to summary |
|---|---|
| public String getCatalogName(int column) throws SQLException Gets the designated column's table's catalog name.
| |
| getColumnClassName | back to summary |
|---|---|
| public String getColumnClassName(int column) throws SQLException Returns the fully-qualified name of the Java class whose instances
are manufactured if the method
| |
| getColumnCount | back to summary |
|---|---|
| public int getColumnCount() throws SQLException Returns the number of columns in this
| |
| getColumnDisplaySize | back to summary |
|---|---|
| public int getColumnDisplaySize(int column) throws SQLException Indicates the designated column's normal maximum width in characters.
| |
| getColumnLabel | back to summary |
|---|---|
| public String getColumnLabel(int column) throws SQLException Gets the designated column's suggested title for use in printouts and
displays. The suggested title is usually specified by the SQL
| |
| getColumnName | back to summary |
|---|---|
| public String getColumnName(int column) throws SQLException Get the designated column's name.
| |
| getColumnType | back to summary |
|---|---|
| public int getColumnType(int column) throws SQLException Retrieves the designated column's SQL type.
| |
| getColumnTypeName | back to summary |
|---|---|
| public String getColumnTypeName(int column) throws SQLException Retrieves the designated column's database-specific type name.
| |
| getPrecision | back to summary |
|---|---|
| public int getPrecision(int column) throws SQLException Get the designated column's specified column size. For numeric data, this is the maximum precision. For character data, this is the length in characters. For datetime datatypes, this is the length in characters of the String representation (assuming the maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, this is the length in bytes. 0 is returned for data types where the column size is not applicable.
| |
| getScale | back to summary |
|---|---|
| public int getScale(int column) throws SQLException Gets the designated column's number of digits to right of the decimal point. 0 is returned for data types where the scale is not applicable.
| |
| getSchemaName | back to summary |
|---|---|
| public String getSchemaName(int column) throws SQLException Get the designated column's table's schema.
| |
| getTableName | back to summary |
|---|---|
| public String getTableName(int column) throws SQLException Gets the designated column's table name.
| |
| isAutoIncrement | back to summary |
|---|---|
| public boolean isAutoIncrement(int column) throws SQLException Indicates whether the designated column is automatically numbered.
| |
| isCaseSensitive | back to summary |
|---|---|
| public boolean isCaseSensitive(int column) throws SQLException Indicates whether a column's case matters.
| |
| isCurrency | back to summary |
|---|---|
| public boolean isCurrency(int column) throws SQLException Indicates whether the designated column is a cash value.
| |
| isDefinitelyWritable | back to summary |
|---|---|
| public boolean isDefinitelyWritable(int column) throws SQLException Indicates whether a write on the designated column will definitely succeed.
| |
| isNullable | back to summary |
|---|---|
| public int isNullable(int column) throws SQLException Indicates the nullability of values in the designated column.
| |
| isReadOnly | back to summary |
|---|---|
| public boolean isReadOnly(int column) throws SQLException Indicates whether the designated column is definitely not writable.
| |
| isSearchable | back to summary |
|---|---|
| public boolean isSearchable(int column) throws SQLException Indicates whether the designated column can be used in a where clause.
| |
| isSigned | back to summary |
|---|---|
| public boolean isSigned(int column) throws SQLException Indicates whether values in the designated column are signed numbers.
| |
| isWritable | back to summary |
|---|---|
| public boolean isWritable(int column) throws SQLException Indicates whether it is possible for a write on the designated column to succeed.
| |