com.irisel.oms.sql

Class SelectQuery

java.lang.Object

com.irisel.util.BaseBean

com.irisel.oms.olapi.beans.XMLBean

com.irisel.oms.sql.Query

com.irisel.oms.sql.SelectQuery

All Implemented Interfaces:

XMLBean, java.io.Serializable

public class SelectQuery
extends Query

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 inherited from class com.irisel.oms.sql.Query

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
SelectQuery() Constructor
SelectQuery(Field[] target) Constructor Creation date: (21/10/02 21:54:21)
SelectQuery(Field[] target, Filter[][] filters) Constructor Creation date: (21/10/02 21:54:21)
SelectQuery(Field[] target, Filter[][][] filters)
SelectQuery(Field[] target, Filter[][][] filters, Option[] options) Constructor Creation date: (21/10/02 21:54:21)
SelectQuery(Field[] target, Filter[][] filters, Option[] options)

Method Summary

Modifier and Type	Method and Description
int	getLimitRows()
void	orderBy(Field[] fieldOrds, int[] ascOrDescOperator)
void	orderBy(Field fieldOrd, int operator)
void	setLimitRows(int limit)
java.lang.String	toString(boolean parametrized) Returns the query in SQL language

Methods inherited from class com.irisel.oms.sql.Query

addFilter, addFilter, chkDeps, getChilds, getChildsDeep, getDbType, getFilters, getKeyword, getOptions, getTarget, getTargetTables, getTargetTablesText, getTime, getTimestamp, getTimeStr, propagateDbType, setDbType, setException, setFilter, setFilter, setFilters, setFilters, setFilters, setKeyword, setOptions, setTarget, setTarget, toString, whereToString

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

Constructor Detail

SelectQuery

public SelectQuery()

Constructor

SelectQuery

public SelectQuery(Field[] target)

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

Parameters:

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

SelectQuery

public SelectQuery(Field[] target,
                   Filter[][] filters)

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

Parameters:

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

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

SelectQuery

public SelectQuery(Field[] target,
                   Filter[][][] filters)

SelectQuery

public SelectQuery(Field[] target,
                   Filter[][][] filters,
                   Option[] options)

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

Parameters:

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

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

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

SelectQuery

public SelectQuery(Field[] target,
                   Filter[][] filters,
                   Option[] options)

Method Detail

toString

public java.lang.String toString(boolean parametrized)

Description copied from class: Query

Returns the query in SQL language

Specified by:

toString in class Query

Parameters:

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

Returns:

getLimitRows

public int getLimitRows()

setLimitRows

public void setLimitRows(int limit)

orderBy

public void orderBy(Field[] fieldOrds,
                    int[] ascOrDescOperator)

orderBy

public void orderBy(Field fieldOrd,
                    int operator)