ca.spaz.sql
Class SQLSelectableStatement

java.lang.Object
  ca.spaz.sql.SQLStatement
      ca.spaz.sql.SQLSelectableStatement

Direct Known Subclasses:

SQLDelete, SQLSelect, SQLUpdate

public abstract class SQLSelectableStatement
extends SQLStatement

An abstract class encapsulating capabilities that are consistent across all selecting SQL statements.

Author:

Chris Rose

Field Summary

static java.lang.String	EQ
static java.lang.String	GT
static java.lang.String	LT

Fields inherited from class ca.spaz.sql.SQLStatement

table

Constructor Summary

protected

SQLSelectableStatement(java.lang.String table, boolean and, boolean querySupport, boolean executeSupport)

Method Summary

void	addWhere(java.lang.String name, char val)
void	addWhere(java.lang.String name, double val)
void	addWhere(java.lang.String name, int val)
void	addWhere(java.lang.String name, java.lang.Object val) Added a WHERE constraint to the SELECT command.
void	addWhere(java.lang.String name, java.lang.String op, char val)
void	addWhere(java.lang.String name, java.lang.String op, double val)
void	addWhere(java.lang.String name, java.lang.String op, int val)
void	addWhere(java.lang.String name, java.lang.String operator, java.lang.Object val)
void	addWhereLike(java.lang.String name, java.lang.String val) Added a WHERE constraint to the SELECT command.
protected java.lang.String	getWhere()

Methods inherited from class ca.spaz.sql.SQLStatement

doExecute, doExecuteQuery, execute, executeQuery, getQueryString, getTableName, isExecuteSupported, isQuerySupported, toString

Methods inherited from class java.lang.Object

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

Field Detail

EQ

public static final java.lang.String EQ

See Also:

Constant Field Values

GT

public static final java.lang.String GT

See Also:

Constant Field Values

LT

public static final java.lang.String LT

See Also:

Constant Field Values

Constructor Detail

SQLSelectableStatement

protected SQLSelectableStatement(java.lang.String table,
                                 boolean and,
                                 boolean querySupport,
                                 boolean executeSupport)

Method Detail

addWhere

public void addWhere(java.lang.String name,
                     java.lang.Object val)

Added a WHERE constraint to the SELECT command.

Parameters:

name - the field to constrain

val - the value this field must equal as a constraint

addWhere

public void addWhere(java.lang.String name,
                     java.lang.String operator,
                     java.lang.Object val)

addWhere

public void addWhere(java.lang.String name,
                     int val)

addWhere

public void addWhere(java.lang.String name,
                     java.lang.String op,
                     int val)

addWhere

public void addWhere(java.lang.String name,
                     double val)

addWhere

public void addWhere(java.lang.String name,
                     java.lang.String op,
                     double val)

addWhere

public void addWhere(java.lang.String name,
                     char val)

addWhere

public void addWhere(java.lang.String name,
                     java.lang.String op,
                     char val)

addWhereLike

public void addWhereLike(java.lang.String name,
                         java.lang.String val)

Added a WHERE constraint to the SELECT command.

Parameters:

name - the field to constrain

val - the value this field must be like

getWhere

protected java.lang.String getWhere()