Defines the constants that are used to identify generic SQL types, called JDBC types.
SQLType
Modifier and Type | Field and Description |
---|---|
public static final JDBCType | ARRAY
Identifies the generic SQL type |
public static final JDBCType | BIGINT
Identifies the generic SQL type |
public static final JDBCType | BINARY
Identifies the generic SQL type |
public static final JDBCType | BIT
Identifies the generic SQL type |
public static final JDBCType | BLOB
Identifies the generic SQL type |
public static final JDBCType | BOOLEAN
Identifies the generic SQL type |
public static final JDBCType | CHAR
Identifies the generic SQL type |
public static final JDBCType | CLOB
Identifies the generic SQL type |
public static final JDBCType | DATALINK
Identifies the generic SQL type |
public static final JDBCType | DATE
Identifies the generic SQL type |
public static final JDBCType | DECIMAL
Identifies the generic SQL type |
public static final JDBCType | DISTINCT
Identifies the generic SQL type |
public static final JDBCType | DOUBLE
Identifies the generic SQL type |
public static final JDBCType | FLOAT
Identifies the generic SQL type |
public static final JDBCType | INTEGER
Identifies the generic SQL type |
public static final JDBCType | JAVA_OBJECT
Indicates that the SQL type is database-specific and gets mapped to a Java object that can be accessed via the methods getObject and setObject. |
public static final JDBCType | LONGNVARCHAR
Identifies the generic SQL type |
public static final JDBCType | LONGVARBINARY
Identifies the generic SQL type |
public static final JDBCType | LONGVARCHAR
Identifies the generic SQL type |
public static final JDBCType | NCHAR
Identifies the generic SQL type |
public static final JDBCType | NCLOB
Identifies the generic SQL type |
public static final JDBCType | NULL
Identifies the generic SQL value |
public static final JDBCType | NUMERIC
Identifies the generic SQL type |
public static final JDBCType | NVARCHAR
Identifies the generic SQL type |
public static final JDBCType | OTHER
Indicates that the SQL type is database-specific and gets mapped to a Java object that can be accessed via the methods getObject and setObject. |
public static final JDBCType | REAL
Identifies the generic SQL type |
public static final JDBCType | REF
Identifies the generic SQL type |
public static final JDBCType | REF_CURSOR
Identifies the generic SQL type |
public static final JDBCType | ROWID
Identifies the SQL type |
public static final JDBCType | SMALLINT
Identifies the generic SQL type |
public static final JDBCType | SQLXML
Identifies the generic SQL type |
public static final JDBCType | STRUCT
Identifies the generic SQL type |
public static final JDBCType | TIME
Identifies the generic SQL type |
public static final JDBCType | TIME_WITH_TIMEZONE
Identifies the generic SQL type |
public static final JDBCType | TIMESTAMP
Identifies the generic SQL type |
public static final JDBCType | TIMESTAMP_WITH_TIMEZONE
Identifies the generic SQL type |
public static final JDBCType | TINYINT
Identifies the generic SQL type |
private final Integer | type
The Integer value for the JDBCType. |
public static final JDBCType | VARBINARY
Identifies the generic SQL type |
public static final JDBCType | VARCHAR
Identifies the generic SQL type |
Access | Constructor and Description |
---|---|
private |
Modifier and Type | Method and Description |
---|---|
public String | Returns: The name of thisSQLType .Implements java. SQLType name that represents a SQL data type.
|
public String | Returns: The name of the vendor for this data type which is java.sql for JDBCType.Implements java. |
public Integer | Returns: An Integer representing the data type. ForJDBCType ,
the value will be the same value as in Types for the data type.Implements java. |
public static JDBCType | |
public static JDBCType | Returns: TheJDBCType constantTypes valueReturns the |
public static JDBCType[] |
ARRAY | back to summary |
---|---|
public static final JDBCType ARRAY Identifies the generic SQL type |
BIGINT | back to summary |
---|---|
public static final JDBCType BIGINT Identifies the generic SQL type |
BINARY | back to summary |
---|---|
public static final JDBCType BINARY Identifies the generic SQL type |
BIT | back to summary |
---|---|
public static final JDBCType BIT Identifies the generic SQL type |
BLOB | back to summary |
---|---|
public static final JDBCType BLOB Identifies the generic SQL type |
BOOLEAN | back to summary |
---|---|
public static final JDBCType BOOLEAN Identifies the generic SQL type |
CHAR | back to summary |
---|---|
public static final JDBCType CHAR Identifies the generic SQL type |
CLOB | back to summary |
---|---|
public static final JDBCType CLOB Identifies the generic SQL type |
DATALINK | back to summary |
---|---|
public static final JDBCType DATALINK Identifies the generic SQL type |
DATE | back to summary |
---|---|
public static final JDBCType DATE Identifies the generic SQL type |
DECIMAL | back to summary |
---|---|
public static final JDBCType DECIMAL Identifies the generic SQL type |
DISTINCT | back to summary |
---|---|
public static final JDBCType DISTINCT Identifies the generic SQL type |
DOUBLE | back to summary |
---|---|
public static final JDBCType DOUBLE Identifies the generic SQL type |
FLOAT | back to summary |
---|---|
public static final JDBCType FLOAT Identifies the generic SQL type |
INTEGER | back to summary |
---|---|
public static final JDBCType INTEGER Identifies the generic SQL type |
JAVA_OBJECT | back to summary |
---|---|
public static final JDBCType JAVA_OBJECT Indicates that the SQL type is database-specific and gets mapped to a Java object that can be accessed via the methods getObject and setObject. |
LONGNVARCHAR | back to summary |
---|---|
public static final JDBCType LONGNVARCHAR Identifies the generic SQL type |
LONGVARBINARY | back to summary |
---|---|
public static final JDBCType LONGVARBINARY Identifies the generic SQL type |
LONGVARCHAR | back to summary |
---|---|
public static final JDBCType LONGVARCHAR Identifies the generic SQL type |
NCHAR | back to summary |
---|---|
public static final JDBCType NCHAR Identifies the generic SQL type |
NCLOB | back to summary |
---|---|
public static final JDBCType NCLOB Identifies the generic SQL type |
NULL | back to summary |
---|---|
public static final JDBCType NULL Identifies the generic SQL value |
NUMERIC | back to summary |
---|---|
public static final JDBCType NUMERIC Identifies the generic SQL type |
NVARCHAR | back to summary |
---|---|
public static final JDBCType NVARCHAR Identifies the generic SQL type |
OTHER | back to summary |
---|---|
public static final JDBCType OTHER Indicates that the SQL type is database-specific and gets mapped to a Java object that can be accessed via the methods getObject and setObject. |
REAL | back to summary |
---|---|
public static final JDBCType REAL Identifies the generic SQL type |
REF | back to summary |
---|---|
public static final JDBCType REF Identifies the generic SQL type |
REF_CURSOR | back to summary |
---|---|
public static final JDBCType REF_CURSOR Identifies the generic SQL type |
ROWID | back to summary |
---|---|
public static final JDBCType ROWID Identifies the SQL type |
SMALLINT | back to summary |
---|---|
public static final JDBCType SMALLINT Identifies the generic SQL type |
SQLXML | back to summary |
---|---|
public static final JDBCType SQLXML Identifies the generic SQL type |
STRUCT | back to summary |
---|---|
public static final JDBCType STRUCT Identifies the generic SQL type |
TIME | back to summary |
---|---|
public static final JDBCType TIME Identifies the generic SQL type |
TIME_WITH_TIMEZONE | back to summary |
---|---|
public static final JDBCType TIME_WITH_TIMEZONE Identifies the generic SQL type |
TIMESTAMP | back to summary |
---|---|
public static final JDBCType TIMESTAMP Identifies the generic SQL type |
TIMESTAMP_WITH_TIMEZONE | back to summary |
---|---|
public static final JDBCType TIMESTAMP_WITH_TIMEZONE Identifies the generic SQL type |
TINYINT | back to summary |
---|---|
public static final JDBCType TINYINT Identifies the generic SQL type |
type | back to summary |
---|---|
private final Integer type The Integer value for the JDBCType. It maps to a value in
|
VARBINARY | back to summary |
---|---|
public static final JDBCType VARBINARY Identifies the generic SQL type |
VARCHAR | back to summary |
---|---|
public static final JDBCType VARCHAR Identifies the generic SQL type |
JDBCType | back to summary |
---|---|
private JDBCType(final Integer type) Constructor to specify the data type value from
|
getName | back to summary |
---|---|
public String getName() Implements java. Doc from java. Returns the
|
getVendor | back to summary |
---|---|
public String getVendor() Implements java. Returns the name of the vendor that supports this data type.
|
getVendorTypeNumber | back to summary |
---|---|
public Integer getVendorTypeNumber() Implements java. Returns the vendor specific type number for the data type.
|
valueOf | back to summary |
---|---|
public static JDBCType valueOf(String name) |
valueOf | back to summary |
---|---|
public static JDBCType valueOf(int type) Returns the
|
values | back to summary |
---|---|
public static JDBCType[] values() |