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

説明を見る。

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

import java.io.Serializable;
import java.sql.SQLException;
import java.util.ArrayList;

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

public class DatabaseProcedure implements Serializable
{
  public static final int ProcedureResultUnknown = 0;
  public static final int ProcedureNoResult      = 1;
  public static final int ProcedureReturnsResult = 2;

  ArrayList               parameters;
  private String          name;
  private String          remarks;
  private int             procedureType;

  public static int getTypeFromString(String type)
  {
    if (type.equals(DatabasesXmlTags.VAL_noResult))
      return ProcedureNoResult;
    if (type.equals(DatabasesXmlTags.VAL_returnsResult))
      return ProcedureReturnsResult;
    else
      return ProcedureResultUnknown;
  }

  public static String getTypeFromInt(int type)
  {
    switch (type)
    {
      case ProcedureNoResult :
        return DatabasesXmlTags.VAL_noResult;
      case ProcedureReturnsResult :
        return DatabasesXmlTags.VAL_returnsResult;
      default :
        return DatabasesXmlTags.VAL_resultUnknown;
    }
  }

  public DatabaseProcedure(String name, String remarks, int procedureType)
  {
    this.name = name;
    this.remarks = remarks;
    this.procedureType = procedureType;
    this.parameters = new ArrayList();
  }

  public void addParameter(DatabaseProcedureParameter param)
  {
    parameters.add(param);
  }

  public String getName()
  {
    return name;
  }

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

  public ArrayList getParameters()
  {
    return parameters;
  }

  public void setParameters(ArrayList parameters)
  {
    this.parameters = parameters;
  }

  public int getProcedureType()
  {
    return procedureType;
  }

  public void setProcedureType(int procedureType)
  {
    this.procedureType = procedureType;
  }

  public String getRemarks()
  {
    return remarks;
  }

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

  public void mergeParameters(DatabaseProcedure procedure) throws SQLException
  {
    if (procedure == null)
      return;

    ArrayList otherParameters = procedure.getParameters();
    if (otherParameters == null && parameters == null)
      return;

    if (this.equals(procedure))
    {
      // Procedures are the same, no conflict
      return;
    }
    else
    {
      throw new SQLException("Unable to merge procedure " + getName()
          + ": parameters are differents ");
    }
  }

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

    DatabaseProcedure p = (DatabaseProcedure) other;
    return (p.getName().equals(name)) && (p.getParameters().equals(parameters));
  }

  public String getXml()
  {
    StringBuffer info = new StringBuffer();
    info.append("<" + DatabasesXmlTags.ELT_DatabaseProcedure + " "
        + DatabasesXmlTags.ATT_name + "=\"" + name + "\" "
        + DatabasesXmlTags.ATT_returnType + "=\""
        + getTypeFromInt(procedureType) + "\">");
    for (int i = 0; i < parameters.size(); i++)
      info.append(((DatabaseProcedureParameter) parameters.get(i)).getXml());
    info.append("</" + DatabasesXmlTags.ELT_DatabaseProcedure + ">");
    return info.toString();
  }

}

---