|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface Query
inteface for resultset (query) object
Nested Class Summary |
---|
Nested classes/interfaces inherited from interface railo.runtime.type.Collection |
---|
Collection.Key |
Field Summary | |
---|---|
static int |
ORDER_ASC
Constant ORDER_ASC , used for method sort |
static int |
ORDER_DESC
Constant ORDER_DESC , used for method sort |
Fields inherited from interface java.sql.ResultSet |
---|
CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE |
Method Summary | |
---|---|
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(String columnName,
Array content)
Deprecated. use instead
|
boolean |
addColumn(String columnName,
Array content,
int type)
Deprecated. use instead
|
boolean |
addRow(int count)
adds a new row to the resultset |
Object |
clone()
|
int |
executionTime()
|
Object |
getAt(Collection.Key key,
int row)
return a value of the resultset by specified column and row |
Object |
getAt(Collection.Key key,
int row,
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) |
Object |
getAt(String key,
int row)
Deprecated. use instead
|
Object |
getAt(String key,
int row,
Object defaultValue)
Deprecated. use instead
|
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(String key)
Deprecated. use instead
|
QueryColumn |
getColumn(String key,
QueryColumn column)
Deprecated. use instead
|
Array |
getMetaDataSimple()
|
int[] |
getTypes()
|
Map |
getTypesAsMap()
|
int |
getUpdateCount()
|
boolean |
isCached()
is query from cache or not |
QueryColumn |
removeColumn(Collection.Key key)
remove column matching to key |
QueryColumn |
removeColumn(String key)
Deprecated. use instead
|
QueryColumn |
removeColumnEL(Collection.Key key)
remove column matching to key |
QueryColumn |
removeColumnEL(String key)
Deprecated. use instead
|
int |
removeRow(int row)
remove row from query |
int |
removeRowEL(int row)
remove row from query |
Object |
setAt(Collection.Key key,
int row,
Object value)
set a value at the defined position |
Object |
setAt(String key,
int row,
Object value)
Deprecated. use instead
|
Object |
setAtEL(Collection.Key key,
int row,
Object value)
set a value at the defined position |
Object |
setAtEL(String key,
int row,
Object value)
Deprecated. use instead
|
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(String column)
Deprecated. use instead
|
void |
sort(String strColumn,
int order)
Deprecated. use instead
|
Methods inherited from interface railo.runtime.type.Collection |
---|
clear, containsKey, containsKey, duplicate, get, get, get, get, keys, keysAsString, remove, removeEL, set, set, setEL, setEL, size |
Methods inherited from interface railo.runtime.dump.Dumpable |
---|
toDumpData |
Methods inherited from interface railo.runtime.type.Iteratorable |
---|
iterator, keyIterator, valueIterator |
Methods inherited from interface railo.runtime.op.Castable |
---|
castToBoolean, castToBooleanValue, castToDateTime, castToDateTime, castToDoubleValue, castToDoubleValue, castToString, castToString, compareTo, compareTo, compareTo, compareTo |
Methods inherited from interface railo.runtime.type.Iterator |
---|
getCurrentrow, getRecordcount, go, go, isEmpty, next, next, reset, reset |
Methods inherited from interface com.allaire.cfx.Query |
---|
addRow, getColumnIndex, getColumns, getData, getName, getRowCount, setData |
Methods inherited from interface java.sql.Wrapper |
---|
isWrapperFor, unwrap |
Field Detail |
---|
static final int ORDER_ASC
ORDER_ASC
, used for method sort
static final int ORDER_DESC
ORDER_DESC
, used for method sort
Method Detail |
---|
int getUpdateCount()
Object getAt(String key, int row) throws PageException
getAt(railo.runtime.type.Collection.Key, int)
key
- column to getrow
- row to get from (1-recordcount)
PageException
- if invalid position definitionObject getAt(Collection.Key key, int row) throws PageException
key
- column to getrow
- row to get from (1-recordcount)
PageException
- if invalid position definitionObject getAt(String key, int row, Object defaultValue)
getAt(railo.runtime.type.Collection.Key, int, Object)
key
- column to getrow
- row to get from (1-recordcount)
Object getAt(Collection.Key key, int row, Object defaultValue)
key
- column to getrow
- row to get from (1-recordcount)
Object setAt(String key, int row, Object value) throws PageException
setAtEL(railo.runtime.type.Collection.Key, int, Object)
key
- column to setrow
- row to setvalue
- value to fill
PageException
Object setAt(Collection.Key key, int row, Object value) throws PageException
key
- column to setrow
- row to setvalue
- value to fill
PageException
Object setAtEL(String key, int row, Object value)
setAtEL(railo.runtime.type.Collection.Key, int, Object)
key
- column to setrow
- row to setvalue
- value to fill
Object setAtEL(Collection.Key key, int row, Object value)
key
- column to setrow
- row to setvalue
- value to fill
boolean addRow(int count)
count
- count of rows to add
int removeRow(int row) throws PageException
row
-
PageException
int removeRowEL(int row)
row
-
boolean addColumn(String columnName, Array content) throws PageException
addColumn(railo.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(String columnName, Array content, int type) throws PageException
addColumn(railo.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
Object clone()
clone
in interface Collection
int[] getTypes()
Map getTypesAsMap()
QueryColumn getColumn(String key) throws PageException
getColumn(railo.runtime.type.Collection.Key)
key
- key to get
PageException
QueryColumn getColumn(Collection.Key key) throws PageException
key
- key to get
PageException
QueryColumn getColumn(String key, QueryColumn column)
getColumn(railo.runtime.type.Collection.Key, QueryColumn)
key
- key to get
QueryColumn getColumn(Collection.Key key, QueryColumn column)
key
- key to get
QueryColumn removeColumn(String key) throws PageException
removeColumn(railo.runtime.type.Collection.Key)
key
- key to remove
PageException
QueryColumn removeColumn(Collection.Key key) throws PageException
key
- key to remove
PageException
QueryColumn removeColumnEL(String key)
removeColumnEL(railo.runtime.type.Collection.Key)
key
- key to remove
QueryColumn removeColumnEL(Collection.Key key)
key
- key to remove
int executionTime()
void setExecutionTime(long l)
l
- void sort(String column) throws PageException
sort(railo.runtime.type.Collection.Key)
column
- colun to sort
PageException
void sort(Collection.Key column) throws PageException
column
- colun to sort
PageException
void sort(String strColumn, int order) throws PageException
sort(railo.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()
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |