typeid.java

derby database source code.good for you.

                          return INTEGER_ID;

                  case Types.BIGINT:
                          ret = LONGINT_ID;
                          if (ret == null)
                                  ret = LONGINT_ID = new TypeId(StoredFormatIds.LONGINT_TYPE_ID,
                                                                        new BaseTypeIdImpl(StoredFormatIds.LONGINT_TYPE_ID_IMPL));
                          break;

                  case Types.REAL:
                          ret = REAL_ID;
                          if (ret == null)
                                  ret = REAL_ID = new TypeId(StoredFormatIds.REAL_TYPE_ID,
                                                                        new BaseTypeIdImpl(StoredFormatIds.REAL_TYPE_ID_IMPL));
                          break;

                  case Types.FLOAT:
                  case Types.DOUBLE:
                          ret = DOUBLE_ID;
                          if (ret == null)
                                  ret = DOUBLE_ID = new TypeId(StoredFormatIds.DOUBLE_TYPE_ID,
                                                                        new BaseTypeIdImpl(StoredFormatIds.DOUBLE_TYPE_ID_IMPL));
                          break;

                  case Types.DECIMAL:
                          ret = DECIMAL_ID;
                          if (ret == null)
                                  ret = DECIMAL_ID = new TypeId(StoredFormatIds.DECIMAL_TYPE_ID,
                                                                        new DecimalTypeIdImpl());
                          break;

                  case Types.NUMERIC:
                          ret = NUMERIC_ID;
                          if (ret == null) {
                                  DecimalTypeIdImpl numericTypeIdImpl = new DecimalTypeIdImpl();
                                  numericTypeIdImpl.setNumericType();
                                  ret = NUMERIC_ID = new TypeId(StoredFormatIds.DECIMAL_TYPE_ID, numericTypeIdImpl);
                          }
                          break;

                  case Types.CHAR:
                          return CHAR_ID;

                  case Types.VARCHAR:
                          ret = VARCHAR_ID;
                          if (ret == null)
                                  ret = VARCHAR_ID = new TypeId(StoredFormatIds.VARCHAR_TYPE_ID,
                                                                        new BaseTypeIdImpl(StoredFormatIds.VARCHAR_TYPE_ID_IMPL));
                          break;

                  case Types.DATE:
                          ret = DATE_ID;
                          if (ret == null)
                                  ret = DATE_ID = new TypeId(StoredFormatIds.DATE_TYPE_ID,
                                                                        new BaseTypeIdImpl(StoredFormatIds.DATE_TYPE_ID_IMPL));
                          break;

                  case Types.TIME:
                          ret = TIME_ID;
                          if (ret == null)
                                  ret = TIME_ID = new TypeId(StoredFormatIds.TIME_TYPE_ID,
                                                                        new BaseTypeIdImpl(StoredFormatIds.TIME_TYPE_ID_IMPL));
                          break;

                  case Types.TIMESTAMP:
                          ret = TIMESTAMP_ID;
                          if (ret == null)
                                  ret = TIMESTAMP_ID = new TypeId(StoredFormatIds.TIMESTAMP_TYPE_ID,
                                                                        new BaseTypeIdImpl(StoredFormatIds.TIMESTAMP_TYPE_ID_IMPL));
                          break;
                  case Types.BIT:
                  case JDBC30Translation.SQL_TYPES_BOOLEAN:
                          return BOOLEAN_ID;

                  case Types.BINARY:
                          ret = BIT_ID;
                          if (ret == null)
                                  ret = BIT_ID = new TypeId(StoredFormatIds.BIT_TYPE_ID,
                                                                        new BaseTypeIdImpl(StoredFormatIds.BIT_TYPE_ID_IMPL));
                          break;

                  case Types.VARBINARY:
                          ret = VARBIT_ID;
                          if (ret == null)
                                  ret = VARBIT_ID = new TypeId(StoredFormatIds.VARBIT_TYPE_ID,
                                                                        new BaseTypeIdImpl(StoredFormatIds.VARBIT_TYPE_ID_IMPL));
                          break;

                  case Types.LONGVARBINARY:
                          ret = LONGVARBIT_ID;
                          if (ret == null)
                                  ret = LONGVARBIT_ID = new TypeId(StoredFormatIds.LONGVARBIT_TYPE_ID,
                                                                        new BaseTypeIdImpl(StoredFormatIds.LONGVARBIT_TYPE_ID_IMPL));
                          break;

                  case Types.LONGVARCHAR:
                      ret = LONGVARCHAR_ID;
                      if (ret == null)
                          ret = LONGVARCHAR_ID = new TypeId(StoredFormatIds.LONGVARCHAR_TYPE_ID,
                                                            new BaseTypeIdImpl(StoredFormatIds.LONGVARCHAR_TYPE_ID_IMPL));
                      break;

                  case JDBC20Translation.SQL_TYPES_BLOB:
                      ret = BLOB_ID;
                      if (ret == null)
                          ret = BLOB_ID = new TypeId(StoredFormatIds.BLOB_TYPE_ID,
                                                     new BaseTypeIdImpl(StoredFormatIds.BLOB_TYPE_ID_IMPL));
                      break;
                                                
                  case JDBC20Translation.SQL_TYPES_CLOB:
                      ret = CLOB_ID;
                      if (ret == null)
                          ret = CLOB_ID = new TypeId(StoredFormatIds.CLOB_TYPE_ID,
                                                     new BaseTypeIdImpl(StoredFormatIds.CLOB_TYPE_ID_IMPL));
                      break;

                  // XML is not a JDBC type, so we have to check for our
                  // internal XML type.
                  case StoredFormatIds.XML_TYPE_ID:
                      ret = XML_ID;
                      if (ret == null)
                          ret = XML_ID = new TypeId(StoredFormatIds.XML_TYPE_ID,
                                                     new BaseTypeIdImpl(StoredFormatIds.XML_TYPE_ID_IMPL));
                      break;
                }
                return ret;
        }

        public static TypeId getUserDefinedTypeId(String className, boolean delimitedIdentifier)
        {
                return new TypeId(StoredFormatIds.USERDEFINED_TYPE_ID_V3,
                                        new UserDefinedTypeIdImpl(className), delimitedIdentifier
                                        );
        }

        /**
         * Get a TypeId for the class that corresponds to the given
         * Java type name.
         *
         * @param javaTypeName          The name of the Java type
         *
         * @return      A TypeId for the SQL type that corresponds to
         *                      the Java type, null if there is no corresponding type.
         */
        public static TypeId getSQLTypeForJavaType(String javaTypeName)
        {
                if (javaTypeName.equals("java.lang.Boolean") ||
                        javaTypeName.equals("boolean"))
                {
                        return TypeId.BOOLEAN_ID;
                }
                else if (javaTypeName.equals("byte[]"))
                {
                        return getBuiltInTypeId(Types.VARBINARY);
                }
                else if (javaTypeName.equals("java.lang.String"))
                {
                        return getBuiltInTypeId(Types.VARCHAR);
                }
                else if (javaTypeName.equals("java.lang.Integer") ||
                                javaTypeName.equals("int"))
                {
                        return TypeId.INTEGER_ID;
                }
                else if (javaTypeName.equals("byte"))
                {
                        return getBuiltInTypeId(Types.TINYINT);
                }
                else if (javaTypeName.equals("short"))
                {
                        return getBuiltInTypeId(Types.SMALLINT);
                }
                else if (javaTypeName.equals("java.lang.Long") ||
                                javaTypeName.equals("long"))
                {
                        return getBuiltInTypeId(Types.BIGINT);
                }
                else if (javaTypeName.equals("java.lang.Float") ||
                                javaTypeName.equals("float"))
                {
                        return getBuiltInTypeId(Types.REAL);
                }
                else if (javaTypeName.equals("java.lang.Double") ||
                                javaTypeName.equals("double"))
                {
                        return getBuiltInTypeId(Types.DOUBLE);
                }
                else if (javaTypeName.equals("java.math.BigDecimal"))
                {
                        return getBuiltInTypeId(Types.DECIMAL);
                }
                else if (javaTypeName.equals("java.sql.Date"))
                {
                        return getBuiltInTypeId(Types.DATE);
                }
                else if (javaTypeName.equals("java.sql.Time"))
                {
                        return getBuiltInTypeId(Types.TIME);
                }
                else if (javaTypeName.equals("java.sql.Timestamp"))
                {
                        return getBuiltInTypeId(Types.TIMESTAMP);
                }
                else if (javaTypeName.equals("java.sql.Blob"))
                {
                        return getBuiltInTypeId(JDBC20Translation.SQL_TYPES_BLOB);
                }
                else if (javaTypeName.equals("java.sql.Clob"))
                {
                        return getBuiltInTypeId(JDBC20Translation.SQL_TYPES_CLOB);
                }
                else if (javaTypeName.equals("org.apache.derby.iapi.types.XML"))
                {
                        return getBuiltInTypeId(StoredFormatIds.XML_TYPE_ID);
                }
                else
                {
                        /*
                        ** If it's a Java primitive type, return null to indicate that
                        ** there is no corresponding SQL type (all the Java primitive
                        ** types that have corresponding SQL types are handled above).
                        **
                        ** There is only one primitive type not mentioned above, char.
                        */
                        if (javaTypeName.equals("char"))
                        {
                                return null;
                        }

                        /*
                        ** It's a non-primitive type (a class) that does not correspond
                        ** to a SQL built-in type, so treat it as a user-defined type.
                        */
                        return TypeId.getUserDefinedTypeId(javaTypeName, false);
                }
        }

        public static TypeId getBuiltInTypeId(String SQLTypeName) {

                if (SQLTypeName.equals(TypeId.BOOLEAN_NAME)) {
                        return TypeId.BOOLEAN_ID;
                }
                if (SQLTypeName.equals(TypeId.CHAR_NAME)) {
                        return TypeId.CHAR_ID;
                }
                if (SQLTypeName.equals(TypeId.DATE_NAME)) {
                        return getBuiltInTypeId(Types.DATE);
                }
                if (SQLTypeName.equals(TypeId.DOUBLE_NAME)) {
                        return getBuiltInTypeId(Types.DOUBLE);
                }
                if (SQLTypeName.equals(TypeId.FLOAT_NAME)) {
                        return getBuiltInTypeId(Types.DOUBLE);
                }
                if (SQLTypeName.equals(TypeId.INTEGER_NAME)) {
                        return TypeId.INTEGER_ID;
                }
                if (SQLTypeName.equals(TypeId.LONGINT_NAME)) {
                        return getBuiltInTypeId(Types.BIGINT);
                }
                if (SQLTypeName.equals(TypeId.REAL_NAME)) {
                        return getBuiltInTypeId(Types.REAL);
                }
                if (SQLTypeName.equals(TypeId.SMALLINT_NAME)) {
                        return getBuiltInTypeId(Types.SMALLINT);
                }
                if (SQLTypeName.equals(TypeId.TIME_NAME)) {
                        return getBuiltInTypeId(Types.TIME);
                }
                if (SQLTypeName.equals(TypeId.TIMESTAMP_NAME)) {
                        return getBuiltInTypeId(Types.TIMESTAMP);
                }
                if (SQLTypeName.equals(TypeId.VARCHAR_NAME)) {
                        return getBuiltInTypeId(Types.VARCHAR);
                }
                if (SQLTypeName.equals(TypeId.BIT_NAME)) {
                        return getBuiltInTypeId(Types.BINARY);
                }
                if (SQLTypeName.equals(TypeId.VARBIT_NAME)) {
                        return getBuiltInTypeId(Types.VARBINARY);
                }
                if (SQLTypeName.equals(TypeId.TINYINT_NAME)) {
                        return getBuiltInTypeId(Types.TINYINT);
                }
                if (SQLTypeName.equals(TypeId.DECIMAL_NAME)) {
                        return getBuiltInTypeId(Types.DECIMAL);
                }
                if (SQLTypeName.equals(TypeId.NUMERIC_NAME)) {
                        return getBuiltInTypeId(Types.NUMERIC);
                }
                if (SQLTypeName.equals(TypeId.LONGVARCHAR_NAME)) {