Package simpleorm.dataset

Class SFieldBigDecimal

java.lang.Object

simpleorm.dataset.SFieldMeta

simpleorm.dataset.SFieldScalar

simpleorm.dataset.SFieldBigDecimal

All Implemented Interfaces:

Serializable

public class SFieldBigDecimal
extends SFieldScalar

Represents BigDecimal field meta data. Default SQL type is NUMERIC(precission, scale), which is roughly sql-92.

What is the best way to represent money ammounts exactly? Scaled longs are no good for direct end user queries on the database. Doubles tend to loose precission due to Java truncating instead of rounding -- things will not balance. And BigDecimals are inefficient and a real pain to use. Your choice.

See Also:

• Serialized Form

Field Summary

Fields inherited from class simpleorm.dataset.SFieldScalar

sqlDataTypeOverride, theGenerator

Fields inherited from class simpleorm.dataset.SFieldMeta

quoteName

Constructor Summary

Constructors

Constructor	Description
SFieldBigDecimal(SRecordMeta meta, String columnName, int precission, int scale, SFieldFlags... pvals)	Note that precission and scale parameters only affect how the tables are created.

Method Summary

Modifier and Type	Method	Description
protected Object	convertToDataSetFieldType(Object raw)	Converts the parameter from the raw type parameter to the correct internal Object type that is stored in the data set.
String	defaultSqlDataType()	This is basically SQL 2, and fairly database independent, we hope.
int	getPrecision()
int	getScale()
boolean	isFKeyCompatible(SFieldScalar field)
int	javaSqlType()
Object	queryFieldValue(ResultSet rs, int sqlIndex)	Issues a JDBC get*() on the result set for the field and converts the database type to the appropriate internal type, eg, Double for a double field.

Methods inherited from class simpleorm.dataset.SFieldScalar

getColumnName, getGeneratorMode, getGeneratorParameter, getMaxSize, getReferences, getTheGenerator, isForeignKey, isGenerated, isMandatory, isNotOptimisticLocked, isPrimary, overrideSqlDataType, setGeneratorMode, setMaxSize, setTheGenerator, toLongerString

Methods inherited from class simpleorm.dataset.SFieldMeta

addFlag, addValidator, doValidate, equals, getFieldName, getFlags, getRecordMeta, getUserProperties, getUserProperty, getValidators, hashCode, isDescriptive, isUnqueried, nextGeneratedValue, putUserProperty, readResolve, setQuoted, toString, writeFieldValue, writeFieldValue

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Constructor Details

SFieldBigDecimal

public SFieldBigDecimal(SRecordMeta meta,
 String columnName,
 int precission,
 int scale,
 SFieldFlags... pvals)

Note that precission and scale parameters only affect how the tables are created. The scale that is actually returned is up to JDBC. And then you are responsible for dealing with rounding issues.

Method Details

getPrecision

public int getPrecision()

getScale

public int getScale()

queryFieldValue

public Object queryFieldValue(ResultSet rs,
 int sqlIndex)
                       throws Exception

Description copied from class: SFieldMeta

Issues a JDBC get*() on the result set for the field and converts the database type to the appropriate internal type, eg, Double for a double field. The first column has sqlIndex==1.

Specified by:

queryFieldValue in class SFieldMeta

Throws:

Exception

convertToDataSetFieldType

protected Object convertToDataSetFieldType(Object raw)
                                    throws Exception

Description copied from class: SFieldMeta

Converts the parameter from the raw type parameter to the correct internal Object type that is stored in the data set. Returns the object if no conversion necessary. Used by SRecordInstance.setObject etc., Not getObject.

Specified by:

convertToDataSetFieldType in class SFieldMeta

Throws:

Exception

defaultSqlDataType

public String defaultSqlDataType()

This is basically SQL 2, and fairly database independent, we hope. Note that "BIGDECIMAL" for Oracle means a text field that can contain over 2K characters!

Specified by:

defaultSqlDataType in class SFieldScalar

isFKeyCompatible

public boolean isFKeyCompatible(SFieldScalar field)

javaSqlType

public int javaSqlType()

Specified by:

javaSqlType in class SFieldScalar

Returns:

int constant from java.sql.Types, used for setting sql datatype with null values