net.jot.persistance
Class JOTSQLCondition

java.lang.Object
  net.jot.persistance.JOTSQLCondition

public class JOTSQLCondition
extends java.lang.Object

Defines a single DB condition, as used in an SQL 'where' closed
ie: 'firstname' IS_EQUAL 'John'

Author:

Thibaut Colar http://jot.colar.net/

Field Summary

static int	IS_EQUAL
static int	IS_GREATER
static int	IS_GREATER_OR_EQUAL
static int	IS_LIKE
static int	IS_LOWER
static int	IS_LOWER_OR_EQUAL
static int	IS_NOT_EQUAL

Constructor Summary

JOTSQLCondition(java.lang.String field, int comparaison, java.lang.Object value)
Create an SQL condition(used in where statement)

Method Summary

int	getComparaison()
java.lang.String	getField()
java.lang.String	getSQLComparator() Return the comparator in SQL form example: getSQLComparator() for IS_GREATER will return " > ? "
java.lang.Object	getValue()

Methods inherited from class java.lang.Object

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

Field Detail

IS_EQUAL

public static final int IS_EQUAL

See Also:

Constant Field Values

IS_NOT_EQUAL

public static final int IS_NOT_EQUAL

See Also:

Constant Field Values

IS_GREATER

public static final int IS_GREATER

See Also:

Constant Field Values

IS_LOWER

public static final int IS_LOWER

See Also:

Constant Field Values

IS_GREATER_OR_EQUAL

public static final int IS_GREATER_OR_EQUAL

See Also:

Constant Field Values

IS_LOWER_OR_EQUAL

public static final int IS_LOWER_OR_EQUAL

See Also:

Constant Field Values

IS_LIKE

public static final int IS_LIKE

See Also:

Constant Field Values

Constructor Detail

JOTSQLCondition

public JOTSQLCondition(java.lang.String field,
                       int comparaison,
                       java.lang.Object value)

Create an SQL condition(used in where statement)

Parameters:

field - ie: 'firstname'

comparaison - ie: IS_EQUAL

value - ie: 'John'

Method Detail

getComparaison

public int getComparaison()

getField

public java.lang.String getField()

getValue

public java.lang.Object getValue()

getSQLComparator

public java.lang.String getSQLComparator()

Return the comparator in SQL form example: getSQLComparator() for IS_GREATER will return " > ? "

Returns: