Enum JDBCType
- java.lang.Object
-
- java.lang.Enum<JDBCType>
-
- java.sql.JDBCType
- All Implemented Interfaces:
-
Serializable
,Comparable<JDBCType>
,SQLType
public enum JDBCType extends Enum<JDBCType> implements SQLType
Defines the constants that are used to identify generic SQL types, called JDBC types.
- Since:
- 1.8
- See Also:
SQLType
Enum Constant Summary
Enum Constant | Description |
---|---|
ARRAY | Identifies the generic SQL type |
BIGINT | Identifies the generic SQL type |
BINARY | Identifies the generic SQL type |
BIT | Identifies the generic SQL type |
BLOB | Identifies the generic SQL type |
BOOLEAN | Identifies the generic SQL type |
CHAR | Identifies the generic SQL type |
CLOB | Identifies the generic SQL type |
DATALINK | Identifies the generic SQL type |
DATE | Identifies the generic SQL type |
DECIMAL | Identifies the generic SQL type |
DISTINCT | Identifies the generic SQL type |
DOUBLE | Identifies the generic SQL type |
FLOAT | Identifies the generic SQL type |
INTEGER | Identifies the generic SQL type |
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 | Identifies the generic SQL type |
LONGVARBINARY | Identifies the generic SQL type |
LONGVARCHAR | Identifies the generic SQL type |
NCHAR | Identifies the generic SQL type |
NCLOB | Identifies the generic SQL type |
NULL | Identifies the generic SQL value |
NUMERIC | Identifies the generic SQL type |
NVARCHAR | Identifies the generic SQL type |
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 | Identifies the generic SQL type |
REF | Identifies the generic SQL type |
REF_CURSOR | Identifies the generic SQL type |
ROWID | Identifies the SQL type |
SMALLINT | Identifies the generic SQL type |
SQLXML | Identifies the generic SQL type |
STRUCT | Identifies the generic SQL type |
TIME | Identifies the generic SQL type |
TIME_WITH_TIMEZONE | Identifies the generic SQL type |
TIMESTAMP | Identifies the generic SQL type |
TIMESTAMP_WITH_TIMEZONE | Identifies the generic SQL type |
TINYINT | Identifies the generic SQL type |
VARBINARY | Identifies the generic SQL type |
VARCHAR | Identifies the generic SQL type |
Method Summary
Modifier and Type | Method | Description |
---|---|---|
String | getName() | Returns the |
String | getVendor() | Returns the name of the vendor that supports this data type. |
Integer | getVendorTypeNumber() | Returns the vendor specific type number for the data type. |
static JDBCType | valueOf(int type) | Returns the |
static JDBCType | valueOf(String name) | Returns the enum constant of this type with the specified name. |
static JDBCType[] | values() | Returns an array containing the constants of this enum type, in the order they are declared. |
Methods declared in class java.lang.Enum
clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf
Methods declared in class java.lang.Object
getClass, notify, notifyAll, wait, wait, wait
Enum Constant Detail
BIT
public static final JDBCType BIT
Identifies the generic SQL type BIT
.
TINYINT
public static final JDBCType TINYINT
Identifies the generic SQL type TINYINT
.
SMALLINT
public static final JDBCType SMALLINT
Identifies the generic SQL type SMALLINT
.
INTEGER
public static final JDBCType INTEGER
Identifies the generic SQL type INTEGER
.
BIGINT
public static final JDBCType BIGINT
Identifies the generic SQL type BIGINT
.
FLOAT
public static final JDBCType FLOAT
Identifies the generic SQL type FLOAT
.
REAL
public static final JDBCType REAL
Identifies the generic SQL type REAL
.
DOUBLE
public static final JDBCType DOUBLE
Identifies the generic SQL type DOUBLE
.
NUMERIC
public static final JDBCType NUMERIC
Identifies the generic SQL type NUMERIC
.
DECIMAL
public static final JDBCType DECIMAL
Identifies the generic SQL type DECIMAL
.
CHAR
public static final JDBCType CHAR
Identifies the generic SQL type CHAR
.
VARCHAR
public static final JDBCType VARCHAR
Identifies the generic SQL type VARCHAR
.
LONGVARCHAR
public static final JDBCType LONGVARCHAR
Identifies the generic SQL type LONGVARCHAR
.
DATE
public static final JDBCType DATE
Identifies the generic SQL type DATE
.
TIME
public static final JDBCType TIME
Identifies the generic SQL type TIME
.
TIMESTAMP
public static final JDBCType TIMESTAMP
Identifies the generic SQL type TIMESTAMP
.
BINARY
public static final JDBCType BINARY
Identifies the generic SQL type BINARY
.
VARBINARY
public static final JDBCType VARBINARY
Identifies the generic SQL type VARBINARY
.
LONGVARBINARY
public static final JDBCType LONGVARBINARY
Identifies the generic SQL type LONGVARBINARY
.
NULL
public static final JDBCType NULL
Identifies the generic SQL value NULL
.
OTHER
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.
JAVA_OBJECT
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.
DISTINCT
public static final JDBCType DISTINCT
Identifies the generic SQL type DISTINCT
.
STRUCT
public static final JDBCType STRUCT
Identifies the generic SQL type STRUCT
.
ARRAY
public static final JDBCType ARRAY
Identifies the generic SQL type ARRAY
.
BLOB
public static final JDBCType BLOB
Identifies the generic SQL type BLOB
.
CLOB
public static final JDBCType CLOB
Identifies the generic SQL type CLOB
.
REF
public static final JDBCType REF
Identifies the generic SQL type REF
.
DATALINK
public static final JDBCType DATALINK
Identifies the generic SQL type DATALINK
.
BOOLEAN
public static final JDBCType BOOLEAN
Identifies the generic SQL type BOOLEAN
.
ROWID
public static final JDBCType ROWID
Identifies the SQL type ROWID
.
NCHAR
public static final JDBCType NCHAR
Identifies the generic SQL type NCHAR
.
NVARCHAR
public static final JDBCType NVARCHAR
Identifies the generic SQL type NVARCHAR
.
LONGNVARCHAR
public static final JDBCType LONGNVARCHAR
Identifies the generic SQL type LONGNVARCHAR
.
NCLOB
public static final JDBCType NCLOB
Identifies the generic SQL type NCLOB
.
SQLXML
public static final JDBCType SQLXML
Identifies the generic SQL type SQLXML
.
REF_CURSOR
public static final JDBCType REF_CURSOR
Identifies the generic SQL type REF_CURSOR
.
TIME_WITH_TIMEZONE
public static final JDBCType TIME_WITH_TIMEZONE
Identifies the generic SQL type TIME_WITH_TIMEZONE
.
TIMESTAMP_WITH_TIMEZONE
public static final JDBCType TIMESTAMP_WITH_TIMEZONE
Identifies the generic SQL type TIMESTAMP_WITH_TIMEZONE
.
Method Detail
values
public static JDBCType[] values()
Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:
for (JDBCType c : JDBCType.values()) System.out.println(c);
- Returns:
- an array containing the constants of this enum type, in the order they are declared
valueOf
public static JDBCType valueOf(String name)
Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)
- Parameters:
-
name
- the name of the enum constant to be returned. - Returns:
- the enum constant with the specified name
- Throws:
-
IllegalArgumentException
- if this enum type has no constant with the specified name -
NullPointerException
- if the argument is null
getName
public String getName()
Returns the SQLType
name that represents a SQL data type.
getVendor
public String getVendor()
Returns the name of the vendor that supports this data type.
- Specified by:
-
getVendor
in interfaceSQLType
- Returns:
- The name of the vendor for this data type which is java.sql for JDBCType.
getVendorTypeNumber
public Integer getVendorTypeNumber()
Returns the vendor specific type number for the data type.
- Specified by:
-
getVendorTypeNumber
in interfaceSQLType
- Returns:
- An Integer representing the data type. For
JDBCType
, the value will be the same value as inTypes
for the data type.
valueOf
public static JDBCType valueOf(int type)
Returns the JDBCType
that corresponds to the specified Types
value
- Parameters:
-
type
-Types
value - Returns:
- The
JDBCType
constant - Throws:
-
IllegalArgumentException
- if this enum type has no constant with the specifiedTypes
value - See Also:
Types