org.openware.job.data
Class Converter

java.lang.Object
  |
  +--org.openware.job.data.Converter

All Implemented Interfaces:

java.io.Serializable

Direct Known Subclasses:

OracleConverter, PostgresConverter

public abstract class Converter

extends java.lang.Object

implements java.io.Serializable

Abstract class to convert between an internal type (which is just a Java String object), Java native types (and Date types), and values suitable for SQL statement consumption.

You will put all of the oddities for dealing with these conversions in subclasses of Converter. There will likely be one per different type of database.

Version:

$Revision: 1.5 $ $Date: 2001/04/26 06:31:58 $

Author:

Vincent Sheffer

See Also:

Serialized Form

Constructor Summary

Converter()

Method Summary

java.lang.String	booleanToInternal(boolean value)
abstract java.lang.String	booleanToSql(java.lang.String value) Get a SQL value for the given boolean as an internal value suitable for a SQL statement.
abstract java.lang.String	dateColumnName(java.lang.String columnName, java.lang.String alias) Select statements with Date types need to convert the date to a known format.
java.lang.String	dateToInternal(java.util.Date date) Return an internal value (of type String) for the java.util.Date.
abstract java.lang.String	dateToSql(java.lang.String value) Get a SQL value for the given Date as an internal value suitable for a SQL statement.
java.lang.String	doubleToInternal(double value)
static java.lang.String	escapeWhereClause(java.lang.String whereClause) Return an escaped string for a where clause.
java.lang.String	floatToInternal(float value)
boolean	internalToBoolean(java.lang.String value)
java.util.Date	internalToDate(java.lang.String value) Convert an internal date value to a java.util.Date value.
double	internalToDouble(java.lang.String value)
float	internalToFloat(java.lang.String value)
int	internalToInt(java.lang.String value)
long	internalToLong(java.lang.String value)
java.lang.String	internalToString(java.lang.String value)
java.lang.String	intToInternal(int value)
java.lang.String	longToInternal(long value)
abstract java.lang.String	numberToSql(java.lang.String value) Get a SQL value for the given number as an internal value suitable for a SQL statement.
protected java.lang.String	replaceStr(java.lang.String str, java.lang.String rep, java.lang.String with)
java.lang.String	stringToInternal(java.lang.String value)
abstract java.lang.String	stringToSql(java.lang.String value) Get a SQL value for the given String as an internal value suitable for a SQL statement.
abstract java.lang.String	translateWhereClause(java.lang.String whereClause) Translate the where clause from some known syntax to the desired database.

Methods inherited from class java.lang.Object

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

Constructor Detail

Converter

public Converter()

Method Detail

internalToString

public java.lang.String internalToString(java.lang.String value)

internalToInt

public int internalToInt(java.lang.String value)

internalToLong

public long internalToLong(java.lang.String value)

internalToFloat

public float internalToFloat(java.lang.String value)

internalToDouble

public double internalToDouble(java.lang.String value)

internalToBoolean

public boolean internalToBoolean(java.lang.String value)

internalToDate

public java.util.Date internalToDate(java.lang.String value)

Convert an internal date value to a java.util.Date value.

The format for the date must be 'EEE dd MMM yyyy HH:mm:ss'.

Parameters:

value - The internal date value.

Returns:

The value converted to a java.util.Date.

dateToInternal

public java.lang.String dateToInternal(java.util.Date date)

Return an internal value (of type String) for the java.util.Date.

NOTE: The format of the returned value will be 'EEE dd MMM yyyy HH:mm:ss'.

Parameters:

date - The original Date object to convert.

The - internal value (String type).

intToInternal

public java.lang.String intToInternal(int value)

longToInternal

public java.lang.String longToInternal(long value)

floatToInternal

public java.lang.String floatToInternal(float value)

doubleToInternal

public java.lang.String doubleToInternal(double value)

booleanToInternal

public java.lang.String booleanToInternal(boolean value)

stringToInternal

public java.lang.String stringToInternal(java.lang.String value)

escapeWhereClause

public static java.lang.String escapeWhereClause(java.lang.String whereClause)

Return an escaped string for a where clause. Override this if your database uses something other than "'" to escape single quotes.

replaceStr

protected java.lang.String replaceStr(java.lang.String str,
                                      java.lang.String rep,
                                      java.lang.String with)

translateWhereClause

public abstract java.lang.String translateWhereClause(java.lang.String whereClause)

Translate the where clause from some known syntax to the desired database.

dateColumnName

public abstract java.lang.String dateColumnName(java.lang.String columnName,
                                                java.lang.String alias)

Select statements with Date types need to convert the date to a known format. Usually, the SQL 'to_char' method is used to do this. This method will return a date type SELECT column appropriate for this purpose.

dateToSql

public abstract java.lang.String dateToSql(java.lang.String value)

Get a SQL value for the given Date as an internal value suitable for a SQL statement.

Parameters:

string - The internal value to convert to a SQL value.

numberToSql

public abstract java.lang.String numberToSql(java.lang.String value)

Get a SQL value for the given number as an internal value suitable for a SQL statement.

Parameters:

string - The internal value to convert to a SQL value.

booleanToSql

public abstract java.lang.String booleanToSql(java.lang.String value)

Get a SQL value for the given boolean as an internal value suitable for a SQL statement.

Parameters:

string - The internal value to convert to a SQL value.

stringToSql

public abstract java.lang.String stringToSql(java.lang.String value)

Get a SQL value for the given String as an internal value suitable for a SQL statement.

Parameters:

string - The internal value to convert to a SQL value.