|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectrailo.runtime.type.QueryImpl
public class QueryImpl
Nested Class Summary |
---|
Nested classes/interfaces inherited from interface railo.runtime.type.Collection |
---|
Collection.Key |
Field Summary | |
---|---|
static Collection.Key |
CACHED
|
static Collection.Key |
COLUMNLIST
|
static Collection.Key |
COLUMNS
|
static Collection.Key |
CURRENTROW
|
static Collection.Key |
EXECUTION_TIME
|
static Collection.Key |
GENERATED_KEYS
|
static Collection.Key |
IDENTITYCOL
|
static Collection.Key |
RECORDCOUNT
|
static Collection.Key |
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 | |
---|---|
QueryImpl()
Constructor of the class only for internal usage (cloning/deserialize) |
|
QueryImpl(Array arrColumns,
Array arrTypes,
int rowNumber,
String name)
constructor of the class, to generate a empty resultset (no database execution) |
|
QueryImpl(Array arrColumns,
int rowNumber,
String name)
constructor of the class, to generate a empty resultset (no database execution) |
|
QueryImpl(Collection.Key[] columnNames,
Array[] arrColumns,
String name)
|
|
QueryImpl(Collection.Key[] columnKeys,
int rowNumber,
String name)
constructor of the class, to generate a empty resultset (no database execution) |
|
QueryImpl(Collection.Key[] columnNames,
String[] strTypes,
int rowNumber,
String name)
constructor of the class, to generate a empty resultset (no database execution) |
|
QueryImpl(DatasourceConnection dc,
SQL sql,
int maxrow,
int fetchsize,
int timeout,
String name)
constructor of the class, to generate a resultset from a sql query |
|
QueryImpl(DatasourceConnection dc,
SQL sql,
int maxrow,
int fetchsize,
int timeout,
String name,
String template)
|
|
QueryImpl(DatasourceConnection dc,
SQL sql,
int maxrow,
int fetchsize,
int timeout,
String name,
String template,
boolean createUpdateData,
boolean allowToCachePreperadeStatement)
|
|
QueryImpl(ResultSet result,
int maxrow,
String name)
create a QueryImpl from a SQL Resultset |
|
QueryImpl(ResultSet result,
String name)
|
|
QueryImpl(String[] strColumnNames,
Array[] arrColumns,
String name)
constructor of the class |
|
QueryImpl(String[] strColumns,
int rowNumber,
String name)
constructor of the class, to generate a empty resultset (no database execution) |
|
QueryImpl(String[] strColumnList,
Object[][] data,
String name)
constructor of the class |
|
QueryImpl(String[] strColumns,
String[] strTypes,
int rowNumber,
String name)
constructor of the class, to generate a empty resultset (no database execution) |
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)
|
|
static QueryImpl |
cloneQuery(QueryPro qry,
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)
|
|
void |
enableShowQueryUsage()
|
|
boolean |
equals(Object obj)
|
|
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()
|
|
static String |
getColumTypeName(int type)
|
|
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)
|
|
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)
|
|
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 columnIndex)
|
|
NClob |
getNClob(String columnLabel)
|
|
String |
getNString(int columnIndex)
|
|
String |
getNString(String columnLabel)
|
|
Object |
getObject(int columnIndex)
|
|
Object |
getObject(int i,
Map map)
|
|
Object |
getObject(String columnName)
|
|
Object |
getObject(String colName,
Map map)
|
|
int |
getRecordcount()
return recordcount of the iterator object |
|
Ref |
getRef(int i)
|
|
Ref |
getRef(String colName)
|
|
int |
getRow()
|
|
int |
getRowCount()
|
|
RowId |
getRowId(int columnIndex)
|
|
RowId |
getRowId(String columnLabel)
|
|
short |
getShort(int columnIndex)
|
|
short |
getShort(String columnName)
|
|
SQL |
getSql()
|
|
SQLXML |
getSQLXML(int columnIndex)
|
|
SQLXML |
getSQLXML(String columnLabel)
|
|
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)
Deprecated. use instead go(int,int) |
|
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 |
isInitalized()
|
|
boolean |
isLast()
|
|
boolean |
isWrapperFor(Class<?> iface)
|
|
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 |
readExternal(ObjectInput in)
|
|
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 |
removeRows(int index,
int count)
|
|
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()
|
|
long |
sizeOf()
return the size of the object |
|
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()
|
|
|
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 columnIndex,
NClob nClob)
|
|
void |
updateNClob(int columnIndex,
Reader reader)
|
|
void |
updateNClob(int columnIndex,
Reader reader,
long length)
|
|
void |
updateNClob(String columnLabel,
NClob nClob)
|
|
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 columnIndex,
RowId x)
|
|
void |
updateRowId(String columnLabel,
RowId x)
|
|
void |
updateShort(int columnIndex,
short x)
|
|
void |
updateShort(String columnName,
short x)
|
|
void |
updateSQLXML(int columnIndex,
SQLXML xmlObject)
|
|
void |
updateSQLXML(String columnLabel,
SQLXML xmlObject)
|
|
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()
|
|
void |
writeExternal(ObjectOutput out)
|
Methods inherited from class java.lang.Object |
---|
getClass, hashCode, notify, notifyAll, wait, wait, wait |
Field Detail |
---|
public static final Collection.Key COLUMNS
public static final Collection.Key SQL
public static final Collection.Key EXECUTION_TIME
public static final Collection.Key RECORDCOUNT
public static final Collection.Key CACHED
public static final Collection.Key COLUMNLIST
public static final Collection.Key CURRENTROW
public static final Collection.Key IDENTITYCOL
public static final Collection.Key GENERATED_KEYS
Constructor Detail |
---|
public QueryImpl(ResultSet result, int maxrow, String name) throws PageException
result
- SQL Resultsetmaxrow
- name
-
PageException
public QueryImpl()
public QueryImpl(ResultSet result, String name) throws PageException
PageException
public QueryImpl(DatasourceConnection dc, SQL sql, int maxrow, int fetchsize, int timeout, String name) throws PageException
dc
- Connection to a databasename
- sql
- sql to executemaxrow
- maxrow for the resultset
PageException
public QueryImpl(DatasourceConnection dc, SQL sql, int maxrow, int fetchsize, int timeout, String name, String template) throws PageException
PageException
public QueryImpl(DatasourceConnection dc, SQL sql, int maxrow, int fetchsize, int timeout, String name, String template, boolean createUpdateData, boolean allowToCachePreperadeStatement) throws PageException
PageException
public QueryImpl(String[] strColumns, int rowNumber, String name)
strColumns
- columns for the resultsetrowNumber
- count of rows to generate (empty fields)name
- public QueryImpl(Collection.Key[] columnKeys, int rowNumber, String name) throws DatabaseException
strColumns
- columns for the resultsetrowNumber
- count of rows to generate (empty fields)name
-
DatabaseException
public QueryImpl(String[] strColumns, String[] strTypes, int rowNumber, String name) throws DatabaseException
strColumns
- columns for the resultsetstrTypes
- array of the typesrowNumber
- count of rows to generate (empty fields)name
-
DatabaseException
public QueryImpl(Collection.Key[] columnNames, String[] strTypes, int rowNumber, String name) throws DatabaseException
strColumns
- columns for the resultsetstrTypes
- array of the typesrowNumber
- count of rows to generate (empty fields)name
-
DatabaseException
public QueryImpl(Array arrColumns, int rowNumber, String name) throws DatabaseException
arrColumns
- columns for the resultsetrowNumber
- count of rows to generate (empty fields)name
-
DatabaseException
public QueryImpl(Array arrColumns, Array arrTypes, int rowNumber, String name) throws PageException
arrColumns
- columns for the resultsetarrTypes
- type of the columnsrowNumber
- count of rows to generate (empty fields)name
-
PageException
public QueryImpl(String[] strColumnNames, Array[] arrColumns, String name) throws DatabaseException
columnNames
- columns definition as String ArrayarrColumns
- valuesname
-
DatabaseException
public QueryImpl(Collection.Key[] columnNames, Array[] arrColumns, String name) throws DatabaseException
DatabaseException
public QueryImpl(String[] strColumnList, Object[][] data, String name) throws DatabaseException
columnList
- data
- name
-
DatabaseException
Method Detail |
---|
public String getTemplate()
getTemplate
in interface QueryPro
public int executionTime()
public int getUpdateCount()
public Query getGeneratedKeys()
getGeneratedKeys
in interface QueryPro
public int size()
size
in interface Collection
Collection.size()
public Collection.Key[] keys()
keys
in interface Collection
Collection.keys()
public String[] keysAsString()
keysAsString
in interface Collection
Collection.keysAsString()
public Object removeEL(String key)
railo.runtime.type.Collection#removeEL(java.lang.String)
public Object removeEL(Collection.Key key)
Collection
removeEL
in interface Collection
key
- key of the collection
Collection.removeEL(railo.runtime.type.Collection.Key)
public Object remove(String key) throws PageException
PageException
railo.runtime.type.Collection#remove(java.lang.String)
public Object remove(Collection.Key key) throws PageException
Collection
remove
in interface Collection
key
- key of the collection
PageException
Collection.remove(railo.runtime.type.Collection.Key)
public void clear()
Collection
clear
in interface Collection
Collection.clear()
public Object get(String key, Object defaultValue)
Collection
get
in interface Collection
key
- key of the value to get
Collection.get(java.lang.String, java.lang.Object)
public Object get(Collection.Key key, Object defaultValue)
Collection
get
in interface Collection
key
- key of the value to get
Collection.get(railo.runtime.type.Collection.Key, java.lang.Object)
public Object get(String key) throws PageException
Collection
get
in interface Collection
key
- key of the value to get
PageException
Collection.get(java.lang.String)
public Object get(Collection.Key key) throws PageException
Collection
get
in interface Collection
key
- key of the value to get must be lower case
PageException
Collection.get(railo.runtime.type.Collection.Key)
public Object getAt(String key, int row, Object defaultValue)
Query
key
- column to getrow
- row to get from (1-recordcount)
Query.getAt(java.lang.String, int, java.lang.Object)
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 definitionQuery.getAt(java.lang.String, int)
public Object getAt(Collection.Key key, int row) throws PageException
Query
key
- column to getrow
- row to get from (1-recordcount)
PageException
- if invalid position definitionQuery.getAt(railo.runtime.type.Collection.Key, int)
public int removeRow(int row) throws PageException
Query
PageException
Query.removeRow(int)
public int removeRowEL(int row)
Query
Query.removeRowEL(int)
public QueryColumn removeColumn(String key) throws DatabaseException
Query
key
- key to remove
DatabaseException
Query.removeColumn(java.lang.String)
public QueryColumn removeColumn(Collection.Key key) throws DatabaseException
Query
key
- key to remove
DatabaseException
Query.removeColumn(railo.runtime.type.Collection.Key)
public QueryColumn removeColumnEL(String key)
Query
key
- key to remove
Query.removeColumnEL(java.lang.String)
public QueryColumn removeColumnEL(Collection.Key key)
Query
key
- key to remove
public Object setEL(String key, Object value)
Collection
setEL
in interface Collection
key
- key of the value to getvalue
- value to set
Collection.setEL(java.lang.String, java.lang.Object)
public Object setEL(Collection.Key key, Object value)
Collection
setEL
in interface Collection
key
- key of the value to getvalue
- value to set
Collection.setEL(railo.runtime.type.Collection.Key, java.lang.Object)
public Object set(String key, Object value) throws PageException
Collection
set
in interface Collection
key
- key of the new valuevalue
- value to set
PageException
Collection.set(java.lang.String, java.lang.Object)
public Object set(Collection.Key key, Object value) throws PageException
Collection
set
in interface Collection
key
- key of the new valuevalue
- value to set
PageException
Collection.set(railo.runtime.type.Collection.Key, java.lang.Object)
public Object setAt(String key, int row, Object value) throws PageException
Query
key
- column to setrow
- row to setvalue
- value to fill
PageException
Query.setAt(java.lang.String, int, java.lang.Object)
public Object setAt(Collection.Key key, int row, Object value) throws PageException
Query
key
- column to setrow
- row to setvalue
- value to fill
PageException
public Object setAtEL(String key, int row, Object value)
Query
key
- column to setrow
- row to setvalue
- value to fill
Query.setAtEL(java.lang.String, int, java.lang.Object)
public Object setAtEL(Collection.Key key, int row, Object value)
Query
key
- column to setrow
- row to setvalue
- value to fill
public boolean next()
Iterator
next
in interface ResultSet
next
in interface Iterator
Iterator.next()
public boolean next(int pid)
Iterator
next
in interface Iterator
next
in interface QueryPro
Iterator.next(int)
public void reset()
Iterator
reset
in interface Iterator
Iterator.reset()
public void reset(int pid)
Iterator
reset
in interface Iterator
reset
in interface QueryPro
public int getRecordcount()
Iterator
getRecordcount
in interface Iterator
Iterator.getRecordcount()
public int getCurrentrow()
Iterator
getCurrentrow
in interface Iterator
FUTURE set this to deprectaed
public int getCurrentrow(int pid)
getCurrentrow
in interface QueryPro
QueryPro.getCurrentrow(int)
public String getColumnlist(boolean upperCase)
public String getColumnlist()
public boolean go(int index)
Iterator
go
in interface Iterator
Iterator.go(int)
public boolean go(int index, int pid)
Iterator
go
in interface Iterator
go
in interface QueryPro
public boolean isEmpty()
isEmpty
in interface Iterator
Iterator.isEmpty()
public DumpData toDumpData(PageContext pageContext, int maxlevel, DumpProperties dp)
Dumpable
toDumpData
in interface Dumpable
railo.runtime.dump.Dumpable#toDumpData(railo.runtime.PageContext, int)
public void sort(String column) throws PageException
column
- colun to sort
PageException
public void sort(Collection.Key column) throws PageException
Query
column
- colun to sort
PageException
Query.sort(railo.runtime.type.Collection.Key)
public void sort(String strColumn, int order) throws PageException
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
Query.sort(railo.runtime.type.Collection.Key, int)
public boolean addRow(int count)
Query
count
- count of rows to add
Query.addRow(int)
public boolean addColumn(String columnName, Array content) throws DatabaseException
Query
columnName
- name of the new columncontent
- content of the new column inside a array (must have same size like query has records)
DatabaseException
Query.addColumn(java.lang.String, railo.runtime.type.Array)
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 DatabaseException
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)
DatabaseException
Query.addColumn(java.lang.String, railo.runtime.type.Array, int)
public boolean addColumn(Collection.Key columnName, Array content, int type) throws DatabaseException
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)
DatabaseException
Query.addColumn(railo.runtime.type.Collection.Key, railo.runtime.type.Array, int)
public Object clone()
clone
in interface Collection
clone
in class Object
Query.clone()
public Collection duplicate(boolean deepCopy)
duplicate
in interface Collection
Collection.duplicate(boolean)
public QueryImpl cloneQuery(boolean deepCopy)
public int[] getTypes()
Query.getTypes()
public Map getTypesAsMap()
Query.getTypesAsMap()
public QueryColumn getColumn(String key) throws DatabaseException
Query
key
- key to get
DatabaseException
Query.getColumn(java.lang.String)
public QueryColumn getColumn(Collection.Key key) throws DatabaseException
Query
key
- key to get
DatabaseException
Query.getColumn(railo.runtime.type.Collection.Key)
public void rename(Collection.Key columnName, Collection.Key newColumnName) throws ExpressionException
rename
in interface QueryPro
ExpressionException
public QueryColumn getColumn(String key, QueryColumn defaultValue)
Query
key
- key to get
Query.getColumn(java.lang.String, railo.runtime.type.QueryColumn)
public QueryColumn getColumn(Collection.Key key, QueryColumn defaultValue)
Query
key
- key to get
Query.getColumn(railo.runtime.type.Collection.Key, railo.runtime.type.QueryColumn)
public String toString()
toString
in class Object
Object.toString()
public static String getColumTypeName(int type)
type
-
public void setExecutionTime(long exeTime)
Query
Query.setExecutionTime(long)
public boolean cutRowsTo(int maxrows)
maxrows
-
public void setCached(boolean isCached)
Query
isCached
- is cached or notQuery.setCached(boolean)
public boolean isCached()
Query
Query.isCached()
public int addRow()
addRow
in interface Query
Query.addRow()
public Collection.Key getColumnName(int columnIndex)
public int getColumnIndex(String coulmnName)
Query
getColumnIndex
in interface Query
coulmnName
- column name to get index for
Query.getColumnIndex(java.lang.String)
public String[] getColumns()
getColumns
in interface Query
Query.getColumns()
public Collection.Key[] getColumnNames()
getColumnNames
in interface QueryPro
QueryPro.getColumnNames()
public void setColumnNames(Collection.Key[] trg) throws PageException
PageException
public String[] getColumnNamesAsString()
getColumnNamesAsString
in interface QueryPro
QueryPro.getColumnNamesAsString()
public String getData(int row, int col) throws IndexOutOfBoundsException
Query
getData
in interface Query
IndexOutOfBoundsException
Query.getData(int, int)
public String getName()
getName
in interface Query
Query.getName()
public int getRowCount()
getRowCount
in interface Query
Query.getRowCount()
public void setData(int row, int col, String value) throws IndexOutOfBoundsException
Query
setData
in interface Query
IndexOutOfBoundsException
Query.setData(int, int, java.lang.String)
public boolean containsKey(String key)
Collection
containsKey
in interface Collection
Collection.containsKey(java.lang.String)
public boolean containsKey(Collection.Key key)
Collection
containsKey
in interface Collection
Collection.containsKey(railo.runtime.type.Collection.Key)
public String castToString() throws ExpressionException
Castable
castToString
in interface Castable
ExpressionException
Castable.castToString()
public String castToString(String defaultValue)
Castable
castToString
in interface Castable
Castable.castToString(java.lang.String)
public boolean castToBooleanValue() throws ExpressionException
Castable
castToBooleanValue
in interface Castable
ExpressionException
Castable.castToBooleanValue()
public Boolean castToBoolean(Boolean defaultValue)
Castable
castToBoolean
in interface Castable
Castable.castToBoolean(java.lang.Boolean)
public double castToDoubleValue() throws ExpressionException
Castable
castToDoubleValue
in interface Castable
ExpressionException
Castable.castToDoubleValue()
public double castToDoubleValue(double defaultValue)
Castable
castToDoubleValue
in interface Castable
Castable.castToDoubleValue(double)
public DateTime castToDateTime() throws ExpressionException
Castable
castToDateTime
in interface Castable
ExpressionException
Castable.castToDateTime()
public DateTime castToDateTime(DateTime defaultValue)
Castable
castToDateTime
in interface Castable
defaultValue
- returned when it is not possible to cast to a dateTime object
Castable.castToDateTime(railo.runtime.type.dt.DateTime)
public int compareTo(boolean b) throws ExpressionException
compareTo
in interface Castable
ExpressionException
railo.runtime.op.Castable#compare(boolean)
public int compareTo(DateTime dt) throws PageException
compareTo
in interface Castable
PageException
Castable.compareTo(railo.runtime.type.dt.DateTime)
public int compareTo(double d) throws PageException
compareTo
in interface Castable
PageException
Castable.compareTo(double)
public int compareTo(String str) throws PageException
compareTo
in interface Castable
PageException
Castable.compareTo(java.lang.String)
public Array getMetaDataSimple()
public Struct _getMetaData()
public SQL getSql()
getSql
in interface QueryPro
public void setSql(SQL sql)
sql
- the sql to setpublic Object getObject(String columnName) throws SQLException
getObject
in interface ResultSet
SQLException
ResultSet.getObject(java.lang.String)
public Object getObject(int columnIndex) throws SQLException
getObject
in interface ResultSet
SQLException
ResultSet.getObject(int)
public String getString(int columnIndex) throws SQLException
getString
in interface ResultSet
SQLException
ResultSet.getString(int)
public String getString(String columnName) throws SQLException
getString
in interface ResultSet
SQLException
ResultSet.getString(java.lang.String)
public boolean getBoolean(int columnIndex) throws SQLException
getBoolean
in interface ResultSet
SQLException
ResultSet.getBoolean(int)
public boolean getBoolean(String columnName) throws SQLException
getBoolean
in interface ResultSet
SQLException
ResultSet.getBoolean(java.lang.String)
public Object call(PageContext pc, String methodName, Object[] arguments) throws PageException
Objects
call
in interface Objects
methodName
- name of the method to callarguments
- arguments to call method with
PageException
Objects.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
methodName
- name of the method to callarguments
- arguments to call method with
PageException
Objects.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
pc
- PageContextmethodName
- name of the methodargs
- Named Arguments for the method
PageException
Objects.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
pc
- PageContextmethodName
- name of the methodargs
- Named Arguments for the method
PageException
Objects.callWithNamedValues(railo.runtime.PageContext, railo.runtime.type.Collection.Key, railo.runtime.type.Struct)
public Object get(PageContext pc, String key, Object defaultValue)
Objects
get
in interface Objects
pc
- PageContextkey
- Name of the Property
Objects.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
pc
- PageContextkey
- Name of the Property
Objects.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
pc
- PageContextkey
- Name of the Property
PageException
Objects.get(railo.runtime.PageContext, java.lang.String)
public Object get(PageContext pc, Collection.Key key) throws PageException
Objects
get
in interface Objects
pc
- PageContextkey
- Name of the Property
PageException
Objects.get(railo.runtime.PageContext, railo.runtime.type.Collection.Key)
public boolean isInitalized()
isInitalized
in interface Objects
Objects.isInitalized()
public Object set(PageContext pc, String propertyName, Object value) throws PageException
Objects
set
in interface Objects
propertyName
- property name to setvalue
- value to insert
PageException
Objects.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
propertyName
- property name to setvalue
- value to insert
PageException
Objects.set(railo.runtime.PageContext, railo.runtime.type.Collection.Key, java.lang.Object)
public Object setEL(PageContext pc, String propertyName, Object value)
Objects
setEL
in interface Objects
propertyName
- property name to setvalue
- value to insert
Objects.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
propertyName
- property name to setvalue
- value to insert
Objects.setEL(railo.runtime.PageContext, railo.runtime.type.Collection.Key, java.lang.Object)
public boolean wasNull()
wasNull
in interface ResultSet
ResultSet.wasNull()
public boolean absolute(int row) throws SQLException
absolute
in interface ResultSet
SQLException
ResultSet.absolute(int)
public void afterLast() throws SQLException
afterLast
in interface ResultSet
SQLException
ResultSet.afterLast()
public void beforeFirst() throws SQLException
beforeFirst
in interface ResultSet
SQLException
ResultSet.beforeFirst()
public void cancelRowUpdates() throws SQLException
cancelRowUpdates
in interface ResultSet
SQLException
ResultSet.cancelRowUpdates()
public void clearWarnings() throws SQLException
clearWarnings
in interface ResultSet
SQLException
ResultSet.clearWarnings()
public void close() throws SQLException
close
in interface ResultSet
SQLException
ResultSet.close()
public void deleteRow() throws SQLException
deleteRow
in interface ResultSet
SQLException
ResultSet.deleteRow()
public int findColumn(String columnName) throws SQLException
findColumn
in interface ResultSet
SQLException
ResultSet.findColumn(java.lang.String)
public boolean first() throws SQLException
first
in interface ResultSet
SQLException
ResultSet.first()
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
ResultSet.getAsciiStream(int)
public InputStream getAsciiStream(String columnName) throws SQLException
getAsciiStream
in interface ResultSet
SQLException
ResultSet.getAsciiStream(java.lang.String)
public BigDecimal getBigDecimal(int columnIndex) throws SQLException
getBigDecimal
in interface ResultSet
SQLException
ResultSet.getBigDecimal(int)
public BigDecimal getBigDecimal(String columnName) throws SQLException
getBigDecimal
in interface ResultSet
SQLException
ResultSet.getBigDecimal(java.lang.String)
public BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLException
getBigDecimal
in interface ResultSet
SQLException
ResultSet.getBigDecimal(int, int)
public BigDecimal getBigDecimal(String columnName, int scale) throws SQLException
getBigDecimal
in interface ResultSet
SQLException
ResultSet.getBigDecimal(java.lang.String, int)
public InputStream getBinaryStream(int columnIndex) throws SQLException
getBinaryStream
in interface ResultSet
SQLException
ResultSet.getBinaryStream(int)
public InputStream getBinaryStream(String columnName) throws SQLException
getBinaryStream
in interface ResultSet
SQLException
ResultSet.getBinaryStream(java.lang.String)
public Blob getBlob(int i) throws SQLException
getBlob
in interface ResultSet
SQLException
ResultSet.getBlob(int)
public Blob getBlob(String colName) throws SQLException
getBlob
in interface ResultSet
SQLException
ResultSet.getBlob(java.lang.String)
public byte getByte(int columnIndex) throws SQLException
getByte
in interface ResultSet
SQLException
ResultSet.getByte(int)
public byte getByte(String columnName) throws SQLException
getByte
in interface ResultSet
SQLException
ResultSet.getByte(java.lang.String)
public byte[] getBytes(int columnIndex) throws SQLException
getBytes
in interface ResultSet
SQLException
ResultSet.getBytes(int)
public byte[] getBytes(String columnName) throws SQLException
getBytes
in interface ResultSet
SQLException
ResultSet.getBytes(java.lang.String)
public Reader getCharacterStream(int columnIndex) throws SQLException
getCharacterStream
in interface ResultSet
SQLException
ResultSet.getCharacterStream(int)
public Reader getCharacterStream(String columnName) throws SQLException
getCharacterStream
in interface ResultSet
SQLException
ResultSet.getCharacterStream(java.lang.String)
public Clob getClob(int i) throws SQLException
getClob
in interface ResultSet
SQLException
ResultSet.getClob(int)
public Clob getClob(String colName) throws SQLException
getClob
in interface ResultSet
SQLException
ResultSet.getClob(java.lang.String)
public int getConcurrency() throws SQLException
getConcurrency
in interface ResultSet
SQLException
ResultSet.getConcurrency()
public String getCursorName() throws SQLException
getCursorName
in interface ResultSet
SQLException
ResultSet.getCursorName()
public Date getDate(int columnIndex) throws SQLException
getDate
in interface ResultSet
SQLException
ResultSet.getDate(int)
public Date getDate(String columnName) throws SQLException
getDate
in interface ResultSet
SQLException
ResultSet.getDate(java.lang.String)
public Date getDate(int columnIndex, Calendar cal) throws SQLException
getDate
in interface ResultSet
SQLException
ResultSet.getDate(int, java.util.Calendar)
public Date getDate(String columnName, Calendar cal) throws SQLException
getDate
in interface ResultSet
SQLException
ResultSet.getDate(java.lang.String, java.util.Calendar)
public double getDouble(int columnIndex) throws SQLException
getDouble
in interface ResultSet
SQLException
ResultSet.getDouble(int)
public double getDouble(String columnName) throws SQLException
getDouble
in interface ResultSet
SQLException
ResultSet.getDouble(java.lang.String)
public int getFetchDirection() throws SQLException
getFetchDirection
in interface ResultSet
SQLException
ResultSet.getFetchDirection()
public int getFetchSize() throws SQLException
getFetchSize
in interface ResultSet
SQLException
ResultSet.getFetchSize()
public float getFloat(int columnIndex) throws SQLException
getFloat
in interface ResultSet
SQLException
ResultSet.getFloat(int)
public float getFloat(String columnName) throws SQLException
getFloat
in interface ResultSet
SQLException
ResultSet.getFloat(java.lang.String)
public int getInt(int columnIndex) throws SQLException
getInt
in interface ResultSet
SQLException
ResultSet.getInt(int)
public int getInt(String columnName) throws SQLException
getInt
in interface ResultSet
SQLException
ResultSet.getInt(java.lang.String)
public long getLong(int columnIndex) throws SQLException
getLong
in interface ResultSet
SQLException
ResultSet.getLong(int)
public long getLong(String columnName) throws SQLException
getLong
in interface ResultSet
SQLException
ResultSet.getLong(java.lang.String)
public Object getObject(int i, Map map) throws SQLException
getObject
in interface ResultSet
SQLException
ResultSet.getObject(int, java.util.Map)
public Object getObject(String colName, Map map) throws SQLException
getObject
in interface ResultSet
SQLException
ResultSet.getObject(java.lang.String, java.util.Map)
public Ref getRef(int i) throws SQLException
getRef
in interface ResultSet
SQLException
ResultSet.getRef(int)
public Ref getRef(String colName) throws SQLException
getRef
in interface ResultSet
SQLException
ResultSet.getRef(java.lang.String)
public int getRow() throws SQLException
getRow
in interface ResultSet
SQLException
ResultSet.getRow()
public short getShort(int columnIndex) throws SQLException
getShort
in interface ResultSet
SQLException
ResultSet.getShort(int)
public short getShort(String columnName) throws SQLException
getShort
in interface ResultSet
SQLException
ResultSet.getShort(java.lang.String)
public Statement getStatement() throws SQLException
getStatement
in interface ResultSet
SQLException
public Time getTime(int columnIndex) throws SQLException
getTime
in interface ResultSet
SQLException
ResultSet.getTime(int)
public Time getTime(String columnName) throws SQLException
getTime
in interface ResultSet
SQLException
ResultSet.getTime(java.lang.String)
public Time getTime(int columnIndex, Calendar cal) throws SQLException
getTime
in interface ResultSet
SQLException
ResultSet.getTime(int, java.util.Calendar)
public Time getTime(String columnName, Calendar cal) throws SQLException
getTime
in interface ResultSet
SQLException
ResultSet.getTime(java.lang.String, java.util.Calendar)
public Timestamp getTimestamp(int columnIndex) throws SQLException
getTimestamp
in interface ResultSet
SQLException
ResultSet.getTimestamp(int)
public Timestamp getTimestamp(String columnName) throws SQLException
getTimestamp
in interface ResultSet
SQLException
ResultSet.getTimestamp(java.lang.String)
public Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLException
getTimestamp
in interface ResultSet
SQLException
ResultSet.getTimestamp(int, java.util.Calendar)
public Timestamp getTimestamp(String columnName, Calendar cal) throws SQLException
getTimestamp
in interface ResultSet
SQLException
ResultSet.getTimestamp(java.lang.String, java.util.Calendar)
public int getType() throws SQLException
getType
in interface ResultSet
SQLException
ResultSet.getType()
public URL getURL(int columnIndex) throws SQLException
getURL
in interface ResultSet
SQLException
ResultSet.getURL(int)
public URL getURL(String columnName) throws SQLException
getURL
in interface ResultSet
SQLException
ResultSet.getURL(java.lang.String)
public InputStream getUnicodeStream(int columnIndex) throws SQLException
getUnicodeStream
in interface ResultSet
SQLException
ResultSet.getUnicodeStream(int)
public InputStream getUnicodeStream(String columnName) throws SQLException
getUnicodeStream
in interface ResultSet
SQLException
ResultSet.getUnicodeStream(java.lang.String)
public SQLWarning getWarnings() throws SQLException
getWarnings
in interface ResultSet
SQLException
ResultSet.getWarnings()
public void insertRow() throws SQLException
insertRow
in interface ResultSet
SQLException
ResultSet.insertRow()
public boolean isAfterLast() throws SQLException
isAfterLast
in interface ResultSet
SQLException
ResultSet.isAfterLast()
public boolean isBeforeFirst() throws SQLException
isBeforeFirst
in interface ResultSet
SQLException
ResultSet.isBeforeFirst()
public boolean isFirst() throws SQLException
isFirst
in interface ResultSet
SQLException
ResultSet.isFirst()
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()
previous
in interface ResultSet
public boolean previous(int pid)
previous
in interface QueryPro
public void refreshRow() throws SQLException
refreshRow
in interface ResultSet
SQLException
public boolean relative(int rows) throws SQLException
relative
in interface ResultSet
SQLException
ResultSet.relative(int)
public boolean rowDeleted() throws SQLException
rowDeleted
in interface ResultSet
SQLException
ResultSet.rowDeleted()
public boolean rowInserted() throws SQLException
rowInserted
in interface ResultSet
SQLException
ResultSet.rowInserted()
public boolean rowUpdated() throws SQLException
rowUpdated
in interface ResultSet
SQLException
ResultSet.rowUpdated()
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
ResultSet.updateArray(int, java.sql.Array)
public void updateArray(String columnName, Array x) throws SQLException
updateArray
in interface ResultSet
SQLException
ResultSet.updateArray(java.lang.String, java.sql.Array)
public void updateAsciiStream(int columnIndex, InputStream x, int length) throws SQLException
updateAsciiStream
in interface ResultSet
SQLException
ResultSet.updateAsciiStream(int, java.io.InputStream, int)
public void updateAsciiStream(String columnName, InputStream x, int length) throws SQLException
updateAsciiStream
in interface ResultSet
SQLException
ResultSet.updateAsciiStream(java.lang.String, java.io.InputStream, int)
public void updateBigDecimal(int columnIndex, BigDecimal x) throws SQLException
updateBigDecimal
in interface ResultSet
SQLException
ResultSet.updateBigDecimal(int, java.math.BigDecimal)
public void updateBigDecimal(String columnName, BigDecimal x) throws SQLException
updateBigDecimal
in interface ResultSet
SQLException
ResultSet.updateBigDecimal(java.lang.String, java.math.BigDecimal)
public void updateBinaryStream(int columnIndex, InputStream x, int length) throws SQLException
updateBinaryStream
in interface ResultSet
SQLException
ResultSet.updateBinaryStream(int, java.io.InputStream, int)
public void updateBinaryStream(String columnName, InputStream x, int length) throws SQLException
updateBinaryStream
in interface ResultSet
SQLException
ResultSet.updateBinaryStream(java.lang.String, java.io.InputStream, int)
public void updateBlob(int columnIndex, Blob x) throws SQLException
updateBlob
in interface ResultSet
SQLException
ResultSet.updateBlob(int, java.sql.Blob)
public void updateBlob(String columnName, Blob x) throws SQLException
updateBlob
in interface ResultSet
SQLException
ResultSet.updateBlob(java.lang.String, java.sql.Blob)
public void updateBoolean(int columnIndex, boolean x) throws SQLException
updateBoolean
in interface ResultSet
SQLException
ResultSet.updateBoolean(int, boolean)
public void updateBoolean(String columnName, boolean x) throws SQLException
updateBoolean
in interface ResultSet
SQLException
ResultSet.updateBoolean(java.lang.String, boolean)
public void updateByte(int columnIndex, byte x) throws SQLException
updateByte
in interface ResultSet
SQLException
ResultSet.updateByte(int, byte)
public void updateByte(String columnName, byte x) throws SQLException
updateByte
in interface ResultSet
SQLException
ResultSet.updateByte(java.lang.String, byte)
public void updateBytes(int columnIndex, byte[] x) throws SQLException
updateBytes
in interface ResultSet
SQLException
ResultSet.updateBytes(int, byte[])
public void updateBytes(String columnName, byte[] x) throws SQLException
updateBytes
in interface ResultSet
SQLException
ResultSet.updateBytes(java.lang.String, byte[])
public void updateCharacterStream(int columnIndex, Reader reader, int length) throws SQLException
updateCharacterStream
in interface ResultSet
SQLException
ResultSet.updateCharacterStream(int, java.io.Reader, int)
public void updateCharacterStream(String columnName, Reader reader, int length) throws SQLException
updateCharacterStream
in interface ResultSet
SQLException
ResultSet.updateCharacterStream(java.lang.String, java.io.Reader, int)
public void updateClob(int columnIndex, Clob x) throws SQLException
updateClob
in interface ResultSet
SQLException
ResultSet.updateClob(int, java.sql.Clob)
public void updateClob(String columnName, Clob x) throws SQLException
updateClob
in interface ResultSet
SQLException
ResultSet.updateClob(java.lang.String, java.sql.Clob)
public void updateDate(int columnIndex, Date x) throws SQLException
updateDate
in interface ResultSet
SQLException
ResultSet.updateDate(int, java.sql.Date)
public void updateDate(String columnName, Date x) throws SQLException
updateDate
in interface ResultSet
SQLException
ResultSet.updateDate(java.lang.String, java.sql.Date)
public void updateDouble(int columnIndex, double x) throws SQLException
updateDouble
in interface ResultSet
SQLException
ResultSet.updateDouble(int, double)
public void updateDouble(String columnName, double x) throws SQLException
updateDouble
in interface ResultSet
SQLException
ResultSet.updateDouble(java.lang.String, double)
public void updateFloat(int columnIndex, float x) throws SQLException
updateFloat
in interface ResultSet
SQLException
ResultSet.updateFloat(int, float)
public void updateFloat(String columnName, float x) throws SQLException
updateFloat
in interface ResultSet
SQLException
ResultSet.updateFloat(java.lang.String, float)
public void updateInt(int columnIndex, int x) throws SQLException
updateInt
in interface ResultSet
SQLException
ResultSet.updateInt(int, int)
public void updateInt(String columnName, int x) throws SQLException
updateInt
in interface ResultSet
SQLException
ResultSet.updateInt(java.lang.String, int)
public void updateLong(int columnIndex, long x) throws SQLException
updateLong
in interface ResultSet
SQLException
ResultSet.updateLong(int, long)
public void updateLong(String columnName, long x) throws SQLException
updateLong
in interface ResultSet
SQLException
ResultSet.updateLong(java.lang.String, long)
public void updateNull(int columnIndex) throws SQLException
updateNull
in interface ResultSet
SQLException
ResultSet.updateNull(int)
public void updateNull(String columnName) throws SQLException
updateNull
in interface ResultSet
SQLException
ResultSet.updateNull(java.lang.String)
public void updateObject(int columnIndex, Object x) throws SQLException
updateObject
in interface ResultSet
SQLException
ResultSet.updateObject(int, java.lang.Object)
public void updateObject(String columnName, Object x) throws SQLException
updateObject
in interface ResultSet
SQLException
ResultSet.updateObject(java.lang.String, java.lang.Object)
public void updateObject(int columnIndex, Object x, int scale) throws SQLException
updateObject
in interface ResultSet
SQLException
ResultSet.updateObject(int, java.lang.Object, int)
public void updateObject(String columnName, Object x, int scale) throws SQLException
updateObject
in interface ResultSet
SQLException
ResultSet.updateObject(java.lang.String, java.lang.Object, int)
public void updateRef(int columnIndex, Ref x) throws SQLException
updateRef
in interface ResultSet
SQLException
ResultSet.updateRef(int, java.sql.Ref)
public void updateRef(String columnName, Ref x) throws SQLException
updateRef
in interface ResultSet
SQLException
ResultSet.updateRef(java.lang.String, java.sql.Ref)
public void updateRow() throws SQLException
updateRow
in interface ResultSet
SQLException
public void updateShort(int columnIndex, short x) throws SQLException
updateShort
in interface ResultSet
SQLException
ResultSet.updateShort(int, short)
public void updateShort(String columnName, short x) throws SQLException
updateShort
in interface ResultSet
SQLException
ResultSet.updateShort(java.lang.String, short)
public void updateString(int columnIndex, String x) throws SQLException
updateString
in interface ResultSet
SQLException
ResultSet.updateString(int, java.lang.String)
public void updateString(String columnName, String x) throws SQLException
updateString
in interface ResultSet
SQLException
ResultSet.updateString(java.lang.String, java.lang.String)
public void updateTime(int columnIndex, Time x) throws SQLException
updateTime
in interface ResultSet
SQLException
ResultSet.updateTime(int, java.sql.Time)
public void updateTime(String columnName, Time x) throws SQLException
updateTime
in interface ResultSet
SQLException
ResultSet.updateTime(java.lang.String, java.sql.Time)
public void updateTimestamp(int columnIndex, Timestamp x) throws SQLException
updateTimestamp
in interface ResultSet
SQLException
ResultSet.updateTimestamp(int, java.sql.Timestamp)
public void updateTimestamp(String columnName, Timestamp x) throws SQLException
updateTimestamp
in interface ResultSet
SQLException
ResultSet.updateTimestamp(java.lang.String, java.sql.Timestamp)
public ResultSetMetaData getMetaData() throws SQLException
getMetaData
in interface ResultSet
SQLException
public Iterator keyIterator()
keyIterator
in interface Iteratorable
Iteratorable.keyIterator()
public Iterator iterator()
iterator
in interface Iteratorable
Iteratorable.iterator()
public Iterator valueIterator()
valueIterator
in interface Iteratorable
public void readExternal(ObjectInput in) throws IOException
IOException
public void writeExternal(ObjectOutput out)
public long sizeOf()
Sizeable
sizeOf
in interface Sizeable
Sizeable.sizeOf()
public boolean equals(Object obj)
equals
in class Object
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 void updateNClob(int columnIndex, NClob nClob) throws SQLException
updateNClob
in interface ResultSet
SQLException
public void updateNClob(String columnLabel, NClob nClob) throws SQLException
updateNClob
in interface ResultSet
SQLException
public NClob getNClob(int columnIndex) throws SQLException
getNClob
in interface ResultSet
SQLException
public NClob getNClob(String columnLabel) throws SQLException
getNClob
in interface ResultSet
SQLException
public SQLXML getSQLXML(int columnIndex) throws SQLException
getSQLXML
in interface ResultSet
SQLException
public SQLXML getSQLXML(String columnLabel) throws SQLException
getSQLXML
in interface ResultSet
SQLException
public void updateSQLXML(int columnIndex, SQLXML xmlObject) throws SQLException
updateSQLXML
in interface ResultSet
SQLException
public void updateSQLXML(String columnLabel, SQLXML xmlObject) throws SQLException
updateSQLXML
in interface ResultSet
SQLException
public RowId getRowId(int columnIndex) throws SQLException
getRowId
in interface ResultSet
SQLException
public RowId getRowId(String columnLabel) throws SQLException
getRowId
in interface ResultSet
SQLException
public void updateRowId(int columnIndex, RowId x) throws SQLException
updateRowId
in interface ResultSet
SQLException
public void updateRowId(String columnLabel, RowId x) throws SQLException
updateRowId
in interface ResultSet
SQLException
public void removeRows(int index, int count) throws PageException
PageException
public void enableShowQueryUsage()
public long getExecutionTime()
getExecutionTime
in interface QueryPro
public static QueryImpl cloneQuery(QueryPro qry, boolean deepCopy)
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |