railo.runtime.type.query
Class SimpleQuery

java.lang.Object
  extended by railo.runtime.type.query.SimpleQuery
All Implemented Interfaces:
Query, Serializable, Cloneable, ResultSet, Wrapper, Dumpable, Castable, Collection, ForEachIteratorable, Iterator, Iteratorable, Objects

public class SimpleQuery
extends Object
implements Query, ResultSet, Objects

See Also:
Serialized Form

Nested Class Summary
 
Nested classes/interfaces inherited from interface railo.runtime.type.Collection
Collection.Key
 
Field Summary
 
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
SimpleQuery(DatasourceConnection dc, SQL sql, int maxrow, int fetchsize, int timeout, String name, String template, TimeZone tz)
           
 
Method Summary
 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 callWithNamedValues(PageContext pc, Collection.Key methodName, Struct args)
          call a method of the Object with named arguments
 void cancelRowUpdates()
           
 Boolean castToBoolean(Boolean defaultValue)
          cast the castable value to a boolean value
 boolean castToBooleanValue()
          cast the castable value to a boolean value
 DateTime castToDateTime()
          cast the castable value to a date time object
 DateTime castToDateTime(DateTime defaultValue)
          cast the castable value to a date time object
 double castToDoubleValue()
          cast the castable value to a double value
 double castToDoubleValue(double defaultValue)
          cast the castable value to a double value
 String castToString()
          cast the castable value to a string, other than the Method toString, this Method can throw a Exception
 String castToString(String defaultValue)
          cast the castable value to a string, return the default value, when the method is not castable
 void clear()
          clears the collection
 void clearWarnings()
           
 Object clone()
           
 QueryImpl cloneQuery(boolean deepCopy)
           
 void close()
           
 int compareTo(boolean b)
           
 int compareTo(DateTime dt)
           
 int compareTo(double d)
           
 int compareTo(String str)
           
 boolean containsKey(Collection.Key key)
          contains this key
 boolean containsKey(String key)
          contains this key
 boolean cutRowsTo(int maxrows)
           
 void deleteRow()
           
 Collection duplicate(boolean deepCopy)
           
 void enableShowQueryUsage()
           
 Iterator<Map.Entry<Collection.Key,Object>> entryIterator()
           
 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(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, int pid)
           
 Object getAt(Collection.Key key, int row, int pid, Object defaultValue)
           
 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)
           
 Collection.Key getColumnName(int columnIndex)
           
 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 columnIndex)
           
 NClob getNClob(String columnLabel)
           
 String getNString(int columnIndex)
           
 String getNString(String columnLabel)
           
 Object getObject(int columnIndex)
           
<T> T
getObject(int columnIndex, Class<T> type)
           
 Object getObject(int i, Map map)
           
 Object getObject(String columnName)
           
<T> T
getObject(String columnLabel, Class<T> type)
           
 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)
           
 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<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.
static PageRuntimeException notSupported()
           
 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(PageContext pc, Collection.Key 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(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 dp)
          method to print out information to a object as HTML
static PageException toPageExc(Throwable t)
           
static PageRuntimeException toRuntimeExc(Throwable t)
           
 String toString()
           
<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 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<Object> valueIterator()
           
 boolean wasNull()
           
 
Methods inherited from class java.lang.Object
getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Constructor Detail

SimpleQuery

public SimpleQuery(DatasourceConnection dc,
                   SQL sql,
                   int maxrow,
                   int fetchsize,
                   int timeout,
                   String name,
                   String template,
                   TimeZone tz)
            throws PageException
Throws:
PageException
Method Detail

executionTime

public int executionTime()
Returns:
returns the execution time

getUpdateCount

public int getUpdateCount()
Returns:
return how many lines are affected by a update/insert

size

public int size()
Specified by:
size in interface Collection
Returns:
the size of the collection

keys

public Collection.Key[] keys()
Specified by:
keys in interface Collection
Returns:
returns a string array of all keys in the collection

removeEL

public Object removeEL(Collection.Key key)
Description copied from interface: Collection
removes value from collection and return it when it exists, otherwise returns null

Specified by:
removeEL in interface Collection
Parameters:
key - key of the collection
Returns:
removed Object

remove

public Object remove(Collection.Key key)
              throws PageException
Description copied from interface: Collection
removes value from collection and return it when it exists, otherwise throws a exception

Specified by:
remove in interface Collection
Parameters:
key - key of the collection
Returns:
removed Object
Throws:
PageException

clear

public void clear()
Description copied from interface: Collection
clears the collection

Specified by:
clear in interface Collection

get

public Object get(Collection.Key key,
                  Object defaultValue)
Description copied from interface: Collection
return a value from the collection, if key doesn't exist, dont throw a exception, reeturns null

Specified by:
get in interface Collection
Parameters:
key - key of the value to get
Returns:
value on key position or null

get

public Object get(String key,
                  Object defaultValue)
Description copied from interface: Collection
return a value from the collection, if key doesn't exist, dont throw a exception, reeturns null

Specified by:
get in interface Collection
Parameters:
key - key of the value to get
Returns:
value on key position or null

get

public Object get(String key)
           throws PageException
Description copied from interface: Collection
return a value from the collection

Specified by:
get in interface Collection
Parameters:
key - key of the value to get
Returns:
value on key position
Throws:
PageException

get

public Object get(Collection.Key key)
           throws PageException
Description copied from interface: Collection
return a value from the collection

Specified by:
get in interface Collection
Parameters:
key - key of the value to get must be lower case
Returns:
value on key position
Throws:
PageException

getAt

public Object getAt(Collection.Key key,
                    int row,
                    int pid,
                    Object defaultValue)

getAt

public Object getAt(Collection.Key key,
                    int row,
                    int pid)
             throws PageException
Throws:
PageException

getAt

public Object getAt(Collection.Key key,
                    int row,
                    Object defaultValue)
Description copied from interface: Query
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)

Parameters:
key - column to get
row - row to get from (1-recordcount)
Returns:
value at the called poition

getAt

public Object getAt(Collection.Key key,
                    int row)
             throws PageException
Description copied from interface: Query
return a value of the resultset by specified column and row

Parameters:
key - column to get
row - row to get from (1-recordcount)
Returns:
value at the called poition
Throws:
PageException - if invalid position definition

getAt

public Object getAt(String key,
                    int row,
                    Object defaultValue)
Description copied from interface: Query
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)

Parameters:
key - column to get
row - row to get from (1-recordcount)
Returns:
value at the called poition

getAt

public Object getAt(String key,
                    int row)
             throws PageException
Description copied from interface: Query
return a value of the resultset by specified column and row

Parameters:
key - column to get
row - row to get from (1-recordcount)
Returns:
value at the called poition
Throws:
PageException - if invalid position definition

removeRow

public int removeRow(int row)
              throws PageException
Description copied from interface: Query
remove row from query

Returns:
return new rowcount
Throws:
PageException

removeRowEL

public int removeRowEL(int row)
Description copied from interface: Query
remove row from query

Returns:
return new rowcount

removeColumn

public QueryColumn removeColumn(String key)
                         throws DatabaseException
Description copied from interface: Query
remove column matching to key

Parameters:
key - key to remove
Returns:
QueryColumn object removed
Throws:
DatabaseException

removeColumn

public QueryColumn removeColumn(Collection.Key key)
                         throws DatabaseException
Description copied from interface: Query
remove column matching to key

Parameters:
key - key to remove
Returns:
QueryColumn object removed
Throws:
DatabaseException

removeColumnEL

public QueryColumn removeColumnEL(String key)
Description copied from interface: Query
remove column matching to key

Parameters:
key - key to remove
Returns:
QueryColumn object removed or null if column not exist

removeColumnEL

public QueryColumn removeColumnEL(Collection.Key key)
Description copied from interface: Query
remove column matching to key

Parameters:
key - key to remove
Returns:
QueryColumn object removed or null if column not exist

setEL

public Object setEL(String key,
                    Object value)
Description copied from interface: Collection
sets a value to the collection, if key doesn't exist, dont throw a exception, returns null

Specified by:
setEL in interface Collection
Parameters:
key - key of the value to get
value - value to set
Returns:
value on key position or null

setEL

public Object setEL(Collection.Key key,
                    Object value)
Description copied from interface: Collection
sets a value to the collection, if key doesn't exist, dont throw a exception, returns null

Specified by:
setEL in interface Collection
Parameters:
key - key of the value to get
value - value to set
Returns:
value on key position or null

set

public Object set(String key,
                  Object value)
           throws PageException
Description copied from interface: Collection
sets a value to the collection

Specified by:
set in interface Collection
Parameters:
key - key of the new value
value - value to set
Returns:
value setted
Throws:
PageException

set

public Object set(Collection.Key key,
                  Object value)
           throws PageException
Description copied from interface: Collection
sets a value to the collection

Specified by:
set in interface Collection
Parameters:
key - key of the new value
value - value to set
Returns:
value setted
Throws:
PageException

setAt

public Object setAt(String key,
                    int row,
                    Object value)
             throws PageException
Description copied from interface: Query
set a value at the defined position

Parameters:
key - column to set
row - row to set
value - value to fill
Returns:
filled value
Throws:
PageException

setAt

public Object setAt(Collection.Key key,
                    int row,
                    Object value)
             throws PageException
Description copied from interface: Query
set a value at the defined position

Parameters:
key - column to set
row - row to set
value - value to fill
Returns:
filled value
Throws:
PageException

setAtEL

public Object setAtEL(String key,
                      int row,
                      Object value)
Description copied from interface: Query
set a value at the defined position

Parameters:
key - column to set
row - row to set
value - value to fill
Returns:
filled value

setAtEL

public Object setAtEL(Collection.Key key,
                      int row,
                      Object value)
Description copied from interface: Query
set a value at the defined position

Parameters:
key - column to set
row - row to set
value - value to fill
Returns:
filled value

next

public boolean next()
Description copied from interface: Iterator
set the intern pointer of the iterator to the next position, return true if next position exist otherwise false.

Specified by:
next in interface ResultSet
Specified by:
next in interface Iterator
Returns:
boolean

next

public boolean next(int pid)
Description copied from interface: Iterator
set the intern pointer of the iterator to the next position, return true if next position exist otherwise false.

Specified by:
next in interface Iterator
Returns:
boolean

reset

public void reset()
Description copied from interface: Iterator
reset ther intern pointer

Specified by:
reset in interface Iterator

reset

public void reset(int pid)
Description copied from interface: Iterator
reset ther intern pointer

Specified by:
reset in interface Iterator

getRecordcount

public int getRecordcount()
Description copied from interface: Iterator
return recordcount of the iterator object

Specified by:
getRecordcount in interface Iterator
Returns:
int

getCurrentrow

public int getCurrentrow(int pid)
Description copied from interface: Iterator
return the current position of the internal pointer

Specified by:
getCurrentrow in interface Iterator
Returns:
int

getColumnlist

public String getColumnlist(boolean upperCase)

getColumnlist

public String getColumnlist()

go

public boolean go(int index)

go

public boolean go(int index,
                  int pid)
Description copied from interface: Iterator
set the internal pointer to defined position

Specified by:
go in interface Iterator
Returns:
int

isEmpty

public boolean isEmpty()
Specified by:
isEmpty in interface Iterator
Returns:
returns if iterator is empty or not

toDumpData

public DumpData toDumpData(PageContext pageContext,
                           int maxlevel,
                           DumpProperties dp)
Description copied from interface: Dumpable
method to print out information to a object as HTML

Specified by:
toDumpData in interface Dumpable
Returns:
HTML print out

sort

public void sort(String column)
          throws PageException
Description copied from interface: Query
sorts a query by a column, direction is asc

Parameters:
column - colun to sort
Throws:
PageException

sort

public void sort(Collection.Key column)
          throws PageException
Description copied from interface: Query
sorts a query by a column, direction is asc

Parameters:
column - colun to sort
Throws:
PageException

sort

public void sort(String strColumn,
                 int order)
          throws PageException
Description copied from interface: Query
sorts a query by a column

Parameters:
strColumn - column to sort
order - sort type (Query.ORDER_ASC or Query.ORDER_DESC)
Throws:
PageException

sort

public void sort(Collection.Key keyColumn,
                 int order)
          throws PageException
Description copied from interface: Query
sorts a query by a column

Parameters:
keyColumn - column to sort
order - sort type (Query.ORDER_ASC or Query.ORDER_DESC)
Throws:
PageException

addRow

public boolean addRow(int count)
Description copied from interface: Query
adds a new row to the resultset

Parameters:
count - count of rows to add
Returns:
return if row is addded or nod (always true)

addColumn

public boolean addColumn(String columnName,
                         Array content)
                  throws DatabaseException
Description copied from interface: Query
adds a new column to the resultset

Parameters:
columnName - name of the new column
content - content of the new column inside a array (must have same size like query has records)
Returns:
if column is added return true otherwise false (always true, throw error when false)
Throws:
DatabaseException

addColumn

public boolean addColumn(Collection.Key columnName,
                         Array content)
                  throws PageException
Description copied from interface: Query
adds a new column to the resultset

Parameters:
columnName - name of the new column
content - content of the new column inside a array (must have same size like query has records)
Returns:
if column is added return true otherwise false (always true, throw error when false)
Throws:
PageException

addColumn

public boolean addColumn(String columnName,
                         Array content,
                         int type)
                  throws DatabaseException
Description copied from interface: Query
adds a new column to the resultset

Parameters:
columnName - name of the new column
content - content of the new column inside a array (must have same size like query has records)
type - data type from (java.sql.Types)
Returns:
if column is added return true otherwise false (always true, throw error when false)
Throws:
DatabaseException

addColumn

public boolean addColumn(Collection.Key columnName,
                         Array content,
                         int type)
                  throws DatabaseException
Description copied from interface: Query
adds a new column to the resultset

Parameters:
columnName - name of the new column
content - content of the new column inside a array (must have same size like query has records)
type - data type from (java.sql.Types)
Returns:
if column is added return true otherwise false (always true, throw error when false)
Throws:
DatabaseException

clone

public Object clone()
Specified by:
clone in interface Collection
Overrides:
clone in class Object
Returns:
Coloned Object

duplicate

public Collection duplicate(boolean deepCopy)
Specified by:
duplicate in interface Collection

cloneQuery

public QueryImpl cloneQuery(boolean deepCopy)

getTypes

public int[] getTypes()
Returns:
return all types

getTypesAsMap

public Map getTypesAsMap()
Returns:
returns all types as Map (key==column)

getColumn

public QueryColumn getColumn(String key)
                      throws DatabaseException
Description copied from interface: Query
return the query column matching to key

Parameters:
key - key to get
Returns:
QieryColumn object
Throws:
DatabaseException

getColumn

public QueryColumn getColumn(Collection.Key key)
                      throws DatabaseException
Description copied from interface: Query
return the query column matching to key

Parameters:
key - key to get
Returns:
QieryColumn object
Throws:
DatabaseException

getColumn

public QueryColumn getColumn(String key,
                             QueryColumn defaultValue)
Description copied from interface: Query
return the query column matching to key, if key not exist return null

Parameters:
key - key to get
Returns:
QieryColumn object

getColumn

public QueryColumn getColumn(Collection.Key key,
                             QueryColumn defaultValue)
Description copied from interface: Query
return the query column matching to key, if key not exist return null

Parameters:
key - key to get
Returns:
QieryColumn object

rename

public void rename(Collection.Key columnName,
                   Collection.Key newColumnName)
            throws ExpressionException
Throws:
ExpressionException

toString

public String toString()
Overrides:
toString in class Object

setExecutionTime

public void setExecutionTime(long exeTime)
Description copied from interface: Query
sets the execution Time of the query


cutRowsTo

public boolean cutRowsTo(int maxrows)

setCached

public void setCached(boolean isCached)
Description copied from interface: Query
sets if query is form cache or not

Parameters:
isCached - is cached or not

isCached

public boolean isCached()
Description copied from interface: Query
is query from cache or not

Returns:
is cached or not

addRow

public int addRow()
Specified by:
addRow in interface Query
Returns:
adds a row to resultset

getColumnName

public Collection.Key getColumnName(int columnIndex)

getColumnIndex

public int getColumnIndex(String coulmnName)
Description copied from interface: Query
returns index of a columnName

Specified by:
getColumnIndex in interface Query
Parameters:
coulmnName - column name to get index for
Returns:
index of a columnName

getColumns

public String[] getColumns()
Specified by:
getColumns in interface Query
Returns:
All column Names of resultset as string

getColumnNames

public Collection.Key[] getColumnNames()
Specified by:
getColumnNames in interface Query

setColumnNames

public void setColumnNames(Collection.Key[] trg)

getColumnNamesAsString

public String[] getColumnNamesAsString()
Specified by:
getColumnNamesAsString in interface Query

getData

public String getData(int row,
                      int col)
               throws IndexOutOfBoundsException
Description copied from interface: Query
returns one field of a Query as String

Specified by:
getData in interface Query
Returns:
data from query object
Throws:
IndexOutOfBoundsException

getName

public String getName()
Specified by:
getName in interface Query
Returns:
returns name of the query

getRowCount

public int getRowCount()
Specified by:
getRowCount in interface Query
Returns:
returns row count

setData

public void setData(int row,
                    int col,
                    String value)
             throws IndexOutOfBoundsException
Description copied from interface: Query
sets value at a defined position in Query

Specified by:
setData in interface Query
Throws:
IndexOutOfBoundsException

containsKey

public boolean containsKey(String key)
Description copied from interface: Collection
contains this key

Specified by:
containsKey in interface Collection
Returns:
returns if collection has a key with given name

containsKey

public boolean containsKey(Collection.Key key)
Description copied from interface: Collection
contains this key

Specified by:
containsKey in interface Collection
Returns:
returns if collection has a key with given name

castToString

public String castToString()
                    throws ExpressionException
Description copied from interface: Castable
cast the castable value to a string, other than the Method toString, this Method can throw a Exception

Specified by:
castToString in interface Castable
Returns:
String representation of the Object
Throws:
ExpressionException

castToString

public String castToString(String defaultValue)
Description copied from interface: Castable
cast the castable value to a string, return the default value, when the method is not castable

Specified by:
castToString in interface Castable
Returns:
String representation of the Object

castToBooleanValue

public boolean castToBooleanValue()
                           throws ExpressionException
Description copied from interface: Castable
cast the castable value to a boolean value

Specified by:
castToBooleanValue in interface Castable
Returns:
boolean Value representation of the Object
Throws:
ExpressionException

castToBoolean

public Boolean castToBoolean(Boolean defaultValue)
Description copied from interface: Castable
cast the castable value to a boolean value

Specified by:
castToBoolean in interface Castable
Returns:
boolean Value representation of the Object

castToDoubleValue

public double castToDoubleValue()
                         throws ExpressionException
Description copied from interface: Castable
cast the castable value to a double value

Specified by:
castToDoubleValue in interface Castable
Returns:
double Value representation of the Object
Throws:
ExpressionException

castToDoubleValue

public double castToDoubleValue(double defaultValue)
Description copied from interface: Castable
cast the castable value to a double value

Specified by:
castToDoubleValue in interface Castable
Returns:
double Value representation of the Object

castToDateTime

public DateTime castToDateTime()
                        throws ExpressionException
Description copied from interface: Castable
cast the castable value to a date time object

Specified by:
castToDateTime in interface Castable
Returns:
date time representation of the Object
Throws:
ExpressionException

castToDateTime

public DateTime castToDateTime(DateTime defaultValue)
Description copied from interface: Castable
cast the castable value to a date time object

Specified by:
castToDateTime in interface Castable
Parameters:
defaultValue - returned when it is not possible to cast to a dateTime object
Returns:
date time representation of the Object

compareTo

public int compareTo(boolean b)
              throws ExpressionException
Specified by:
compareTo in interface Castable
Throws:
ExpressionException

compareTo

public int compareTo(DateTime dt)
              throws PageException
Specified by:
compareTo in interface Castable
Throws:
PageException

compareTo

public int compareTo(double d)
              throws PageException
Specified by:
compareTo in interface Castable
Throws:
PageException

compareTo

public int compareTo(String str)
              throws PageException
Specified by:
compareTo in interface Castable
Throws:
PageException

getMetaDataSimple

public Array getMetaDataSimple()
Returns:
returns array with meta data to the query (only column names and type)

getObject

public Object getObject(String columnName)
                 throws SQLException
Specified by:
getObject in interface ResultSet
Throws:
SQLException

getObject

public Object getObject(int columnIndex)
                 throws SQLException
Specified by:
getObject in interface ResultSet
Throws:
SQLException

getString

public String getString(int columnIndex)
                 throws SQLException
Specified by:
getString in interface ResultSet
Throws:
SQLException

getString

public String getString(String columnName)
                 throws SQLException
Specified by:
getString in interface ResultSet
Throws:
SQLException

getBoolean

public boolean getBoolean(int columnIndex)
                   throws SQLException
Specified by:
getBoolean in interface ResultSet
Throws:
SQLException

getBoolean

public boolean getBoolean(String columnName)
                   throws SQLException
Specified by:
getBoolean in interface ResultSet
Throws:
SQLException

call

public Object call(PageContext pc,
                   Collection.Key methodName,
                   Object[] arguments)
            throws PageException
Description copied from interface: Objects
calls a method of the object

Specified by:
call in interface Objects
methodName - name of the method to call
arguments - arguments to call method with
Returns:
return value of the method
Throws:
PageException

callWithNamedValues

public Object callWithNamedValues(PageContext pc,
                                  Collection.Key methodName,
                                  Struct args)
                           throws PageException
Description copied from interface: Objects
call a method of the Object with named arguments

Specified by:
callWithNamedValues in interface Objects
Parameters:
pc - PageContext
methodName - name of the method
args - Named Arguments for the method
Returns:
return result of the method
Throws:
PageException

get

public Object get(PageContext pc,
                  Collection.Key key,
                  Object defaultValue)
Description copied from interface: Objects
return property

Specified by:
get in interface Objects
Parameters:
pc - PageContext
key - Name of the Property
Returns:
return value of the Property

get

public Object get(PageContext pc,
                  Collection.Key key)
           throws PageException
Description copied from interface: Objects
return property or getter of the ContextCollection

Specified by:
get in interface Objects
Parameters:
pc - PageContext
key - Name of the Property
Returns:
return value of the Property
Throws:
PageException

isInitalized

public boolean isInitalized()

set

public Object set(PageContext pc,
                  Collection.Key propertyName,
                  Object value)
           throws PageException
Description copied from interface: Objects
sets a property (Data Member) value of the object

Specified by:
set in interface Objects
propertyName - property name to set
value - value to insert
Returns:
value set to property
Throws:
PageException

setEL

public Object setEL(PageContext pc,
                    Collection.Key propertyName,
                    Object value)
Description copied from interface: Objects
sets a property (Data Member) value of the object

Specified by:
setEL in interface Objects
propertyName - property name to set
value - value to insert
Returns:
value set to property

wasNull

public boolean wasNull()
Specified by:
wasNull in interface ResultSet

absolute

public boolean absolute(int row)
                 throws SQLException
Specified by:
absolute in interface ResultSet
Throws:
SQLException

afterLast

public void afterLast()
               throws SQLException
Specified by:
afterLast in interface ResultSet
Throws:
SQLException

beforeFirst

public void beforeFirst()
                 throws SQLException
Specified by:
beforeFirst in interface ResultSet
Throws:
SQLException

cancelRowUpdates

public void cancelRowUpdates()
                      throws SQLException
Specified by:
cancelRowUpdates in interface ResultSet
Throws:
SQLException

clearWarnings

public void clearWarnings()
                   throws SQLException
Specified by:
clearWarnings in interface ResultSet
Throws:
SQLException

close

public void close()
           throws SQLException
Specified by:
close in interface ResultSet
Throws:
SQLException

deleteRow

public void deleteRow()
               throws SQLException
Specified by:
deleteRow in interface ResultSet
Throws:
SQLException

findColumn

public int findColumn(String columnName)
               throws SQLException
Specified by:
findColumn in interface ResultSet
Throws:
SQLException

first

public boolean first()
              throws SQLException
Specified by:
first in interface ResultSet
Throws:
SQLException

getArray

public Array getArray(int i)
               throws SQLException
Specified by:
getArray in interface ResultSet
Throws:
SQLException

getArray

public Array getArray(String colName)
               throws SQLException
Specified by:
getArray in interface ResultSet
Throws:
SQLException

getAsciiStream

public InputStream getAsciiStream(int columnIndex)
                           throws SQLException
Specified by:
getAsciiStream in interface ResultSet
Throws:
SQLException

getAsciiStream

public InputStream getAsciiStream(String columnName)
                           throws SQLException
Specified by:
getAsciiStream in interface ResultSet
Throws:
SQLException

getBigDecimal

public BigDecimal getBigDecimal(int columnIndex)
                         throws SQLException
Specified by:
getBigDecimal in interface ResultSet
Throws:
SQLException

getBigDecimal

public BigDecimal getBigDecimal(String columnName)
                         throws SQLException
Specified by:
getBigDecimal in interface ResultSet
Throws:
SQLException

getBigDecimal

public BigDecimal getBigDecimal(int columnIndex,
                                int scale)
                         throws SQLException
Specified by:
getBigDecimal in interface ResultSet
Throws:
SQLException

getBigDecimal

public BigDecimal getBigDecimal(String columnName,
                                int scale)
                         throws SQLException
Specified by:
getBigDecimal in interface ResultSet
Throws:
SQLException

getBinaryStream

public InputStream getBinaryStream(int columnIndex)
                            throws SQLException
Specified by:
getBinaryStream in interface ResultSet
Throws:
SQLException

getBinaryStream

public InputStream getBinaryStream(String columnName)
                            throws SQLException
Specified by:
getBinaryStream in interface ResultSet
Throws:
SQLException

getBlob

public Blob getBlob(int i)
             throws SQLException
Specified by:
getBlob in interface ResultSet
Throws:
SQLException

getBlob

public Blob getBlob(String colName)
             throws SQLException
Specified by:
getBlob in interface ResultSet
Throws:
SQLException

getByte

public byte getByte(int columnIndex)
             throws SQLException
Specified by:
getByte in interface ResultSet
Throws:
SQLException

getByte

public byte getByte(String columnName)
             throws SQLException
Specified by:
getByte in interface ResultSet
Throws:
SQLException

getBytes

public byte[] getBytes(int columnIndex)
                throws SQLException
Specified by:
getBytes in interface ResultSet
Throws:
SQLException

getBytes

public byte[] getBytes(String columnName)
                throws SQLException
Specified by:
getBytes in interface ResultSet
Throws:
SQLException

getCharacterStream

public Reader getCharacterStream(int columnIndex)
                          throws SQLException
Specified by:
getCharacterStream in interface ResultSet
Throws:
SQLException

getCharacterStream

public Reader getCharacterStream(String columnName)
                          throws SQLException
Specified by:
getCharacterStream in interface ResultSet
Throws:
SQLException

getClob

public Clob getClob(int i)
             throws SQLException
Specified by:
getClob in interface ResultSet
Throws:
SQLException

getClob

public Clob getClob(String colName)
             throws SQLException
Specified by:
getClob in interface ResultSet
Throws:
SQLException

getConcurrency

public int getConcurrency()
                   throws SQLException
Specified by:
getConcurrency in interface ResultSet
Throws:
SQLException

getCursorName

public String getCursorName()
                     throws SQLException
Specified by:
getCursorName in interface ResultSet
Throws:
SQLException

getDate

public Date getDate(int columnIndex)
             throws SQLException
Specified by:
getDate in interface ResultSet
Throws:
SQLException

getDate

public Date getDate(String columnName)
             throws SQLException
Specified by:
getDate in interface ResultSet
Throws:
SQLException

getDate

public Date getDate(int columnIndex,
                    Calendar cal)
             throws SQLException
Specified by:
getDate in interface ResultSet
Throws:
SQLException

getDate

public Date getDate(String columnName,
                    Calendar cal)
             throws SQLException
Specified by:
getDate in interface ResultSet
Throws:
SQLException

getDouble

public double getDouble(int columnIndex)
                 throws SQLException
Specified by:
getDouble in interface ResultSet
Throws:
SQLException

getDouble

public double getDouble(String columnName)
                 throws SQLException
Specified by:
getDouble in interface ResultSet
Throws:
SQLException

getFetchDirection

public int getFetchDirection()
                      throws SQLException
Specified by:
getFetchDirection in interface ResultSet
Throws:
SQLException

getFetchSize

public int getFetchSize()
                 throws SQLException
Specified by:
getFetchSize in interface ResultSet
Throws:
SQLException

getFloat

public float getFloat(int columnIndex)
               throws SQLException
Specified by:
getFloat in interface ResultSet
Throws:
SQLException

getFloat

public float getFloat(String columnName)
               throws SQLException
Specified by:
getFloat in interface ResultSet
Throws:
SQLException

getInt

public int getInt(int columnIndex)
           throws SQLException
Specified by:
getInt in interface ResultSet
Throws:
SQLException

getInt

public int getInt(String columnName)
           throws SQLException
Specified by:
getInt in interface ResultSet
Throws:
SQLException

getLong

public long getLong(int columnIndex)
             throws SQLException
Specified by:
getLong in interface ResultSet
Throws:
SQLException

getLong

public long getLong(String columnName)
             throws SQLException
Specified by:
getLong in interface ResultSet
Throws:
SQLException

getObject

public Object getObject(int i,
                        Map map)
                 throws SQLException
Specified by:
getObject in interface ResultSet
Throws:
SQLException

getObject

public Object getObject(String colName,
                        Map map)
                 throws SQLException
Specified by:
getObject in interface ResultSet
Throws:
SQLException

getObject

public <T> T getObject(int columnIndex,
                       Class<T> type)
            throws SQLException
Throws:
SQLException

getObject

public <T> T getObject(String columnLabel,
                       Class<T> type)
            throws SQLException
Throws:
SQLException

getRef

public Ref getRef(int i)
           throws SQLException
Specified by:
getRef in interface ResultSet
Throws:
SQLException

getRef

public Ref getRef(String colName)
           throws SQLException
Specified by:
getRef in interface ResultSet
Throws:
SQLException

getRow

public int getRow()
           throws SQLException
Specified by:
getRow in interface ResultSet
Throws:
SQLException

getShort

public short getShort(int columnIndex)
               throws SQLException
Specified by:
getShort in interface ResultSet
Throws:
SQLException

getShort

public short getShort(String columnName)
               throws SQLException
Specified by:
getShort in interface ResultSet
Throws:
SQLException

getStatement

public Statement getStatement()
                       throws SQLException
Specified by:
getStatement in interface ResultSet
Throws:
SQLException

getTime

public Time getTime(int columnIndex)
             throws SQLException
Specified by:
getTime in interface ResultSet
Throws:
SQLException

getTime

public Time getTime(String columnName)
             throws SQLException
Specified by:
getTime in interface ResultSet
Throws:
SQLException

getTime

public Time getTime(int columnIndex,
                    Calendar cal)
             throws SQLException
Specified by:
getTime in interface ResultSet
Throws:
SQLException

getTime

public Time getTime(String columnName,
                    Calendar cal)
             throws SQLException
Specified by:
getTime in interface ResultSet
Throws:
SQLException

getTimestamp

public Timestamp getTimestamp(int columnIndex)
                       throws SQLException
Specified by:
getTimestamp in interface ResultSet
Throws:
SQLException

getTimestamp

public Timestamp getTimestamp(String columnName)
                       throws SQLException
Specified by:
getTimestamp in interface ResultSet
Throws:
SQLException

getTimestamp

public Timestamp getTimestamp(int columnIndex,
                              Calendar cal)
                       throws SQLException
Specified by:
getTimestamp in interface ResultSet
Throws:
SQLException

getTimestamp

public Timestamp getTimestamp(String columnName,
                              Calendar cal)
                       throws SQLException
Specified by:
getTimestamp in interface ResultSet
Throws:
SQLException

getType

public int getType()
            throws SQLException
Specified by:
getType in interface ResultSet
Throws:
SQLException

getURL

public URL getURL(int columnIndex)
           throws SQLException
Specified by:
getURL in interface ResultSet
Throws:
SQLException

getURL

public URL getURL(String columnName)
           throws SQLException
Specified by:
getURL in interface ResultSet
Throws:
SQLException

getUnicodeStream

public InputStream getUnicodeStream(int columnIndex)
                             throws SQLException
Specified by:
getUnicodeStream in interface ResultSet
Throws:
SQLException

getUnicodeStream

public InputStream getUnicodeStream(String columnName)
                             throws SQLException
Specified by:
getUnicodeStream in interface ResultSet
Throws:
SQLException

getWarnings

public SQLWarning getWarnings()
                       throws SQLException
Specified by:
getWarnings in interface ResultSet
Throws:
SQLException

insertRow

public void insertRow()
               throws SQLException
Specified by:
insertRow in interface ResultSet
Throws:
SQLException

isAfterLast

public boolean isAfterLast()
                    throws SQLException
Specified by:
isAfterLast in interface ResultSet
Throws:
SQLException

isBeforeFirst

public boolean isBeforeFirst()
                      throws SQLException
Specified by:
isBeforeFirst in interface ResultSet
Throws:
SQLException

isFirst

public boolean isFirst()
                throws SQLException
Specified by:
isFirst in interface ResultSet
Throws:
SQLException

isLast

public boolean isLast()
               throws SQLException
Specified by:
isLast in interface ResultSet
Throws:
SQLException

last

public boolean last()
             throws SQLException
Specified by:
last in interface ResultSet
Throws:
SQLException

moveToCurrentRow

public void moveToCurrentRow()
                      throws SQLException
Specified by:
moveToCurrentRow in interface ResultSet
Throws:
SQLException

moveToInsertRow

public void moveToInsertRow()
                     throws SQLException
Specified by:
moveToInsertRow in interface ResultSet
Throws:
SQLException

previous

public boolean previous()
Specified by:
previous in interface ResultSet

previous

public boolean previous(int pid)
Specified by:
previous in interface Iterator

refreshRow

public void refreshRow()
                throws SQLException
Specified by:
refreshRow in interface ResultSet
Throws:
SQLException

relative

public boolean relative(int rows)
                 throws SQLException
Specified by:
relative in interface ResultSet
Throws:
SQLException

rowDeleted

public boolean rowDeleted()
                   throws SQLException
Specified by:
rowDeleted in interface ResultSet
Throws:
SQLException

rowInserted

public boolean rowInserted()
                    throws SQLException
Specified by:
rowInserted in interface ResultSet
Throws:
SQLException

rowUpdated

public boolean rowUpdated()
                   throws SQLException
Specified by:
rowUpdated in interface ResultSet
Throws:
SQLException

setFetchDirection

public void setFetchDirection(int direction)
                       throws SQLException
Specified by:
setFetchDirection in interface ResultSet
Throws:
SQLException

setFetchSize

public void setFetchSize(int rows)
                  throws SQLException
Specified by:
setFetchSize in interface ResultSet
Throws:
SQLException

updateArray

public void updateArray(int columnIndex,
                        Array x)
                 throws SQLException
Specified by:
updateArray in interface ResultSet
Throws:
SQLException

updateArray

public void updateArray(String columnName,
                        Array x)
                 throws SQLException
Specified by:
updateArray in interface ResultSet
Throws:
SQLException

updateAsciiStream

public void updateAsciiStream(int columnIndex,
                              InputStream x,
                              int length)
                       throws SQLException
Specified by:
updateAsciiStream in interface ResultSet
Throws:
SQLException

updateAsciiStream

public void updateAsciiStream(String columnName,
                              InputStream x,
                              int length)
                       throws SQLException
Specified by:
updateAsciiStream in interface ResultSet
Throws:
SQLException

updateBigDecimal

public void updateBigDecimal(int columnIndex,
                             BigDecimal x)
                      throws SQLException
Specified by:
updateBigDecimal in interface ResultSet
Throws:
SQLException

updateBigDecimal

public void updateBigDecimal(String columnName,
                             BigDecimal x)
                      throws SQLException
Specified by:
updateBigDecimal in interface ResultSet
Throws:
SQLException

updateBinaryStream

public void updateBinaryStream(int columnIndex,
                               InputStream x,
                               int length)
                        throws SQLException
Specified by:
updateBinaryStream in interface ResultSet
Throws:
SQLException

updateBinaryStream

public void updateBinaryStream(String columnName,
                               InputStream x,
                               int length)
                        throws SQLException
Specified by:
updateBinaryStream in interface ResultSet
Throws:
SQLException

updateBlob

public void updateBlob(int columnIndex,
                       Blob x)
                throws SQLException
Specified by:
updateBlob in interface ResultSet
Throws:
SQLException

updateBlob

public void updateBlob(String columnName,
                       Blob x)
                throws SQLException
Specified by:
updateBlob in interface ResultSet
Throws:
SQLException

updateBoolean

public void updateBoolean(int columnIndex,
                          boolean x)
                   throws SQLException
Specified by:
updateBoolean in interface ResultSet
Throws:
SQLException

updateBoolean

public void updateBoolean(String columnName,
                          boolean x)
                   throws SQLException
Specified by:
updateBoolean in interface ResultSet
Throws:
SQLException

updateByte

public void updateByte(int columnIndex,
                       byte x)
                throws SQLException
Specified by:
updateByte in interface ResultSet
Throws:
SQLException

updateByte

public void updateByte(String columnName,
                       byte x)
                throws SQLException
Specified by:
updateByte in interface ResultSet
Throws:
SQLException

updateBytes

public void updateBytes(int columnIndex,
                        byte[] x)
                 throws SQLException
Specified by:
updateBytes in interface ResultSet
Throws:
SQLException

updateBytes

public void updateBytes(String columnName,
                        byte[] x)
                 throws SQLException
Specified by:
updateBytes in interface ResultSet
Throws:
SQLException

updateCharacterStream

public void updateCharacterStream(int columnIndex,
                                  Reader reader,
                                  int length)
                           throws SQLException
Specified by:
updateCharacterStream in interface ResultSet
Throws:
SQLException

updateCharacterStream

public void updateCharacterStream(String columnName,
                                  Reader reader,
                                  int length)
                           throws SQLException
Specified by:
updateCharacterStream in interface ResultSet
Throws:
SQLException

updateClob

public void updateClob(int columnIndex,
                       Clob x)
                throws SQLException
Specified by:
updateClob in interface ResultSet
Throws:
SQLException

updateClob

public void updateClob(String columnName,
                       Clob x)
                throws SQLException
Specified by:
updateClob in interface ResultSet
Throws:
SQLException

updateDate

public void updateDate(int columnIndex,
                       Date x)
                throws SQLException
Specified by:
updateDate in interface ResultSet
Throws:
SQLException

updateDate

public void updateDate(String columnName,
                       Date x)
                throws SQLException
Specified by:
updateDate in interface ResultSet
Throws:
SQLException

updateDouble

public void updateDouble(int columnIndex,
                         double x)
                  throws SQLException
Specified by:
updateDouble in interface ResultSet
Throws:
SQLException

updateDouble

public void updateDouble(String columnName,
                         double x)
                  throws SQLException
Specified by:
updateDouble in interface ResultSet
Throws:
SQLException

updateFloat

public void updateFloat(int columnIndex,
                        float x)
                 throws SQLException
Specified by:
updateFloat in interface ResultSet
Throws:
SQLException

updateFloat

public void updateFloat(String columnName,
                        float x)
                 throws SQLException
Specified by:
updateFloat in interface ResultSet
Throws:
SQLException

updateInt

public void updateInt(int columnIndex,
                      int x)
               throws SQLException
Specified by:
updateInt in interface ResultSet
Throws:
SQLException

updateInt

public void updateInt(String columnName,
                      int x)
               throws SQLException
Specified by:
updateInt in interface ResultSet
Throws:
SQLException

updateLong

public void updateLong(int columnIndex,
                       long x)
                throws SQLException
Specified by:
updateLong in interface ResultSet
Throws:
SQLException

updateLong

public void updateLong(String columnName,
                       long x)
                throws SQLException
Specified by:
updateLong in interface ResultSet
Throws:
SQLException

updateNull

public void updateNull(int columnIndex)
                throws SQLException
Specified by:
updateNull in interface ResultSet
Throws:
SQLException

updateNull

public void updateNull(String columnName)
                throws SQLException
Specified by:
updateNull in interface ResultSet
Throws:
SQLException

updateObject

public void updateObject(int columnIndex,
                         Object x)
                  throws SQLException
Specified by:
updateObject in interface ResultSet
Throws:
SQLException

updateObject

public void updateObject(String columnName,
                         Object x)
                  throws SQLException
Specified by:
updateObject in interface ResultSet
Throws:
SQLException

updateObject

public void updateObject(int columnIndex,
                         Object x,
                         int scale)
                  throws SQLException
Specified by:
updateObject in interface ResultSet
Throws:
SQLException

updateObject

public void updateObject(String columnName,
                         Object x,
                         int scale)
                  throws SQLException
Specified by:
updateObject in interface ResultSet
Throws:
SQLException

updateRef

public void updateRef(int columnIndex,
                      Ref x)
               throws SQLException
Specified by:
updateRef in interface ResultSet
Throws:
SQLException

updateRef

public void updateRef(String columnName,
                      Ref x)
               throws SQLException
Specified by:
updateRef in interface ResultSet
Throws:
SQLException

updateRow

public void updateRow()
               throws SQLException
Specified by:
updateRow in interface ResultSet
Throws:
SQLException

updateShort

public void updateShort(int columnIndex,
                        short x)
                 throws SQLException
Specified by:
updateShort in interface ResultSet
Throws:
SQLException

updateShort

public void updateShort(String columnName,
                        short x)
                 throws SQLException
Specified by:
updateShort in interface ResultSet
Throws:
SQLException

updateString

public void updateString(int columnIndex,
                         String x)
                  throws SQLException
Specified by:
updateString in interface ResultSet
Throws:
SQLException

updateString

public void updateString(String columnName,
                         String x)
                  throws SQLException
Specified by:
updateString in interface ResultSet
Throws:
SQLException

updateTime

public void updateTime(int columnIndex,
                       Time x)
                throws SQLException
Specified by:
updateTime in interface ResultSet
Throws:
SQLException

updateTime

public void updateTime(String columnName,
                       Time x)
                throws SQLException
Specified by:
updateTime in interface ResultSet
Throws:
SQLException

updateTimestamp

public void updateTimestamp(int columnIndex,
                            Timestamp x)
                     throws SQLException
Specified by:
updateTimestamp in interface ResultSet
Throws:
SQLException

updateTimestamp

public void updateTimestamp(String columnName,
                            Timestamp x)
                     throws SQLException
Specified by:
updateTimestamp in interface ResultSet
Throws:
SQLException

getMetaData

public ResultSetMetaData getMetaData()
                              throws SQLException
Specified by:
getMetaData in interface ResultSet
Throws:
SQLException

keyIterator

public Iterator<Collection.Key> keyIterator()
Specified by:
keyIterator in interface Iteratorable
Returns:
return a Iterator for Keys as Collection.Keys

keysAsStringIterator

public Iterator<String> keysAsStringIterator()
Specified by:
keysAsStringIterator in interface Iteratorable
Returns:
return a Iterator for Keys as String

entryIterator

public Iterator<Map.Entry<Collection.Key,Object>> entryIterator()
Specified by:
entryIterator in interface Iteratorable

valueIterator

public Iterator<Object> valueIterator()
Specified by:
valueIterator in interface Iteratorable
Returns:
return a Iterator for Values

equals

public boolean equals(Object obj)
Overrides:
equals in class Object

getHoldability

public int getHoldability()
                   throws SQLException
Specified by:
getHoldability in interface ResultSet
Throws:
SQLException

isClosed

public boolean isClosed()
                 throws SQLException
Specified by:
isClosed in interface ResultSet
Throws:
SQLException

updateNString

public void updateNString(int columnIndex,
                          String nString)
                   throws SQLException
Specified by:
updateNString in interface ResultSet
Throws:
SQLException

updateNString

public void updateNString(String columnLabel,
                          String nString)
                   throws SQLException
Specified by:
updateNString in interface ResultSet
Throws:
SQLException

getNString

public String getNString(int columnIndex)
                  throws SQLException
Specified by:
getNString in interface ResultSet
Throws:
SQLException

getNString

public String getNString(String columnLabel)
                  throws SQLException
Specified by:
getNString in interface ResultSet
Throws:
SQLException

getNCharacterStream

public Reader getNCharacterStream(int columnIndex)
                           throws SQLException
Specified by:
getNCharacterStream in interface ResultSet
Throws:
SQLException

getNCharacterStream

public Reader getNCharacterStream(String columnLabel)
                           throws SQLException
Specified by:
getNCharacterStream in interface ResultSet
Throws:
SQLException

updateNCharacterStream

public void updateNCharacterStream(int columnIndex,
                                   Reader x,
                                   long length)
                            throws SQLException
Specified by:
updateNCharacterStream in interface ResultSet
Throws:
SQLException

updateNCharacterStream

public void updateNCharacterStream(String columnLabel,
                                   Reader reader,
                                   long length)
                            throws SQLException
Specified by:
updateNCharacterStream in interface ResultSet
Throws:
SQLException

updateAsciiStream

public void updateAsciiStream(int columnIndex,
                              InputStream x,
                              long length)
                       throws SQLException
Specified by:
updateAsciiStream in interface ResultSet
Throws:
SQLException

updateBinaryStream

public void updateBinaryStream(int columnIndex,
                               InputStream x,
                               long length)
                        throws SQLException
Specified by:
updateBinaryStream in interface ResultSet
Throws:
SQLException

updateCharacterStream

public void updateCharacterStream(int columnIndex,
                                  Reader x,
                                  long length)
                           throws SQLException
Specified by:
updateCharacterStream in interface ResultSet
Throws:
SQLException

updateAsciiStream

public void updateAsciiStream(String columnLabel,
                              InputStream x,
                              long length)
                       throws SQLException
Specified by:
updateAsciiStream in interface ResultSet
Throws:
SQLException

updateBinaryStream

public void updateBinaryStream(String columnLabel,
                               InputStream x,
                               long length)
                        throws SQLException
Specified by:
updateBinaryStream in interface ResultSet
Throws:
SQLException

updateCharacterStream

public void updateCharacterStream(String columnLabel,
                                  Reader reader,
                                  long length)
                           throws SQLException
Specified by:
updateCharacterStream in interface ResultSet
Throws:
SQLException

updateBlob

public void updateBlob(int columnIndex,
                       InputStream inputStream,
                       long length)
                throws SQLException
Specified by:
updateBlob in interface ResultSet
Throws:
SQLException

updateBlob

public void updateBlob(String columnLabel,
                       InputStream inputStream,
                       long length)
                throws SQLException
Specified by:
updateBlob in interface ResultSet
Throws:
SQLException

updateClob

public void updateClob(int columnIndex,
                       Reader reader,
                       long length)
                throws SQLException
Specified by:
updateClob in interface ResultSet
Throws:
SQLException

updateClob

public void updateClob(String columnLabel,
                       Reader reader,
                       long length)
                throws SQLException
Specified by:
updateClob in interface ResultSet
Throws:
SQLException

updateNClob

public void updateNClob(int columnIndex,
                        Reader reader,
                        long length)
                 throws SQLException
Specified by:
updateNClob in interface ResultSet
Throws:
SQLException

updateNClob

public void updateNClob(String columnLabel,
                        Reader reader,
                        long length)
                 throws SQLException
Specified by:
updateNClob in interface ResultSet
Throws:
SQLException

updateNCharacterStream

public void updateNCharacterStream(int columnIndex,
                                   Reader x)
                            throws SQLException
Specified by:
updateNCharacterStream in interface ResultSet
Throws:
SQLException

updateNCharacterStream

public void updateNCharacterStream(String columnLabel,
                                   Reader reader)
                            throws SQLException
Specified by:
updateNCharacterStream in interface ResultSet
Throws:
SQLException

updateAsciiStream

public void updateAsciiStream(int columnIndex,
                              InputStream x)
                       throws SQLException
Specified by:
updateAsciiStream in interface ResultSet
Throws:
SQLException

updateBinaryStream

public void updateBinaryStream(int columnIndex,
                               InputStream x)
                        throws SQLException
Specified by:
updateBinaryStream in interface ResultSet
Throws:
SQLException

updateCharacterStream

public void updateCharacterStream(int columnIndex,
                                  Reader x)
                           throws SQLException
Specified by:
updateCharacterStream in interface ResultSet
Throws:
SQLException

updateAsciiStream

public void updateAsciiStream(String columnLabel,
                              InputStream x)
                       throws SQLException
Specified by:
updateAsciiStream in interface ResultSet
Throws:
SQLException

updateBinaryStream

public void updateBinaryStream(String columnLabel,
                               InputStream x)
                        throws SQLException
Specified by:
updateBinaryStream in interface ResultSet
Throws:
SQLException

updateCharacterStream

public void updateCharacterStream(String columnLabel,
                                  Reader reader)
                           throws SQLException
Specified by:
updateCharacterStream in interface ResultSet
Throws:
SQLException

updateBlob

public void updateBlob(int columnIndex,
                       InputStream inputStream)
                throws SQLException
Specified by:
updateBlob in interface ResultSet
Throws:
SQLException

updateBlob

public void updateBlob(String columnLabel,
                       InputStream inputStream)
                throws SQLException
Specified by:
updateBlob in interface ResultSet
Throws:
SQLException

updateClob

public void updateClob(int columnIndex,
                       Reader reader)
                throws SQLException
Specified by:
updateClob in interface ResultSet
Throws:
SQLException

updateClob

public void updateClob(String columnLabel,
                       Reader reader)
                throws SQLException
Specified by:
updateClob in interface ResultSet
Throws:
SQLException

updateNClob

public void updateNClob(int columnIndex,
                        Reader reader)
                 throws SQLException
Specified by:
updateNClob in interface ResultSet
Throws:
SQLException

updateNClob

public void updateNClob(String columnLabel,
                        Reader reader)
                 throws SQLException
Specified by:
updateNClob in interface ResultSet
Throws:
SQLException

unwrap

public <T> T unwrap(Class<T> iface)
         throws SQLException
Specified by:
unwrap in interface Wrapper
Throws:
SQLException

isWrapperFor

public boolean isWrapperFor(Class<?> iface)
                     throws SQLException
Specified by:
isWrapperFor in interface Wrapper
Throws:
SQLException

updateNClob

public void updateNClob(int columnIndex,
                        NClob nClob)
                 throws SQLException
Specified by:
updateNClob in interface ResultSet
Throws:
SQLException

updateNClob

public void updateNClob(String columnLabel,
                        NClob nClob)
                 throws SQLException
Specified by:
updateNClob in interface ResultSet
Throws:
SQLException

getNClob

public NClob getNClob(int columnIndex)
               throws SQLException
Specified by:
getNClob in interface ResultSet
Throws:
SQLException

getNClob

public NClob getNClob(String columnLabel)
               throws SQLException
Specified by:
getNClob in interface ResultSet
Throws:
SQLException

getSQLXML

public SQLXML getSQLXML(int columnIndex)
                 throws SQLException
Specified by:
getSQLXML in interface ResultSet
Throws:
SQLException

getSQLXML

public SQLXML getSQLXML(String columnLabel)
                 throws SQLException
Specified by:
getSQLXML in interface ResultSet
Throws:
SQLException

updateSQLXML

public void updateSQLXML(int columnIndex,
                         SQLXML xmlObject)
                  throws SQLException
Specified by:
updateSQLXML in interface ResultSet
Throws:
SQLException

updateSQLXML

public void updateSQLXML(String columnLabel,
                         SQLXML xmlObject)
                  throws SQLException
Specified by:
updateSQLXML in interface ResultSet
Throws:
SQLException

getRowId

public RowId getRowId(int columnIndex)
               throws SQLException
Specified by:
getRowId in interface ResultSet
Throws:
SQLException

getRowId

public RowId getRowId(String columnLabel)
               throws SQLException
Specified by:
getRowId in interface ResultSet
Throws:
SQLException

updateRowId

public void updateRowId(int columnIndex,
                        RowId x)
                 throws SQLException
Specified by:
updateRowId in interface ResultSet
Throws:
SQLException

updateRowId

public void updateRowId(String columnLabel,
                        RowId x)
                 throws SQLException
Specified by:
updateRowId in interface ResultSet
Throws:
SQLException

enableShowQueryUsage

public void enableShowQueryUsage()

notSupported

public static PageRuntimeException notSupported()

toRuntimeExc

public static PageRuntimeException toRuntimeExc(Throwable t)

toPageExc

public static PageException toPageExc(Throwable t)

getGeneratedKeys

public Query getGeneratedKeys()

getSql

public SQL getSql()

getTemplate

public String getTemplate()

getExecutionTime

public long getExecutionTime()
Returns:
return the query execution time in nanoseconds

getIterator

public Iterator getIterator()
Specified by:
getIterator in interface ForEachIteratorable


Copyright © 2012 Railo