TypeDecimal.java :  » Database-DBMS » Quadcap-Embeddable-Database » com » quadcap » sql » types » Java Open Source

Java Open Source » Database DBMS » Quadcap Embeddable Database 
Quadcap Embeddable Database » com » quadcap » sql » types » TypeDecimal.java
package com.quadcap.sql.types;

/* Copyright 1999 - 2003 Quadcap Software.  All rights reserved.
 *
 * This software is distributed under the Quadcap Free Software License.
 * This software may be used or modified for any purpose, personal or
 * commercial.  Open Source redistributions are permitted.  Commercial
 * redistribution of larger works derived from, or works which bundle
 * this software requires a "Commercial Redistribution License"; see
 * http://www.quadcap.com/purchase.
 *
 * Redistributions qualify as "Open Source" under  one of the following terms:
 *   
 *    Redistributions are made at no charge beyond the reasonable cost of
 *    materials and delivery.
 *
 *    Redistributions are accompanied by a copy of the Source Code or by an
 *    irrevocable offer to provide a copy of the Source Code for up to three
 *    years at the cost of materials and delivery.  Such redistributions
 *    must allow further use, modification, and redistribution of the Source
 *    Code under substantially the same terms as this license.
 *
 * Redistributions of source code must retain the copyright notices as they
 * appear in each source code file, these license terms, and the
 * disclaimer/limitation of liability set forth as paragraph 6 below.
 *
 * Redistributions in binary form must reproduce this Copyright Notice,
 * these license terms, and the disclaimer/limitation of liability set
 * forth as paragraph 6 below, in the documentation and/or other materials
 * provided with the distribution.
 *
 * The Software is provided on an "AS IS" basis.  No warranty is
 * provided that the Software is free of defects, or fit for a
 * particular purpose.  
 *
 * Limitation of Liability. Quadcap Software shall not be liable
 * for any damages suffered by the Licensee or any third party resulting
 * from use of the Software.
 */

import java.io.Externalizable;
import java.io.IOException;
import java.io.ObjectInput;
import java.io.ObjectOutput;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;

import java.math.BigDecimal;

import com.quadcap.util.Debug;

/**
 * The SQL <b>DECIMAL</b> type.
 *
 * @author Stan Bailes
 */
public class TypeDecimal implements Type, Externalizable {
    public static final TypeDecimal  typeDecimal  = new TypeDecimal();

    int       precision  = -1;
    int        scale    = -1;

    public TypeDecimal() {}

    public TypeDecimal(int precision, int scale) {
  this.precision = precision;
  this.scale = scale;
    }
    
    public String getTypeName() {
  return "DECIMAL";
    }

    public int getJDBCType() { return Types.DECIMAL; }

    public String getJDBCClassName() { return "java.math.BigDecimal"; }

    public int getPrecision() { return precision; }

    public int getScale() { return scale; }

    public int getMaxPrecision() { return -1; }

    public int getMinScale() { return -1; }

    public int getMaxScale() { return -1; }

    public boolean isCharType() { return false; }

    public boolean isCaseSensitive() { return false; }

    public boolean isCurrency() { return false; }

    public boolean isSigned() { return true; }

    public int getDisplayWidth() { return precision + 1; }
    
    public String toString() {
        if (precision > 0) {
            return "DECIMAL(" + precision + ", " + scale + ")";
        } else {
            return "DECIMAL";
        }
    }
    
    public void readExternal(ObjectInput in) throws IOException {
  precision = in.readInt();
  scale = in.readInt();
    }
    
    public void writeExternal(ObjectOutput out) throws IOException {
  out.writeInt(precision);
  out.writeInt(scale);
    }

    public Value convert(Value v) throws ValueException {
  return v.convert(this);
    }

    /**
     * Utility method to help convert numbers to DECIMALs
     */
    public Value convertNumber(long n) throws ValueException {
        if (precision > 0 && scale >= 0) {
            long lim = (long)(Math.pow(10, precision-scale)) - 1;
            if (n > lim || n < (0-lim)) {
                throw new ValueException("Can't convert to type: " + this);
            }
        }
        BigDecimal d =
            BigDecimal.valueOf(n).setScale((scale < 0 ? 0 : scale),
                                           BigDecimal.ROUND_HALF_DOWN);
        return new ValueScaledInteger(d);
    }

    public String getCreateParams() {
        return "precision, scale";
    }
}
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.