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

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

int	geLimitRows()
void	orderBy(Field[] fieldOrds, int[] ascOrDescOperator)
void	orderBy(Field fieldOrd, int operator)
void	seLimitRows(int limit)
java.lang.String	toString(boolean parametrized) Returns the query in SQL language

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

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, getDescId, getGeneratedAt, getGenericAttr, getIcon, getIconName, getId, getLabel, getName, getO, getOrd, getVisibility, isDirty, isEnabled, isErased, isMandatory, isReadOnly, readFromFile, readFromStream, 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:

geLimitRows

public int geLimitRows()

seLimitRows

public void seLimitRows(int limit)

orderBy

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

orderBy

public void orderBy(Field fieldOrd,
                    int operator)