org.firebirdsql.jdbc.field.FBBigDecimalField Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of jaybird Show documentation
JDBC Driver for the Firebird RDBMS
There is a newer version: 6.0.0-beta-1
/*
 * Firebird Open Source J2ee connector - jdbc driver
 *
 * Distributable under LGPL license.
 * You may obtain a copy of the License at http://www.gnu.org/copyleft/lgpl.html
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * LGPL License for more details.
 *
 * This file was created by members of the firebird development team.
 * All individual contributions remain the Copyright (C) of those
 * individuals.  Contributors to this file are either listed here or
 * can be obtained from a CVS history command.
 *
 * All rights reserved.
 */

package org.firebirdsql.jdbc.field;

import java.math.BigDecimal;
import java.math.BigInteger;
import java.sql.SQLException;

import org.firebirdsql.gds.XSQLVAR;

/**
 * Describe class FBBigDecimalField here.
 *
 * @author Roman Rokytskyy
 * @version 1.0
 */
public class FBBigDecimalField extends FBField {
    
    private static final BigInteger MAX_SHORT = BigInteger.valueOf(Short.MAX_VALUE);
    private static final BigInteger MIN_SHORT = BigInteger.valueOf(Short.MIN_VALUE);
    
    private static final BigInteger MAX_INT = BigInteger.valueOf(Integer.MAX_VALUE);
    private static final BigInteger MIN_INT = BigInteger.valueOf(Integer.MIN_VALUE);
    
    private static final BigInteger MAX_LONG = BigInteger.valueOf(Long.MAX_VALUE);
    private static final BigInteger MIN_LONG = BigInteger.valueOf(Long.MIN_VALUE);

    private int fieldType = 0; // 1.- Short, 2.- Integer, 3.- Long

    FBBigDecimalField(XSQLVAR field, FieldDataProvider dataProvider, int fieldType, 
        int requiredType) throws SQLException 
    {
        super(field, dataProvider, requiredType);
        this.fieldType = fieldType;
    }

    public boolean getBoolean() throws SQLException {
        return getByte() == 1;
    }

    public byte getByte() throws SQLException {
        if (getFieldData()==null) return BYTE_NULL_VALUE;

        long longValue = getLong();

        // check if value is withing bounds
        if (longValue > MAX_BYTE_VALUE ||
            longValue < MIN_BYTE_VALUE)
                throw (SQLException)createException(
                    BYTE_CONVERSION_ERROR).fillInStackTrace();


        return (byte)longValue;
    }

    public double getDouble() throws SQLException {
        if (getFieldData()==null) return DOUBLE_NULL_VALUE;

        BigDecimal value = getBigDecimal();
        
        if (value == BIGDECIMAL_NULL_VALUE)
            return DOUBLE_NULL_VALUE;
        
        return value.doubleValue();
    }

    public float getFloat() throws SQLException {
        if (getFieldData()==null) return FLOAT_NULL_VALUE;

        double doubleValue = getDouble();

        // check if value is withing bounds
        if (doubleValue > MAX_FLOAT_VALUE ||
            doubleValue < MIN_FLOAT_VALUE)
                throw (SQLException)createException(
                    FLOAT_CONVERSION_ERROR).fillInStackTrace();


        return (float)doubleValue;

    }

    public int getInt() throws SQLException {
        if (getFieldData()==null) return INT_NULL_VALUE;

        long longValue = getLong();

        // check if value is withing bounds
        if (longValue > MAX_INT_VALUE ||
            longValue < MIN_INT_VALUE)
                throw (SQLException)createException(
                    INT_CONVERSION_ERROR).fillInStackTrace();


        return (int)longValue;

    }

    public long getLong() throws SQLException {
        
        BigDecimal value = getBigDecimal();
        
        if (value == BIGDECIMAL_NULL_VALUE)
            return LONG_NULL_VALUE;
        
        return value.longValue();
    }

    /*
    public Object getObject() throws SQLException {
        return getBigDecimal();
    }
    */

    public short getShort() throws SQLException {
        if (getFieldData()==null) return SHORT_NULL_VALUE;

        long longValue = getLong();

        // check if value is withing bounds
        if (longValue > MAX_SHORT_VALUE ||
            longValue < MIN_SHORT_VALUE)
                throw (SQLException)createException(
                    SHORT_CONVERSION_ERROR).fillInStackTrace();


        return (short)longValue;
    }

    public String getString() throws SQLException {
        if (getFieldData()==null) return STRING_NULL_VALUE;
        
        BigDecimal value = getBigDecimal();
        
        if (value == BIGDECIMAL_NULL_VALUE)
            return STRING_NULL_VALUE;
        
        return value.toString();
    }

    public BigDecimal getBigDecimal() throws SQLException {
        if (getFieldData()==null) return BIGDECIMAL_NULL_VALUE;

        long longValue;

        if (fieldType==2)
            longValue = field.decodeInt(getFieldData());
        else
        if (fieldType==3)
            longValue = field.decodeLong(getFieldData());
        else
        if (fieldType==1)
            longValue = field.decodeShort(getFieldData());
        else
            throw (SQLException)createException(
                BIGDECIMAL_CONVERSION_ERROR).fillInStackTrace();

        return BigDecimal.valueOf(longValue, -field.sqlscale);
    }

    //--- setXXX methods

    public void setBoolean(boolean value) throws SQLException {
        setInteger(value ? 1 : 0);
    }

    public void setByte(byte value) throws SQLException {
        setLong(value);
    }

    public void setDouble(double value) throws SQLException {
        setBigDecimal(new BigDecimal(Double.toString(value)));
    }

    public void setFloat(float value) throws SQLException {
        setDouble(value);
    }

    public void setInteger(int value) throws SQLException {
        setLong(value);
    }

    public void setLong(long value) throws SQLException {
        setBigDecimal(BigDecimal.valueOf(value, 0));
    }

    public void setShort(short value) throws SQLException {
        setLong(value);
    }

    public void setString(String value) throws SQLException {
        if (value == STRING_NULL_VALUE) {
            setNull();
            return;
        }
        
        try {
            setBigDecimal(new BigDecimal(value));
        } catch(NumberFormatException nex) {
            throw (SQLException)createException(
                STRING_CONVERSION_ERROR).fillInStackTrace();
        }
    }

    public void setBigDecimal(BigDecimal value) throws SQLException {
        if (value == BIGDECIMAL_NULL_VALUE) {
            setNull();
            return;
        }
        
        value = value.setScale(-field.sqlscale, BigDecimal.ROUND_HALF_UP);

        if (fieldType == 1) {

            // check if value is withing bounds
            if (value.unscaledValue().compareTo(MAX_SHORT) > 0 ||
                value.unscaledValue().compareTo(MIN_SHORT) < 0)
                    throw (SQLException)createException(
                        BIGDECIMAL_CONVERSION_ERROR).fillInStackTrace();

            setFieldData(field.encodeShort(value.unscaledValue().shortValue()));
        } else
        if (fieldType == 2) {

            // check if value is withing bounds
            if (value.unscaledValue().compareTo(MAX_INT) > 0 ||
                value.unscaledValue().compareTo(MIN_INT) < 0)
                    throw (SQLException)createException(
                        BIGDECIMAL_CONVERSION_ERROR).fillInStackTrace();

            setFieldData(field.encodeInt(value.unscaledValue().intValue()));
        } else
        if (fieldType == 3) {
            
            // check if value is withing bounds
            if (value.unscaledValue().compareTo(MAX_LONG) > 0 ||
                value.unscaledValue().compareTo(MIN_LONG) < 0)
                    throw (SQLException)createException(
                        BIGDECIMAL_CONVERSION_ERROR).fillInStackTrace();
            
            setFieldData(field.encodeLong(value.unscaledValue().longValue()));
        } else
            throw (SQLException)createException(
                BIGDECIMAL_CONVERSION_ERROR).fillInStackTrace();

    }



}