|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectrailo.runtime.type.QueryImpl
railo.runtime.query.QueryCacheQuery
public class QueryCacheQuery
Nested Class Summary |
---|
Nested classes/interfaces inherited from interface railo.runtime.type.Collection |
---|
Collection.Key |
Field Summary |
---|
Fields inherited from class railo.runtime.type.QueryImpl |
---|
CACHED, COLUMNLIST, COLUMNS, CURRENTROW, EXECUTION_TIME, GENERATED_KEYS, IDENTITYCOL, RECORDCOUNT, SQL |
Fields inherited from interface railo.runtime.type.Query |
---|
ORDER_ASC, ORDER_DESC |
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 |
Constructor Summary | |
---|---|
QueryCacheQuery(QueryImpl query)
|
Method Summary | |
---|---|
Struct |
_getMetaData()
|
boolean |
absolute(int row)
|
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)
adds a new column to the resultset |
boolean |
addColumn(String columnName,
Array content,
int type)
adds a new column to the resultset |
int |
addRow()
|
boolean |
addRow(int count)
adds a new row to the resultset |
void |
afterLast()
|
void |
beforeFirst()
|
Object |
call(PageContext pc,
Collection.Key methodName,
Object[] arguments)
calls a method of the object |
Object |
call(PageContext pc,
String methodName,
Object[] arguments)
calls a method of the object |
Object |
callWithNamedValues(PageContext pc,
Collection.Key methodName,
Struct args)
call a method of the Object with named arguments |
Object |
callWithNamedValues(PageContext pc,
String methodName,
Struct args)
call a method of the Object with named arguments |
void |
cancelRowUpdates()
|
Boolean |
castToBoolean(Boolean defaultValue)
cast the castable value to a boolean value |
boolean |
castToBooleanValue()
cast the castable value to a boolean value |
DateTime |
castToDateTime()
cast the castable value to a date time object |
DateTime |
castToDateTime(DateTime defaultValue)
cast the castable value to a date time object |
double |
castToDoubleValue()
cast the castable value to a double value |
double |
castToDoubleValue(double defaultValue)
cast the castable value to a double value |
String |
castToString()
cast the castable value to a string, other than the Method toString, this Method can throw a Exception |
String |
castToString(String defaultValue)
cast the castable value to a string, return the default value, when the method is not castable |
void |
clear()
clears the collection |
void |
clearWarnings()
|
Object |
clone()
|
QueryImpl |
cloneQuery(boolean deepCopy)
|
void |
close()
|
int |
compareTo(boolean b)
|
int |
compareTo(DateTime dt)
|
int |
compareTo(double d)
|
int |
compareTo(String str)
|
boolean |
containsKey(Collection.Key key)
contains this key |
boolean |
containsKey(String key)
contains this key |
boolean |
cutRowsTo(int maxrows)
|
void |
deleteRow()
|
Collection |
duplicate(boolean deepCopy)
|
int |
executionTime()
|
int |
findColumn(String columnName)
|
boolean |
first()
|
Object |
get(Collection.Key key)
return a value from the collection |
Object |
get(Collection.Key key,
Object defaultValue)
return a value from the collection, if key doesn't exist, dont throw a exception, reeturns null |
Object |
get(PageContext pc,
Collection.Key key)
return property or getter of the ContextCollection |
Object |
get(PageContext pc,
Collection.Key key,
Object defaultValue)
return property |
Object |
get(PageContext pc,
String key)
return property or getter of the ContextCollection |
Object |
get(PageContext pc,
String key,
Object defaultValue)
return property |
Object |
get(String key)
return a value from the collection |
Object |
get(String key,
Object defaultValue)
return a value from the collection, if key doesn't exist, dont throw a exception, reeturns null |
Array |
getArray(int i)
|
Array |
getArray(String colName)
|
InputStream |
getAsciiStream(int columnIndex)
|
InputStream |
getAsciiStream(String columnName)
|
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)
return a value of the resultset by specified column and row |
Object |
getAt(String 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) |
BigDecimal |
getBigDecimal(int columnIndex)
|
BigDecimal |
getBigDecimal(int columnIndex,
int scale)
|
BigDecimal |
getBigDecimal(String columnName)
|
BigDecimal |
getBigDecimal(String columnName,
int scale)
|
InputStream |
getBinaryStream(int columnIndex)
|
InputStream |
getBinaryStream(String columnName)
|
Blob |
getBlob(int i)
|
Blob |
getBlob(String colName)
|
boolean |
getBoolean(int columnIndex)
|
boolean |
getBoolean(String columnName)
|
byte |
getByte(int columnIndex)
|
byte |
getByte(String columnName)
|
byte[] |
getBytes(int columnIndex)
|
byte[] |
getBytes(String columnName)
|
Reader |
getCharacterStream(int columnIndex)
|
Reader |
getCharacterStream(String columnName)
|
Clob |
getClob(int i)
|
Clob |
getClob(String colName)
|
QueryColumn |
getColumn(Collection.Key key)
return the query column matching to key |
QueryColumn |
getColumn(Collection.Key key,
QueryColumn defaultValue)
return the query column matching to key, if key not exist return null |
QueryColumn |
getColumn(String key)
return the query column matching to key |
QueryColumn |
getColumn(String key,
QueryColumn defaultValue)
return the query column matching to key, if key not exist return null |
int |
getColumnIndex(String coulmnName)
returns index of a columnName |
String |
getColumnlist()
|
String |
getColumnlist(boolean upperCase)
return a string list of all columns |
Collection.Key |
getColumnName(int columnIndex)
|
Collection.Key[] |
getColumnNames()
|
String[] |
getColumnNamesAsString()
|
String[] |
getColumns()
|
int |
getConcurrency()
|
int |
getCurrentrow()
return the current position of the internal pointer |
int |
getCurrentrow(int pid)
|
String |
getCursorName()
|
String |
getData(int row,
int col)
returns one field of a Query as String |
Date |
getDate(int columnIndex)
|
Date |
getDate(int columnIndex,
Calendar cal)
|
Date |
getDate(String columnName)
|
Date |
getDate(String columnName,
Calendar cal)
|
double |
getDouble(int columnIndex)
|
double |
getDouble(String columnName)
|
int |
getFetchDirection()
|
int |
getFetchSize()
|
float |
getFloat(int columnIndex)
|
float |
getFloat(String columnName)
|
Query |
getGeneratedKeys()
|
int |
getInt(int columnIndex)
|
int |
getInt(String columnName)
|
long |
getLong(int columnIndex)
|
long |
getLong(String columnName)
|
ResultSetMetaData |
getMetaData()
|
Array |
getMetaDataSimple()
|
String |
getName()
|
Object |
getObject(int columnIndex)
|
Object |
getObject(int i,
Map map)
|
Object |
getObject(String columnName)
|
Object |
getObject(String colName,
Map map)
|
QueryImpl |
getQuery()
|
int |
getRecordcount()
return recordcount of the iterator object |
Ref |
getRef(int i)
|
Ref |
getRef(String colName)
|
int |
getRow()
|
int |
getRowCount()
|
short |
getShort(int columnIndex)
|
short |
getShort(String columnName)
|
SQL |
getSql()
|
Statement |
getStatement()
|
String |
getString(int columnIndex)
|
String |
getString(String columnName)
|
Time |
getTime(int columnIndex)
|
Time |
getTime(int columnIndex,
Calendar cal)
|
Time |
getTime(String columnName)
|
Time |
getTime(String columnName,
Calendar cal)
|
Timestamp |
getTimestamp(int columnIndex)
|
Timestamp |
getTimestamp(int columnIndex,
Calendar cal)
|
Timestamp |
getTimestamp(String columnName)
|
Timestamp |
getTimestamp(String columnName,
Calendar cal)
|
int |
getType()
|
int[] |
getTypes()
|
Map |
getTypesAsMap()
|
InputStream |
getUnicodeStream(int columnIndex)
|
InputStream |
getUnicodeStream(String columnName)
|
int |
getUpdateCount()
|
URL |
getURL(int columnIndex)
|
URL |
getURL(String columnName)
|
SQLWarning |
getWarnings()
|
boolean |
go(int index)
set the internal pointer to defined position |
boolean |
go(int index,
int pid)
set the internal pointer to defined position |
void |
insertRow()
|
boolean |
isAfterLast()
|
boolean |
isBeforeFirst()
|
boolean |
isCached()
is query from cache or not |
boolean |
isEmpty()
|
boolean |
isFirst()
|
boolean |
isInitalized()
|
boolean |
isLast()
|
Iterator |
iterator()
|
Iterator |
keyIterator()
|
Collection.Key[] |
keys()
|
String[] |
keysAsString()
|
boolean |
last()
|
void |
moveToCurrentRow()
|
void |
moveToInsertRow()
|
boolean |
next()
set the intern pointer of the iterator to the next position, return true if next position exist otherwise false. |
boolean |
next(int pid)
set the intern pointer of the iterator to the next position, return true if next position exist otherwise false. |
boolean |
previous()
|
boolean |
previous(int pid)
|
void |
refreshRow()
|
boolean |
relative(int rows)
|
Object |
remove(Collection.Key key)
removes value from collection and return it when it exists, otherwise throws a exception |
Object |
remove(String key)
|
QueryColumn |
removeColumn(Collection.Key key)
remove column matching to key |
QueryColumn |
removeColumn(String key)
remove column matching to key |
QueryColumn |
removeColumnEL(Collection.Key key)
remove column matching to key |
QueryColumn |
removeColumnEL(String key)
remove column matching to key |
Object |
removeEL(Collection.Key key)
removes value from collection and return it when it exists, otherwise returns null |
Object |
removeEL(String key)
|
int |
removeRow(int row)
remove row from query |
int |
removeRowEL(int row)
remove row from query |
void |
rename(Collection.Key columnName,
Collection.Key newColumnName)
|
void |
reset()
reset ther intern pointer |
void |
reset(int pid)
reset ther intern pointer |
boolean |
rowDeleted()
|
boolean |
rowInserted()
|
boolean |
rowUpdated()
|
Object |
set(Collection.Key key,
Object value)
sets a value to the collection |
Object |
set(PageContext pc,
Collection.Key propertyName,
Object value)
sets a property (Data Member) value of the object |
Object |
set(PageContext pc,
String propertyName,
Object value)
sets a property (Data Member) value of the object |
Object |
set(String key,
Object value)
sets a value to the collection |
Object |
setAt(Collection.Key key,
int row,
Object value)
set a value at the defined position |
Object |
setAt(String key,
int row,
Object value)
set a value at the defined position |
Object |
setAtEL(Collection.Key key,
int row,
Object value)
set a value at the defined position |
Object |
setAtEL(String key,
int row,
Object value)
set a value at the defined position |
void |
setCached(boolean isCached)
sets if query is form cache or not |
void |
setColumnNames(Collection.Key[] trg)
|
void |
setData(int row,
int col,
String value)
sets value at a defined position in Query |
Object |
setEL(Collection.Key key,
Object value)
sets a value to the collection, if key doesn't exist, dont throw a exception, returns null |
Object |
setEL(PageContext pc,
Collection.Key propertyName,
Object value)
sets a property (Data Member) value of the object |
Object |
setEL(PageContext pc,
String propertyName,
Object value)
sets a property (Data Member) value of the object |
Object |
setEL(String key,
Object value)
sets a value to the collection, if key doesn't exist, dont throw a exception, returns null |
void |
setExecutionTime(long exeTime)
sets the execution Time of the query |
void |
setFetchDirection(int direction)
|
void |
setFetchSize(int rows)
|
void |
setSql(SQL sql)
|
int |
size()
|
void |
sort(Collection.Key column)
sorts a query by a column, direction is asc |
void |
sort(Collection.Key keyColumn,
int order)
sorts a query by a column |
void |
sort(String column)
sorts a query by a column |
void |
sort(String strColumn,
int order)
sorts a query by a column |
DumpData |
toDumpData(PageContext pageContext,
int maxlevel,
DumpProperties dp)
method to print out information to a object as HTML |
String |
toString()
|
void |
updateArray(int columnIndex,
Array x)
|
void |
updateArray(String columnName,
Array x)
|
void |
updateAsciiStream(int columnIndex,
InputStream x,
int length)
|
void |
updateAsciiStream(String columnName,
InputStream x,
int length)
|
void |
updateBigDecimal(int columnIndex,
BigDecimal x)
|
void |
updateBigDecimal(String columnName,
BigDecimal x)
|
void |
updateBinaryStream(int columnIndex,
InputStream x,
int length)
|
void |
updateBinaryStream(String columnName,
InputStream x,
int length)
|
void |
updateBlob(int columnIndex,
Blob x)
|
void |
updateBlob(String columnName,
Blob x)
|
void |
updateBoolean(int columnIndex,
boolean x)
|
void |
updateBoolean(String columnName,
boolean x)
|
void |
updateByte(int columnIndex,
byte x)
|
void |
updateByte(String columnName,
byte x)
|
void |
updateBytes(int columnIndex,
byte[] x)
|
void |
updateBytes(String columnName,
byte[] x)
|
void |
updateCharacterStream(int columnIndex,
Reader reader,
int length)
|
void |
updateCharacterStream(String columnName,
Reader reader,
int length)
|
void |
updateClob(int columnIndex,
Clob x)
|
void |
updateClob(String columnName,
Clob x)
|
void |
updateDate(int columnIndex,
Date x)
|
void |
updateDate(String columnName,
Date x)
|
void |
updateDouble(int columnIndex,
double x)
|
void |
updateDouble(String columnName,
double x)
|
void |
updateFloat(int columnIndex,
float x)
|
void |
updateFloat(String columnName,
float x)
|
void |
updateInt(int columnIndex,
int x)
|
void |
updateInt(String columnName,
int x)
|
void |
updateLong(int columnIndex,
long x)
|
void |
updateLong(String columnName,
long x)
|
void |
updateNull(int columnIndex)
|
void |
updateNull(String columnName)
|
void |
updateObject(int columnIndex,
Object x)
|
void |
updateObject(int columnIndex,
Object x,
int scale)
|
void |
updateObject(String columnName,
Object x)
|
void |
updateObject(String columnName,
Object x,
int scale)
|
void |
updateRef(int columnIndex,
Ref x)
|
void |
updateRef(String columnName,
Ref x)
|
void |
updateRow()
|
void |
updateShort(int columnIndex,
short x)
|
void |
updateShort(String columnName,
short x)
|
void |
updateString(int columnIndex,
String x)
|
void |
updateString(String columnName,
String x)
|
void |
updateTime(int columnIndex,
Time x)
|
void |
updateTime(String columnName,
Time x)
|
void |
updateTimestamp(int columnIndex,
Timestamp x)
|
void |
updateTimestamp(String columnName,
Timestamp x)
|
Iterator |
valueIterator()
|
boolean |
wasNull()
|
Methods inherited from class java.lang.Object |
---|
getClass, hashCode, notify, notifyAll, wait, wait, wait |
Constructor Detail |
---|
public QueryCacheQuery(QueryImpl query) throws DatabaseException
DatabaseException
Method Detail |
---|
public boolean addColumn(String columnName, Array content) throws DatabaseException
Query
addColumn
in class QueryImpl
columnName
- name of the new columncontent
- content of the new column inside a array (must have same size like query has records)
DatabaseException
QueryImpl.addColumn(java.lang.String, railo.runtime.type.Array)
public boolean addColumn(Collection.Key columnName, Array content) throws PageException
Query
addColumn
in class QueryImpl
columnName
- name of the new columncontent
- content of the new column inside a array (must have same size like query has records)
PageException
QueryImpl.addColumn(railo.runtime.type.Collection.Key, railo.runtime.type.Array)
public boolean addColumn(String columnName, Array content, int type) throws DatabaseException
Query
addColumn
in class QueryImpl
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)
DatabaseException
QueryImpl.addColumn(java.lang.String, railo.runtime.type.Array, int)
public boolean addColumn(Collection.Key columnName, Array content, int type) throws DatabaseException
Query
addColumn
in class QueryImpl
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)
DatabaseException
QueryImpl.addColumn(railo.runtime.type.Collection.Key, railo.runtime.type.Array, int)
public boolean addRow(int count)
Query
addRow
in class QueryImpl
count
- count of rows to add
QueryImpl.addRow(int)
public int addRow()
addRow
in interface Query
addRow
in class QueryImpl
QueryImpl.addRow()
public Object call(PageContext pc, String methodName, Object[] arguments) throws PageException
Objects
call
in interface Objects
call
in class QueryImpl
methodName
- name of the method to callarguments
- arguments to call method with
PageException
QueryImpl.call(railo.runtime.PageContext, java.lang.String, java.lang.Object[])
public Object call(PageContext pc, Collection.Key methodName, Object[] arguments) throws PageException
Objects
call
in interface Objects
call
in class QueryImpl
methodName
- name of the method to callarguments
- arguments to call method with
PageException
QueryImpl.call(railo.runtime.PageContext, railo.runtime.type.Collection.Key, java.lang.Object[])
public Object callWithNamedValues(PageContext pc, String methodName, Struct args) throws PageException
Objects
callWithNamedValues
in interface Objects
callWithNamedValues
in class QueryImpl
pc
- PageContextmethodName
- name of the methodargs
- Named Arguments for the method
PageException
QueryImpl.callWithNamedValues(railo.runtime.PageContext, java.lang.String, railo.runtime.type.Struct)
public Object callWithNamedValues(PageContext pc, Collection.Key methodName, Struct args) throws PageException
Objects
callWithNamedValues
in interface Objects
callWithNamedValues
in class QueryImpl
pc
- PageContextmethodName
- name of the methodargs
- Named Arguments for the method
PageException
QueryImpl.callWithNamedValues(railo.runtime.PageContext, railo.runtime.type.Collection.Key, railo.runtime.type.Struct)
public boolean castToBooleanValue() throws ExpressionException
Castable
castToBooleanValue
in interface Castable
castToBooleanValue
in class QueryImpl
ExpressionException
QueryImpl.castToBooleanValue()
public Boolean castToBoolean(Boolean defaultValue)
Castable
castToBoolean
in interface Castable
castToBoolean
in class QueryImpl
Castable.castToBoolean(java.lang.Boolean)
public DateTime castToDateTime() throws ExpressionException
Castable
castToDateTime
in interface Castable
castToDateTime
in class QueryImpl
ExpressionException
QueryImpl.castToDateTime()
public DateTime castToDateTime(DateTime defaultValue)
Castable
castToDateTime
in interface Castable
castToDateTime
in class QueryImpl
defaultValue
- returned when it is not possible to cast to a dateTime object
Castable.castToDateTime(railo.runtime.type.dt.DateTime)
public double castToDoubleValue() throws ExpressionException
Castable
castToDoubleValue
in interface Castable
castToDoubleValue
in class QueryImpl
ExpressionException
QueryImpl.castToDoubleValue()
public double castToDoubleValue(double defaultValue)
Castable
castToDoubleValue
in interface Castable
castToDoubleValue
in class QueryImpl
Castable.castToDoubleValue(double)
public String castToString() throws ExpressionException
Castable
castToString
in interface Castable
castToString
in class QueryImpl
ExpressionException
QueryImpl.castToString()
public String castToString(String defaultValue)
Castable
castToString
in interface Castable
castToString
in class QueryImpl
StructSupport.castToString(java.lang.String)
public void clear()
Collection
clear
in interface Collection
clear
in class QueryImpl
QueryImpl.clear()
public Object clone()
clone
in interface Collection
clone
in class QueryImpl
QueryImpl.clone()
public QueryImpl cloneQuery(boolean deepCopy)
cloneQuery
in class QueryImpl
QueryImpl.cloneQuery(boolean)
public int compareTo(boolean b) throws ExpressionException
compareTo
in interface Castable
compareTo
in class QueryImpl
ExpressionException
QueryImpl.compareTo(boolean)
public int compareTo(DateTime dt) throws PageException
compareTo
in interface Castable
compareTo
in class QueryImpl
PageException
QueryImpl.compareTo(railo.runtime.type.dt.DateTime)
public int compareTo(double d) throws PageException
compareTo
in interface Castable
compareTo
in class QueryImpl
PageException
QueryImpl.compareTo(double)
public int compareTo(String str) throws PageException
compareTo
in interface Castable
compareTo
in class QueryImpl
PageException
QueryImpl.compareTo(java.lang.String)
public boolean containsKey(String key)
Collection
containsKey
in interface Collection
containsKey
in class QueryImpl
QueryImpl.containsKey(java.lang.String)
public boolean containsKey(Collection.Key key)
Collection
containsKey
in interface Collection
containsKey
in class QueryImpl
QueryImpl.containsKey(railo.runtime.type.Collection.Key)
public boolean cutRowsTo(int maxrows)
cutRowsTo
in class QueryImpl
QueryImpl.cutRowsTo(int)
public Collection duplicate(boolean deepCopy)
duplicate
in interface Collection
duplicate
in class QueryImpl
QueryImpl.duplicate(boolean)
public int executionTime()
executionTime
in class QueryImpl
QueryImpl.executionTime()
public Object get(String key, Object defaultValue)
Collection
get
in interface Collection
get
in class QueryImpl
key
- key of the value to get
QueryImpl.get(java.lang.String, java.lang.Object)
public Object get(Collection.Key key, Object defaultValue)
Collection
get
in interface Collection
get
in class QueryImpl
key
- key of the value to get
QueryImpl.get(railo.runtime.type.Collection.Key, java.lang.Object)
public Object get(String key) throws PageException
Collection
get
in interface Collection
get
in class QueryImpl
key
- key of the value to get
PageException
QueryImpl.get(java.lang.String)
public Object get(Collection.Key key) throws PageException
Collection
get
in interface Collection
get
in class QueryImpl
key
- key of the value to get must be lower case
PageException
QueryImpl.get(railo.runtime.type.Collection.Key)
public Object get(PageContext pc, String key, Object defaultValue)
Objects
get
in interface Objects
get
in class QueryImpl
pc
- PageContextkey
- Name of the Property
QueryImpl.get(railo.runtime.PageContext, java.lang.String, java.lang.Object)
public Object get(PageContext pc, Collection.Key key, Object defaultValue)
Objects
get
in interface Objects
get
in class QueryImpl
pc
- PageContextkey
- Name of the Property
QueryImpl.get(railo.runtime.PageContext, railo.runtime.type.Collection.Key, java.lang.Object)
public Object get(PageContext pc, String key) throws PageException
Objects
get
in interface Objects
get
in class QueryImpl
pc
- PageContextkey
- Name of the Property
PageException
QueryImpl.get(railo.runtime.PageContext, java.lang.String)
public Object get(PageContext pc, Collection.Key key) throws PageException
Objects
get
in interface Objects
get
in class QueryImpl
pc
- PageContextkey
- Name of the Property
PageException
QueryImpl.get(railo.runtime.PageContext, railo.runtime.type.Collection.Key)
public Object getAt(String key, int row, Object defaultValue)
Query
getAt
in class QueryImpl
key
- column to getrow
- row to get from (1-recordcount)
QueryImpl.getAt(java.lang.String, int, java.lang.Object)
public Object getAt(Collection.Key key, int row, Object defaultValue)
Query
getAt
in class QueryImpl
key
- column to getrow
- row to get from (1-recordcount)
QueryImpl.getAt(railo.runtime.type.Collection.Key, int, java.lang.Object)
public Object getAt(String key, int row) throws PageException
Query
getAt
in class QueryImpl
key
- column to getrow
- row to get from (1-recordcount)
PageException
- if invalid position definitionQueryImpl.getAt(java.lang.String, int)
public Object getAt(Collection.Key key, int row) throws PageException
Query
getAt
in class QueryImpl
key
- column to getrow
- row to get from (1-recordcount)
PageException
- if invalid position definitionQueryImpl.getAt(railo.runtime.type.Collection.Key, int)
public boolean getBoolean(int columnIndex) throws SQLException
getBoolean
in interface ResultSet
getBoolean
in class QueryImpl
SQLException
QueryImpl.getBoolean(int)
public boolean getBoolean(String columnName) throws SQLException
getBoolean
in interface ResultSet
getBoolean
in class QueryImpl
SQLException
QueryImpl.getBoolean(java.lang.String)
public QueryColumn getColumn(String key) throws DatabaseException
Query
getColumn
in class QueryImpl
key
- key to get
DatabaseException
QueryImpl.getColumn(java.lang.String)
public QueryColumn getColumn(Collection.Key key) throws DatabaseException
Query
getColumn
in class QueryImpl
key
- key to get
DatabaseException
QueryImpl.getColumn(railo.runtime.type.Collection.Key)
public QueryColumn getColumn(String key, QueryColumn defaultValue)
Query
getColumn
in class QueryImpl
key
- key to get
QueryImpl.getColumn(java.lang.String, railo.runtime.type.QueryColumn)
public QueryColumn getColumn(Collection.Key key, QueryColumn defaultValue)
Query
getColumn
in class QueryImpl
key
- key to get
QueryImpl.getColumn(railo.runtime.type.Collection.Key, railo.runtime.type.QueryColumn)
public int getColumnIndex(String coulmnName)
Query
getColumnIndex
in interface Query
getColumnIndex
in class QueryImpl
coulmnName
- column name to get index for
QueryImpl.getColumnIndex(java.lang.String)
public String getColumnlist()
getColumnlist
in class QueryImpl
QueryImpl.getColumnlist()
public String[] getColumns()
getColumns
in interface Query
getColumns
in class QueryImpl
QueryImpl.getColumns()
public int getCurrentrow()
Iterator
getCurrentrow
in interface Iterator
getCurrentrow
in class QueryImpl
QueryImpl.getCurrentrow()
public int getCurrentrow(int pid)
getCurrentrow
in interface QueryPro
getCurrentrow
in class QueryImpl
QueryImpl.getCurrentrow(int)
public String getData(int row, int col) throws IndexOutOfBoundsException
Query
getData
in interface Query
getData
in class QueryImpl
IndexOutOfBoundsException
QueryImpl.getData(int, int)
public Struct _getMetaData()
_getMetaData
in class QueryImpl
QueryImpl._getMetaData()
public Array getMetaDataSimple()
getMetaDataSimple
in class QueryImpl
QueryImpl.getMetaDataSimple()
public String getName()
getName
in interface Query
getName
in class QueryImpl
QueryImpl.getName()
public Object getObject(String columnName) throws SQLException
getObject
in interface ResultSet
getObject
in class QueryImpl
SQLException
QueryImpl.getObject(java.lang.String)
public Object getObject(int columnIndex) throws SQLException
getObject
in interface ResultSet
getObject
in class QueryImpl
SQLException
QueryImpl.getObject(int)
public int getRecordcount()
Iterator
getRecordcount
in interface Iterator
getRecordcount
in class QueryImpl
QueryImpl.getRecordcount()
public int getRowCount()
getRowCount
in interface Query
getRowCount
in class QueryImpl
QueryImpl.getRowCount()
public SQL getSql()
getSql
in interface QueryPro
getSql
in class QueryImpl
QueryImpl.getSql()
public String getString(int columnIndex) throws SQLException
getString
in interface ResultSet
getString
in class QueryImpl
SQLException
QueryImpl.getString(int)
public String getString(String columnName) throws SQLException
getString
in interface ResultSet
getString
in class QueryImpl
SQLException
QueryImpl.getString(java.lang.String)
public int[] getTypes()
getTypes
in class QueryImpl
QueryImpl.getTypes()
public Map getTypesAsMap()
getTypesAsMap
in class QueryImpl
QueryImpl.getTypesAsMap()
public boolean go(int index)
Iterator
go
in interface Iterator
go
in class QueryImpl
QueryImpl.go(int)
public boolean go(int index, int pid)
Iterator
go
in interface Iterator
go
in interface QueryPro
go
in class QueryImpl
QueryImpl.go(int, int)
public boolean isCached()
Query
isCached
in class QueryImpl
QueryImpl.isCached()
public boolean isEmpty()
isEmpty
in interface Iterator
isEmpty
in class QueryImpl
QueryImpl.isEmpty()
public boolean isInitalized()
isInitalized
in interface Objects
isInitalized
in class QueryImpl
QueryImpl.isInitalized()
public Iterator iterator()
iterator
in interface Iteratorable
iterator
in class QueryImpl
QueryImpl.iterator()
public Iterator keyIterator()
keyIterator
in interface Iteratorable
keyIterator
in class QueryImpl
QueryImpl.keyIterator()
public Collection.Key[] keys()
keys
in interface Collection
keys
in class QueryImpl
QueryImpl.keys()
public String[] keysAsString()
keysAsString
in interface Collection
keysAsString
in class QueryImpl
QueryImpl.keysAsString()
public boolean next()
Iterator
next
in interface ResultSet
next
in interface Iterator
next
in class QueryImpl
QueryImpl.next()
public boolean next(int pid)
Iterator
next
in interface Iterator
next
in interface QueryPro
next
in class QueryImpl
QueryImpl.next(int)
public Object remove(String key) throws PageException
remove
in class QueryImpl
PageException
QueryImpl.remove(java.lang.String)
public Object remove(Collection.Key key) throws PageException
Collection
remove
in interface Collection
remove
in class QueryImpl
key
- key of the collection
PageException
QueryImpl.remove(railo.runtime.type.Collection.Key)
public QueryColumn removeColumn(String key) throws DatabaseException
Query
removeColumn
in class QueryImpl
key
- key to remove
DatabaseException
QueryImpl.removeColumn(java.lang.String)
public QueryColumn removeColumn(Collection.Key key) throws DatabaseException
Query
removeColumn
in class QueryImpl
key
- key to remove
DatabaseException
QueryImpl.removeColumn(railo.runtime.type.Collection.Key)
public QueryColumn removeColumnEL(String key)
Query
removeColumnEL
in class QueryImpl
key
- key to remove
QueryImpl.removeColumnEL(java.lang.String)
public QueryColumn removeColumnEL(Collection.Key key)
Query
removeColumnEL
in class QueryImpl
key
- key to remove
QueryImpl.removeColumnEL(railo.runtime.type.Collection.Key)
public Object removeEL(String key)
removeEL
in class QueryImpl
QueryImpl.removeEL(java.lang.String)
public Object removeEL(Collection.Key key)
Collection
removeEL
in interface Collection
removeEL
in class QueryImpl
key
- key of the collection
QueryImpl.removeEL(railo.runtime.type.Collection.Key)
public int removeRow(int row) throws PageException
Query
removeRow
in class QueryImpl
PageException
QueryImpl.removeRow(int)
public int removeRowEL(int row)
Query
removeRowEL
in class QueryImpl
QueryImpl.removeRowEL(int)
public void reset()
Iterator
reset
in interface Iterator
reset
in class QueryImpl
QueryImpl.reset()
public void reset(int pid)
Iterator
reset
in interface Iterator
reset
in interface QueryPro
reset
in class QueryImpl
QueryImpl.reset(int)
public Object set(String key, Object value) throws PageException
Collection
set
in interface Collection
set
in class QueryImpl
key
- key of the new valuevalue
- value to set
PageException
QueryImpl.set(java.lang.String, java.lang.Object)
public Object set(Collection.Key key, Object value) throws PageException
Collection
set
in interface Collection
set
in class QueryImpl
key
- key of the new valuevalue
- value to set
PageException
QueryImpl.set(railo.runtime.type.Collection.Key, java.lang.Object)
public Object set(PageContext pc, String propertyName, Object value) throws PageException
Objects
set
in interface Objects
set
in class QueryImpl
propertyName
- property name to setvalue
- value to insert
PageException
QueryImpl.set(railo.runtime.PageContext, java.lang.String, java.lang.Object)
public Object set(PageContext pc, Collection.Key propertyName, Object value) throws PageException
Objects
set
in interface Objects
set
in class QueryImpl
propertyName
- property name to setvalue
- value to insert
PageException
QueryImpl.set(railo.runtime.PageContext, railo.runtime.type.Collection.Key, java.lang.Object)
public Object setAt(String key, int row, Object value) throws PageException
Query
setAt
in class QueryImpl
key
- column to setrow
- row to setvalue
- value to fill
PageException
QueryImpl.setAt(java.lang.String, int, java.lang.Object)
public Object setAt(Collection.Key key, int row, Object value) throws PageException
Query
setAt
in class QueryImpl
key
- column to setrow
- row to setvalue
- value to fill
PageException
QueryImpl.setAt(railo.runtime.type.Collection.Key, int, java.lang.Object)
public Object setAtEL(String key, int row, Object value)
Query
setAtEL
in class QueryImpl
key
- column to setrow
- row to setvalue
- value to fill
QueryImpl.setAtEL(java.lang.String, int, java.lang.Object)
public Object setAtEL(Collection.Key key, int row, Object value)
Query
setAtEL
in class QueryImpl
key
- column to setrow
- row to setvalue
- value to fill
QueryImpl.setAtEL(railo.runtime.type.Collection.Key, int, java.lang.Object)
public void setCached(boolean isCached)
Query
setCached
in class QueryImpl
isCached
- is cached or notQueryImpl.setCached(boolean)
public void setData(int row, int col, String value) throws IndexOutOfBoundsException
Query
setData
in interface Query
setData
in class QueryImpl
IndexOutOfBoundsException
QueryImpl.setData(int, int, java.lang.String)
public Object setEL(String key, Object value)
Collection
setEL
in interface Collection
setEL
in class QueryImpl
key
- key of the value to getvalue
- value to set
QueryImpl.setEL(java.lang.String, java.lang.Object)
public Object setEL(Collection.Key key, Object value)
Collection
setEL
in interface Collection
setEL
in class QueryImpl
key
- key of the value to getvalue
- value to set
QueryImpl.setEL(railo.runtime.type.Collection.Key, java.lang.Object)
public Object setEL(PageContext pc, String propertyName, Object value)
Objects
setEL
in interface Objects
setEL
in class QueryImpl
propertyName
- property name to setvalue
- value to insert
QueryImpl.setEL(railo.runtime.PageContext, java.lang.String, java.lang.Object)
public Object setEL(PageContext pc, Collection.Key propertyName, Object value)
Objects
setEL
in interface Objects
setEL
in class QueryImpl
propertyName
- property name to setvalue
- value to insert
QueryImpl.setEL(railo.runtime.PageContext, railo.runtime.type.Collection.Key, java.lang.Object)
public void setExecutionTime(long exeTime)
Query
setExecutionTime
in class QueryImpl
QueryImpl.setExecutionTime(long)
public void setSql(SQL sql)
setSql
in class QueryImpl
sql
- the sql to setQueryImpl.setSql(railo.runtime.db.SQL)
public int size()
size
in interface Collection
size
in class QueryImpl
QueryImpl.size()
public void sort(String column) throws PageException
QueryImpl
sort
in class QueryImpl
column
- colun to sort
PageException
QueryImpl.sort(java.lang.String)
public void sort(Collection.Key column) throws PageException
Query
sort
in class QueryImpl
column
- colun to sort
PageException
QueryImpl.sort(railo.runtime.type.Collection.Key)
public void sort(String strColumn, int order) throws PageException
QueryImpl
sort
in class QueryImpl
strColumn
- column to sortorder
- sort type (Query.ORDER_ASC or Query.ORDER_DESC)
PageException
QueryImpl.sort(java.lang.String, int)
public void sort(Collection.Key keyColumn, int order) throws PageException
Query
sort
in class QueryImpl
keyColumn
- column to sortorder
- sort type (Query.ORDER_ASC or Query.ORDER_DESC)
PageException
QueryImpl.sort(railo.runtime.type.Collection.Key, int)
public DumpData toDumpData(PageContext pageContext, int maxlevel, DumpProperties dp)
Dumpable
toDumpData
in interface Dumpable
toDumpData
in class QueryImpl
railo.runtime.type.QueryImpl#toDumpData(railo.runtime.PageContext, int)
public String toString()
toString
in class QueryImpl
QueryImpl.toString()
public QueryImpl getQuery()
public void cancelRowUpdates() throws SQLException
cancelRowUpdates
in interface ResultSet
cancelRowUpdates
in class QueryImpl
SQLException
QueryImpl.cancelRowUpdates()
public void deleteRow() throws SQLException
deleteRow
in interface ResultSet
deleteRow
in class QueryImpl
SQLException
QueryImpl.deleteRow()
public void insertRow() throws SQLException
insertRow
in interface ResultSet
insertRow
in class QueryImpl
SQLException
QueryImpl.insertRow()
public void rename(Collection.Key columnName, Collection.Key newColumnName) throws ExpressionException
rename
in interface QueryPro
rename
in class QueryImpl
ExpressionException
QueryImpl.rename(railo.runtime.type.Collection.Key, railo.runtime.type.Collection.Key)
public boolean rowDeleted() throws SQLException
rowDeleted
in interface ResultSet
rowDeleted
in class QueryImpl
SQLException
QueryImpl.rowDeleted()
public boolean rowInserted() throws SQLException
rowInserted
in interface ResultSet
rowInserted
in class QueryImpl
SQLException
QueryImpl.rowInserted()
public boolean rowUpdated() throws SQLException
rowUpdated
in interface ResultSet
rowUpdated
in class QueryImpl
SQLException
QueryImpl.rowUpdated()
public void setFetchDirection(int direction) throws SQLException
setFetchDirection
in interface ResultSet
setFetchDirection
in class QueryImpl
SQLException
QueryImpl.setFetchDirection(int)
public void setFetchSize(int rows) throws SQLException
setFetchSize
in interface ResultSet
setFetchSize
in class QueryImpl
SQLException
QueryImpl.setFetchSize(int)
public void updateArray(int columnIndex, Array x) throws SQLException
updateArray
in interface ResultSet
updateArray
in class QueryImpl
SQLException
QueryImpl.updateArray(int, java.sql.Array)
public void updateArray(String columnName, Array x) throws SQLException
updateArray
in interface ResultSet
updateArray
in class QueryImpl
SQLException
QueryImpl.updateArray(java.lang.String, java.sql.Array)
public void updateAsciiStream(int columnIndex, InputStream x, int length) throws SQLException
updateAsciiStream
in interface ResultSet
updateAsciiStream
in class QueryImpl
SQLException
QueryImpl.updateAsciiStream(int, java.io.InputStream, int)
public void updateAsciiStream(String columnName, InputStream x, int length) throws SQLException
updateAsciiStream
in interface ResultSet
updateAsciiStream
in class QueryImpl
SQLException
QueryImpl.updateAsciiStream(java.lang.String, java.io.InputStream, int)
public void updateBigDecimal(int columnIndex, BigDecimal x) throws SQLException
updateBigDecimal
in interface ResultSet
updateBigDecimal
in class QueryImpl
SQLException
QueryImpl.updateBigDecimal(int, java.math.BigDecimal)
public void updateBigDecimal(String columnName, BigDecimal x) throws SQLException
updateBigDecimal
in interface ResultSet
updateBigDecimal
in class QueryImpl
SQLException
QueryImpl.updateBigDecimal(java.lang.String, java.math.BigDecimal)
public void updateBinaryStream(int columnIndex, InputStream x, int length) throws SQLException
updateBinaryStream
in interface ResultSet
updateBinaryStream
in class QueryImpl
SQLException
QueryImpl.updateBinaryStream(int, java.io.InputStream, int)
public void updateBinaryStream(String columnName, InputStream x, int length) throws SQLException
updateBinaryStream
in interface ResultSet
updateBinaryStream
in class QueryImpl
SQLException
QueryImpl.updateBinaryStream(java.lang.String, java.io.InputStream, int)
public void updateBlob(int columnIndex, Blob x) throws SQLException
updateBlob
in interface ResultSet
updateBlob
in class QueryImpl
SQLException
QueryImpl.updateBlob(int, java.sql.Blob)
public void updateBlob(String columnName, Blob x) throws SQLException
updateBlob
in interface ResultSet
updateBlob
in class QueryImpl
SQLException
QueryImpl.updateBlob(java.lang.String, java.sql.Blob)
public void updateBoolean(int columnIndex, boolean x) throws SQLException
updateBoolean
in interface ResultSet
updateBoolean
in class QueryImpl
SQLException
QueryImpl.updateBoolean(int, boolean)
public void updateBoolean(String columnName, boolean x) throws SQLException
updateBoolean
in interface ResultSet
updateBoolean
in class QueryImpl
SQLException
QueryImpl.updateBoolean(java.lang.String, boolean)
public void updateByte(int columnIndex, byte x) throws SQLException
updateByte
in interface ResultSet
updateByte
in class QueryImpl
SQLException
QueryImpl.updateByte(int, byte)
public void updateByte(String columnName, byte x) throws SQLException
updateByte
in interface ResultSet
updateByte
in class QueryImpl
SQLException
QueryImpl.updateByte(java.lang.String, byte)
public void updateBytes(int columnIndex, byte[] x) throws SQLException
updateBytes
in interface ResultSet
updateBytes
in class QueryImpl
SQLException
QueryImpl.updateBytes(int, byte[])
public void updateBytes(String columnName, byte[] x) throws SQLException
updateBytes
in interface ResultSet
updateBytes
in class QueryImpl
SQLException
QueryImpl.updateBytes(java.lang.String, byte[])
public void updateCharacterStream(int columnIndex, Reader reader, int length) throws SQLException
updateCharacterStream
in interface ResultSet
updateCharacterStream
in class QueryImpl
SQLException
QueryImpl.updateCharacterStream(int, java.io.Reader, int)
public void updateCharacterStream(String columnName, Reader reader, int length) throws SQLException
updateCharacterStream
in interface ResultSet
updateCharacterStream
in class QueryImpl
SQLException
QueryImpl.updateCharacterStream(java.lang.String, java.io.Reader, int)
public void updateClob(int columnIndex, Clob x) throws SQLException
updateClob
in interface ResultSet
updateClob
in class QueryImpl
SQLException
QueryImpl.updateClob(int, java.sql.Clob)
public void updateClob(String columnName, Clob x) throws SQLException
updateClob
in interface ResultSet
updateClob
in class QueryImpl
SQLException
QueryImpl.updateClob(java.lang.String, java.sql.Clob)
public void updateDate(int columnIndex, Date x) throws SQLException
updateDate
in interface ResultSet
updateDate
in class QueryImpl
SQLException
QueryImpl.updateDate(int, java.sql.Date)
public void updateDate(String columnName, Date x) throws SQLException
updateDate
in interface ResultSet
updateDate
in class QueryImpl
SQLException
QueryImpl.updateDate(java.lang.String, java.sql.Date)
public void updateDouble(int columnIndex, double x) throws SQLException
updateDouble
in interface ResultSet
updateDouble
in class QueryImpl
SQLException
QueryImpl.updateDouble(int, double)
public void updateDouble(String columnName, double x) throws SQLException
updateDouble
in interface ResultSet
updateDouble
in class QueryImpl
SQLException
QueryImpl.updateDouble(java.lang.String, double)
public void updateFloat(int columnIndex, float x) throws SQLException
updateFloat
in interface ResultSet
updateFloat
in class QueryImpl
SQLException
QueryImpl.updateFloat(int, float)
public void updateFloat(String columnName, float x) throws SQLException
updateFloat
in interface ResultSet
updateFloat
in class QueryImpl
SQLException
QueryImpl.updateFloat(java.lang.String, float)
public void updateInt(int columnIndex, int x) throws SQLException
updateInt
in interface ResultSet
updateInt
in class QueryImpl
SQLException
QueryImpl.updateInt(int, int)
public void updateInt(String columnName, int x) throws SQLException
updateInt
in interface ResultSet
updateInt
in class QueryImpl
SQLException
QueryImpl.updateInt(java.lang.String, int)
public void updateLong(int columnIndex, long x) throws SQLException
updateLong
in interface ResultSet
updateLong
in class QueryImpl
SQLException
QueryImpl.updateLong(int, long)
public void updateLong(String columnName, long x) throws SQLException
updateLong
in interface ResultSet
updateLong
in class QueryImpl
SQLException
QueryImpl.updateLong(java.lang.String, long)
public void updateNull(int columnIndex) throws SQLException
updateNull
in interface ResultSet
updateNull
in class QueryImpl
SQLException
QueryImpl.updateNull(int)
public void updateNull(String columnName) throws SQLException
updateNull
in interface ResultSet
updateNull
in class QueryImpl
SQLException
QueryImpl.updateNull(java.lang.String)
public void updateObject(int columnIndex, Object x) throws SQLException
updateObject
in interface ResultSet
updateObject
in class QueryImpl
SQLException
QueryImpl.updateObject(int, java.lang.Object)
public void updateObject(String columnName, Object x) throws SQLException
updateObject
in interface ResultSet
updateObject
in class QueryImpl
SQLException
QueryImpl.updateObject(java.lang.String, java.lang.Object)
public void updateObject(int columnIndex, Object x, int scale) throws SQLException
updateObject
in interface ResultSet
updateObject
in class QueryImpl
SQLException
QueryImpl.updateObject(int, java.lang.Object, int)
public void updateObject(String columnName, Object x, int scale) throws SQLException
updateObject
in interface ResultSet
updateObject
in class QueryImpl
SQLException
QueryImpl.updateObject(java.lang.String, java.lang.Object, int)
public void updateRef(int columnIndex, Ref x) throws SQLException
updateRef
in interface ResultSet
updateRef
in class QueryImpl
SQLException
QueryImpl.updateRef(int, java.sql.Ref)
public void updateRef(String columnName, Ref x) throws SQLException
updateRef
in interface ResultSet
updateRef
in class QueryImpl
SQLException
QueryImpl.updateRef(java.lang.String, java.sql.Ref)
public void updateRow() throws SQLException
updateRow
in interface ResultSet
updateRow
in class QueryImpl
SQLException
QueryImpl.updateRow()
public void updateShort(int columnIndex, short x) throws SQLException
updateShort
in interface ResultSet
updateShort
in class QueryImpl
SQLException
QueryImpl.updateShort(int, short)
public void updateShort(String columnName, short x) throws SQLException
updateShort
in interface ResultSet
updateShort
in class QueryImpl
SQLException
QueryImpl.updateShort(java.lang.String, short)
public void updateString(int columnIndex, String x) throws SQLException
updateString
in interface ResultSet
updateString
in class QueryImpl
SQLException
QueryImpl.updateString(int, java.lang.String)
public void updateString(String columnName, String x) throws SQLException
updateString
in interface ResultSet
updateString
in class QueryImpl
SQLException
QueryImpl.updateString(java.lang.String, java.lang.String)
public void updateTime(int columnIndex, Time x) throws SQLException
updateTime
in interface ResultSet
updateTime
in class QueryImpl
SQLException
QueryImpl.updateTime(int, java.sql.Time)
public void updateTime(String columnName, Time x) throws SQLException
updateTime
in interface ResultSet
updateTime
in class QueryImpl
SQLException
QueryImpl.updateTime(java.lang.String, java.sql.Time)
public void updateTimestamp(int columnIndex, Timestamp x) throws SQLException
updateTimestamp
in interface ResultSet
updateTimestamp
in class QueryImpl
SQLException
QueryImpl.updateTimestamp(int, java.sql.Timestamp)
public void updateTimestamp(String columnName, Timestamp x) throws SQLException
updateTimestamp
in interface ResultSet
updateTimestamp
in class QueryImpl
SQLException
QueryImpl.updateTimestamp(java.lang.String, java.sql.Timestamp)
public boolean wasNull()
wasNull
in interface ResultSet
wasNull
in class QueryImpl
QueryImpl.wasNull()
public boolean absolute(int row) throws SQLException
absolute
in interface ResultSet
absolute
in class QueryImpl
SQLException
QueryImpl.absolute(int)
public void afterLast() throws SQLException
afterLast
in interface ResultSet
afterLast
in class QueryImpl
SQLException
QueryImpl.afterLast()
public void beforeFirst() throws SQLException
beforeFirst
in interface ResultSet
beforeFirst
in class QueryImpl
SQLException
QueryImpl.beforeFirst()
public void clearWarnings() throws SQLException
clearWarnings
in interface ResultSet
clearWarnings
in class QueryImpl
SQLException
QueryImpl.clearWarnings()
public void close() throws SQLException
close
in interface ResultSet
close
in class QueryImpl
SQLException
QueryImpl.close()
public int findColumn(String columnName) throws SQLException
findColumn
in interface ResultSet
findColumn
in class QueryImpl
SQLException
QueryImpl.findColumn(java.lang.String)
public boolean first() throws SQLException
first
in interface ResultSet
first
in class QueryImpl
SQLException
QueryImpl.first()
public Array getArray(int i) throws SQLException
getArray
in interface ResultSet
getArray
in class QueryImpl
SQLException
QueryImpl.getArray(int)
public Array getArray(String colName) throws SQLException
getArray
in interface ResultSet
getArray
in class QueryImpl
SQLException
QueryImpl.getArray(java.lang.String)
public InputStream getAsciiStream(int columnIndex) throws SQLException
getAsciiStream
in interface ResultSet
getAsciiStream
in class QueryImpl
SQLException
QueryImpl.getAsciiStream(int)
public InputStream getAsciiStream(String columnName) throws SQLException
getAsciiStream
in interface ResultSet
getAsciiStream
in class QueryImpl
SQLException
QueryImpl.getAsciiStream(java.lang.String)
public BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLException
getBigDecimal
in interface ResultSet
getBigDecimal
in class QueryImpl
SQLException
QueryImpl.getBigDecimal(int, int)
public BigDecimal getBigDecimal(int columnIndex) throws SQLException
getBigDecimal
in interface ResultSet
getBigDecimal
in class QueryImpl
SQLException
QueryImpl.getBigDecimal(int)
public BigDecimal getBigDecimal(String columnName, int scale) throws SQLException
getBigDecimal
in interface ResultSet
getBigDecimal
in class QueryImpl
SQLException
QueryImpl.getBigDecimal(java.lang.String, int)
public BigDecimal getBigDecimal(String columnName) throws SQLException
getBigDecimal
in interface ResultSet
getBigDecimal
in class QueryImpl
SQLException
QueryImpl.getBigDecimal(java.lang.String)
public InputStream getBinaryStream(int columnIndex) throws SQLException
getBinaryStream
in interface ResultSet
getBinaryStream
in class QueryImpl
SQLException
QueryImpl.getBinaryStream(int)
public InputStream getBinaryStream(String columnName) throws SQLException
getBinaryStream
in interface ResultSet
getBinaryStream
in class QueryImpl
SQLException
QueryImpl.getBinaryStream(java.lang.String)
public Blob getBlob(int i) throws SQLException
getBlob
in interface ResultSet
getBlob
in class QueryImpl
SQLException
QueryImpl.getBlob(int)
public Blob getBlob(String colName) throws SQLException
getBlob
in interface ResultSet
getBlob
in class QueryImpl
SQLException
QueryImpl.getBlob(java.lang.String)
public byte getByte(int columnIndex) throws SQLException
getByte
in interface ResultSet
getByte
in class QueryImpl
SQLException
QueryImpl.getByte(int)
public byte getByte(String columnName) throws SQLException
getByte
in interface ResultSet
getByte
in class QueryImpl
SQLException
QueryImpl.getByte(java.lang.String)
public byte[] getBytes(int columnIndex) throws SQLException
getBytes
in interface ResultSet
getBytes
in class QueryImpl
SQLException
QueryImpl.getBytes(int)
public byte[] getBytes(String columnName) throws SQLException
getBytes
in interface ResultSet
getBytes
in class QueryImpl
SQLException
QueryImpl.getBytes(java.lang.String)
public Reader getCharacterStream(int columnIndex) throws SQLException
getCharacterStream
in interface ResultSet
getCharacterStream
in class QueryImpl
SQLException
QueryImpl.getCharacterStream(int)
public Reader getCharacterStream(String columnName) throws SQLException
getCharacterStream
in interface ResultSet
getCharacterStream
in class QueryImpl
SQLException
QueryImpl.getCharacterStream(java.lang.String)
public Clob getClob(int i) throws SQLException
getClob
in interface ResultSet
getClob
in class QueryImpl
SQLException
QueryImpl.getClob(int)
public Clob getClob(String colName) throws SQLException
getClob
in interface ResultSet
getClob
in class QueryImpl
SQLException
QueryImpl.getClob(java.lang.String)
public String getColumnlist(boolean upperCase)
QueryImpl
getColumnlist
in class QueryImpl
QueryImpl.getColumnlist(boolean)
public Collection.Key getColumnName(int columnIndex)
getColumnName
in class QueryImpl
QueryImpl.getColumnName(int)
public Collection.Key[] getColumnNames()
getColumnNames
in interface QueryPro
getColumnNames
in class QueryImpl
QueryImpl.getColumnNames()
public String[] getColumnNamesAsString()
getColumnNamesAsString
in interface QueryPro
getColumnNamesAsString
in class QueryImpl
QueryImpl.getColumnNamesAsString()
public int getConcurrency() throws SQLException
getConcurrency
in interface ResultSet
getConcurrency
in class QueryImpl
SQLException
QueryImpl.getConcurrency()
public String getCursorName() throws SQLException
getCursorName
in interface ResultSet
getCursorName
in class QueryImpl
SQLException
QueryImpl.getCursorName()
public Date getDate(int columnIndex, Calendar cal) throws SQLException
getDate
in interface ResultSet
getDate
in class QueryImpl
SQLException
QueryImpl.getDate(int, java.util.Calendar)
public Date getDate(int columnIndex) throws SQLException
getDate
in interface ResultSet
getDate
in class QueryImpl
SQLException
QueryImpl.getDate(int)
public Date getDate(String columnName, Calendar cal) throws SQLException
getDate
in interface ResultSet
getDate
in class QueryImpl
SQLException
QueryImpl.getDate(java.lang.String, java.util.Calendar)
public Date getDate(String columnName) throws SQLException
getDate
in interface ResultSet
getDate
in class QueryImpl
SQLException
QueryImpl.getDate(java.lang.String)
public double getDouble(int columnIndex) throws SQLException
getDouble
in interface ResultSet
getDouble
in class QueryImpl
SQLException
QueryImpl.getDouble(int)
public double getDouble(String columnName) throws SQLException
getDouble
in interface ResultSet
getDouble
in class QueryImpl
SQLException
QueryImpl.getDouble(java.lang.String)
public int getFetchDirection() throws SQLException
getFetchDirection
in interface ResultSet
getFetchDirection
in class QueryImpl
SQLException
QueryImpl.getFetchDirection()
public int getFetchSize() throws SQLException
getFetchSize
in interface ResultSet
getFetchSize
in class QueryImpl
SQLException
QueryImpl.getFetchSize()
public float getFloat(int columnIndex) throws SQLException
getFloat
in interface ResultSet
getFloat
in class QueryImpl
SQLException
QueryImpl.getFloat(int)
public float getFloat(String columnName) throws SQLException
getFloat
in interface ResultSet
getFloat
in class QueryImpl
SQLException
QueryImpl.getFloat(java.lang.String)
public Query getGeneratedKeys()
getGeneratedKeys
in interface QueryPro
getGeneratedKeys
in class QueryImpl
QueryImpl.getGeneratedKeys()
public int getInt(int columnIndex) throws SQLException
getInt
in interface ResultSet
getInt
in class QueryImpl
SQLException
QueryImpl.getInt(int)
public int getInt(String columnName) throws SQLException
getInt
in interface ResultSet
getInt
in class QueryImpl
SQLException
QueryImpl.getInt(java.lang.String)
public long getLong(int columnIndex) throws SQLException
getLong
in interface ResultSet
getLong
in class QueryImpl
SQLException
QueryImpl.getLong(int)
public long getLong(String columnName) throws SQLException
getLong
in interface ResultSet
getLong
in class QueryImpl
SQLException
QueryImpl.getLong(java.lang.String)
public ResultSetMetaData getMetaData() throws SQLException
getMetaData
in interface ResultSet
getMetaData
in class QueryImpl
SQLException
QueryImpl.getMetaData()
public Object getObject(int i, Map map) throws SQLException
getObject
in interface ResultSet
getObject
in class QueryImpl
SQLException
QueryImpl.getObject(int, java.util.Map)
public Object getObject(String colName, Map map) throws SQLException
getObject
in interface ResultSet
getObject
in class QueryImpl
SQLException
QueryImpl.getObject(java.lang.String, java.util.Map)
public Ref getRef(int i) throws SQLException
getRef
in interface ResultSet
getRef
in class QueryImpl
SQLException
QueryImpl.getRef(int)
public Ref getRef(String colName) throws SQLException
getRef
in interface ResultSet
getRef
in class QueryImpl
SQLException
QueryImpl.getRef(java.lang.String)
public int getRow() throws SQLException
getRow
in interface ResultSet
getRow
in class QueryImpl
SQLException
QueryImpl.getRow()
public short getShort(int columnIndex) throws SQLException
getShort
in interface ResultSet
getShort
in class QueryImpl
SQLException
QueryImpl.getShort(int)
public short getShort(String columnName) throws SQLException
getShort
in interface ResultSet
getShort
in class QueryImpl
SQLException
QueryImpl.getShort(java.lang.String)
public Statement getStatement() throws SQLException
getStatement
in interface ResultSet
getStatement
in class QueryImpl
SQLException
QueryImpl.getStatement()
public Time getTime(int columnIndex, Calendar cal) throws SQLException
getTime
in interface ResultSet
getTime
in class QueryImpl
SQLException
QueryImpl.getTime(int, java.util.Calendar)
public Time getTime(int columnIndex) throws SQLException
getTime
in interface ResultSet
getTime
in class QueryImpl
SQLException
QueryImpl.getTime(int)
public Time getTime(String columnName, Calendar cal) throws SQLException
getTime
in interface ResultSet
getTime
in class QueryImpl
SQLException
QueryImpl.getTime(java.lang.String, java.util.Calendar)
public Time getTime(String columnName) throws SQLException
getTime
in interface ResultSet
getTime
in class QueryImpl
SQLException
QueryImpl.getTime(java.lang.String)
public Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLException
getTimestamp
in interface ResultSet
getTimestamp
in class QueryImpl
SQLException
QueryImpl.getTimestamp(int, java.util.Calendar)
public Timestamp getTimestamp(int columnIndex) throws SQLException
getTimestamp
in interface ResultSet
getTimestamp
in class QueryImpl
SQLException
QueryImpl.getTimestamp(int)
public Timestamp getTimestamp(String columnName, Calendar cal) throws SQLException
getTimestamp
in interface ResultSet
getTimestamp
in class QueryImpl
SQLException
QueryImpl.getTimestamp(java.lang.String, java.util.Calendar)
public Timestamp getTimestamp(String columnName) throws SQLException
getTimestamp
in interface ResultSet
getTimestamp
in class QueryImpl
SQLException
QueryImpl.getTimestamp(java.lang.String)
public int getType() throws SQLException
getType
in interface ResultSet
getType
in class QueryImpl
SQLException
QueryImpl.getType()
public InputStream getUnicodeStream(int columnIndex) throws SQLException
getUnicodeStream
in interface ResultSet
getUnicodeStream
in class QueryImpl
SQLException
QueryImpl.getUnicodeStream(int)
public InputStream getUnicodeStream(String columnName) throws SQLException
getUnicodeStream
in interface ResultSet
getUnicodeStream
in class QueryImpl
SQLException
QueryImpl.getUnicodeStream(java.lang.String)
public int getUpdateCount()
getUpdateCount
in class QueryImpl
QueryImpl.getUpdateCount()
public URL getURL(int columnIndex) throws SQLException
getURL
in interface ResultSet
getURL
in class QueryImpl
SQLException
QueryImpl.getURL(int)
public URL getURL(String columnName) throws SQLException
getURL
in interface ResultSet
getURL
in class QueryImpl
SQLException
QueryImpl.getURL(java.lang.String)
public SQLWarning getWarnings() throws SQLException
getWarnings
in interface ResultSet
getWarnings
in class QueryImpl
SQLException
QueryImpl.getWarnings()
public boolean isAfterLast() throws SQLException
isAfterLast
in interface ResultSet
isAfterLast
in class QueryImpl
SQLException
QueryImpl.isAfterLast()
public boolean isBeforeFirst() throws SQLException
isBeforeFirst
in interface ResultSet
isBeforeFirst
in class QueryImpl
SQLException
QueryImpl.isBeforeFirst()
public boolean isFirst() throws SQLException
isFirst
in interface ResultSet
isFirst
in class QueryImpl
SQLException
QueryImpl.isFirst()
public boolean isLast() throws SQLException
isLast
in interface ResultSet
isLast
in class QueryImpl
SQLException
QueryImpl.isLast()
public boolean last() throws SQLException
last
in interface ResultSet
last
in class QueryImpl
SQLException
QueryImpl.last()
public void moveToCurrentRow() throws SQLException
moveToCurrentRow
in interface ResultSet
moveToCurrentRow
in class QueryImpl
SQLException
QueryImpl.moveToCurrentRow()
public void moveToInsertRow() throws SQLException
moveToInsertRow
in interface ResultSet
moveToInsertRow
in class QueryImpl
SQLException
QueryImpl.moveToInsertRow()
public boolean previous()
previous
in interface ResultSet
previous
in class QueryImpl
QueryImpl.previous()
public boolean previous(int pid)
previous
in interface QueryPro
previous
in class QueryImpl
QueryImpl.previous(int)
public void refreshRow() throws SQLException
refreshRow
in interface ResultSet
refreshRow
in class QueryImpl
SQLException
QueryImpl.refreshRow()
public boolean relative(int rows) throws SQLException
relative
in interface ResultSet
relative
in class QueryImpl
SQLException
QueryImpl.relative(int)
public void setColumnNames(Collection.Key[] trg) throws PageException
setColumnNames
in class QueryImpl
PageException
QueryImpl.setColumnNames(railo.runtime.type.Collection.Key[])
public Iterator valueIterator()
valueIterator
in interface Iteratorable
valueIterator
in class QueryImpl
QueryImpl.valueIterator()
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |