columns.java

数据仓库工具

//                                                                            
// Copyright 1998 CDS Networks, Inc., Medford Oregon                          
//                                                                            
// All rights reserved.                                                       
//                                                                            
// Redistribution and use in source and binary forms, with or without         
// modification, are permitted provided that the following conditions are met:
// 1. Redistributions of source code must retain the above copyright          
//    notice, this list of conditions and the following disclaimer.           
// 2. Redistributions in binary form must reproduce the above copyright       
//    notice, this list of conditions and the following disclaimer in the     
//    documentation and/or other materials provided with the distribution.    
// 3. All advertising materials mentioning features or use of this software   
//    must display the following acknowledgement:                             
//      This product includes software developed by CDS Networks, Inc.        
// 4. The name of CDS Networks, Inc.  may not be used to endorse or promote   
//    products derived from this software without specific prior              
//    written permission.                                                     
//                                                                            
// THIS SOFTWARE IS PROVIDED BY CDS NETWORKS, INC. ``AS IS'' AND              
// ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE      
// IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE 
// ARE DISCLAIMED.  IN NO EVENT SHALL CDS NETWORKS, INC. BE LIABLE            
// FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL 
// DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS    
// OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)      
// HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT 
// LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY  
// OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF     
// SUCH DAMAGE.                                                               
//                                                                            




package com.internetcds.jdbc.tds;

import java.util.Vector;
import java.sql.Types;
import com.internetcds.jdbc.tds.Column;


/**
 * Information about the columns in a result set.
 *
 * @author Craig Spannring
 */
public class Columns
{
   public static final String cvsVersion = "$Id: Columns.java,v 1.1 2003/04/29 18:07:50 sinisa Exp $";


   private Vector  columns = null;
   private int     columnCount = 0;

   public Columns()
   {
      columns = new Vector();
      columnCount = 0;
   }

   /**
    * merge the data from two instances of Columns.
    *
    * The 4.2 TDS protocol gives the column information in multiple pieces.
    * Each piece gives us a specific piece of information for all the 
    * columns in the result set.  We must join those pieces of information
    * together to use as the basis for the ResultSetMetaData class.
    *
    * @exception TdsException thrown if the two instances of Columns can't
    *                         be merged.  This can happen if the number of 
    *                         columns isn't identical or if there is 
    *                         conflicting data.
    */ 
   public Columns merge(Columns other)
      throws TdsException
   {
      int   tmp;
      int   i;

      if (this.columns.size() != other.columns.size())
      {
         throw new TdsException("Confused.  Mismatch in number of columns");
      }

      for(i=1; i<=columnCount; i++)
      {
         if (this.getName(i) == null)
         {
            this.setName(i, other.getName(i));
         }
         else if (other.getName(i) == null)
         {
            // fine
         }
         else
         {
            throw new TdsException("Trying to merge two non-null columns");
         }

         if (this.getDisplaySize(i) == -1)
         {
            this.setDisplaySize(i, other.getDisplaySize(i));
         }
         else if (other.getDisplaySize(i) == -1)
         {
            // fine
         }
         else
         {
            throw new TdsException("Trying to merge two non-null columns");
         }

         if (this.getLabel(i) == null)
         {
            this.setLabel(i, other.getLabel(i));
         }
         else if (other.getLabel(i) == null)
         {
            // fine
         }
         else
         {
            throw new TdsException("Trying to merge two non-null columns");
         }

         if (this.getType(i) == -1)
         {
            this.setType(i, other.getType(i));
         }
         else if (other.getType(i) == -1)
         {
            // fine
         }
         else
         {
            throw new TdsException("Trying to merge two non-null columns");
         }

         if (this.getPrecision(i) == -1)
         {
            this.setPrecision(i, other.getPrecision(i));
         }
         else if (other.getPrecision(i) == -1)
         {
            // fine
         }
         else
         {
            throw new TdsException("Trying to merge two non-null columns");
         }

         if (this.getScale(i) == -1)
         {
            this.setScale(i, other.getScale(i));
         }
         else if (other.getScale(i) == -1)
         {
            // fine
         }
         else
         {
            throw new TdsException("Trying to merge two non-null columns");
         }

         if ((this.nullableWasSet(i)) && (other.nullableWasSet(i)))
         {
            throw new TdsException("Trying to merge two non-null columns");
         }
         else if ((! this.nullableWasSet(i)) && (other.nullableWasSet(i)))
         {
            this.setNullable (i, other.isNullable(i));
         }
         else 
         {
            // fine
         }

         if ((this.readOnlyWasSet(i)) && (other.readOnlyWasSet(i)))
         {
            throw new TdsException("Trying to merge two non-null columns");
         }
         else if ((! this.readOnlyWasSet(i)) && (other.readOnlyWasSet(i)))
         {
            this.setReadOnly(i, other.isReadOnly(i));
         }
         else 
         {
            // fine
         }

         if ((this.autoIncrementWasSet(i)) && (other.autoIncrementWasSet(i)))
         {
            throw new TdsException("Trying to merge two non-null columns");
         }
         else if ((! this.autoIncrementWasSet(i)) 
                  && (other.autoIncrementWasSet(i)))
         {
            this.setAutoIncrement(i, other.isAutoIncrement(i));
         }
         else 
         {
            // fine
         }
      }
      return this;
   } /* merge() */


   private void resize(int columnNumber)
   {
      if (columnNumber > columnCount)
      {
         columnCount = columnNumber;
      }

      if (columns.size() <= columnNumber)
      {
         columns.setSize(columnNumber+1);
      }

      if (columns.elementAt(columnNumber-1) == null)
      {
         columns.setElementAt(new Column(), columnNumber-1);
      }

   }


   /**
    * 
    */
   public int getColumnCount()
   {
      return columnCount;
   }


   public void setName(int columnNumber, String value)
   {
      resize(columnNumber);
      if (columns.elementAt(columnNumber-1) == null)
      {
         columns.setElementAt(new Column(), columnNumber-1);
      }
      ((Column)(columns.elementAt(columnNumber-1))).setName(value);
   }

   public String getName(int columnNumber)
   {
      return ((Column)columns.elementAt(columnNumber-1)).getName();
   }

   public void setDisplaySize(int columnNumber, int value)
   {
      resize(columnNumber);
      ((Column)(columns.elementAt(columnNumber-1))).setDisplaySize(value);
   }

   public int getDisplaySize(int columnNumber)
   {
      return ((Column)columns.elementAt(columnNumber-1)).getDisplaySize();
   }

   public void setLabel(int columnNumber, String value)
   {
      ((Column)(columns.elementAt(columnNumber-1))).setLabel(value);
   }

   public String getLabel(int columnNumber)
   {
      return ((Column)columns.elementAt(columnNumber-1)).getLabel();
   }

   public void setType(int columnNumber, int value)
   {
      // remeber that this is the native type
      resize(columnNumber);
      ((Column)(columns.elementAt(columnNumber-1))).setType(value);
   }

   public int getType(int columnNumber)
   {
      // remeber that this is the native type
      return ((Column)columns.elementAt(columnNumber-1)).getType();
   }

   public void setPrecision(int columnNumber, int value)
   {
      resize(columnNumber);
      ((Column)(columns.elementAt(columnNumber-1))).setPrecision(value);
   }

   public int getPrecision(int columnNumber)
   {
      return ((Column)columns.elementAt(columnNumber-1)).getPrecision();
   }

   public void setScale(int columnNumber, int value)
   {
      resize(columnNumber);
      ((Column)(columns.elementAt(columnNumber-1))).setScale(value);
   }
   
   public int getScale(int columnNumber)
   {
      return ((Column)columns.elementAt(columnNumber-1)).getScale();
   }
   
   public boolean isAutoIncrement(int columnNumber)
   {
      return ((Column)columns.elementAt(columnNumber-1)).isAutoIncrement();
   }
   
   public void setAutoIncrement(int columnNumber, boolean value)
   {
      resize(columnNumber);
      ((Column)(columns.elementAt(columnNumber-1))).setAutoIncrement(value);
   }
   
   public boolean autoIncrementWasSet(int columnNumber)
   {
      return ((Column)(columns.elementAt(columnNumber-1))).autoIncrementWasSet();
   }

   public int isNullable(int columnNumber)
   {
      return ((Column)columns.elementAt(columnNumber-1)).isNullable();
   }
   
   public void setNullable(int columnNumber, int value)
   {
      resize(columnNumber);
      ((Column)(columns.elementAt(columnNumber-1))).setNullable (value);
   }
   
   public boolean nullableWasSet(int columnNumber)
   {
      return (isNullable(columnNumber) 
              != java.sql.ResultSetMetaData.columnNullableUnknown);
   }
   
   public boolean isReadOnly(int columnNumber)
   {
      return ((Column)columns.elementAt(columnNumber-1)).isReadOnly();
   }
   
   public void setReadOnly(int columnNumber, boolean value)
   {
      resize(columnNumber);
      ((Column)columns.elementAt(columnNumber-1)).setReadOnly(value);
   }
   
   public boolean readOnlyWasSet(int columnNumber)
   {
      return ((Column)(columns.elementAt(columnNumber-1))).readOnlyWasSet();
   }
   
}