src/org/objectweb/cjdbc/common/sql/schema/DatabaseProcedureParameter.java

説明を見る。

package org.objectweb.cjdbc.common.sql.schema;

import java.io.Serializable;
import java.sql.Types;

import org.objectweb.cjdbc.common.xml.DatabasesXmlTags;

public class DatabaseProcedureParameter implements Serializable
{
  public static final int ProcedureColumnUnknown   = 0;
  public static final int ProcedureColumnIn        = 1;
  public static final int ProcedureColumnInOut     = 2;
  public static final int ProcedureColumnOut       = 3;
  public static final int ProcedureColumnReturn    = 4;
  public static final int ProcedureColumnResult    = 5;

  public static final int ProcedureNoNulls         = 0;
  public static final int ProcedureNullable        = 1;
  public static final int ProcedureNullableUnknown = 2;

  private String          name;
  private int             columnType;
  private int             dataType;
  private String          typeName;
  private float           precision;
  private int             length;
  private int             scale;
  private int             radix;
  private int             nullable;
  private String          remarks;

  public static int getNullFromString(String nullable)
  {
    if (nullable.equalsIgnoreCase(DatabasesXmlTags.VAL_noNulls))
      return ProcedureNoNulls;
    if (nullable.equalsIgnoreCase(DatabasesXmlTags.VAL_nullable))
      return ProcedureNullable;
    else
      return ProcedureNullableUnknown;
  }

  public static String getNullFromInt(int nullable)
  {
    switch (nullable)
    {
      case ProcedureNoNulls :
        return DatabasesXmlTags.VAL_noNulls;
      case ProcedureNullable :
        return DatabasesXmlTags.VAL_nullable;
      case ProcedureNullableUnknown :
      default :
        return DatabasesXmlTags.VAL_nullableUnknown;
    }
  }

  public static String getColumnTypeFromInt(int type)
  {
    switch (type)
    {
      case ProcedureColumnIn :
        return DatabasesXmlTags.VAL_in;
      case ProcedureColumnOut :
        return DatabasesXmlTags.VAL_out;
      case ProcedureColumnInOut :
        return DatabasesXmlTags.VAL_inout;
      case ProcedureColumnReturn :
        return DatabasesXmlTags.VAL_return;
      case ProcedureColumnResult :
        return DatabasesXmlTags.VAL_result;
      case ProcedureColumnUnknown :
      default :
        return DatabasesXmlTags.VAL_unknown;
    }
  }

  public static int getColumnTypeFromString(String type)
  {
    if (type.equalsIgnoreCase(DatabasesXmlTags.VAL_in))
      return ProcedureColumnIn;
    if (type.equalsIgnoreCase(DatabasesXmlTags.VAL_out))
      return ProcedureColumnOut;
    if (type.equalsIgnoreCase(DatabasesXmlTags.VAL_inout))
      return ProcedureColumnInOut;
    if (type.equalsIgnoreCase(DatabasesXmlTags.VAL_return))
      return ProcedureColumnReturn;
    if (type.equalsIgnoreCase(DatabasesXmlTags.VAL_result))
      return ProcedureColumnResult;
    else
      return ProcedureColumnUnknown;
  }

  public DatabaseProcedureParameter(String name, int columnType, int nullable)
  {
    this(name, columnType, Types.VARCHAR, "VARCHAR", 0, 0, 0, 0, nullable, "");
  }

  public DatabaseProcedureParameter(String name, int columnType, int dataType,
      String typeName, float precision, int length, int scale, int radix,
      int nullable, String remarks)
  {
    this.name = name;
    this.columnType = columnType;
    this.dataType = dataType;
    this.typeName = typeName;
    this.precision = precision;
    this.length = length;
    this.scale = scale;
    this.radix = radix;
    this.nullable = nullable;
    this.remarks = remarks;
  }

  public final int getColumnType()
  {
    return columnType;
  }

  public final void setColumnType(int columnType)
  {
    this.columnType = columnType;
  }

  public final int getDataType()
  {
    return dataType;
  }

  public final void setDataType(int dataType)
  {
    this.dataType = dataType;
  }

  public final int getLength()
  {
    return length;
  }

  public final void setLength(int length)
  {
    this.length = length;
  }

  public final String getName()
  {
    return name;
  }

  public final void setName(String name)
  {
    this.name = name;
  }

  public final int getNullable()
  {
    return nullable;
  }

  public final void setNullable(int nullable)
  {
    this.nullable = nullable;
  }

  public final float getPrecision()
  {
    return precision;
  }

  public final void setPrecision(int precision)
  {
    this.precision = precision;
  }

  public final int getRadix()
  {
    return radix;
  }

  public final void setRadix(int radix)
  {
    this.radix = radix;
  }

  public final String getRemarks()
  {
    return remarks;
  }

  public final void setRemarks(String remarks)
  {
    this.remarks = remarks;
  }

  public final int getScale()
  {
    return scale;
  }

  public final void setScale(int scale)
  {
    this.scale = scale;
  }

  public final String getTypeName()
  {
    return typeName;
  }

  public final void setTypeName(String typeName)
  {
    this.typeName = typeName;
  }

  public boolean equals(Object other)
  {
    if ((other == null) || !(other instanceof DatabaseProcedureParameter))
      return false;

    DatabaseProcedureParameter p = (DatabaseProcedureParameter) other;

    // first we check simple types
    if (!(p.columnType == columnType && p.dataType == dataType
        && p.precision == precision && p.length == length && p.scale == scale
        && p.radix == radix && p.nullable == nullable))
    {
      return false;
    }

    // now we compare object types
    if (!(name == null ? p.name == null : name.equals(p.name)))
    {
      return false;
    }

    if (!(typeName == null ? p.typeName == null : typeName.equals(p.typeName)))
    {
      return false;
    }

    return remarks == null ? p.remarks == null : remarks.equals(p.remarks);
  }

  public String getXml()
  {
    StringBuffer info = new StringBuffer();
    info.append("<" + DatabasesXmlTags.ELT_DatabaseProcedureColumn + " "
        + DatabasesXmlTags.ATT_name + "=\"" + name + "\"" + " "
        + DatabasesXmlTags.ATT_paramType + "=\""
        + getColumnTypeFromInt(columnType) + "\"" + " "
        + DatabasesXmlTags.ATT_nullable + "=\"" + getNullFromInt(nullable)
        + "\"/>");
    return info.toString();
  }

}

---