Types
public
class
Types
extends Object
java.lang.Object | |
↳ | java.sql.Types |
The class that defines the constants that are used to identify generic SQL types, called JDBC types.
This class is never instantiated.
Summary
Constants | |
---|---|
int |
ARRAY
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type
|
int |
BIGINT
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
|
int |
BINARY
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
|
int |
BIT
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
|
int |
BLOB
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type
|
int |
BOOLEAN
The constant in the Java programming language, somtimes referred to
as a type code, that identifies the generic SQL type |
int |
CHAR
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
|
int |
CLOB
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type
|
int |
DATALINK
The constant in the Java programming language, somtimes referred to
as a type code, that identifies the generic SQL type |
int |
DATE
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
|
int |
DECIMAL
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
|
int |
DISTINCT
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type
|
int |
DOUBLE
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
|
int |
FLOAT
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
|
int |
INTEGER
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
|
int |
JAVA_OBJECT
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type
|
int |
LONGNVARCHAR
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type |
int |
LONGVARBINARY
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
|
int |
LONGVARCHAR
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
|
int |
NCHAR
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type |
int |
NCLOB
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type |
int |
NULL
The constant in the Java programming language
that identifies the generic SQL value
|
int |
NUMERIC
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
|
int |
NVARCHAR
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type |
int |
OTHER
The constant in the Java programming language that indicates
that the SQL type is database-specific and
gets mapped to a Java object that can be accessed via
the methods |
int |
REAL
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
|
int |
REF
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type
|
int |
ROWID
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type |
int |
SMALLINT
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
|
int |
SQLXML
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type |
int |
STRUCT
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type
|
int |
TIME
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
|
int |
TIMESTAMP
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
|
int |
TINYINT
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
|
int |
VARBINARY
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
|
int |
VARCHAR
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
|
Inherited methods | |
---|---|
Constants
ARRAY
public static final int ARRAY
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type
ARRAY
.
Constant Value: 2003 (0x000007d3)
BIGINT
public static final int BIGINT
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
BIGINT
.
Constant Value: -5 (0xfffffffb)
BINARY
public static final int BINARY
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
BINARY
.
Constant Value: -2 (0xfffffffe)
BIT
public static final int BIT
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
BIT
.
Constant Value: -7 (0xfffffff9)
BLOB
public static final int BLOB
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type
BLOB
.
Constant Value: 2004 (0x000007d4)
BOOLEAN
public static final int BOOLEAN
The constant in the Java programming language, somtimes referred to
as a type code, that identifies the generic SQL type BOOLEAN
.
Constant Value: 16 (0x00000010)
CHAR
public static final int CHAR
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
CHAR
.
Constant Value: 1 (0x00000001)
CLOB
public static final int CLOB
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type
CLOB
.
Constant Value: 2005 (0x000007d5)
DATALINK
public static final int DATALINK
The constant in the Java programming language, somtimes referred to
as a type code, that identifies the generic SQL type DATALINK
.
Constant Value: 70 (0x00000046)
DATE
public static final int DATE
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
DATE
.
Constant Value: 91 (0x0000005b)
DECIMAL
public static final int DECIMAL
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
DECIMAL
.
Constant Value: 3 (0x00000003)
DISTINCT
public static final int DISTINCT
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type
DISTINCT
.
Constant Value: 2001 (0x000007d1)
DOUBLE
public static final int DOUBLE
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
DOUBLE
.
Constant Value: 8 (0x00000008)
FLOAT
public static final int FLOAT
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
FLOAT
.
Constant Value: 6 (0x00000006)
INTEGER
public static final int INTEGER
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
INTEGER
.
Constant Value: 4 (0x00000004)
JAVA_OBJECT
public static final int JAVA_OBJECT
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type
JAVA_OBJECT
.
Constant Value: 2000 (0x000007d0)
LONGNVARCHAR
public static final int LONGNVARCHAR
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type LONGNVARCHAR
.
Constant Value: -16 (0xfffffff0)
LONGVARBINARY
public static final int LONGVARBINARY
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
LONGVARBINARY
.
Constant Value: -4 (0xfffffffc)
LONGVARCHAR
public static final int LONGVARCHAR
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
LONGVARCHAR
.
Constant Value: -1 (0xffffffff)
NCHAR
public static final int NCHAR
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type NCHAR
Constant Value: -15 (0xfffffff1)
NCLOB
public static final int NCLOB
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type NCLOB
.
Constant Value: 2011 (0x000007db)
NULL
public static final int NULL
The constant in the Java programming language
that identifies the generic SQL value
NULL
.
Constant Value: 0 (0x00000000)
NUMERIC
public static final int NUMERIC
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
NUMERIC
.
Constant Value: 2 (0x00000002)
NVARCHAR
public static final int NVARCHAR
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type NVARCHAR
.
Constant Value: -9 (0xfffffff7)
OTHER
public static final int OTHER
The constant in the Java programming language that 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
.
Constant Value: 1111 (0x00000457)
REAL
public static final int REAL
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
REAL
.
Constant Value: 7 (0x00000007)
REF
public static final int REF
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type
REF
.
Constant Value: 2006 (0x000007d6)
ROWID
public static final int ROWID
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type ROWID
Constant Value: -8 (0xfffffff8)
SMALLINT
public static final int SMALLINT
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
SMALLINT
.
Constant Value: 5 (0x00000005)
SQLXML
public static final int SQLXML
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type XML
.
Constant Value: 2009 (0x000007d9)
STRUCT
public static final int STRUCT
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type
STRUCT
.
Constant Value: 2002 (0x000007d2)
TIME
public static final int TIME
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
TIME
.
Constant Value: 92 (0x0000005c)
TIMESTAMP
public static final int TIMESTAMP
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
TIMESTAMP
.
Constant Value: 93 (0x0000005d)
TINYINT
public static final int TINYINT
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
TINYINT
.
Constant Value: -6 (0xfffffffa)
VARBINARY
public static final int VARBINARY
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
VARBINARY
.
Constant Value: -3 (0xfffffffd)
VARCHAR
public static final int VARCHAR
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
VARCHAR
.
Constant Value: 12 (0x0000000c)