Enum CmdParamsDbType

  • All Implemented Interfaces:
    java.io.Serializable, java.lang.Comparable<CmdParamsDbType>

    public enum CmdParamsDbType
    extends java.lang.Enum<CmdParamsDbType>
    Specifies the type of command parameters.
    • Enum Constant Summary

      Enum Constants 
      Enum Constant Description
      AnsiString
      An extension of the ASCII character set in that it includes all the ASCII characters with an additional 128 character codes
      AnsiStringFixedLength
      fixed-length stream of non-Unicode characters.
      Binary
      A fixed-length stream of binary data ranging between 1 and 8,000 bytes.
      Boolean
      2 logical values, true and false
      Byte
      Allows whole numbers from 0 to 255
      Currency
      Use for currency.
      Date
      Date data ranging in value from January 1,1 AD through December 31, 9999 AD.
      DateTime
      Date and time data ranging in value from January 1, 1753 to December 31, 9999 to an accuracy of 3.33 milliseconds.
      DateTime2
      From January 1, 0001 to December 31, 9999 with an accuracy of 100 nanoseconds
      DateTimeOffset
      Date and time data with time zone awareness.
      Decimal
      A fixed precision and scale numeric value between -10 to -1 and 10 to -1.
      Double
      Double precision floating-point.
      Guid
      Stores a globally unique identifier.
      Int16
      A 16-bit signed integer.
      Int32
      A 32-bit signed integer.
      Int64
      A 64-bit signed integer.
      Object
      Can store pictures, audio, video, or other BLOBs (Binary Large OBjects)
      SByte
      Signed integer
      Single
      Single precision floating-point.
      String
      Used for string datatypes
      StringFixedLength
      A fixed-length string of Unicode characters.
      Time
      Time data based on a 24-hour clock.
      UInt16
      A 32-bit un-signed integer.
      UInt32
      A 32-bit un-signed integer.
      UInt64
      A 64-bit un-signed integer.
      VarNumeric
      A variable-length numeric value.
      Xml
      A SQL Server 2005 user-defined type (UDT).
    • Method Summary

      All Methods Static Methods Concrete Methods 
      Modifier and Type Method Description
      static CmdParamsDbType getCmdParamsDbType​(int value)
      retreives the enum constant of the specified value, if exists.
      static CmdParamsDbType valueOf​(java.lang.String name)
      Returns the enum constant of this type with the specified name.
      static CmdParamsDbType[] values()
      Returns an array containing the constants of this enum type, in the order they are declared.
      • Methods inherited from class java.lang.Enum

        clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf
      • Methods inherited from class java.lang.Object

        getClass, notify, notifyAll, wait, wait, wait
    • Enum Constant Detail

      • AnsiString

        public static final CmdParamsDbType AnsiString
        An extension of the ASCII character set in that it includes all the ASCII characters with an additional 128 character codes
      • Binary

        public static final CmdParamsDbType Binary
        A fixed-length stream of binary data ranging between 1 and 8,000 bytes.
      • Byte

        public static final CmdParamsDbType Byte
        Allows whole numbers from 0 to 255
      • Boolean

        public static final CmdParamsDbType Boolean
        2 logical values, true and false
      • Currency

        public static final CmdParamsDbType Currency
        Use for currency. Holds up to 15 digits of whole dollars, plus 4 decimal places. Tip: You can choose which country's currency to use
      • Date

        public static final CmdParamsDbType Date
        Date data ranging in value from January 1,1 AD through December 31, 9999 AD.
      • DateTime

        public static final CmdParamsDbType DateTime
        Date and time data ranging in value from January 1, 1753 to December 31, 9999 to an accuracy of 3.33 milliseconds.
      • Decimal

        public static final CmdParamsDbType Decimal
        A fixed precision and scale numeric value between -10 to -1 and 10 to -1.
      • Double

        public static final CmdParamsDbType Double
        Double precision floating-point. Will handle most decimals.
      • Guid

        public static final CmdParamsDbType Guid
        Stores a globally unique identifier.
      • Int16

        public static final CmdParamsDbType Int16
        A 16-bit signed integer.
      • Int32

        public static final CmdParamsDbType Int32
        A 32-bit signed integer. Allows whole numbers from -2,147,483,648 to 2,147,483,647
      • Int64

        public static final CmdParamsDbType Int64
        A 64-bit signed integer. Allows whole numbers from -2,147,483,648 to 2,147,483,647
      • Object

        public static final CmdParamsDbType Object
        Can store pictures, audio, video, or other BLOBs (Binary Large OBjects)
      • Single

        public static final CmdParamsDbType Single
        Single precision floating-point. Will handle most decimals Allows whole numbers from -128 to 127
      • String

        public static final CmdParamsDbType String
        Used for string datatypes
      • Time

        public static final CmdParamsDbType Time
        Time data based on a 24-hour clock. Time value range is 00:00:00 through 23:59:59.9999999 with an accuracy of 100 nanoseconds.
      • UInt16

        public static final CmdParamsDbType UInt16
        A 32-bit un-signed integer. Allows whole numbers from 0 to 65535
      • UInt32

        public static final CmdParamsDbType UInt32
        A 32-bit un-signed integer. Allows whole numbers from 0 to 4294967295
      • UInt64

        public static final CmdParamsDbType UInt64
        A 64-bit un-signed integer. Allows whole numbers from 0 to 18446744073709551615
      • VarNumeric

        public static final CmdParamsDbType VarNumeric
        A variable-length numeric value.
      • AnsiStringFixedLength

        public static final CmdParamsDbType AnsiStringFixedLength
        fixed-length stream of non-Unicode characters.
      • StringFixedLength

        public static final CmdParamsDbType StringFixedLength
        A fixed-length string of Unicode characters.
      • Xml

        public static final CmdParamsDbType Xml
        A SQL Server 2005 user-defined type (UDT). Stores XML formatted data. Maximum 2GB
      • DateTime2

        public static final CmdParamsDbType DateTime2
        From January 1, 0001 to December 31, 9999 with an accuracy of 100 nanoseconds
      • DateTimeOffset

        public static final CmdParamsDbType DateTimeOffset
        Date and time data with time zone awareness. Date value range is from January 1,1 AD through December 31, 9999 AD. Time value range is 00:00:00 through 23:59:59.9999999 with an accuracy of 100 nanoseconds. Time zone value range is -14:00 through +14:00.
    • Method Detail

      • values

        public static CmdParamsDbType[] values()
        Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:
        for (CmdParamsDbType c : CmdParamsDbType.values())
            System.out.println(c);
        
        Returns:
        an array containing the constants of this enum type, in the order they are declared
      • valueOf

        public static CmdParamsDbType valueOf​(java.lang.String name)
        Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)
        Parameters:
        name - the name of the enum constant to be returned.
        Returns:
        the enum constant with the specified name
        Throws:
        java.lang.IllegalArgumentException - if this enum type has no constant with the specified name
        java.lang.NullPointerException - if the argument is null
      • getCmdParamsDbType

        public static CmdParamsDbType getCmdParamsDbType​(int value)
                                                  throws java.lang.IllegalArgumentException
        retreives the enum constant of the specified value, if exists.
        Parameters:
        value - enum constant index
        Returns:
        enum constant
        Throws:
        java.lang.IllegalArgumentException