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-jdk17 Show documentation
Show all versions of jaybird-jdk17 Show documentation
JDBC Driver for the Firebird RDBMS
/*
* 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 org.firebirdsql.gds.XSQLVAR;
import java.sql.SQLException;
import java.math.BigDecimal;
import java.math.BigInteger;
/**
* 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();
}
}