public interface Query extends Collection, Iterator, Query
Collection.Key
Modifier and Type | Field and Description |
---|---|
static int |
ORDER_ASC
Constant
ORDER_ASC , used for method sort |
static int |
ORDER_DESC
Constant
ORDER_DESC , used for method sort |
Modifier and Type | Method and Description |
---|---|
boolean |
addColumn(Collection.Key columnName,
Array content)
adds a new column to the resultset
|
boolean |
addColumn(Collection.Key columnName,
Array content,
int type)
adds a new column to the resultset
|
boolean |
addColumn(java.lang.String columnName,
Array content)
Deprecated.
|
boolean |
addColumn(java.lang.String columnName,
Array content,
int type)
Deprecated.
|
boolean |
addRow(int count)
adds a new row to the resultset
|
java.lang.Object |
clone() |
int |
executionTime()
Deprecated.
use
getExecutionTime() instead |
java.lang.Object |
getAt(Collection.Key key,
int row)
return a value of the resultset by specified column and row
|
java.lang.Object |
getAt(Collection.Key key,
int row,
java.lang.Object defaultValue)
return a value of the resultset by specified column and row, otherwise to getAt this method throw no exception if value dont exist (return null)
|
java.lang.Object |
getAt(java.lang.String key,
int row)
Deprecated.
use instead
|
java.lang.Object |
getAt(java.lang.String key,
int row,
java.lang.Object defaultValue)
Deprecated.
|
QueryColumn |
getColumn(Collection.Key key)
return the query column matching to key
|
QueryColumn |
getColumn(Collection.Key key,
QueryColumn column)
return the query column matching to key, if key not exist return null
|
QueryColumn |
getColumn(java.lang.String key)
Deprecated.
use instead
|
QueryColumn |
getColumn(java.lang.String key,
QueryColumn column)
Deprecated.
|
Collection.Key[] |
getColumnNames() |
java.lang.String[] |
getColumnNamesAsString() |
long |
getExecutionTime() |
Query |
getGeneratedKeys() |
Array |
getMetaDataSimple() |
SQL |
getSql() |
java.lang.String |
getTemplate() |
int[] |
getTypes() |
java.util.Map |
getTypesAsMap() |
int |
getUpdateCount() |
boolean |
isCached()
is query from cache or not
|
QueryColumn |
removeColumn(Collection.Key key)
remove column matching to key
|
QueryColumn |
removeColumn(java.lang.String key)
Deprecated.
use instead
|
QueryColumn |
removeColumnEL(Collection.Key key)
remove column matching to key
|
QueryColumn |
removeColumnEL(java.lang.String key)
Deprecated.
|
int |
removeRow(int row)
remove row from query
|
int |
removeRowEL(int row)
remove row from query
|
void |
rename(Collection.Key columnName,
Collection.Key newColumnName) |
java.lang.Object |
setAt(Collection.Key key,
int row,
java.lang.Object value)
set a value at the defined position
|
java.lang.Object |
setAt(java.lang.String key,
int row,
java.lang.Object value)
Deprecated.
|
java.lang.Object |
setAtEL(Collection.Key key,
int row,
java.lang.Object value)
set a value at the defined position
|
java.lang.Object |
setAtEL(java.lang.String key,
int row,
java.lang.Object value)
Deprecated.
|
void |
setCached(boolean isCached)
sets if query is form cache or not
|
void |
setExecutionTime(long l)
sets the execution Time of the query
|
void |
sort(Collection.Key column)
sorts a query by a column, direction is asc
|
void |
sort(Collection.Key strColumn,
int order)
sorts a query by a column
|
void |
sort(java.lang.String column)
Deprecated.
use instead
|
void |
sort(java.lang.String strColumn,
int order)
Deprecated.
use instead
|
clear, containsKey, containsKey, duplicate, get, get, get, get, keys, remove, removeEL, set, set, setEL, setEL, size
toDumpData
entryIterator, keyIterator, keysAsStringIterator, valueIterator
castToBoolean, castToBooleanValue, castToDateTime, castToDateTime, castToDoubleValue, castToDoubleValue, castToString, castToString, compareTo, compareTo, compareTo, compareTo
getIterator
getCurrentrow, getRecordcount, go, isEmpty, next, next, previous, reset, reset
addRow, getColumnIndex, getColumns, getData, getName, getRowCount, setData
absolute, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, close, deleteRow, findColumn, first, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getConcurrency, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getFetchDirection, getFetchSize, getFloat, getFloat, getHoldability, getInt, getInt, getLong, getLong, getMetaData, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getObject, getRef, getRef, getRow, getRowId, getRowId, getShort, getShort, getSQLXML, getSQLXML, getStatement, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, insertRow, isAfterLast, isBeforeFirst, isClosed, isFirst, isLast, last, moveToCurrentRow, moveToInsertRow, next, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setFetchDirection, setFetchSize, updateArray, updateArray, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateClob, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateRef, updateRef, updateRow, updateRowId, updateRowId, updateShort, updateShort, updateSQLXML, updateSQLXML, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp, wasNull
static final int ORDER_ASC
ORDER_ASC
, used for method sortstatic final int ORDER_DESC
ORDER_DESC
, used for method sortint getUpdateCount()
java.lang.Object getAt(java.lang.String key, int row) throws PageException
getAt(lucee.runtime.type.Collection.Key, int)
key
- column to getrow
- row to get from (1-recordcount)PageException
- if invalid position definitionjava.lang.Object getAt(Collection.Key key, int row) throws PageException
key
- column to getrow
- row to get from (1-recordcount)PageException
- if invalid position definitionjava.lang.Object getAt(java.lang.String key, int row, java.lang.Object defaultValue)
getAt(lucee.runtime.type.Collection.Key, int, Object)
key
- column to getrow
- row to get from (1-recordcount)java.lang.Object getAt(Collection.Key key, int row, java.lang.Object defaultValue)
key
- column to getrow
- row to get from (1-recordcount)java.lang.Object setAt(java.lang.String key, int row, java.lang.Object value) throws PageException
setAtEL(lucee.runtime.type.Collection.Key, int, Object)
key
- column to setrow
- row to setvalue
- value to fillPageException
java.lang.Object setAt(Collection.Key key, int row, java.lang.Object value) throws PageException
key
- column to setrow
- row to setvalue
- value to fillPageException
java.lang.Object setAtEL(java.lang.String key, int row, java.lang.Object value)
setAtEL(lucee.runtime.type.Collection.Key, int, Object)
key
- column to setrow
- row to setvalue
- value to filljava.lang.Object setAtEL(Collection.Key key, int row, java.lang.Object value)
key
- column to setrow
- row to setvalue
- value to fillboolean addRow(int count)
count
- count of rows to addint removeRow(int row) throws PageException
row
- PageException
int removeRowEL(int row)
row
- boolean addColumn(java.lang.String columnName, Array content) throws PageException
addColumn(lucee.runtime.type.Collection.Key, Array)
columnName
- name of the new columncontent
- content of the new column inside a array (must have same size like query has records)PageException
boolean addColumn(Collection.Key columnName, Array content) throws PageException
columnName
- name of the new columncontent
- content of the new column inside a array (must have same size like query has records)PageException
boolean addColumn(java.lang.String columnName, Array content, int type) throws PageException
addColumn(lucee.runtime.type.Collection.Key, Array, int)
columnName
- name of the new columncontent
- content of the new column inside a array (must have same size like query has records)type
- data type from (java.sql.Types)PageException
boolean addColumn(Collection.Key columnName, Array content, int type) throws PageException
columnName
- name of the new columncontent
- content of the new column inside a array (must have same size like query has records)type
- data type from (java.sql.Types)PageException
java.lang.Object clone()
clone
in interface Collection
int[] getTypes()
java.util.Map getTypesAsMap()
QueryColumn getColumn(java.lang.String key) throws PageException
getColumn(lucee.runtime.type.Collection.Key)
key
- key to getPageException
QueryColumn getColumn(Collection.Key key) throws PageException
key
- key to getPageException
QueryColumn getColumn(java.lang.String key, QueryColumn column)
getColumn(lucee.runtime.type.Collection.Key, QueryColumn)
key
- key to getQueryColumn getColumn(Collection.Key key, QueryColumn column)
key
- key to getQueryColumn removeColumn(java.lang.String key) throws PageException
removeColumn(lucee.runtime.type.Collection.Key)
key
- key to removePageException
QueryColumn removeColumn(Collection.Key key) throws PageException
key
- key to removePageException
QueryColumn removeColumnEL(java.lang.String key)
removeColumnEL(lucee.runtime.type.Collection.Key)
key
- key to removeQueryColumn removeColumnEL(Collection.Key key)
key
- key to removevoid setExecutionTime(long l)
l
- void sort(java.lang.String column) throws PageException
sort(lucee.runtime.type.Collection.Key)
column
- colun to sortPageException
void sort(Collection.Key column) throws PageException
column
- colun to sortPageException
void sort(java.lang.String strColumn, int order) throws PageException
sort(lucee.runtime.type.Collection.Key, int)
strColumn
- column to sortorder
- sort type (Query.ORDER_ASC or Query.ORDER_DESC)PageException
void sort(Collection.Key strColumn, int order) throws PageException
strColumn
- column to sortorder
- sort type (Query.ORDER_ASC or Query.ORDER_DESC)PageException
void setCached(boolean isCached)
isCached
- is cached or notboolean isCached()
Array getMetaDataSimple()
void rename(Collection.Key columnName, Collection.Key newColumnName) throws PageException
PageException
Collection.Key[] getColumnNames()
getColumnNames
in interface Query
java.lang.String[] getColumnNamesAsString()
getColumnNamesAsString
in interface Query
Query getGeneratedKeys()
SQL getSql()
java.lang.String getTemplate()
long getExecutionTime()
int executionTime()
getExecutionTime()
instead