public class

Types

extends Object
java.lang.Object
   ↳ java.sql.Types

Class Overview

A class which defines constants used to identify generic SQL types, also called JDBC types. The type constant values are equivalent to those defined by X/OPEN.

Summary

Constants
int ARRAY The type code that identifies the SQL type ARRAY.
int BIGINT The type code that identifies the SQL type BIGINT.
int BINARY The type code that identifies the SQL type BINARY.
int BIT The type code that identifies the SQL type BIT.
int BLOB The type code that identifies the SQL type BLOB.
int BOOLEAN The type code that identifies the SQL type BOOLEAN.
int CHAR The type code that identifies the SQL type CHAR.
int CLOB The type code that identifies the SQL type CLOB.
int DATALINK The type code that identifies the SQL type DATALINK.
int DATE The type code that identifies the SQL type DATE.
int DECIMAL The type code that identifies the SQL type DECIMAL.
int DISTINCT The type code that identifies the SQL type DISTINCT.
int DOUBLE The type code that identifies the SQL type DOUBLE.
int FLOAT The type code that identifies the SQL type FLOAT.
int INTEGER The type code that identifies the SQL type INTEGER.
int JAVA_OBJECT The type code that identifies the SQL type JAVA_OBJECT.
int LONGVARBINARY The type code that identifies the SQL type LONGVARBINARY.
int LONGVARCHAR The type code that identifies the SQL type LONGVARCHAR.
int NULL The type code that identifies the SQL type NULL.
int NUMERIC The type code that identifies the SQL type NUMERIC.
int OTHER The type code that identifies that the SQL type is database specific and is mapped to a Java object, accessed via the methods getObject and setObject.
int REAL The type code that identifies the SQL type REAL.
int REF The type code that identifies the SQL type REF.
int SMALLINT The type code that identifies the SQL type SMALLINT.
int STRUCT The type code that identifies the SQL type STRUCT.
int TIME The type code that identifies the SQL type TIME.
int TIMESTAMP The type code that identifies the SQL type TIMESTAMP.
int TINYINT The type code that identifies the SQL type TINYINT.
int VARBINARY The type code that identifies the SQL type VARBINARY.
int VARCHAR The type code that identifies the SQL type VARCHAR.
[Expand]
Inherited Methods
From class java.lang.Object

Constants

public static final int ARRAY

The type code that identifies the SQL type ARRAY.

Constant Value: 2003 (0x000007d3)

public static final int BIGINT

The type code that identifies the SQL type BIGINT.

Constant Value: -5 (0xfffffffb)

public static final int BINARY

The type code that identifies the SQL type BINARY.

Constant Value: -2 (0xfffffffe)

public static final int BIT

The type code that identifies the SQL type BIT.

Constant Value: -7 (0xfffffff9)

public static final int BLOB

The type code that identifies the SQL type BLOB.

Constant Value: 2004 (0x000007d4)

public static final int BOOLEAN

The type code that identifies the SQL type BOOLEAN.

Constant Value: 16 (0x00000010)

public static final int CHAR

The type code that identifies the SQL type CHAR.

Constant Value: 1 (0x00000001)

public static final int CLOB

The type code that identifies the SQL type CLOB.

Constant Value: 2005 (0x000007d5)

public static final int DATALINK

The type code that identifies the SQL type DATALINK.

Constant Value: 70 (0x00000046)

public static final int DATE

The type code that identifies the SQL type DATE.

Constant Value: 91 (0x0000005b)

public static final int DECIMAL

The type code that identifies the SQL type DECIMAL.

Constant Value: 3 (0x00000003)

public static final int DISTINCT

The type code that identifies the SQL type DISTINCT.

Constant Value: 2001 (0x000007d1)

public static final int DOUBLE

The type code that identifies the SQL type DOUBLE.

Constant Value: 8 (0x00000008)

public static final int FLOAT

The type code that identifies the SQL type FLOAT.

Constant Value: 6 (0x00000006)

public static final int INTEGER

The type code that identifies the SQL type INTEGER.

Constant Value: 4 (0x00000004)

public static final int JAVA_OBJECT

The type code that identifies the SQL type JAVA_OBJECT.

Constant Value: 2000 (0x000007d0)

public static final int LONGVARBINARY

The type code that identifies the SQL type LONGVARBINARY.

Constant Value: -4 (0xfffffffc)

public static final int LONGVARCHAR

The type code that identifies the SQL type LONGVARCHAR.

Constant Value: -1 (0xffffffff)

public static final int NULL

The type code that identifies the SQL type NULL.

Constant Value: 0 (0x00000000)

public static final int NUMERIC

The type code that identifies the SQL type NUMERIC.

Constant Value: 2 (0x00000002)

public static final int OTHER

The type code that identifies that the SQL type is database specific and is mapped to a Java object, accessed via the methods getObject and setObject.

Constant Value: 1111 (0x00000457)

public static final int REAL

The type code that identifies the SQL type REAL.

Constant Value: 7 (0x00000007)

public static final int REF

The type code that identifies the SQL type REF.

Constant Value: 2006 (0x000007d6)

public static final int SMALLINT

The type code that identifies the SQL type SMALLINT.

Constant Value: 5 (0x00000005)

public static final int STRUCT

The type code that identifies the SQL type STRUCT.

Constant Value: 2002 (0x000007d2)

public static final int TIME

The type code that identifies the SQL type TIME.

Constant Value: 92 (0x0000005c)

public static final int TIMESTAMP

The type code that identifies the SQL type TIMESTAMP.

Constant Value: 93 (0x0000005d)

public static final int TINYINT

The type code that identifies the SQL type TINYINT.

Constant Value: -6 (0xfffffffa)

public static final int VARBINARY

The type code that identifies the SQL type VARBINARY.

Constant Value: -3 (0xfffffffd)

public static final int VARCHAR

The type code that identifies the SQL type VARCHAR.

Constant Value: 12 (0x0000000c)