de.uplanet.lucy.server.util.db
Class DbResultSet

java.lang.Object
  de.uplanet.lucy.server.util.db.DbResultSet

All Implemented Interfaces:

IDbResultSet, ICloseable, java.lang.Iterable<IDbRow>

public final class DbResultSet
extends java.lang.Object
implements IDbResultSet, java.lang.Iterable<IDbRow>

Version:

$Revision: 85786 $

Method Summary

void	close() Close this object.
java.util.List<?>	findAll(groovy.lang.Closure p_closure) Calls the given closure for every row in the result set and returns a list of rows for which the closure is valid.
java.math.BigDecimal	getBigDecimalValue(int p_iIdx)
java.math.BigDecimal	getBigDecimalValue(int p_iIdx, java.math.BigDecimal p_valueIfNull)
java.lang.Boolean	getBooleanValue(int p_iIdx)
java.lang.Boolean	getBooleanValue(int p_iIdx, java.lang.Boolean p_valueIfNull)
byte	getByteValue(int p_iIdx)
java.lang.Byte	getByteValue(int p_iIdx, java.lang.Byte p_valueIfNull)
java.util.Date	getDateValue(int p_iIdx)
java.util.Date	getDateValue(int p_iIdx, java.util.Calendar p_cal)
java.util.Date	getDateValue(int p_iIdx, java.util.Date p_valueIfNull)
java.util.Date	getDateValue(int p_iIdx, java.util.Date p_valueIfNull, java.util.Calendar p_cal)
java.util.Date	getDateValue(int p_iIdx, java.util.Date p_valueIfNull, java.util.TimeZone p_tz)
java.util.Date	getDateValue(int p_iIdx, java.util.TimeZone p_tz)
java.lang.Double	getDoubleValue(int p_iIdx)
java.lang.Double	getDoubleValue(int p_iIdx, java.lang.Double p_valueIfNull)
java.lang.Float	getFloatValue(int p_iIdx)
java.lang.Float	getFloatValue(int p_iIdx, java.lang.Float p_valueIfNull)
java.lang.Integer	getIntValue(int p_iIdx)
java.lang.Integer	getIntValue(int p_iIdx, java.lang.Integer p_valueIfNull)
java.lang.Long	getLongValue(int p_iIdx)
java.lang.Long	getLongValue(int p_iIdx, java.lang.Long p_valueIfNull)
java.lang.Short	getShortValue(int p_iIdx)
java.lang.Short	getShortValue(int p_iIdx, java.lang.Short p_valueIfNull)
java.lang.String	getStringValue(int p_iIdx)
java.lang.String	getStringValue(int p_iIdx, java.lang.String p_valueIfNull)
java.sql.Timestamp	getTimestampValue(int p_iIdx)
java.sql.Timestamp	getTimestampValue(int p_iIdx, java.util.Calendar p_cal)
java.sql.Timestamp	getTimestampValue(int p_iIdx, java.sql.Timestamp p_valueIfNull)
java.sql.Timestamp	getTimestampValue(int p_iIdx, java.sql.Timestamp p_valueIfNull, java.util.Calendar p_cal)
java.sql.Timestamp	getTimestampValue(int p_iIdx, java.sql.Timestamp p_valueIfNull, java.util.TimeZone p_tz)
java.sql.Timestamp	getTimestampValue(int p_iIdx, java.util.TimeZone p_tz)
java.util.Date	getTimeValue(int p_iIdx)
java.util.Date	getTimeValue(int p_iIdx, java.util.Calendar p_cal)
java.util.Date	getTimeValue(int p_iIdx, java.util.Date p_valueIfNull)
java.util.Date	getTimeValue(int p_iIdx, java.util.Date p_valueIfNull, java.util.Calendar p_cal)
java.util.Date	getTimeValue(int p_iIdx, java.util.Date p_valueIfNull, java.util.TimeZone p_tz)
java.util.Date	getTimeValue(int p_iIdx, java.util.TimeZone p_tz)
java.lang.Object	getValue(int p_iIdx)
java.lang.Object	getValue(int p_iIdx, java.lang.Object p_valueIfNull)
IValueHolder<?>	getValueHolder(int p_iIdx)
IValueHolder<?>	getValueHolder(int p_iIdx, javax.xml.namespace.QName p_qmnDataType)
IValueHolder<?>	getValueHolder(int p_iIdx, javax.xml.namespace.QName p_qmnDataType, IValueHolder<?> p_valueIfNull)
IValueHolder<?>	getValueHolder(int p_iIdx, java.lang.String p_strDataTypeAsSerializedQName)
IValueHolder<?>	getValueHolder(int p_iIdx, java.lang.String p_strDataTypeAsSerializedQName, IValueHolder<?> p_valueIfNull)
java.util.Collection<?>	grep(java.lang.Object p_filter) This method is not supported.
java.util.Iterator<IDbRow>	iterator()
boolean	next()
java.lang.Object	value(int p_iIdx) Deprecated. Please use getValue(int) or one of the getXxxValue(int) methods instead.
boolean	wasNull(int p_iIdx)

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

next

public boolean next()
             throws java.sql.SQLException

Specified by:

next in interface IDbResultSet

Throws:

java.sql.SQLException

wasNull

public boolean wasNull(int p_iIdx)
                throws java.sql.SQLException

Specified by:

wasNull in interface IDbResultSet

Throws:

java.sql.SQLException

getValueHolder

public IValueHolder<?> getValueHolder(int p_iIdx)
                               throws java.sql.SQLException

Specified by:

getValueHolder in interface IDbResultSet

Throws:

java.sql.SQLException

getValueHolder

public IValueHolder<?> getValueHolder(int p_iIdx,
                                      javax.xml.namespace.QName p_qmnDataType)
                               throws java.sql.SQLException

Specified by:

getValueHolder in interface IDbResultSet

Throws:

java.sql.SQLException

getValueHolder

public IValueHolder<?> getValueHolder(int p_iIdx,
                                      java.lang.String p_strDataTypeAsSerializedQName)
                               throws java.sql.SQLException

Specified by:

getValueHolder in interface IDbResultSet

Throws:

java.sql.SQLException

getValueHolder

public IValueHolder<?> getValueHolder(int p_iIdx,
                                      javax.xml.namespace.QName p_qmnDataType,
                                      IValueHolder<?> p_valueIfNull)
                               throws java.sql.SQLException

Specified by:

getValueHolder in interface IDbResultSet

Throws:

java.sql.SQLException

getValueHolder

public IValueHolder<?> getValueHolder(int p_iIdx,
                                      java.lang.String p_strDataTypeAsSerializedQName,
                                      IValueHolder<?> p_valueIfNull)
                               throws java.sql.SQLException

Specified by:

getValueHolder in interface IDbResultSet

Throws:

java.sql.SQLException

close

public void close()
           throws java.sql.SQLException

Description copied from interface: ICloseable

Close this object.

Specified by:

close in interface IDbResultSet

Specified by:

close in interface ICloseable

Throws:

java.sql.SQLException

value

@Deprecated
public java.lang.Object value(int p_iIdx)
                       throws java.sql.SQLException

Deprecated. Please use getValue(int) or one of the getXxxValue(int) methods instead.

Throws:

java.sql.SQLException - If a database error occurred.

getValue

public java.lang.Object getValue(int p_iIdx)
                          throws java.sql.SQLException

Specified by:

getValue in interface IDbResultSet

Throws:

java.sql.SQLException

getValue

public java.lang.Object getValue(int p_iIdx,
                                 java.lang.Object p_valueIfNull)
                          throws java.sql.SQLException

Specified by:

getValue in interface IDbResultSet

Throws:

java.sql.SQLException

getBooleanValue

public java.lang.Boolean getBooleanValue(int p_iIdx)
                                  throws java.sql.SQLException,
                                         ValueCastException

Specified by:

getBooleanValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getBooleanValue

public java.lang.Boolean getBooleanValue(int p_iIdx,
                                         java.lang.Boolean p_valueIfNull)
                                  throws java.sql.SQLException,
                                         ValueCastException

Specified by:

getBooleanValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getByteValue

public byte getByteValue(int p_iIdx)
                  throws java.sql.SQLException,
                         ValueCastException

Specified by:

getByteValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getByteValue

public java.lang.Byte getByteValue(int p_iIdx,
                                   java.lang.Byte p_valueIfNull)
                            throws java.sql.SQLException,
                                   ValueCastException

Specified by:

getByteValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getShortValue

public java.lang.Short getShortValue(int p_iIdx)
                              throws java.sql.SQLException,
                                     ValueCastException

Specified by:

getShortValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getShortValue

public java.lang.Short getShortValue(int p_iIdx,
                                     java.lang.Short p_valueIfNull)
                              throws java.sql.SQLException,
                                     ValueCastException

Specified by:

getShortValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getIntValue

public java.lang.Integer getIntValue(int p_iIdx)
                              throws java.sql.SQLException,
                                     ValueCastException

Specified by:

getIntValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getIntValue

public java.lang.Integer getIntValue(int p_iIdx,
                                     java.lang.Integer p_valueIfNull)
                              throws java.sql.SQLException,
                                     ValueCastException

Specified by:

getIntValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getLongValue

public java.lang.Long getLongValue(int p_iIdx)
                            throws java.sql.SQLException,
                                   ValueCastException

Specified by:

getLongValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getLongValue

public java.lang.Long getLongValue(int p_iIdx,
                                   java.lang.Long p_valueIfNull)
                            throws java.sql.SQLException,
                                   ValueCastException

Specified by:

getLongValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getFloatValue

public java.lang.Float getFloatValue(int p_iIdx)
                              throws java.sql.SQLException,
                                     ValueCastException

Specified by:

getFloatValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getFloatValue

public java.lang.Float getFloatValue(int p_iIdx,
                                     java.lang.Float p_valueIfNull)
                              throws java.sql.SQLException,
                                     ValueCastException

Specified by:

getFloatValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getDoubleValue

public java.lang.Double getDoubleValue(int p_iIdx)
                                throws java.sql.SQLException,
                                       ValueCastException

Specified by:

getDoubleValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getDoubleValue

public java.lang.Double getDoubleValue(int p_iIdx,
                                       java.lang.Double p_valueIfNull)
                                throws java.sql.SQLException,
                                       ValueCastException

Specified by:

getDoubleValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getBigDecimalValue

public java.math.BigDecimal getBigDecimalValue(int p_iIdx)
                                        throws java.sql.SQLException,
                                               ValueCastException

Specified by:

getBigDecimalValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getBigDecimalValue

public java.math.BigDecimal getBigDecimalValue(int p_iIdx,
                                               java.math.BigDecimal p_valueIfNull)
                                        throws java.sql.SQLException,
                                               ValueCastException

Specified by:

getBigDecimalValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getStringValue

public java.lang.String getStringValue(int p_iIdx)
                                throws java.sql.SQLException,
                                       ValueCastException

Specified by:

getStringValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getStringValue

public java.lang.String getStringValue(int p_iIdx,
                                       java.lang.String p_valueIfNull)
                                throws java.sql.SQLException,
                                       ValueCastException

Specified by:

getStringValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getTimestampValue

public java.sql.Timestamp getTimestampValue(int p_iIdx)
                                     throws java.sql.SQLException,
                                            ValueCastException

Specified by:

getTimestampValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getTimestampValue

public java.sql.Timestamp getTimestampValue(int p_iIdx,
                                            java.util.Calendar p_cal)
                                     throws java.sql.SQLException,
                                            ValueCastException

Specified by:

getTimestampValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getTimestampValue

public java.sql.Timestamp getTimestampValue(int p_iIdx,
                                            java.util.TimeZone p_tz)
                                     throws java.sql.SQLException,
                                            ValueCastException

Specified by:

getTimestampValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getTimestampValue

public java.sql.Timestamp getTimestampValue(int p_iIdx,
                                            java.sql.Timestamp p_valueIfNull)
                                     throws java.sql.SQLException,
                                            ValueCastException

Specified by:

getTimestampValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getTimestampValue

public java.sql.Timestamp getTimestampValue(int p_iIdx,
                                            java.sql.Timestamp p_valueIfNull,
                                            java.util.TimeZone p_tz)
                                     throws java.sql.SQLException,
                                            ValueCastException

Specified by:

getTimestampValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getTimestampValue

public java.sql.Timestamp getTimestampValue(int p_iIdx,
                                            java.sql.Timestamp p_valueIfNull,
                                            java.util.Calendar p_cal)
                                     throws java.sql.SQLException,
                                            ValueCastException

Specified by:

getTimestampValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getDateValue

public java.util.Date getDateValue(int p_iIdx)
                            throws java.sql.SQLException,
                                   ValueCastException

Specified by:

getDateValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getDateValue

public java.util.Date getDateValue(int p_iIdx,
                                   java.util.Calendar p_cal)
                            throws java.sql.SQLException,
                                   ValueCastException

Specified by:

getDateValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getDateValue

public java.util.Date getDateValue(int p_iIdx,
                                   java.util.TimeZone p_tz)
                            throws java.sql.SQLException,
                                   ValueCastException

Specified by:

getDateValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getDateValue

public java.util.Date getDateValue(int p_iIdx,
                                   java.util.Date p_valueIfNull)
                            throws java.sql.SQLException,
                                   ValueCastException

Specified by:

getDateValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getDateValue

public java.util.Date getDateValue(int p_iIdx,
                                   java.util.Date p_valueIfNull,
                                   java.util.TimeZone p_tz)
                            throws java.sql.SQLException,
                                   ValueCastException

Specified by:

getDateValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getDateValue

public java.util.Date getDateValue(int p_iIdx,
                                   java.util.Date p_valueIfNull,
                                   java.util.Calendar p_cal)
                            throws java.sql.SQLException,
                                   ValueCastException

Specified by:

getDateValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getTimeValue

public java.util.Date getTimeValue(int p_iIdx)
                            throws java.sql.SQLException,
                                   ValueCastException

Specified by:

getTimeValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getTimeValue

public java.util.Date getTimeValue(int p_iIdx,
                                   java.util.Calendar p_cal)
                            throws java.sql.SQLException,
                                   ValueCastException

Specified by:

getTimeValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getTimeValue

public java.util.Date getTimeValue(int p_iIdx,
                                   java.util.TimeZone p_tz)
                            throws java.sql.SQLException,
                                   ValueCastException

Specified by:

getTimeValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getTimeValue

public java.util.Date getTimeValue(int p_iIdx,
                                   java.util.Date p_valueIfNull)
                            throws java.sql.SQLException,
                                   ValueCastException

Specified by:

getTimeValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getTimeValue

public java.util.Date getTimeValue(int p_iIdx,
                                   java.util.Date p_valueIfNull,
                                   java.util.TimeZone p_tz)
                            throws java.sql.SQLException,
                                   ValueCastException

Specified by:

getTimeValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

getTimeValue

public java.util.Date getTimeValue(int p_iIdx,
                                   java.util.Date p_valueIfNull,
                                   java.util.Calendar p_cal)
                            throws java.sql.SQLException,
                                   ValueCastException

Specified by:

getTimeValue in interface IDbResultSet

Throws:

java.sql.SQLException

ValueCastException

iterator

public java.util.Iterator<IDbRow> iterator()

Specified by:

iterator in interface java.lang.Iterable<IDbRow>

findAll

public java.util.List<?> findAll(groovy.lang.Closure p_closure)

Calls the given closure for every row in the result set and returns a list of rows for which the closure is valid.

Parameters:

p_closure - The closure that's being called.

Returns:

A list of rows the closure is valid for.

Throws:

java.lang.UnsupportedOperationException - - If the result set does not provide disconnected rows.

grep

public java.util.Collection<?> grep(java.lang.Object p_filter)

This method is not supported

.

Throws:

java.lang.UnsupportedOperationException