Module java.sql
Package java.sql

Class Types

java.lang.Object
java.sql.Types

public classTypesextendsObject

The class that defines the constants that are used to identify generic SQL types, called JDBC types.

This class is never instantiated.

Since:
1.1
  • Field Summary

    Fields
    Modifier and Type
    Field
    Description
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeARRAY.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeBIGINT.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeBINARY.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeBIT.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeBLOB.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeBOOLEAN.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeCHAR.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeCLOB.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeDATALINK.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeDATE.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeDECIMAL.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeDISTINCT.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeDOUBLE.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeFLOAT.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeINTEGER.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeJAVA_OBJECT.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeLONGNVARCHAR.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeLONGVARBINARY.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeLONGVARCHAR.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeNCHAR
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeNCLOB.
    static final int
    The constant in the Java programming language that identifies the generic SQL valueNULL.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeNUMERIC.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeNVARCHAR.
    static final int
    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 methodsgetObject andsetObject.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeREAL.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeREF.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeREF CURSOR.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeROWID
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeSMALLINT.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeXML.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeSTRUCT.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeTIME.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeTIME WITH TIMEZONE.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeTIMESTAMP.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeTIMESTAMP WITH TIMEZONE.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeTINYINT.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeVARBINARY.
    static final int
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeVARCHAR.
  • Method Summary

  • Field Details

    • 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 typeBIT.

      See Also:
    • 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 typeTINYINT.

      See Also:
    • 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 typeSMALLINT.

      See Also:
    • 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 typeINTEGER.

      See Also:
    • 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 typeBIGINT.

      See Also:
    • 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 typeFLOAT.

      See Also:
    • 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 typeREAL.

      See Also:
    • 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 typeDOUBLE.

      See Also:
    • 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 typeNUMERIC.

      See Also:
    • 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 typeDECIMAL.

      See Also:
    • 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 typeCHAR.

      See Also:
    • 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 typeVARCHAR.

      See Also:
    • 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 typeLONGVARCHAR.

      See Also:
    • 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 typeDATE.

      See Also:
    • 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 typeTIME.

      See Also:
    • 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 typeTIMESTAMP.

      See Also:
    • 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 typeBINARY.

      See Also:
    • 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 typeVARBINARY.

      See Also:
    • 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 typeLONGVARBINARY.

      See Also:
    • NULL

      public static final int NULL

      The constant in the Java programming language that identifies the generic SQL valueNULL.

      See Also:
    • 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 methodsgetObject andsetObject.
      See Also:
    • 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 typeJAVA_OBJECT.
      Since:
      1.2
      See Also:
    • 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 typeDISTINCT.
      Since:
      1.2
      See Also:
    • 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 typeSTRUCT.
      Since:
      1.2
      See Also:
    • 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 typeARRAY.
      Since:
      1.2
      See Also:
    • 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 typeBLOB.
      Since:
      1.2
      See Also:
    • 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 typeCLOB.
      Since:
      1.2
      See Also:
    • 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 typeREF.
      Since:
      1.2
      See Also:
    • DATALINK

      public static final int DATALINK
      The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeDATALINK.
      Since:
      1.4
      See Also:
    • BOOLEAN

      public static final int BOOLEAN
      The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeBOOLEAN.
      Since:
      1.4
      See Also:
    • 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 typeROWID
      Since:
      1.6
      See Also:
    • 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 typeNCHAR
      Since:
      1.6
      See Also:
    • 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 typeNVARCHAR.
      Since:
      1.6
      See Also:
    • 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 typeLONGNVARCHAR.
      Since:
      1.6
      See Also:
    • 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 typeNCLOB.
      Since:
      1.6
      See Also:
    • 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 typeXML.
      Since:
      1.6
      See Also:
    • REF_CURSOR

      public static final int REF_CURSOR
      The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeREF CURSOR.
      Since:
      1.8
      See Also:
    • TIME_WITH_TIMEZONE

      public static final int TIME_WITH_TIMEZONE
      The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeTIME WITH TIMEZONE.
      Since:
      1.8
      See Also:
    • TIMESTAMP_WITH_TIMEZONE

      public static final int TIMESTAMP_WITH_TIMEZONE
      The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL typeTIMESTAMP WITH TIMEZONE.
      Since:
      1.8
      See Also: