Package net.datenwerke.gxtdto.client.utils

Class SqlTypes

java.lang.Object
net.datenwerke.gxtdto.client.utils.SqlTypes
Functional Interface:
This is a functional interface and can therefore be used as the assignment target for a lambda expression or method reference.
public class SqlTypes extends Object

  • Field Summary

    Fields
    Modifier and Type
    Field
    Description
    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.
    static final String
    ARRAY_NAME
     
    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.
    static final String
    BIGINT_NAME
     
    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.
    static final int
    BINARY_DOUBLE
    Oracle BINARY_DOUBLE
    static final String
    BINARY_DOUBLE_NAME
     
    static final int
    BINARY_FLOAT
    Oracle BINARY_FLOAT
    static final String
    BINARY_FLOAT_NAME
     
    static final String
    BINARY_NAME
     
    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.
    static final String
    BIT_NAME
     
    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.
    static final String
    BLOB_NAME
     
    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.
    static final String
    BOOLEAN_NAME
     
    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.
    static final String
    CHAR_NAME
     
    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.
    static final String
    CLOB_NAME
     
    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.
    static final String
    DATALINK_NAME
     
    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.
    static final String
    DATE_NAME
     
    static final int
    DATE_TIME_OFFSET
    MSSQL DateTimeOffset
    static final String
    DATE_TIME_OFFSET_NAME
     
    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.
    static final String
    DECIMAL_NAME
     
    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.
    static final String
    DISTINCT_NAME
     
    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.
    static final String
    DOUBLE_NAME
     
    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.
    static final String
    FLOAT_NAME
     
    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.
    static final String
    INTEGER_NAME
     
    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.
    static final String
    JAVA_OBJECT_NAME
     
    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.
    static final String
    LONGNVARCHAR_NAME
     
    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.
    static final String
    LONGVARBINARY_NAME
     
    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.
    static final String
    LONGVARCHAR_NAME
     
    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
    static final String
    NCHAR_NAME
     
    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.
    static final String
    NCLOB_NAME
     
    static final int
    NULL
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NULL.
    static final String
    NULL_NAME
     
    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.
    static final String
    NUMERIC_NAME
     
    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.
    static final String
    NVARCHAR_NAME
     
    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.
    static final String
    OTHER_NAME
     
    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.
    static final String
    REAL_NAME
     
    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.
    static final String
    REF_NAME
     
    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
    static final String
    ROWID_NAME
     
    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.
    static final String
    SMALLINT_NAME
     
    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.
    static final String
    SQLXML_NAME
     
    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.
    static final String
    STRUCT_NAME
     
    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.
    static final String
    TIME_NAME
     
    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.
    static final String
    TIMESTAMP_NAME
     
    static final int
    TIMESTAMPLTZ
    Oracle Timestamp with Local Timezone
    static final String
    TIMESTAMPLTZ_NAME
     
    static final int
    TIMESTAMPTZ
    Oracle Timestamp with Timezone
    static final String
    TIMESTAMPTZ_NAME
     
    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.
    static final String
    TINYINT_NAME
     
    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.
    static final String
    VARBINARY_NAME
     
    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.
    static final String
    VARCHAR_NAME
     

  • Constructor Summary

    Constructors
    Constructor
    Description
    SqlTypes()
     

  • Method Summary

    Modifier and Type
    Method
    Description
    static String
    getName(Integer type)
     
    boolean
    isBinary(Integer type)
     
    static boolean
    isDate(Integer type)
     
    static boolean
    isDateLikeType(Integer type)
     
    boolean
    isFloatingPoint(Integer type)
     
    static boolean
    isInteger(Integer type)
     
    boolean
    isLob(Integer type)
     
    static boolean
    isNumerical(Integer type)
     
    static boolean
    isString(Integer type)
     
    static boolean
    isTime(Integer type)
     
    static boolean
    isTimeStamp(Integer type)
     

    Methods inherited from class java.lang.Object

    equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

  • 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 type BIT.

      See Also:

    • BIT_NAME

      public static final String BIT_NAME
      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 type TINYINT.

      See Also:

    • TINYINT_NAME

      public static final String TINYINT_NAME
      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 type SMALLINT.

      See Also:

    • SMALLINT_NAME

      public static final String SMALLINT_NAME
      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 type INTEGER.

      See Also:

    • INTEGER_NAME

      public static final String INTEGER_NAME
      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 type BIGINT.

      See Also:

    • BIGINT_NAME

      public static final String BIGINT_NAME
      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 type FLOAT.

      See Also:

    • FLOAT_NAME

      public static final String FLOAT_NAME
      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 type REAL.

      See Also:

    • REAL_NAME

      public static final String REAL_NAME
      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 type DOUBLE.

      See Also:

    • DOUBLE_NAME

      public static final String DOUBLE_NAME
      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 type NUMERIC.

      See Also:

    • NUMERIC_NAME

      public static final String NUMERIC_NAME
      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 type DECIMAL.

      See Also:

    • DECIMAL_NAME

      public static final String DECIMAL_NAME
      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 type CHAR.

      See Also:

    • CHAR_NAME

      public static final String CHAR_NAME
      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 type VARCHAR.

      See Also:

    • VARCHAR_NAME

      public static final String VARCHAR_NAME
      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 type LONGVARCHAR.

      See Also:

    • LONGVARCHAR_NAME

      public static final String LONGVARCHAR_NAME
      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 type DATE.

      See Also:

    • DATE_NAME

      public static final String DATE_NAME
      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 type TIME.

      See Also:

    • TIME_NAME

      public static final String TIME_NAME
      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 type TIMESTAMP.

      See Also:

    • TIMESTAMP_NAME

      public static final String TIMESTAMP_NAME
      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 type BINARY.

      See Also:

    • BINARY_NAME

      public static final String BINARY_NAME
      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 type VARBINARY.

      See Also:

    • VARBINARY_NAME

      public static final String VARBINARY_NAME
      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 type LONGVARBINARY.

      See Also:

    • LONGVARBINARY_NAME

      public static final String LONGVARBINARY_NAME
      See Also:

    • NULL

      public static final int NULL

      The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NULL.

      See Also:

    • NULL_NAME

      public static final String NULL_NAME
      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 methods getObject and setObject.
      See Also:

    • OTHER_NAME

      public static final String OTHER_NAME
      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 type JAVA_OBJECT.
      Since:
      1.2
      See Also:

    • JAVA_OBJECT_NAME

      public static final String JAVA_OBJECT_NAME
      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 type DISTINCT.
      Since:
      1.2
      See Also:

    • DISTINCT_NAME

      public static final String DISTINCT_NAME
      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 type STRUCT.
      Since:
      1.2
      See Also:

    • STRUCT_NAME

      public static final String STRUCT_NAME
      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 type ARRAY.
      Since:
      1.2
      See Also:

    • ARRAY_NAME

      public static final String ARRAY_NAME
      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 type BLOB.
      Since:
      1.2
      See Also:

    • BLOB_NAME

      public static final String BLOB_NAME
      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 type CLOB.
      Since:
      1.2
      See Also:

    • CLOB_NAME

      public static final String CLOB_NAME
      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 type REF.
      Since:
      1.2
      See Also:

    • REF_NAME

      public static final String REF_NAME
      See Also:

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

    • BOOLEAN_NAME

      public static final String BOOLEAN_NAME
      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 type ROWID
      Since:
      1.6
      See Also:

    • ROWID_NAME

      public static final String ROWID_NAME
      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 type NCHAR
      Since:
      1.6
      See Also:

    • NCHAR_NAME

      public static final String NCHAR_NAME
      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 type NVARCHAR.
      Since:
      1.6
      See Also:

    • NVARCHAR_NAME

      public static final String NVARCHAR_NAME
      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 type LONGNVARCHAR.
      Since:
      1.6
      See Also:

    • LONGNVARCHAR_NAME

      public static final String LONGNVARCHAR_NAME
      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 type NCLOB.
      Since:
      1.6
      See Also:

    • NCLOB_NAME

      public static final String NCLOB_NAME
      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 type XML.
      Since:
      1.6
      See Also:

    • SQLXML_NAME

      public static final String SQLXML_NAME
      See Also:

    • TIMESTAMPTZ

      public static final int TIMESTAMPTZ
      Oracle Timestamp with Timezone
      See Also:

    • TIMESTAMPTZ_NAME

      public static final String TIMESTAMPTZ_NAME
      See Also:

    • TIMESTAMPLTZ

      public static final int TIMESTAMPLTZ
      Oracle Timestamp with Local Timezone
      See Also:

    • TIMESTAMPLTZ_NAME

      public static final String TIMESTAMPLTZ_NAME
      See Also:

    • BINARY_DOUBLE

      public static final int BINARY_DOUBLE
      Oracle BINARY_DOUBLE
      See Also:

    • BINARY_DOUBLE_NAME

      public static final String BINARY_DOUBLE_NAME
      See Also:

    • BINARY_FLOAT

      public static final int BINARY_FLOAT
      Oracle BINARY_FLOAT
      See Also:

    • BINARY_FLOAT_NAME

      public static final String BINARY_FLOAT_NAME
      See Also:

    • DATE_TIME_OFFSET

      public static final int DATE_TIME_OFFSET
      MSSQL DateTimeOffset
      See Also:

    • DATE_TIME_OFFSET_NAME

      public static final String DATE_TIME_OFFSET_NAME
      See Also:

  • Constructor Details

    • SqlTypes

      public SqlTypes()

  • Method Details

    • getName

      public static String getName(Integer type)

    • isString

      public static boolean isString(Integer type)

    • isNumerical

      public static boolean isNumerical(Integer type)

    • isInteger

      public static boolean isInteger(Integer type)

    • isDateLikeType

      public static boolean isDateLikeType(Integer type)

    • isTimeStamp

      public static boolean isTimeStamp(Integer type)

    • isTime

      public static boolean isTime(Integer type)

    • isDate

      public static boolean isDate(Integer type)

    • isFloatingPoint

      public boolean isFloatingPoint(Integer type)

    • isLob

      public boolean isLob(Integer type)

    • isBinary

      public boolean isBinary(Integer type)