Enum CmdParamsType

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

    public enum CmdParamsType
    extends java.lang.Enum<CmdParamsType>
    Describes the type of the parameters passed to the command.
    • Enum Constant Summary

      Enum Constants 
      Enum Constant Description
      BigInt
      A 64-bit signed integer.
      Binary
      A fixed-length stream of binary data ranging between 1 and 8,000 bytes.
      Bit
      An unsigned numeric value that can be 0, 1, or null.
      Char
      A fixed-length stream of non-Unicode characters ranging between 1 and 8,000 characters.
      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
      Date and time data.
      DateTimeOffset
      Date and time data with time zone awareness.
      Decimal
      A fixed precision and scale numeric value between -10 38 -1 and 10 38 -1.
      Float
      A floating point number within the range of -1.79E +308 through 1.79E +308.
      Int
      A 32-bit signed integer.
      Money
      A currency value ranging from -2 63 (or -9,223,372,036,854,775,808) to 2 63 -1 (or +9,223,372,036,854,775,807) with an accuracy to a ten-thousandth of a currency unit.
      NChar
      A fixed-length stream of Unicode characters ranging between 1 and 4,000 characters.
      NVarChar
      A variable-length stream of Unicode characters ranging between 1 and 4,000 characters.
      Real
      A floating point number within the range of -3.40E +38 through 3.40E +38.
      SmallDateTime
      Date and time data ranging in value from January 1, 1900 to June 6, 2079 to an accuracy of one minute.
      SmallInt
      A 16-bit signed integer.
      SmallMoney
      A currency value ranging from -214,748.3648 to +214,748.3647 with an accuracy to a ten-thousandth of a currency unit.
      Structured
      A special data type for specifying structured data contained in table-valued parameters.
      Time
      Time data based on a 24-hour clock.
      Timestamp
      Automatically generated binary numbers, which are guaranteed to be unique within a database.
      TinyInt
      An 8-bit unsigned integer.
      Udt
      A SQL Server user-defined type (UDT).
      UniqueIdentifier
      A globally unique identifier (or GUID).
      VarBinary
      A variable-length stream of binary data ranging between 1 and 8,000 bytes.
      VarChar
      A variable-length stream of non-Unicode characters ranging between 1 and 8,000 characters.
      Variant
      A special data type that can contain numeric, string, binary, or date data as well as the SQL Server values Empty and Null, which is assumed if no other type is declared.
      Xml
      An XML value.
    • Method Summary

      All Methods Static Methods Instance Methods Concrete Methods 
      Modifier and Type Method Description
      static CmdParamsType forValue​(int value)
      retreives the enum constant of the specified value, if exists.
      int getValue()
      Order is important in enums.By using getValue() method, each enum constant index can be found, just like array index.
      static CmdParamsType valueOf​(java.lang.String name)
      Returns the enum constant of this type with the specified name.
      static CmdParamsType[] 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

      • BigInt

        public static final CmdParamsType BigInt
        A 64-bit signed integer.
      • Binary

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

        public static final CmdParamsType Bit
        An unsigned numeric value that can be 0, 1, or null.
      • Char

        public static final CmdParamsType Char
        A fixed-length stream of non-Unicode characters ranging between 1 and 8,000 characters.
      • DateTime

        public static final CmdParamsType 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 CmdParamsType Decimal
        A fixed precision and scale numeric value between -10 38 -1 and 10 38 -1.
      • Float

        public static final CmdParamsType Float
        A floating point number within the range of -1.79E +308 through 1.79E +308.
      • Int

        public static final CmdParamsType Int
        A 32-bit signed integer.
      • Money

        public static final CmdParamsType Money
        A currency value ranging from -2 63 (or -9,223,372,036,854,775,808) to 2 63 -1 (or +9,223,372,036,854,775,807) with an accuracy to a ten-thousandth of a currency unit.
      • NChar

        public static final CmdParamsType NChar
        A fixed-length stream of Unicode characters ranging between 1 and 4,000 characters.
      • NVarChar

        public static final CmdParamsType NVarChar
        A variable-length stream of Unicode characters ranging between 1 and 4,000 characters. Implicit conversion fails if the string is greater than 4,000 characters. Explicitly set the object when working with strings longer than 4,000 characters.
      • Real

        public static final CmdParamsType Real
        A floating point number within the range of -3.40E +38 through 3.40E +38.
      • UniqueIdentifier

        public static final CmdParamsType UniqueIdentifier
        A globally unique identifier (or GUID).
      • SmallDateTime

        public static final CmdParamsType SmallDateTime
        Date and time data ranging in value from January 1, 1900 to June 6, 2079 to an accuracy of one minute.
      • SmallInt

        public static final CmdParamsType SmallInt
        A 16-bit signed integer.
      • SmallMoney

        public static final CmdParamsType SmallMoney
        A currency value ranging from -214,748.3648 to +214,748.3647 with an accuracy to a ten-thousandth of a currency unit.
      • Timestamp

        public static final CmdParamsType Timestamp
        Automatically generated binary numbers, which are guaranteed to be unique within a database. timestamp is used typically as a mechanism for version-stamping table rows. The storage size is 8 bytes.
      • TinyInt

        public static final CmdParamsType TinyInt
        An 8-bit unsigned integer.
      • VarBinary

        public static final CmdParamsType VarBinary
        A variable-length stream of binary data ranging between 1 and 8,000 bytes. Implicit conversion fails if the byte array is greater than 8,000 bytes. Explicitly set the object when working with byte arrays larger than 8,000 bytes.
      • VarChar

        public static final CmdParamsType VarChar
        A variable-length stream of non-Unicode characters ranging between 1 and 8,000 characters.
      • Variant

        public static final CmdParamsType Variant
        A special data type that can contain numeric, string, binary, or date data as well as the SQL Server values Empty and Null, which is assumed if no other type is declared.
      • Xml

        public static final CmdParamsType Xml
        An XML value. Obtain the XML as a string.
      • Udt

        public static final CmdParamsType Udt
        A SQL Server user-defined type (UDT).
      • Structured

        public static final CmdParamsType Structured
        A special data type for specifying structured data contained in table-valued parameters.
      • Date

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

        public static final CmdParamsType 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.
      • DateTime2

        public static final CmdParamsType DateTime2
        Date and time data. 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.
      • DateTimeOffset

        public static final CmdParamsType 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 CmdParamsType[] 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 (CmdParamsType c : CmdParamsType.values())
            System.out.println(c);
        
        Returns:
        an array containing the constants of this enum type, in the order they are declared
      • valueOf

        public static CmdParamsType 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
      • getValue

        public int getValue()
        Order is important in enums.By using getValue() method, each enum constant index can be found, just like array index.
        Returns:
        enum constant index
      • forValue

        public static CmdParamsType forValue​(int value)
        retreives the enum constant of the specified value, if exists.
        Parameters:
        value - enum constant index
        Returns:
        enum constant