Package com.mckoi.database.global
Class CastHelper
- java.lang.Object
-
- com.mckoi.database.global.CastHelper
-
public class CastHelper extends java.lang.Object
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 Constructor Description CastHelper()
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description static java.lang.Object
castObjectToSQLType(java.lang.Object ob, int sql_type, int sql_size, int sql_scale, java.lang.String sql_type_string)
Casts a Java object to the SQL type specified by the given DataTableColumnDef object.static java.util.Date
toDate(java.lang.String str)
Parses a String as an SQL date.static java.util.Date
toTime(java.lang.String str)
Parses a String as an SQL time.static java.util.Date
toTimeStamp(java.lang.String str)
Parses a String as an SQL timestamp.
-
-
-
Method Detail
-
toDate
public static java.util.Date toDate(java.lang.String str)
Parses a String as an SQL date.
-
toTime
public static java.util.Date toTime(java.lang.String str)
Parses a String as an SQL time.
-
toTimeStamp
public static java.util.Date toTimeStamp(java.lang.String str)
Parses a String as an SQL timestamp.
-
castObjectToSQLType
public static java.lang.Object castObjectToSQLType(java.lang.Object ob, int sql_type, int sql_size, int sql_scale, java.lang.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"
-
-