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

java.lang.Object
  extended by de.uplanet.lucy.server.util.db.DbResultSet
All Implemented Interfaces:
de.uplanet.util.ICloseable, java.lang.Iterable<IDbRow>

public final class DbResultSet
extends java.lang.Object
implements de.uplanet.util.ICloseable, java.lang.Iterable<IDbRow>

Version:
$Revision: 81036 $

Method Summary
 void close()
           
 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.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.sql.Timestamp p_valueIfNull)
           
 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
Throws:
java.sql.SQLException

wasNull

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

getValueHolder

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

getValueHolder

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

getValueHolder

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

getValueHolder

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

getValueHolder

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

iterator

public java.util.Iterator<IDbRow> iterator()
Specified by:
iterator in interface java.lang.Iterable<IDbRow>

close

public void close()
           throws java.sql.SQLException
Specified by:
close in interface de.uplanet.util.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
Throws:
java.sql.SQLException

getValue

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

getBooleanValue

public java.lang.Boolean getBooleanValue(int p_iIdx)
                                  throws java.sql.SQLException,
                                         de.uplanet.lucy.server.util.db.ValueCastException
Throws:
java.sql.SQLException
de.uplanet.lucy.server.util.db.ValueCastException

getBooleanValue

public java.lang.Boolean getBooleanValue(int p_iIdx,
                                         java.lang.Boolean p_valueIfNull)
                                  throws java.sql.SQLException,
                                         de.uplanet.lucy.server.util.db.ValueCastException
Throws:
java.sql.SQLException
de.uplanet.lucy.server.util.db.ValueCastException

getByteValue

public byte getByteValue(int p_iIdx)
                  throws java.sql.SQLException,
                         de.uplanet.lucy.server.util.db.ValueCastException
Throws:
java.sql.SQLException
de.uplanet.lucy.server.util.db.ValueCastException

getByteValue

public java.lang.Byte getByteValue(int p_iIdx,
                                   java.lang.Byte p_valueIfNull)
                            throws java.sql.SQLException,
                                   de.uplanet.lucy.server.util.db.ValueCastException
Throws:
java.sql.SQLException
de.uplanet.lucy.server.util.db.ValueCastException

getShortValue

public java.lang.Short getShortValue(int p_iIdx)
                              throws java.sql.SQLException,
                                     de.uplanet.lucy.server.util.db.ValueCastException
Throws:
java.sql.SQLException
de.uplanet.lucy.server.util.db.ValueCastException

getShortValue

public java.lang.Short getShortValue(int p_iIdx,
                                     java.lang.Short p_valueIfNull)
                              throws java.sql.SQLException,
                                     de.uplanet.lucy.server.util.db.ValueCastException
Throws:
java.sql.SQLException
de.uplanet.lucy.server.util.db.ValueCastException

getIntValue

public java.lang.Integer getIntValue(int p_iIdx)
                              throws java.sql.SQLException,
                                     de.uplanet.lucy.server.util.db.ValueCastException
Throws:
java.sql.SQLException
de.uplanet.lucy.server.util.db.ValueCastException

getIntValue

public java.lang.Integer getIntValue(int p_iIdx,
                                     java.lang.Integer p_valueIfNull)
                              throws java.sql.SQLException,
                                     de.uplanet.lucy.server.util.db.ValueCastException
Throws:
java.sql.SQLException
de.uplanet.lucy.server.util.db.ValueCastException

getLongValue

public java.lang.Long getLongValue(int p_iIdx)
                            throws java.sql.SQLException,
                                   de.uplanet.lucy.server.util.db.ValueCastException
Throws:
java.sql.SQLException
de.uplanet.lucy.server.util.db.ValueCastException

getLongValue

public java.lang.Long getLongValue(int p_iIdx,
                                   java.lang.Long p_valueIfNull)
                            throws java.sql.SQLException,
                                   de.uplanet.lucy.server.util.db.ValueCastException
Throws:
java.sql.SQLException
de.uplanet.lucy.server.util.db.ValueCastException

getFloatValue

public java.lang.Float getFloatValue(int p_iIdx)
                              throws java.sql.SQLException,
                                     de.uplanet.lucy.server.util.db.ValueCastException
Throws:
java.sql.SQLException
de.uplanet.lucy.server.util.db.ValueCastException

getFloatValue

public java.lang.Float getFloatValue(int p_iIdx,
                                     java.lang.Float p_valueIfNull)
                              throws java.sql.SQLException,
                                     de.uplanet.lucy.server.util.db.ValueCastException
Throws:
java.sql.SQLException
de.uplanet.lucy.server.util.db.ValueCastException

getDoubleValue

public java.lang.Double getDoubleValue(int p_iIdx)
                                throws java.sql.SQLException,
                                       de.uplanet.lucy.server.util.db.ValueCastException
Throws:
java.sql.SQLException
de.uplanet.lucy.server.util.db.ValueCastException

getDoubleValue

public java.lang.Double getDoubleValue(int p_iIdx,
                                       java.lang.Double p_valueIfNull)
                                throws java.sql.SQLException,
                                       de.uplanet.lucy.server.util.db.ValueCastException
Throws:
java.sql.SQLException
de.uplanet.lucy.server.util.db.ValueCastException

getBigDecimalValue

public java.math.BigDecimal getBigDecimalValue(int p_iIdx)
                                        throws java.sql.SQLException,
                                               de.uplanet.lucy.server.util.db.ValueCastException
Throws:
java.sql.SQLException
de.uplanet.lucy.server.util.db.ValueCastException

getBigDecimalValue

public java.math.BigDecimal getBigDecimalValue(int p_iIdx,
                                               java.math.BigDecimal p_valueIfNull)
                                        throws java.sql.SQLException,
                                               de.uplanet.lucy.server.util.db.ValueCastException
Throws:
java.sql.SQLException
de.uplanet.lucy.server.util.db.ValueCastException

getStringValue

public java.lang.String getStringValue(int p_iIdx)
                                throws java.sql.SQLException,
                                       de.uplanet.lucy.server.util.db.ValueCastException
Throws:
java.sql.SQLException
de.uplanet.lucy.server.util.db.ValueCastException

getStringValue

public java.lang.String getStringValue(int p_iIdx,
                                       java.lang.String p_valueIfNull)
                                throws java.sql.SQLException,
                                       de.uplanet.lucy.server.util.db.ValueCastException
Throws:
java.sql.SQLException
de.uplanet.lucy.server.util.db.ValueCastException

getTimestampValue

public java.sql.Timestamp getTimestampValue(int p_iIdx)
                                     throws java.sql.SQLException,
                                            de.uplanet.lucy.server.util.db.ValueCastException
Throws:
java.sql.SQLException
de.uplanet.lucy.server.util.db.ValueCastException

getTimestampValue

public java.sql.Timestamp getTimestampValue(int p_iIdx,
                                            java.sql.Timestamp p_valueIfNull)
                                     throws java.sql.SQLException,
                                            de.uplanet.lucy.server.util.db.ValueCastException
Throws:
java.sql.SQLException
de.uplanet.lucy.server.util.db.ValueCastException

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


Last updated: 2011-01-27
Copyright 2000-2010 United Planet. All Rights Reserved.