org.brains2b.sql.meta

Class TypesInfo

java.lang.Object

org.brains2b.sql.meta.TypesInfo

public class TypesInfo
extends java.lang.Object

Types to Java Static class to translate java.sql.Types into appropriate Java types At the moment only primitives, String and java.sql.Date,Time,Timestamp are used

Version:

0.32.1 [13-04-2008]

Author:

dennis@brains2b.nl

Field Summary

Fields

Modifier and Type	Field and Description
static TypesInfo	DEFAULT
static int	LARGE
static int	OPTIMIZE
static int	SMALLEST

Constructor Summary

Constructors

Constructor and Description
TypesInfo(java.sql.Connection con)

Method Summary

Modifier and Type	Method and Description
java.lang.String	getAutoIncrement()
int	getDataType(java.lang.Class c) get the java.sql.Types value for a given class
int	getDataType(java.lang.String typeName, int columnSize, int decimaldigits) get the closest datatype for a field given the typename, columSize and decimal digits
Database	getDb()
java.lang.Class	getJavaType(int dataType, int columnsize, int decimaldigits) gets a Class as a valid java type on the basis of JDBC column information
java.lang.String	getJavaTypeName(int dataType, int columnsize, int decimaldigits) gets a String representation of a valid java type on the basis of JDBC column information
java.lang.String	getLimitRows(int count)
java.lang.String	getSQLType(int dataType, int columnSize, int decimaldigits)
TypeModel	getTypeModel(int dataType, int columnSize, int decimaldigits)
java.util.Collection	getTypeNames()
java.util.List<TypeModel>	getTypes()
boolean	isKeyWord(java.lang.String s)
boolean	isPrimitive(int dataType) get the JavaType for a specific dataType as defined in java.sql.Types
void	setDataModel(int dataModel)
boolean	supportsPseudoIdentifier()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

DEFAULT

public static final TypesInfo DEFAULT

SMALLEST

public static final int SMALLEST

See Also:

Constant Field Values

OPTIMIZE

public static final int OPTIMIZE

See Also:

Constant Field Values

LARGE

public static final int LARGE

See Also:

Constant Field Values

Constructor Detail

TypesInfo

public TypesInfo(java.sql.Connection con)

Method Detail

getDataType

public int getDataType(java.lang.Class c)

get the java.sql.Types value for a given class

Parameters:

c - Class, the class for which the java.sql.Types value is requested

Returns:

int, a number representing a constant from java.sql.Types

getJavaTypeName

public java.lang.String getJavaTypeName(int dataType,
                                        int columnsize,
                                        int decimaldigits)

gets a String representation of a valid java type on the basis of JDBC column information

Normally the dataType is enough to make a good determination, except in the case of Numbers.

For numbers the following rules appy
• If decimaldigits is 0 and columnsize < 10 the number is made into an int
• If decimaldigits is 0 and columnsize > 10 the number is made into a long
• If decimaldigits > 0 and columnsize < 10 the number is made into a float
• If decimaldigits > 0 and columnsize > 10 the number is made into a double

  Types.OTHER is returned as a generic Object.

  Note:Please be sure to understand that not all Types are defined and translated here if you miss one add it yourself or mail me.

Parameters:

dataType - int, A valid datatype from java.sql.Types

columnsize - int, The length of the column

decimaldigits - int, The number of decimal digits

Returns:

String, the String representation of a valid Java type.

isPrimitive

public boolean isPrimitive(int dataType)

get the JavaType for a specific dataType as defined in java.sql.Types

This method returns only one of two values PRIMITIVE or CLASS

Parameters:

dataType - int, the datatype as defined in java.sql.Types

Returns:

int, the java type for the dataType submitted, either returns one of the constants PRIMITIVE or CLASS

Note:Please be sure to understand that the determination is not done for all Types if you miss one add it yourself or mail me.

getJavaType

public java.lang.Class getJavaType(int dataType,
                                   int columnsize,
                                   int decimaldigits)

gets a Class as a valid java type on the basis of JDBC column information

Normally the dataType is enough to make a good determination, except in the case of Numbers.

For numbers the following rules appy
• If decimaldigits is 0 and columnsize < 22 the number is made into an int
• If decimaldigits is 0 and columnsize > 22 the number is made into a long
• If decimaldigits > 0 and columnsize < 22 the number is made into a float
• If decimaldigits > 0 and columnsize > 22 the number is made into a double

  Types.OTHER is returned as a generic Object.

  Note:Please be sure to understand that not all Types are defined and translated here if you miss one add it yourself or mail me.

Parameters:

dataType - int, A valid datatype from java.sql.Types

columnsize - int, The length of the column

decimaldigits - int, The number of decimal digits

Returns:

Class, the class representing a valid data-type for Java. Will return the "WrapperClass".TYPE for primitives

getLimitRows

public java.lang.String getLimitRows(int count)

supportsPseudoIdentifier

public boolean supportsPseudoIdentifier()

getAutoIncrement

public java.lang.String getAutoIncrement()

getSQLType

public java.lang.String getSQLType(int dataType,
                                   int columnSize,
                                   int decimaldigits)

getTypeModel

public TypeModel getTypeModel(int dataType,
                              int columnSize,
                              int decimaldigits)

getDataType

public int getDataType(java.lang.String typeName,
                       int columnSize,
                       int decimaldigits)

get the closest datatype for a field given the typename, columSize and decimal digits

Parameters:

typeName - String, the typename as given by the database

columnSize - int, column length

decimaldigits - int, the decimal digits for this type

Returns:

int, a type as defined in java.sql.Types

Since:

Squeler 1.03

getTypeNames

public java.util.Collection getTypeNames()

getTypes

public java.util.List<TypeModel> getTypes()

setDataModel

public void setDataModel(int dataModel)

isKeyWord

public boolean isKeyWord(java.lang.String s)

getDb

public Database getDb()