Package com.mckoi.database.global
Class CastHelper
java.lang.Object
com.mckoi.database.global.CastHelper
Various utility methods for helping to cast a Java object to a type that
is conformant to an SQL type.
- Author:
- Tobias Downer
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionstatic Object
castObjectToSQLType
(Object ob, int sql_type, int sql_size, int sql_scale, String sql_type_string) Casts a Java object to the SQL type specified by the given DataTableColumnDef object.static Date
Parses a String as an SQL date.static Date
Parses a String as an SQL time.static Date
toTimeStamp
(String str) Parses a String as an SQL timestamp.
-
Constructor Details
-
CastHelper
public CastHelper()
-
-
Method Details
-
toDate
Parses a String as an SQL date. -
toTime
Parses a String as an SQL time. -
toTimeStamp
Parses a String as an SQL timestamp. -
castObjectToSQLType
public static Object castObjectToSQLType(Object ob, int sql_type, int sql_size, int sql_scale, String sql_type_string) Casts a Java object to the SQL type specified by the given DataTableColumnDef object. This is used for the following engine functions;- To prepare a value for insertion into the data store. For example, the table column may be STRING but the value here is a BigNumber.
- To cast an object to a specific type in an SQL function such as CAST.
- Parameters:
ob
- the Object to cast to the given typesql_type
- the enumerated sql type, eg. SQLTypes.LONGVARCHARsql_size
- the size of the type. For example, CHAR(20)sql_scale
- the scale of the numerical type.sql_type_string
- 'sql_type' as a human understandable string, eg. "LONGVARCHAR"
-