クラス PgResultSetMetaData
- すべての実装されたインタフェース:
ResultSetMetaData
,Wrapper
,PGResultSetMetaData
-
フィールドの概要
フィールドインタフェースから継承されたフィールド java.sql.ResultSetMetaData
columnNoNulls, columnNullable, columnNullableUnknown
-
コンストラクタの概要
コンストラクタコンストラクタ説明PgResultSetMetaData
(BaseConnection connection, Field[] fields) Initialise for a result with a tuple set and a field descriptor set -
メソッドの概要
修飾子とタイプメソッド説明getBaseColumnName
(int column) Returns the underlying column name of a query result, or "" if it is unable to be determined.getBaseSchemaName
(int column) Returns the underlying schema name of query result, or "" if it is unable to be determined.getBaseTableName
(int column) Returns the underlying table name of query result, or "" if it is unable to be determined.getCatalogName
(int column) getColumnClassName
(int column) int
int
getColumnDisplaySize
(int column) getColumnLabel
(int column) getColumnName
(int column) int
getColumnType
(int column) getColumnTypeName
(int column) protected Field
getField
(int columnIndex) For several routines in this package, we need to convert a columnIndex into a Field[] descriptor.int
getFormat
(int column) Is a column Text or Binary?protected @Nullable String
getPGType
(int columnIndex) int
getPrecision
(int column) int
getScale
(int column) getSchemaName
(int column) protected int
getSQLType
(int columnIndex) getTableName
(int column) boolean
isAutoIncrement
(int column) boolean
isCaseSensitive
(int column) boolean
isCurrency
(int column) boolean
isDefinitelyWritable
(int column) int
isNullable
(int column) boolean
isReadOnly
(int column) boolean
isSearchable
(int column) boolean
isSigned
(int column) boolean
isWrapperFor
(Class<?> iface) boolean
isWritable
(int column) <T> T
-
フィールド詳細
-
connection
-
fields
-
-
コンストラクタの詳細
-
PgResultSetMetaData
Initialise for a result with a tuple set and a field descriptor set- パラメータ:
connection
- the connection to retrieve metadatafields
- the array of field descriptors
-
-
メソッドの詳細
-
getColumnCount
- 定義:
getColumnCount
インタフェース内ResultSetMetaData
- 例外:
SQLException
-
isAutoIncrement
It is believed that PostgreSQL does not support this feature.
- 定義:
isAutoIncrement
インタフェース内ResultSetMetaData
- パラメータ:
column
- the first column is 1, the second is 2...- 戻り値:
- true if so
- 例外:
SQLException
- if a database access error occurs
-
isCaseSensitive
Does a column's case matter? ASSUMPTION: Any field that is not obviously case insensitive is assumed to be case sensitive
- 定義:
isCaseSensitive
インタフェース内ResultSetMetaData
- パラメータ:
column
- the first column is 1, the second is 2...- 戻り値:
- true if so
- 例外:
SQLException
- if a database access error occurs
-
isSearchable
Can the column be used in a WHERE clause? Basically for this, I split the functions into two types: recognised types (which are always useable), and OTHER types (which may or may not be useable). The OTHER types, for now, I will assume they are useable. We should really query the catalog to see if they are useable.
- 定義:
isSearchable
インタフェース内ResultSetMetaData
- パラメータ:
column
- the first column is 1, the second is 2...- 戻り値:
- true if they can be used in a WHERE clause
- 例外:
SQLException
- if a database access error occurs
-
isCurrency
Is the column a cash value? 6.1 introduced the cash/money type, which haven't been incorporated as of 970414, so I just check the type name for both 'cash' and 'money'
- 定義:
isCurrency
インタフェース内ResultSetMetaData
- パラメータ:
column
- the first column is 1, the second is 2...- 戻り値:
- true if its a cash column
- 例外:
SQLException
- if a database access error occurs
-
isNullable
- 定義:
isNullable
インタフェース内ResultSetMetaData
- 例外:
SQLException
-
isSigned
Is the column a signed number? In PostgreSQL, all numbers are signed, so this is trivial. However, strings are not signed (duh!)
- 定義:
isSigned
インタフェース内ResultSetMetaData
- パラメータ:
column
- the first column is 1, the second is 2...- 戻り値:
- true if so
- 例外:
SQLException
- if a database access error occurs
-
getColumnDisplaySize
- 定義:
getColumnDisplaySize
インタフェース内ResultSetMetaData
- 例外:
SQLException
-
getColumnLabel
- 定義:
getColumnLabel
インタフェース内ResultSetMetaData
- 例外:
SQLException
-
getColumnName
- 定義:
getColumnName
インタフェース内ResultSetMetaData
- 例外:
SQLException
-
getBaseColumnName
インタフェースからコピーされた説明:PGResultSetMetaData
Returns the underlying column name of a query result, or "" if it is unable to be determined.- 定義:
getBaseColumnName
インタフェース内PGResultSetMetaData
- パラメータ:
column
- column position (1-based)- 戻り値:
- underlying column name of a query result
- 例外:
SQLException
- if something wrong happens
-
getSchemaName
- 定義:
getSchemaName
インタフェース内ResultSetMetaData
- 例外:
SQLException
-
getBaseSchemaName
インタフェースからコピーされた説明:PGResultSetMetaData
Returns the underlying schema name of query result, or "" if it is unable to be determined.- 定義:
getBaseSchemaName
インタフェース内PGResultSetMetaData
- パラメータ:
column
- column position (1-based)- 戻り値:
- underlying schema name of query result
- 例外:
SQLException
- if something wrong happens
-
getPrecision
- 定義:
getPrecision
インタフェース内ResultSetMetaData
- 例外:
SQLException
-
getScale
- 定義:
getScale
インタフェース内ResultSetMetaData
- 例外:
SQLException
-
getTableName
- 定義:
getTableName
インタフェース内ResultSetMetaData
- 例外:
SQLException
-
getBaseTableName
インタフェースからコピーされた説明:PGResultSetMetaData
Returns the underlying table name of query result, or "" if it is unable to be determined.- 定義:
getBaseTableName
インタフェース内PGResultSetMetaData
- パラメータ:
column
- column position (1-based)- 戻り値:
- underlying table name of query result
- 例外:
SQLException
- if something wrong happens
-
getCatalogName
As with getSchemaName(), we can say that if getTableName() returns n/a, then we can too - otherwise, we need to work on it.
- 定義:
getCatalogName
インタフェース内ResultSetMetaData
- パラメータ:
column
- the first column is 1, the second is 2...- 戻り値:
- catalog name, or "" if not applicable
- 例外:
SQLException
- if a database access error occurs
-
getColumnType
- 定義:
getColumnType
インタフェース内ResultSetMetaData
- 例外:
SQLException
-
getFormat
インタフェースからコピーされた説明:PGResultSetMetaData
Is a column Text or Binary?- 定義:
getFormat
インタフェース内PGResultSetMetaData
- パラメータ:
column
- column position (1-based)- 戻り値:
- 0 if column data format is TEXT, or 1 if BINARY
- 例外:
SQLException
- if something wrong happens- 関連項目:
-
getColumnTypeName
- 定義:
getColumnTypeName
インタフェース内ResultSetMetaData
- 例外:
SQLException
-
isReadOnly
In reality, we would have to check the GRANT/REVOKE stuff for this to be effective, and I haven't really looked into that yet, so this will get re-visited.
- 定義:
isReadOnly
インタフェース内ResultSetMetaData
- パラメータ:
column
- the first column is 1, the second is 2, etc.*- 戻り値:
- true if so*
- 例外:
SQLException
- if a database access error occurs
-
isWritable
In reality have to check the GRANT/REVOKE stuff, which I haven't worked with as yet. However, if it isn't ReadOnly, then it is obviously writable.
- 定義:
isWritable
インタフェース内ResultSetMetaData
- パラメータ:
column
- the first column is 1, the second is 2, etc.- 戻り値:
- true if so
- 例外:
SQLException
- if a database access error occurs
-
isDefinitelyWritable
Hmmm...this is a bad one, since the two preceding functions have not been really defined. I cannot tell is the short answer. I thus return isWritable() just to give us an idea.
- 定義:
isDefinitelyWritable
インタフェース内ResultSetMetaData
- パラメータ:
column
- the first column is 1, the second is 2, etc..- 戻り値:
- true if so
- 例外:
SQLException
- if a database access error occurs
-
getField
For several routines in this package, we need to convert a columnIndex into a Field[] descriptor. Rather than do the same code several times, here it is.- パラメータ:
columnIndex
- the first column is 1, the second is 2...- 戻り値:
- the Field description
- 例外:
SQLException
- if a database access error occurs
-
getPGType
- 例外:
SQLException
-
getSQLType
- 例外:
SQLException
-
getColumnClassName
- 定義:
getColumnClassName
インタフェース内ResultSetMetaData
- 例外:
SQLException
-
isWrapperFor
- 定義:
isWrapperFor
インタフェース内Wrapper
- 例外:
SQLException
-
unwrap
- 定義:
unwrap
インタフェース内Wrapper
- 例外:
SQLException
-