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)