|
Préférences
Moteurs de recherche
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
JavaTM 2 Platform Std. Ed. v1.5.0
javax.sql.rowset
|
Field Summary |
---|
Fields inherited from interface java.sql.ResultSetMetaData |
---|
columnNoNulls, columnNullable, columnNullableUnknown |
Constructor Summary | |
---|---|
RowSetMetaDataImpl()
|
Method Summary | |
---|---|
String |
getCatalogName(int columnIndex)
Retrieves the catalog name of the table from which the value in the designated column was derived. |
String |
getColumnClassName(int columnIndex)
Retrieves the fully-qualified name of the class in the Java programming language to which a value in the designated column will be mapped. |
int |
getColumnCount()
Retrieves the number of columns in the RowSet object
for which this RowSetMetaDataImpl object was created. |
int |
getColumnDisplaySize(int columnIndex)
Retrieves the normal maximum width in chars of the designated column. |
String |
getColumnLabel(int columnIndex)
Retrieves the the suggested column title for the designated column for use in printouts and displays. |
String |
getColumnName(int columnIndex)
Retrieves the name of the designated column. |
int |
getColumnType(int columnIndex)
Retrieves the type code (one of the java.sql.Types
constants) for the SQL type of the value stored in the
designated column. |
String |
getColumnTypeName(int columnIndex)
Retrieves the DBMS-specific type name for values stored in the designated column. |
int |
getPrecision(int columnIndex)
Retrieves the total number of digits for values stored in the designated column. |
int |
getScale(int columnIndex)
Retrieves the number of digits to the right of the decimal point for values stored in the designated column. |
String |
getSchemaName(int columnIndex)
Retrieves the schema name of the table from which the value in the designated column was derived. |
String |
getTableName(int columnIndex)
Retrieves the name of the table from which the value in the designated column was derived. |
boolean |
isAutoIncrement(int columnIndex)
Retrieves whether a value stored in the designated column is automatically numbered, and thus readonly. |
boolean |
isCaseSensitive(int columnIndex)
Indicates whether the case of the designated column's name matters. |
boolean |
isCurrency(int columnIndex)
Indicates whether a value stored in the designated column is a cash value. |
boolean |
isDefinitelyWritable(int columnIndex)
Indicates whether a write operation on the designated column will definitely succeed. |
int |
isNullable(int columnIndex)
Retrieves a constant indicating whether it is possible to store a NULL value in the designated column. |
boolean |
isReadOnly(int columnIndex)
Indicates whether the designated column is definitely not writable, thus readonly. |
boolean |
isSearchable(int columnIndex)
Indicates whether a value stored in the designated column can be used in a WHERE clause. |
boolean |
isSigned(int columnIndex)
Indicates whether a value stored in the designated column is a signed number. |
boolean |
isWritable(int columnIndex)
Indicates whether it is possible for a write operation on the designated column to succeed. |
void |
setAutoIncrement(int columnIndex,
boolean property)
Sets whether the designated column is automatically numbered, thus read-only, to the given boolean
value. |
void |
setCaseSensitive(int columnIndex,
boolean property)
Sets whether the name of the designated column is case sensitive to the given boolean . |
void |
setCatalogName(int columnIndex,
String catalogName)
Sets the catalog name of the table from which the designated column was derived to catalogName. |
void |
setColumnCount(int columnCount)
Sets to the given number the number of columns in the RowSet
object for which this RowSetMetaDataImpl object was created. |
void |
setColumnDisplaySize(int columnIndex,
int size)
Sets the normal maximum number of chars in the designated column to the given number. |
void |
setColumnLabel(int columnIndex,
String label)
Sets the suggested column label for use in printouts and displays, if any, to label. |
void |
setColumnName(int columnIndex,
String columnName)
Sets the column name of the designated column to the given name. |
void |
setColumnType(int columnIndex,
int SQLType)
Sets the SQL type code for values stored in the designated column to the given type code from the class java.sql.Types . |
void |
setColumnTypeName(int columnIndex,
String typeName)
Sets the type name used by the data source for values stored in the designated column to the given type name. |
void |
setCurrency(int columnIndex,
boolean property)
Sets whether a value stored in the designated column is a cash value to the given boolean . |
void |
setNullable(int columnIndex,
int property)
Sets whether a value stored in the designated column can be set to NULL to the given constant from the interface
ResultSetMetaData . |
void |
setPrecision(int columnIndex,
int precision)
Sets the total number of decimal digits in a value stored in the designated column to the given number. |
void |
setScale(int columnIndex,
int scale)
Sets the number of digits to the right of the decimal point in a value stored in the designated column to the given number. |
void |
setSchemaName(int columnIndex,
String schemaName)
Sets the designated column's table's schema name, if any, to schemaName. |
void |
setSearchable(int columnIndex,
boolean property)
Sets whether a value stored in the designated column can be used in a WHERE clause to the given boolean value. |
void |
setSigned(int columnIndex,
boolean property)
Sets whether a value stored in the designated column is a signed number to the given boolean . |
void |
setTableName(int columnIndex,
String tableName)
Sets the name of the table from which the designated column was derived to the given table name. |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public RowSetMetaDataImpl()
Method Detail |
---|
public void setColumnCount(int columnCount) throws SQLException
RowSet
object for which this RowSetMetaDataImpl
object was created.
setColumnCount
in interface RowSetMetaData
columnCount
- an int
giving the number of columns in the
RowSet
object
SQLException
- if the given number is equal to or less than zeropublic void setAutoIncrement(int columnIndex, boolean property) throws SQLException
boolean
value.
setAutoIncrement
in interface RowSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns
in the rowset, inclusiveproperty
- true
if the given column is
automatically incremented; false
otherwise
SQLException
- if a database access error occurs or
the given index is out of bounds
SQLException
- if a database access error occurspublic void setCaseSensitive(int columnIndex, boolean property) throws SQLException
boolean
.
setCaseSensitive
in interface RowSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns
in the rowset, inclusiveproperty
- true
to indicate that the column
name is case sensitive; false
otherwise
SQLException
- if a database access error occurs or
the given column number is out of boundspublic void setSearchable(int columnIndex, boolean property) throws SQLException
WHERE
clause to the given boolean
value.
setSearchable
in interface RowSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number
of columns in the rowset, inclusiveproperty
- true
to indicate that a column
value can be used in a WHERE
clause;
false
otherwise
SQLException
- if a database access error occurs or
the given column number is out of bounds
SQLException
- if a database access error occurspublic void setCurrency(int columnIndex, boolean property) throws SQLException
boolean
.
setCurrency
in interface RowSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns,
inclusive between 1
and the number of columns, inclusiveproperty
- true if the value is a cash value; false otherwise.
SQLException
- if a database access error occurs
or the given column number is out of bounds
SQLException
- if a database access error occurspublic void setNullable(int columnIndex, int property) throws SQLException
NULL
to the given constant from the interface
ResultSetMetaData
.
setNullable
in interface RowSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusiveproperty
- one of the following ResultSetMetaData
constants:
columnNoNulls
,
columnNullable
, or
columnNullableUnknown
SQLException
- if a database access error occurs,
the given column number is out of bounds, or the value supplied
for the property parameter is not one of the following
constants:
ResultSetMetaData.columnNoNulls
,
ResultSetMetaData.columnNullable
, or
ResultSetMetaData.columnNullableUnknown
SQLException
- if a database access error occurspublic void setSigned(int columnIndex, boolean property) throws SQLException
boolean
.
setSigned
in interface RowSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusiveproperty
- true
to indicate that a column
value is a signed number;
false
to indicate that it is not
SQLException
- if a database access error occurs
or the given column number is out of boundspublic void setColumnDisplaySize(int columnIndex, int size) throws SQLException
setColumnDisplaySize
in interface RowSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusivesize
- the maximum size of the column in chars; must be
0
or more
SQLException
- if a database access error occurs,
the given column number is out of bounds, or size is
less than 0
public void setColumnLabel(int columnIndex, String label) throws SQLException
null
, the column label is set to an empty string
("").
setColumnLabel
in interface RowSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusivelabel
- the column label to be used in printouts and displays; if the
column label is null
, an empty String
is
set
SQLException
- if a database access error occurs
or the given column index is out of boundspublic void setColumnName(int columnIndex, String columnName) throws SQLException
setColumnName
in interface RowSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusivecolumnName
- a String
object indicating the column name;
if the given name is null
, an empty String
is set
SQLException
- if a database access error occurs or the given column
index is out of boundspublic void setSchemaName(int columnIndex, String schemaName) throws SQLException
null
,
the schema name is set to an empty string ("").
setSchemaName
in interface RowSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusiveschemaName
- the schema name for the table from which a value in the
designated column was derived; may be an empty String
or null
SQLException
- if a database access error occurs
or the given column number is out of boundspublic void setPrecision(int columnIndex, int precision) throws SQLException
setPrecision
in interface RowSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusiveprecision
- the total number of decimal digits; must be 0
or more
SQLException
- if a database access error occurs,
columnIndex is out of bounds, or precision
is less than 0
public void setScale(int columnIndex, int scale) throws SQLException
setScale
in interface RowSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusivescale
- the number of digits to the right of the decimal point; must be
zero or greater
SQLException
- if a database access error occurs,
columnIndex is out of bounds, or scale
is less than 0
public void setTableName(int columnIndex, String tableName) throws SQLException
setTableName
in interface RowSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusivetableName
- the column's table name; may be null
or an
empty string
SQLException
- if a database access error occurs
or the given column number is out of boundspublic void setCatalogName(int columnIndex, String catalogName) throws SQLException
null
, the catalog name is set to an empty string.
setCatalogName
in interface RowSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusivecatalogName
- the column's table's catalog name; if the catalogName
is null
, an empty String
is set
SQLException
- if a database access error occurs
or the given column number is out of boundspublic void setColumnType(int columnIndex, int SQLType) throws SQLException
java.sql.Types
.
setColumnType
in interface RowSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusiveSQLType
- the designated column's SQL type, which must be one of the
constants in the class java.sql.Types
SQLException
- if a database access error occurs,
the given column number is out of bounds, or the column type
specified is not one of the constants in
java.sql.Types
Types
public void setColumnTypeName(int columnIndex, String typeName) throws SQLException
setColumnTypeName
in interface RowSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusivetypeName
- the data source-specific type name; if typeName is
null
, an empty String
is set
SQLException
- if a database access error occurs
or the given column number is out of boundspublic int getColumnCount() throws SQLException
RowSet
object
for which this RowSetMetaDataImpl
object was created.
getColumnCount
in interface ResultSetMetaData
SQLException
- if an error occurs determining the column countpublic boolean isAutoIncrement(int columnIndex) throws SQLException
isAutoIncrement
in interface ResultSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusive
true
if the column is automatically numbered;
false
otherwise
SQLException
- if a database access error occurs
or the given column number is out of boundspublic boolean isCaseSensitive(int columnIndex) throws SQLException
isCaseSensitive
in interface ResultSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusive
true
if the column name is case sensitive;
false
otherwise
SQLException
- if a database access error occurs
or the given column number is out of boundspublic boolean isSearchable(int columnIndex) throws SQLException
WHERE
clause.
isSearchable
in interface ResultSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusive
true
if a value in the designated column can be used in a
WHERE
clause; false
otherwise
SQLException
- if a database access error occurs
or the given column number is out of boundspublic boolean isCurrency(int columnIndex) throws SQLException
isCurrency
in interface ResultSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusive
true
if a value in the designated column is a cash value;
false
otherwise
SQLException
- if a database access error occurs
or the given column number is out of boundspublic int isNullable(int columnIndex) throws SQLException
NULL
value in the designated column.
isNullable
in interface ResultSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusive
ResultSetMetaData
interface;
either columnNoNulls
,
columnNullable
, or
columnNullableUnknown
SQLException
- if a database access error occurs
or the given column number is out of boundspublic boolean isSigned(int columnIndex) throws SQLException
isSigned
in interface ResultSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusive
true
if if a value in the designated column is a signed
number; false
otherwise
SQLException
- if a database access error occurs
or the given column number is out of boundspublic int getColumnDisplaySize(int columnIndex) throws SQLException
getColumnDisplaySize
in interface ResultSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusive
SQLException
- if a database access error occurs
or the given column number is out of boundspublic String getColumnLabel(int columnIndex) throws SQLException
getColumnLabel
in interface ResultSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusive
SQLException
- if a database access error occurs
or the given column number is out of boundspublic String getColumnName(int columnIndex) throws SQLException
getColumnName
in interface ResultSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusive
SQLException
- if a database access error occurs
or the given column number is out of boundspublic String getSchemaName(int columnIndex) throws SQLException
getSchemaName
in interface ResultSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns,
inclusive
String
if no schema
name is available
SQLException
- if a database access error occurs
or the given column number is out of boundspublic int getPrecision(int columnIndex) throws SQLException
getPrecision
in interface ResultSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusive
SQLException
- if a database access error occurs
or the given column number is out of boundspublic int getScale(int columnIndex) throws SQLException
getScale
in interface ResultSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusive
SQLException
- if a database access error occurs
or the given column number is out of boundspublic String getTableName(int columnIndex) throws SQLException
getTableName
in interface ResultSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusive
String
if no table name
is available
SQLException
- if a database access error occurs
or the given column number is out of boundspublic String getCatalogName(int columnIndex) throws SQLException
getCatalogName
in interface ResultSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusive
String
if no catalog name is available
SQLException
- if a database access error occurs
or the given column number is out of boundspublic int getColumnType(int columnIndex) throws SQLException
java.sql.Types
constants) for the SQL type of the value stored in the
designated column.
getColumnType
in interface ResultSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusive
int
representing the SQL type of values
stored in the designated column
SQLException
- if a database access error occurs
or the given column number is out of boundsTypes
public String getColumnTypeName(int columnIndex) throws SQLException
getColumnTypeName
in interface ResultSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusive
SQLException
- if a database access error occurs
or the given column number is out of boundspublic boolean isReadOnly(int columnIndex) throws SQLException
isReadOnly
in interface ResultSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusive
true
if this RowSet
object is read-Only
and thus not updatable; false
otherwise
SQLException
- if a database access error occurs
or the given column number is out of boundspublic boolean isWritable(int columnIndex) throws SQLException
true
means that a write operation may or may
not succeed.
isWritable
in interface ResultSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusive
true
if a write operation on the designated column may
will succeed; false
otherwise
SQLException
- if a database access error occurs
or the given column number is out of boundspublic boolean isDefinitelyWritable(int columnIndex) throws SQLException
isDefinitelyWritable
in interface ResultSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusive
true
if a write operation on the designated column will
definitely succeed; false
otherwise
SQLException
- if a database access error occurs
or the given column number is out of boundspublic String getColumnClassName(int columnIndex) throws SQLException
int
,
the class name returned by this method will be
java.lang.Integer
.
If the value in the designated column has a custom mapping,
this method returns the name of the class that implements
SQLData
. When the method ResultSet.getObject
is called to retrieve a value from the designated column, it will
create an instance of this class or one of its subclasses.
getColumnClassName
in interface ResultSetMetaData
columnIndex
- the first column is 1, the second is 2, and so on;
must be between 1
and the number of columns, inclusive
RowSet.getObject
to
retrieve the value in the specified column. This is the class
name used for custom mapping when there is a custom mapping.
SQLException
- if a database access error occurs
or the given column number is out of bounds