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)