public class TOQuery extends TOObjects implements Query, Query
Collection.Key
ORDER_ASC, ORDER_DESC
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
Modifier and Type | Method and Description |
---|---|
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() |
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() |
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
|
void |
deleteRow() |
Collection |
duplicate(boolean deepCopy) |
Iterator<Map.Entry<Collection.Key,Object>> |
entryIterator() |
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(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
|
Collection.Key[] |
getColumnNames() |
String[] |
getColumnNamesAsString() |
String[] |
getColumns() |
int |
getConcurrency() |
int |
getCurrentrow(int pid)
return the current position of the internal pointer
|
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) |
long |
getExecutionTime() |
int |
getFetchDirection() |
int |
getFetchSize() |
float |
getFloat(int columnIndex) |
float |
getFloat(String columnName) |
Query |
getGeneratedKeys() |
int |
getHoldability() |
int |
getInt(int columnIndex) |
int |
getInt(String columnName) |
Iterator |
getIterator() |
long |
getLong(int columnIndex) |
long |
getLong(String columnName) |
ResultSetMetaData |
getMetaData() |
Array |
getMetaDataSimple() |
String |
getName() |
Reader |
getNCharacterStream(int columnIndex) |
Reader |
getNCharacterStream(String columnLabel) |
NClob |
getNClob(int arg0) |
NClob |
getNClob(String arg0) |
String |
getNString(int columnIndex) |
String |
getNString(String columnLabel) |
Object |
getObject(int columnIndex) |
<T> T |
getObject(int columnIndex,
Class<T> type) |
Object |
getObject(int arg0,
Map<String,Class<?>> arg1) |
Object |
getObject(String columnName) |
<T> T |
getObject(String columnLabel,
Class<T> type) |
Object |
getObject(String arg0,
Map<String,Class<?>> arg1) |
int |
getRecordcount()
return recordcount of the iterator object
|
Ref |
getRef(int i) |
Ref |
getRef(String colName) |
int |
getRow() |
int |
getRowCount() |
RowId |
getRowId(int arg0) |
RowId |
getRowId(String arg0) |
short |
getShort(int columnIndex) |
short |
getShort(String columnName) |
SQL |
getSql() |
SQLXML |
getSQLXML(int arg0) |
SQLXML |
getSQLXML(String arg0) |
Statement |
getStatement() |
String |
getString(int columnIndex) |
String |
getString(String columnName) |
String |
getTemplate() |
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,
int pid)
set the internal pointer to defined position
|
void |
insertRow() |
boolean |
isAfterLast() |
boolean |
isBeforeFirst() |
boolean |
isCached()
is query from cache or not
|
boolean |
isClosed() |
boolean |
isEmpty() |
boolean |
isFirst() |
boolean |
isLast() |
boolean |
isWrapperFor(Class<?> iface) |
Iterator<Collection.Key> |
keyIterator() |
Collection.Key[] |
keys() |
Iterator<String> |
keysAsStringIterator() |
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
|
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
|
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(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 |
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(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) |
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, direction is asc
|
void |
sort(String strColumn,
int order)
sorts a query by a column
|
DumpData |
toDumpData(PageContext pageContext,
int maxlevel,
DumpProperties properties)
method to print out information to a object as HTML
|
<T> T |
unwrap(Class<T> iface) |
void |
updateArray(int columnIndex,
Array x) |
void |
updateArray(String columnName,
Array x) |
void |
updateAsciiStream(int columnIndex,
InputStream x) |
void |
updateAsciiStream(int columnIndex,
InputStream x,
int length) |
void |
updateAsciiStream(int columnIndex,
InputStream x,
long length) |
void |
updateAsciiStream(String columnLabel,
InputStream x) |
void |
updateAsciiStream(String columnName,
InputStream x,
int length) |
void |
updateAsciiStream(String columnLabel,
InputStream x,
long length) |
void |
updateBigDecimal(int columnIndex,
BigDecimal x) |
void |
updateBigDecimal(String columnName,
BigDecimal x) |
void |
updateBinaryStream(int columnIndex,
InputStream x) |
void |
updateBinaryStream(int columnIndex,
InputStream x,
int length) |
void |
updateBinaryStream(int columnIndex,
InputStream x,
long length) |
void |
updateBinaryStream(String columnLabel,
InputStream x) |
void |
updateBinaryStream(String columnName,
InputStream x,
int length) |
void |
updateBinaryStream(String columnLabel,
InputStream x,
long length) |
void |
updateBlob(int columnIndex,
Blob x) |
void |
updateBlob(int columnIndex,
InputStream inputStream) |
void |
updateBlob(int columnIndex,
InputStream inputStream,
long length) |
void |
updateBlob(String columnName,
Blob x) |
void |
updateBlob(String columnLabel,
InputStream inputStream) |
void |
updateBlob(String columnLabel,
InputStream inputStream,
long length) |
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 x) |
void |
updateCharacterStream(int columnIndex,
Reader reader,
int length) |
void |
updateCharacterStream(int columnIndex,
Reader x,
long length) |
void |
updateCharacterStream(String columnLabel,
Reader reader) |
void |
updateCharacterStream(String columnName,
Reader reader,
int length) |
void |
updateCharacterStream(String columnLabel,
Reader reader,
long length) |
void |
updateClob(int columnIndex,
Clob x) |
void |
updateClob(int columnIndex,
Reader reader) |
void |
updateClob(int columnIndex,
Reader reader,
long length) |
void |
updateClob(String columnName,
Clob x) |
void |
updateClob(String columnLabel,
Reader reader) |
void |
updateClob(String columnLabel,
Reader reader,
long length) |
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 |
updateNCharacterStream(int columnIndex,
Reader x) |
void |
updateNCharacterStream(int columnIndex,
Reader x,
long length) |
void |
updateNCharacterStream(String columnLabel,
Reader reader) |
void |
updateNCharacterStream(String columnLabel,
Reader reader,
long length) |
void |
updateNClob(int arg0,
NClob arg1) |
void |
updateNClob(int columnIndex,
Reader reader) |
void |
updateNClob(int columnIndex,
Reader reader,
long length) |
void |
updateNClob(String arg0,
NClob arg1) |
void |
updateNClob(String columnLabel,
Reader reader) |
void |
updateNClob(String columnLabel,
Reader reader,
long length) |
void |
updateNString(int columnIndex,
String nString) |
void |
updateNString(String columnLabel,
String nString) |
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 |
updateRowId(int arg0,
RowId arg1) |
void |
updateRowId(String arg0,
RowId arg1) |
void |
updateShort(int columnIndex,
short x) |
void |
updateShort(String columnName,
short x) |
void |
updateSQLXML(int arg0,
SQLXML arg1) |
void |
updateSQLXML(String columnIndex,
SQLXML 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<Object> |
valueIterator() |
boolean |
wasNull() |
call, callWithNamedValues, get, get, isInitalized, set, setEL
equals, log, toString, toTraceObject
getClass, hashCode, notify, notifyAll, wait, wait, wait
clear, containsKey, containsKey, 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
public int executionTime()
public int getUpdateCount()
public Query getGeneratedKeys()
public Object getAt(String key, int row, Object defaultValue)
Query
key
- column to getrow
- row to get from (1-recordcount)public Object getAt(Collection.Key key, int row, Object defaultValue)
Query
key
- column to getrow
- row to get from (1-recordcount)public Object getAt(String key, int row) throws PageException
Query
key
- column to getrow
- row to get from (1-recordcount)PageException
- if invalid position definitionpublic Object getAt(Collection.Key key, int row) throws PageException
Query
key
- column to getrow
- row to get from (1-recordcount)PageException
- if invalid position definitionpublic int removeRow(int row) throws PageException
Query
PageException
public int removeRowEL(int row)
Query
public QueryColumn removeColumn(String key) throws PageException
Query
key
- key to removePageException
public QueryColumn removeColumn(Collection.Key key) throws PageException
Query
key
- key to removePageException
public QueryColumn removeColumnEL(String key)
Query
key
- key to removepublic QueryColumn removeColumnEL(Collection.Key key)
Query
key
- key to removepublic Object setAt(String key, int row, Object value) throws PageException
Query
key
- column to setrow
- row to setvalue
- value to fillPageException
public Object setAt(Collection.Key key, int row, Object value) throws PageException
Query
key
- column to setrow
- row to setvalue
- value to fillPageException
public Object setAtEL(String key, int row, Object value)
Query
key
- column to setrow
- row to setvalue
- value to fillpublic Object setAtEL(Collection.Key key, int row, Object value)
Query
key
- column to setrow
- row to setvalue
- value to fillpublic boolean next()
Iterator
public boolean next(int pid) throws PageException
Iterator
next
in interface Iterator
PageException
public void reset() throws PageException
Iterator
reset
in interface Iterator
PageException
public void reset(int pid) throws PageException
Iterator
reset
in interface Iterator
PageException
public int getRecordcount()
Iterator
getRecordcount
in interface Iterator
public int getCurrentrow(int pid)
Iterator
getCurrentrow
in interface Iterator
public boolean go(int index, int pid) throws PageException
Iterator
go
in interface Iterator
PageException
public boolean isEmpty()
public void sort(String column) throws PageException
Query
column
- colun to sortPageException
public void sort(Collection.Key column) throws PageException
Query
column
- colun to sortPageException
public void sort(String strColumn, int order) throws PageException
Query
strColumn
- column to sortorder
- sort type (Query.ORDER_ASC or Query.ORDER_DESC)PageException
public void sort(Collection.Key keyColumn, int order) throws PageException
Query
keyColumn
- column to sortorder
- sort type (Query.ORDER_ASC or Query.ORDER_DESC)PageException
public boolean addRow(int count)
Query
count
- count of rows to addpublic boolean addColumn(String columnName, Array content) throws PageException
Query
columnName
- name of the new columncontent
- content of the new column inside a array (must have same size like query has records)PageException
public boolean addColumn(Collection.Key columnName, Array content) throws PageException
Query
columnName
- name of the new columncontent
- content of the new column inside a array (must have same size like query has records)PageException
public boolean addColumn(String columnName, Array content, int type) throws PageException
Query
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
public boolean addColumn(Collection.Key columnName, Array content, int type) throws PageException
Query
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
public int[] getTypes()
public Map getTypesAsMap()
public QueryColumn getColumn(String key) throws PageException
Query
key
- key to getPageException
public QueryColumn getColumn(Collection.Key key) throws PageException
Query
key
- key to getPageException
public void rename(Collection.Key columnName, Collection.Key newColumnName) throws PageException
PageException
public QueryColumn getColumn(String key, QueryColumn defaultValue)
Query
key
- key to getpublic QueryColumn getColumn(Collection.Key key, QueryColumn defaultValue)
Query
key
- key to getpublic void setExecutionTime(long exeTime)
Query
public void setCached(boolean isCached)
Query
isCached
- is cached or notpublic boolean isCached()
Query
public int getColumnIndex(String coulmnName)
Query
getColumnIndex
in interface Query
coulmnName
- column name to get index forpublic String[] getColumns()
getColumns
in interface Query
public Collection.Key[] getColumnNames()
getColumnNames
in interface Query
public String[] getColumnNamesAsString()
getColumnNamesAsString
in interface Query
public String getData(int row, int col) throws IndexOutOfBoundsException
Query
getData
in interface Query
IndexOutOfBoundsException
public int getRowCount()
getRowCount
in interface Query
public void setData(int row, int col, String value) throws IndexOutOfBoundsException
Query
setData
in interface Query
IndexOutOfBoundsException
public Array getMetaDataSimple()
public Object getObject(String columnName) throws SQLException
getObject
in interface ResultSet
SQLException
public Object getObject(int columnIndex) throws SQLException
getObject
in interface ResultSet
SQLException
public String getString(int columnIndex) throws SQLException
getString
in interface ResultSet
SQLException
public String getString(String columnName) throws SQLException
getString
in interface ResultSet
SQLException
public boolean getBoolean(int columnIndex) throws SQLException
getBoolean
in interface ResultSet
SQLException
public boolean getBoolean(String columnName) throws SQLException
getBoolean
in interface ResultSet
SQLException
public boolean wasNull() throws SQLException
wasNull
in interface ResultSet
SQLException
public boolean absolute(int row) throws SQLException
absolute
in interface ResultSet
SQLException
public void afterLast() throws SQLException
afterLast
in interface ResultSet
SQLException
public void beforeFirst() throws SQLException
beforeFirst
in interface ResultSet
SQLException
public void cancelRowUpdates() throws SQLException
cancelRowUpdates
in interface ResultSet
SQLException
public void clearWarnings() throws SQLException
clearWarnings
in interface ResultSet
SQLException
public void close() throws SQLException
close
in interface AutoCloseable
close
in interface ResultSet
SQLException
public void deleteRow() throws SQLException
deleteRow
in interface ResultSet
SQLException
public int findColumn(String columnName) throws SQLException
findColumn
in interface ResultSet
SQLException
public boolean first() throws SQLException
first
in interface ResultSet
SQLException
public Array getArray(int i) throws SQLException
getArray
in interface ResultSet
SQLException
public Array getArray(String colName) throws SQLException
getArray
in interface ResultSet
SQLException
public InputStream getAsciiStream(int columnIndex) throws SQLException
getAsciiStream
in interface ResultSet
SQLException
public InputStream getAsciiStream(String columnName) throws SQLException
getAsciiStream
in interface ResultSet
SQLException
public BigDecimal getBigDecimal(int columnIndex) throws SQLException
getBigDecimal
in interface ResultSet
SQLException
public BigDecimal getBigDecimal(String columnName) throws SQLException
getBigDecimal
in interface ResultSet
SQLException
public BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLException
getBigDecimal
in interface ResultSet
SQLException
public BigDecimal getBigDecimal(String columnName, int scale) throws SQLException
getBigDecimal
in interface ResultSet
SQLException
public InputStream getBinaryStream(int columnIndex) throws SQLException
getBinaryStream
in interface ResultSet
SQLException
public InputStream getBinaryStream(String columnName) throws SQLException
getBinaryStream
in interface ResultSet
SQLException
public Blob getBlob(int i) throws SQLException
getBlob
in interface ResultSet
SQLException
public Blob getBlob(String colName) throws SQLException
getBlob
in interface ResultSet
SQLException
public byte getByte(int columnIndex) throws SQLException
getByte
in interface ResultSet
SQLException
public byte getByte(String columnName) throws SQLException
getByte
in interface ResultSet
SQLException
public byte[] getBytes(int columnIndex) throws SQLException
getBytes
in interface ResultSet
SQLException
public byte[] getBytes(String columnName) throws SQLException
getBytes
in interface ResultSet
SQLException
public Reader getCharacterStream(int columnIndex) throws SQLException
getCharacterStream
in interface ResultSet
SQLException
public Reader getCharacterStream(String columnName) throws SQLException
getCharacterStream
in interface ResultSet
SQLException
public Clob getClob(int i) throws SQLException
getClob
in interface ResultSet
SQLException
public Clob getClob(String colName) throws SQLException
getClob
in interface ResultSet
SQLException
public int getConcurrency() throws SQLException
getConcurrency
in interface ResultSet
SQLException
public String getCursorName() throws SQLException
getCursorName
in interface ResultSet
SQLException
public Date getDate(int columnIndex) throws SQLException
getDate
in interface ResultSet
SQLException
public Date getDate(String columnName) throws SQLException
getDate
in interface ResultSet
SQLException
public Date getDate(int columnIndex, Calendar cal) throws SQLException
getDate
in interface ResultSet
SQLException
public Date getDate(String columnName, Calendar cal) throws SQLException
getDate
in interface ResultSet
SQLException
public double getDouble(int columnIndex) throws SQLException
getDouble
in interface ResultSet
SQLException
public double getDouble(String columnName) throws SQLException
getDouble
in interface ResultSet
SQLException
public int getFetchDirection() throws SQLException
getFetchDirection
in interface ResultSet
SQLException
public int getFetchSize() throws SQLException
getFetchSize
in interface ResultSet
SQLException
public float getFloat(int columnIndex) throws SQLException
getFloat
in interface ResultSet
SQLException
public float getFloat(String columnName) throws SQLException
getFloat
in interface ResultSet
SQLException
public int getInt(int columnIndex) throws SQLException
getInt
in interface ResultSet
SQLException
public int getInt(String columnName) throws SQLException
getInt
in interface ResultSet
SQLException
public long getLong(int columnIndex) throws SQLException
getLong
in interface ResultSet
SQLException
public long getLong(String columnName) throws SQLException
getLong
in interface ResultSet
SQLException
public Ref getRef(int i) throws SQLException
getRef
in interface ResultSet
SQLException
public Ref getRef(String colName) throws SQLException
getRef
in interface ResultSet
SQLException
public int getRow() throws SQLException
getRow
in interface ResultSet
SQLException
public short getShort(int columnIndex) throws SQLException
getShort
in interface ResultSet
SQLException
public short getShort(String columnName) throws SQLException
getShort
in interface ResultSet
SQLException
public Statement getStatement() throws SQLException
getStatement
in interface ResultSet
SQLException
public Time getTime(int columnIndex) throws SQLException
getTime
in interface ResultSet
SQLException
public Time getTime(String columnName) throws SQLException
getTime
in interface ResultSet
SQLException
public Time getTime(int columnIndex, Calendar cal) throws SQLException
getTime
in interface ResultSet
SQLException
public Time getTime(String columnName, Calendar cal) throws SQLException
getTime
in interface ResultSet
SQLException
public Timestamp getTimestamp(int columnIndex) throws SQLException
getTimestamp
in interface ResultSet
SQLException
public Timestamp getTimestamp(String columnName) throws SQLException
getTimestamp
in interface ResultSet
SQLException
public Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLException
getTimestamp
in interface ResultSet
SQLException
public Timestamp getTimestamp(String columnName, Calendar cal) throws SQLException
getTimestamp
in interface ResultSet
SQLException
public int getType() throws SQLException
getType
in interface ResultSet
SQLException
public URL getURL(int columnIndex) throws SQLException
getURL
in interface ResultSet
SQLException
public URL getURL(String columnName) throws SQLException
getURL
in interface ResultSet
SQLException
public InputStream getUnicodeStream(int columnIndex) throws SQLException
getUnicodeStream
in interface ResultSet
SQLException
public InputStream getUnicodeStream(String columnName) throws SQLException
getUnicodeStream
in interface ResultSet
SQLException
public SQLWarning getWarnings() throws SQLException
getWarnings
in interface ResultSet
SQLException
public void insertRow() throws SQLException
insertRow
in interface ResultSet
SQLException
public boolean isAfterLast() throws SQLException
isAfterLast
in interface ResultSet
SQLException
public boolean isBeforeFirst() throws SQLException
isBeforeFirst
in interface ResultSet
SQLException
public boolean isFirst() throws SQLException
isFirst
in interface ResultSet
SQLException
public boolean isLast() throws SQLException
isLast
in interface ResultSet
SQLException
public boolean last() throws SQLException
last
in interface ResultSet
SQLException
public void moveToCurrentRow() throws SQLException
moveToCurrentRow
in interface ResultSet
SQLException
public void moveToInsertRow() throws SQLException
moveToInsertRow
in interface ResultSet
SQLException
public boolean previous() throws SQLException
previous
in interface ResultSet
SQLException
public void refreshRow() throws SQLException
refreshRow
in interface ResultSet
SQLException
public boolean relative(int rows) throws SQLException
relative
in interface ResultSet
SQLException
public boolean rowDeleted() throws SQLException
rowDeleted
in interface ResultSet
SQLException
public boolean rowInserted() throws SQLException
rowInserted
in interface ResultSet
SQLException
public boolean rowUpdated() throws SQLException
rowUpdated
in interface ResultSet
SQLException
public void setFetchDirection(int direction) throws SQLException
setFetchDirection
in interface ResultSet
SQLException
public void setFetchSize(int rows) throws SQLException
setFetchSize
in interface ResultSet
SQLException
public void updateArray(int columnIndex, Array x) throws SQLException
updateArray
in interface ResultSet
SQLException
public void updateArray(String columnName, Array x) throws SQLException
updateArray
in interface ResultSet
SQLException
public void updateAsciiStream(int columnIndex, InputStream x, int length) throws SQLException
updateAsciiStream
in interface ResultSet
SQLException
public void updateAsciiStream(String columnName, InputStream x, int length) throws SQLException
updateAsciiStream
in interface ResultSet
SQLException
public void updateBigDecimal(int columnIndex, BigDecimal x) throws SQLException
updateBigDecimal
in interface ResultSet
SQLException
public void updateBigDecimal(String columnName, BigDecimal x) throws SQLException
updateBigDecimal
in interface ResultSet
SQLException
public void updateBinaryStream(int columnIndex, InputStream x, int length) throws SQLException
updateBinaryStream
in interface ResultSet
SQLException
public void updateBinaryStream(String columnName, InputStream x, int length) throws SQLException
updateBinaryStream
in interface ResultSet
SQLException
public void updateBlob(int columnIndex, Blob x) throws SQLException
updateBlob
in interface ResultSet
SQLException
public void updateBlob(String columnName, Blob x) throws SQLException
updateBlob
in interface ResultSet
SQLException
public void updateBoolean(int columnIndex, boolean x) throws SQLException
updateBoolean
in interface ResultSet
SQLException
public void updateBoolean(String columnName, boolean x) throws SQLException
updateBoolean
in interface ResultSet
SQLException
public void updateByte(int columnIndex, byte x) throws SQLException
updateByte
in interface ResultSet
SQLException
public void updateByte(String columnName, byte x) throws SQLException
updateByte
in interface ResultSet
SQLException
public void updateBytes(int columnIndex, byte[] x) throws SQLException
updateBytes
in interface ResultSet
SQLException
public void updateBytes(String columnName, byte[] x) throws SQLException
updateBytes
in interface ResultSet
SQLException
public void updateCharacterStream(int columnIndex, Reader reader, int length) throws SQLException
updateCharacterStream
in interface ResultSet
SQLException
public void updateCharacterStream(String columnName, Reader reader, int length) throws SQLException
updateCharacterStream
in interface ResultSet
SQLException
public void updateClob(int columnIndex, Clob x) throws SQLException
updateClob
in interface ResultSet
SQLException
public void updateClob(String columnName, Clob x) throws SQLException
updateClob
in interface ResultSet
SQLException
public void updateDate(int columnIndex, Date x) throws SQLException
updateDate
in interface ResultSet
SQLException
public void updateDate(String columnName, Date x) throws SQLException
updateDate
in interface ResultSet
SQLException
public void updateDouble(int columnIndex, double x) throws SQLException
updateDouble
in interface ResultSet
SQLException
public void updateDouble(String columnName, double x) throws SQLException
updateDouble
in interface ResultSet
SQLException
public void updateFloat(int columnIndex, float x) throws SQLException
updateFloat
in interface ResultSet
SQLException
public void updateFloat(String columnName, float x) throws SQLException
updateFloat
in interface ResultSet
SQLException
public void updateInt(int columnIndex, int x) throws SQLException
updateInt
in interface ResultSet
SQLException
public void updateInt(String columnName, int x) throws SQLException
updateInt
in interface ResultSet
SQLException
public void updateLong(int columnIndex, long x) throws SQLException
updateLong
in interface ResultSet
SQLException
public void updateLong(String columnName, long x) throws SQLException
updateLong
in interface ResultSet
SQLException
public void updateNull(int columnIndex) throws SQLException
updateNull
in interface ResultSet
SQLException
public void updateNull(String columnName) throws SQLException
updateNull
in interface ResultSet
SQLException
public void updateObject(int columnIndex, Object x) throws SQLException
updateObject
in interface ResultSet
SQLException
public void updateObject(String columnName, Object x) throws SQLException
updateObject
in interface ResultSet
SQLException
public void updateObject(int columnIndex, Object x, int scale) throws SQLException
updateObject
in interface ResultSet
SQLException
public void updateObject(String columnName, Object x, int scale) throws SQLException
updateObject
in interface ResultSet
SQLException
public void updateRef(int columnIndex, Ref x) throws SQLException
updateRef
in interface ResultSet
SQLException
public void updateRef(String columnName, Ref x) throws SQLException
updateRef
in interface ResultSet
SQLException
public void updateRow() throws SQLException
updateRow
in interface ResultSet
SQLException
public void updateShort(int columnIndex, short x) throws SQLException
updateShort
in interface ResultSet
SQLException
public void updateShort(String columnName, short x) throws SQLException
updateShort
in interface ResultSet
SQLException
public void updateString(int columnIndex, String x) throws SQLException
updateString
in interface ResultSet
SQLException
public void updateString(String columnName, String x) throws SQLException
updateString
in interface ResultSet
SQLException
public void updateTime(int columnIndex, Time x) throws SQLException
updateTime
in interface ResultSet
SQLException
public void updateTime(String columnName, Time x) throws SQLException
updateTime
in interface ResultSet
SQLException
public void updateTimestamp(int columnIndex, Timestamp x) throws SQLException
updateTimestamp
in interface ResultSet
SQLException
public void updateTimestamp(String columnName, Timestamp x) throws SQLException
updateTimestamp
in interface ResultSet
SQLException
public ResultSetMetaData getMetaData() throws SQLException
getMetaData
in interface ResultSet
SQLException
public int getHoldability() throws SQLException
getHoldability
in interface ResultSet
SQLException
public boolean isClosed() throws SQLException
isClosed
in interface ResultSet
SQLException
public void updateNString(int columnIndex, String nString) throws SQLException
updateNString
in interface ResultSet
SQLException
public void updateNString(String columnLabel, String nString) throws SQLException
updateNString
in interface ResultSet
SQLException
public String getNString(int columnIndex) throws SQLException
getNString
in interface ResultSet
SQLException
public String getNString(String columnLabel) throws SQLException
getNString
in interface ResultSet
SQLException
public Reader getNCharacterStream(int columnIndex) throws SQLException
getNCharacterStream
in interface ResultSet
SQLException
public Reader getNCharacterStream(String columnLabel) throws SQLException
getNCharacterStream
in interface ResultSet
SQLException
public void updateNCharacterStream(int columnIndex, Reader x, long length) throws SQLException
updateNCharacterStream
in interface ResultSet
SQLException
public void updateNCharacterStream(String columnLabel, Reader reader, long length) throws SQLException
updateNCharacterStream
in interface ResultSet
SQLException
public void updateAsciiStream(int columnIndex, InputStream x, long length) throws SQLException
updateAsciiStream
in interface ResultSet
SQLException
public void updateBinaryStream(int columnIndex, InputStream x, long length) throws SQLException
updateBinaryStream
in interface ResultSet
SQLException
public void updateCharacterStream(int columnIndex, Reader x, long length) throws SQLException
updateCharacterStream
in interface ResultSet
SQLException
public void updateAsciiStream(String columnLabel, InputStream x, long length) throws SQLException
updateAsciiStream
in interface ResultSet
SQLException
public void updateBinaryStream(String columnLabel, InputStream x, long length) throws SQLException
updateBinaryStream
in interface ResultSet
SQLException
public void updateCharacterStream(String columnLabel, Reader reader, long length) throws SQLException
updateCharacterStream
in interface ResultSet
SQLException
public void updateBlob(int columnIndex, InputStream inputStream, long length) throws SQLException
updateBlob
in interface ResultSet
SQLException
public void updateBlob(String columnLabel, InputStream inputStream, long length) throws SQLException
updateBlob
in interface ResultSet
SQLException
public void updateClob(int columnIndex, Reader reader, long length) throws SQLException
updateClob
in interface ResultSet
SQLException
public void updateClob(String columnLabel, Reader reader, long length) throws SQLException
updateClob
in interface ResultSet
SQLException
public void updateNClob(int columnIndex, Reader reader, long length) throws SQLException
updateNClob
in interface ResultSet
SQLException
public void updateNClob(String columnLabel, Reader reader, long length) throws SQLException
updateNClob
in interface ResultSet
SQLException
public void updateNCharacterStream(int columnIndex, Reader x) throws SQLException
updateNCharacterStream
in interface ResultSet
SQLException
public void updateNCharacterStream(String columnLabel, Reader reader) throws SQLException
updateNCharacterStream
in interface ResultSet
SQLException
public void updateAsciiStream(int columnIndex, InputStream x) throws SQLException
updateAsciiStream
in interface ResultSet
SQLException
public void updateBinaryStream(int columnIndex, InputStream x) throws SQLException
updateBinaryStream
in interface ResultSet
SQLException
public void updateCharacterStream(int columnIndex, Reader x) throws SQLException
updateCharacterStream
in interface ResultSet
SQLException
public void updateAsciiStream(String columnLabel, InputStream x) throws SQLException
updateAsciiStream
in interface ResultSet
SQLException
public void updateBinaryStream(String columnLabel, InputStream x) throws SQLException
updateBinaryStream
in interface ResultSet
SQLException
public void updateCharacterStream(String columnLabel, Reader reader) throws SQLException
updateCharacterStream
in interface ResultSet
SQLException
public void updateBlob(int columnIndex, InputStream inputStream) throws SQLException
updateBlob
in interface ResultSet
SQLException
public void updateBlob(String columnLabel, InputStream inputStream) throws SQLException
updateBlob
in interface ResultSet
SQLException
public void updateClob(int columnIndex, Reader reader) throws SQLException
updateClob
in interface ResultSet
SQLException
public void updateClob(String columnLabel, Reader reader) throws SQLException
updateClob
in interface ResultSet
SQLException
public void updateNClob(int columnIndex, Reader reader) throws SQLException
updateNClob
in interface ResultSet
SQLException
public void updateNClob(String columnLabel, Reader reader) throws SQLException
updateNClob
in interface ResultSet
SQLException
public <T> T unwrap(Class<T> iface) throws SQLException
unwrap
in interface Wrapper
SQLException
public boolean isWrapperFor(Class<?> iface) throws SQLException
isWrapperFor
in interface Wrapper
SQLException
public Collection duplicate(boolean deepCopy)
duplicate
in interface Collection
public NClob getNClob(int arg0) throws SQLException
getNClob
in interface ResultSet
SQLException
public NClob getNClob(String arg0) throws SQLException
getNClob
in interface ResultSet
SQLException
public Object getObject(int arg0, Map<String,Class<?>> arg1) throws SQLException
getObject
in interface ResultSet
SQLException
public Object getObject(String arg0, Map<String,Class<?>> arg1) throws SQLException
getObject
in interface ResultSet
SQLException
public <T> T getObject(int columnIndex, Class<T> type) throws SQLException
getObject
in interface ResultSet
SQLException
public <T> T getObject(String columnLabel, Class<T> type) throws SQLException
getObject
in interface ResultSet
SQLException
public RowId getRowId(int arg0) throws SQLException
getRowId
in interface ResultSet
SQLException
public RowId getRowId(String arg0) throws SQLException
getRowId
in interface ResultSet
SQLException
public SQLXML getSQLXML(int arg0) throws SQLException
getSQLXML
in interface ResultSet
SQLException
public SQLXML getSQLXML(String arg0) throws SQLException
getSQLXML
in interface ResultSet
SQLException
public void updateNClob(int arg0, NClob arg1) throws SQLException
updateNClob
in interface ResultSet
SQLException
public void updateNClob(String arg0, NClob arg1) throws SQLException
updateNClob
in interface ResultSet
SQLException
public void updateRowId(int arg0, RowId arg1) throws SQLException
updateRowId
in interface ResultSet
SQLException
public void updateRowId(String arg0, RowId arg1) throws SQLException
updateRowId
in interface ResultSet
SQLException
public void updateSQLXML(int arg0, SQLXML arg1) throws SQLException
updateSQLXML
in interface ResultSet
SQLException
public void updateSQLXML(String columnIndex, SQLXML x) throws SQLException
updateSQLXML
in interface ResultSet
SQLException
public String getTemplate()
public long getExecutionTime()
public Iterator getIterator()
getIterator
in interface ForEachIteratorable
public Object clone()
clone
in interface Collection
clone
in class Object
public Iterator<Collection.Key> keyIterator()
keyIterator
in interface Iteratorable
public Iterator<String> keysAsStringIterator()
keysAsStringIterator
in interface Iteratorable
public Iterator<Map.Entry<Collection.Key,Object>> entryIterator()
entryIterator
in interface Iteratorable
public Iterator<Object> valueIterator()
valueIterator
in interface Iteratorable
public String castToString() throws PageException
Castable
castToString
in interface Castable
castToString
in class TOObjects
PageException
public String castToString(String defaultValue)
Castable
castToString
in interface Castable
castToString
in class TOObjects
public boolean castToBooleanValue() throws PageException
Castable
castToBooleanValue
in interface Castable
castToBooleanValue
in class TOObjects
PageException
public Boolean castToBoolean(Boolean defaultValue)
Castable
castToBoolean
in interface Castable
castToBoolean
in class TOObjects
public double castToDoubleValue() throws PageException
Castable
castToDoubleValue
in interface Castable
castToDoubleValue
in class TOObjects
PageException
public double castToDoubleValue(double defaultValue)
Castable
castToDoubleValue
in interface Castable
castToDoubleValue
in class TOObjects
public DateTime castToDateTime() throws PageException
Castable
castToDateTime
in interface Castable
castToDateTime
in class TOObjects
PageException
public DateTime castToDateTime(DateTime defaultValue)
Castable
castToDateTime
in interface Castable
castToDateTime
in class TOObjects
defaultValue
- returned when it is not possible to cast to a dateTime objectpublic int compareTo(String str) throws PageException
compareTo
in interface Castable
compareTo
in class TOObjects
PageException
public int compareTo(boolean b) throws PageException
compareTo
in interface Castable
compareTo
in class TOObjects
PageException
public int compareTo(double d) throws PageException
compareTo
in interface Castable
compareTo
in class TOObjects
PageException
public int compareTo(DateTime dt) throws PageException
compareTo
in interface Castable
compareTo
in class TOObjects
PageException
public int size()
size
in interface Collection
public Collection.Key[] keys()
keys
in interface Collection
public Object remove(Collection.Key key) throws PageException
Collection
remove
in interface Collection
key
- key of the collectionPageException
public Object removeEL(Collection.Key key)
Collection
removeEL
in interface Collection
key
- key of the collectionpublic void clear()
Collection
clear
in interface Collection
public Object get(String key) throws PageException
Collection
get
in interface Collection
key
- key of the value to getPageException
public Object get(Collection.Key key) throws PageException
Collection
get
in interface Collection
key
- key of the value to get must be lower casePageException
public Object get(String key, Object defaultValue)
Collection
get
in interface Collection
key
- key of the value to getpublic Object get(Collection.Key key, Object defaultValue)
Collection
get
in interface Collection
key
- key of the value to getpublic Object set(String key, Object value) throws PageException
Collection
set
in interface Collection
key
- key of the new valuevalue
- value to setPageException
public Object set(Collection.Key key, Object value) throws PageException
Collection
set
in interface Collection
key
- key of the new valuevalue
- value to setPageException
public Object setEL(String key, Object value)
Collection
setEL
in interface Collection
key
- key of the value to getvalue
- value to setpublic Object setEL(Collection.Key key, Object value)
Collection
setEL
in interface Collection
key
- key of the value to getvalue
- value to setpublic boolean containsKey(String key)
Collection
containsKey
in interface Collection
public boolean containsKey(Collection.Key key)
Collection
containsKey
in interface Collection
public DumpData toDumpData(PageContext pageContext, int maxlevel, DumpProperties properties)
Dumpable
toDumpData
in interface Dumpable
toDumpData
in class TOObjects
Copyright © 2015 Lucee