com.irisel.oms.sql

Class Query

java.lang.Object

com.irisel.util.BaseBean

com.irisel.oms.olapi.beans.XMLBean

com.irisel.oms.sql.Query

All Implemented Interfaces:

XMLBean, java.io.Serializable

Direct Known Subclasses:

AlterTableQuery, CreateTableQuery, DeleteQuery, DropTableQuery, InsertQuery, SelectQuery, UpdateQuery

public abstract class Query
extends XMLBean
implements java.io.Serializable

This class is used to generate, store and analyze SQL statements. Creation date: (21/10/02 21:17:23)

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	PARAM_PLACEHOLDER

Fields inherited from class com.irisel.oms.olapi.beans.XMLBean

CLASSNAME, CLASSTYPE, DEFAULT_VISIBILITY, NOT_VISIBLE, VISIBLE

Fields inherited from interface com.irisel.util.XMLBean

CSV

Constructor Summary

Constructors

Constructor and Description
Query() Constructor
Query(int keyword, Field[] target, Filter[][][] filters, Option[] options)
Query(int keyword, Field[] target, Filter[][] filters, Option[] options) Constructor Creation date: (21/10/02 21:54:21)
Query(java.lang.String s)

Method Summary

Modifier and Type	Method and Description
void	addFilter(Field f, int op)
void	addFilter(Filter f)
boolean	chkDeps() Check dependencies in this query (filters correctness, etc.) Creation date: (21/10/02 21:52:11)
Query[]	getChilds() Returns array of 1st-level child Querys.
Query[]	getChildsDeep() Returns array of child Querys (recursively).
java.lang.String	getDbType() Getter for property dbType.
Filter[][][]	getFilters() Returns array of filters Creation date: (21/10/02 21:46:36)
int	getKeyword() Returns int constant associated with query's method keyword i.e.Keyword.SELECT, Keyword.INSERT, etc.
Option[]	getOptions() Returns array of Options.
Field[]	getTarget() Returns array of target fields: fields selected, updated, etc.
java.util.Vector	getTargetTables() Returns the names of the tables used.
java.lang.String	getTargetTablesText() Returns the names of the tables used, as String.
static java.sql.Time	getTime()
static java.sql.Timestamp	getTimestamp()
static java.lang.String	getTimeStr()
void	propagateDbType()
void	setDbType(java.lang.String dbType) Setter for property dbType.
void	setException(java.sql.SQLException e)
void	setFilter(Field f, int op)
void	setFilter(Filter f)
void	setFilters(Filter[] filters)
void	setFilters(Filter[][] filters)
void	setFilters(Filter[][][] filters) Sets filters as a 2-dimensional array of Filter objects applied in this way: ( filters(1,1,1) AND filters (1,1,2) AND...AND filters (1,1,m) ) OR ( filters(1,2,1) AND filters (1,2,2) AND...AND filters (1,2,m) ) (...) OR ( filters(1,n,1) AND filters (1,n,2) AND...AND filters (1,n,m) ) AND ( ( filters(2,1,1) AND filters (2,1,2) AND...AND filters (2,1,m) ) OR ( filters(2,2,1) AND filters (2,2,2) AND...AND filters (2,2,m) ) (...) OR ( filters(2,n,1) AND filters (2,n,2) AND...AND filters (2,n,m) ) ) AND ( ...
void	setKeyword(int newKeyword) Sets keyword (type of query).
void	setOptions(Option[] newOptions) Set options.
void	setTarget(Field newTarget) Set target fields.
void	setTarget(Field[] newTarget) Set target fields.
java.lang.String	toString() Returns the query in SQL language.
abstract java.lang.String	toString(boolean parametrized) Returns the query in SQL language
java.lang.String	whereToString(boolean parametrized)

Methods inherited from class com.irisel.oms.olapi.beans.XMLBean

copyToInstance, export2csv, getComments, getDescId, getGeneratedAt, getGenericAttr, getIcon, getIconName, getId, getLabel, getName, getO, getOrd, getVisibility, isDirty, isEnabled, isErased, isMandatory, isReadOnly, readFromFile, readFromStream, refreshMyLabel, refreshMyLabel, setComments, setDescId, setDirty, setEnabled, setErased, setGeneratedAt, setGenericAttr, setIcon, setIconName, setId, setLabel, setName, setO, setOrd, setVisibility, updateFromInstance, writeToFile, writeToStream, xmlSerialize

Methods inherited from class com.irisel.util.BaseBean

decode64, decode64bin, encode64, encode64bin, readObject, readObject64, toBean, toByteArray, toJSON, toJSONObject, toXML

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

PARAM_PLACEHOLDER

public static final java.lang.String PARAM_PLACEHOLDER

See Also:

Constant Field Values

Constructor Detail

Query

public Query()

Constructor

Query

public Query(int keyword,
             Field[] target,
             Filter[][] filters,
             Option[] options)

Constructor Creation date: (21/10/02 21:54:21)

Parameters:

keyword - com.irisel.oms.sql.Keyword

target - com.irisel.oms.sql.Field[]

filters - com.irisel.oms.sql.Filter[]

options - com.irisel.oms.sql.Option[]

Query

public Query(int keyword,
             Field[] target,
             Filter[][][] filters,
             Option[] options)

Query

public Query(java.lang.String s)

Method Detail

chkDeps

public boolean chkDeps()
                throws QueryException

Check dependencies in this query (filters correctness, etc.) Creation date: (21/10/02 21:52:11)

Returns:

boolean

Throws:

QueryException

getChilds

public Query[] getChilds()

Returns array of 1st-level child Querys. Creation date: (21/10/02 21:49:17)

Returns:

com.irisel.oms.sql.Query[]

getChildsDeep

public Query[] getChildsDeep()

Returns array of child Querys (recursively). Creation date: (21/10/02 21:49:47)

Returns:

com.irisel.oms.sql.Query[]

getFilters

public Filter[][][] getFilters()

Returns array of filters Creation date: (21/10/02 21:46:36)

Returns:

com.irisel.oms.sql.Filter[][]

See Also:

Filter

getKeyword

public int getKeyword()

Returns int constant associated with query's method keyword i.e.Keyword.SELECT, Keyword.INSERT, etc. Creation date: (21/10/02 21:44:25)

Returns:

com.irisel.oms.sql.Keyword

See Also:

Keyword

getOptions

public Option[] getOptions()

Returns array of Options. Creation date: (21/10/02 21:46:55)

Returns:

com.irisel.oms.sql.Option[]

See Also:

Option

getTarget

public Field[] getTarget()

Returns array of target fields: fields selected, updated, etc. Creation date: (21/10/02 21:46:19)

Returns:

com.irisel.oms.sql.Field[]

See Also:

Field

getTargetTables

public java.util.Vector getTargetTables()

Returns the names of the tables used. Creation date: (21/10/02 21:48:36)

Returns:

java.lang.String[]

getTargetTablesText

public java.lang.String getTargetTablesText()

Returns the names of the tables used, as String. Creation date: (21/10/02 21:48:36)

Returns:

java.lang.String[]

setFilters

public void setFilters(Filter[][][] filters)

Sets filters as a 2-dimensional array of Filter objects applied in this way: ( filters(1,1,1) AND filters (1,1,2) AND...AND filters (1,1,m) ) OR ( filters(1,2,1) AND filters (1,2,2) AND...AND filters (1,2,m) ) (...) OR ( filters(1,n,1) AND filters (1,n,2) AND...AND filters (1,n,m) ) AND ( ( filters(2,1,1) AND filters (2,1,2) AND...AND filters (2,1,m) ) OR ( filters(2,2,1) AND filters (2,2,2) AND...AND filters (2,2,m) ) (...) OR ( filters(2,n,1) AND filters (2,n,2) AND...AND filters (2,n,m) ) ) AND ( ... ) Creation date: (21/10/02 21:46:36)

Parameters:

filters - com.irisel.oms.sql.Filter[][]

See Also:

Filter

setFilters

public void setFilters(Filter[][] filters)

setFilters

public void setFilters(Filter[] filters)

setFilter

public void setFilter(Filter f)

setFilter

public void setFilter(Field f,
                      int op)

addFilter

public void addFilter(Field f,
                      int op)

addFilter

public void addFilter(Filter f)

setKeyword

public void setKeyword(int newKeyword)

Sets keyword (type of query). Creation date: (21/10/02 21:44:25)

Parameters:

newKeywords - com.irisel.oms.sql.Keyword

See Also:

Keyword

setOptions

public void setOptions(Option[] newOptions)

Set options. Creation date: (21/10/02 21:46:55)

Parameters:

newOptions - com.irisel.oms.sql.Option[]

See Also:

Option

setTarget

public void setTarget(Field[] newTarget)

Set target fields. Creation date: (21/10/02 21:46:19)

Parameters:

newTarget - com.irisel.oms.sql.Field[]

See Also:

Field

setTarget

public void setTarget(Field newTarget)

Set target fields. Creation date: (21/10/02 21:46:19)

Parameters:

newTarget - com.irisel.oms.sql.Field[]

See Also:

Field

toString

public java.lang.String toString()

Returns the query in SQL language.

Overrides:

toString in class XMLBean

Returns:

the query in SQL language

toString

public abstract java.lang.String toString(boolean parametrized)

Returns the query in SQL language

Parameters:

parametrized - if true returns sql with placeholders for the values of the filters

Returns:

whereToString

public java.lang.String whereToString(boolean parametrized)

getDbType

public java.lang.String getDbType()

Getter for property dbType.

Returns:

Value of property dbType.

propagateDbType

public void propagateDbType()

setDbType

public void setDbType(java.lang.String dbType)

Setter for property dbType.

Parameters:

dbType - New value of property dbType.

getTimestamp

public static java.sql.Timestamp getTimestamp()

getTime

public static java.sql.Time getTime()

getTimeStr

public static java.lang.String getTimeStr()

setException

public void setException(java.sql.SQLException e)