Package de.uplanet.lucy.server.util.db
Class DbResultSet
java.lang.Object
de.uplanet.lucy.server.util.db.DbResultSet
- All Implemented Interfaces:
IDbResultSet
,IValueAccess
,IValueHolderAccess
,de.uplanet.util.ICloseable
,AutoCloseable
,Iterable<IDbRow>
-
Method Summary
Modifier and TypeMethodDescriptionvoid
close()
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.getBigDecimalValue
(int p_iIdx) Get a decimal number value.getBigDecimalValue
(int p_iIdx, BigDecimal p_valueIfNull) Get a decimal number value.getBooleanValue
(int p_iIdx) Get a boolean value.getBooleanValue
(int p_iIdx, Boolean p_valueIfNull) Get a boolean value.byte
getByteValue
(int p_iIdx) Get a byte value.getByteValue
(int p_iIdx, Byte p_valueIfNull) Get a byte value.getDateValue
(int p_iIdx) Get a date value.getDateValue
(int p_iIdx, Calendar p_cal) getDateValue
(int p_iIdx, Date p_valueIfNull) Get a date value.getDateValue
(int p_iIdx, Date p_valueIfNull, Calendar p_cal) getDateValue
(int p_iIdx, Date p_valueIfNull, TimeZone p_tz) getDateValue
(int p_iIdx, TimeZone p_tz) Create a list of disconnected rows from this result set.getDoubleValue
(int p_iIdx) Get a double value.getDoubleValue
(int p_iIdx, Double p_valueIfNull) Get a double precision float value.getFloatValue
(int p_iIdx) Get a single precision float value.getFloatValue
(int p_iIdx, Float p_valueIfNull) Get a single precision float value.getIntValue
(int p_iIdx) Get an integer value.getIntValue
(int p_iIdx, Integer p_valueIfNull) Get an integer value.getLongValue
(int p_iIdx) Get a long value.getLongValue
(int p_iIdx, Long p_valueIfNull) Get a long value.int
Get the number of rows read so far.getShortValue
(int p_iIdx) Get a short value.getShortValue
(int p_iIdx, Short p_valueIfNull) Get a short value.getStringValue
(int p_iIdx) Get a string value.getStringValue
(int p_iIdx, String p_valueIfNull) Get a string value.getTimestampValue
(int p_iIdx) Get a timestamp value.getTimestampValue
(int p_iIdx, Timestamp p_valueIfNull) Get a timestamp value.getTimestampValue
(int p_iIdx, Timestamp p_valueIfNull, Calendar p_cal) getTimestampValue
(int p_iIdx, Timestamp p_valueIfNull, TimeZone p_tz) getTimestampValue
(int p_iIdx, Calendar p_cal) getTimestampValue
(int p_iIdx, TimeZone p_tz) getTimeValue
(int p_iIdx) Get a time value.getTimeValue
(int p_iIdx, Calendar p_cal) getTimeValue
(int p_iIdx, Date p_valueIfNull) Get a time value.getTimeValue
(int p_iIdx, Date p_valueIfNull, Calendar p_cal) getTimeValue
(int p_iIdx, Date p_valueIfNull, TimeZone p_tz) getTimeValue
(int p_iIdx, TimeZone p_tz) getValue
(int p_iIdx) Get a value.Get a value.IValueHolder<?>
getValueHolder
(int p_iIdx) IValueHolder<?>
getValueHolder
(int p_iIdx, String p_strDataTypeAsSerializedQName) IValueHolder<?>
getValueHolder
(int p_iIdx, String p_strDataTypeAsSerializedQName, IValueHolder<?> p_valueIfNull) IValueHolder<?>
getValueHolder
(int p_iIdx, QName p_qmnDataType) IValueHolder<?>
getValueHolder
(int p_iIdx, QName p_qmnDataType, IValueHolder<?> p_valueIfNull) Collection<?>
This method is not supportediterator()
boolean
next()
boolean
wasNull
(int p_iIdx) Check if the value in the given column wasnull
.Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
Methods inherited from interface java.lang.Iterable
forEach, spliterator
-
Method Details
-
getRowCount
public int getRowCount()Get the number of rows read so far.- Returns:
- The number of rows read so far.
-
next
- Specified by:
next
in interfaceIDbResultSet
- Throws:
SQLException
-
wasNull
Description copied from interface:IValueAccess
Check if the value in the given column wasnull
.- Specified by:
wasNull
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.- Returns:
true
if the value wasnull
, orfalse
otherwise.- Throws:
SQLException
- If a database error occurred.
-
getValueHolder
- Specified by:
getValueHolder
in interfaceIValueHolderAccess
- Throws:
SQLException
-
getValueHolder
- Specified by:
getValueHolder
in interfaceIValueHolderAccess
- Throws:
SQLException
-
getValueHolder
public IValueHolder<?> getValueHolder(int p_iIdx, String p_strDataTypeAsSerializedQName) throws SQLException - Specified by:
getValueHolder
in interfaceIValueHolderAccess
- Throws:
SQLException
-
getValueHolder
public IValueHolder<?> getValueHolder(int p_iIdx, QName p_qmnDataType, IValueHolder<?> p_valueIfNull) throws SQLException - Specified by:
getValueHolder
in interfaceIValueHolderAccess
- Throws:
SQLException
-
getValueHolder
public IValueHolder<?> getValueHolder(int p_iIdx, String p_strDataTypeAsSerializedQName, IValueHolder<?> p_valueIfNull) throws SQLException - Specified by:
getValueHolder
in interfaceIValueHolderAccess
- Throws:
SQLException
-
close
- Specified by:
close
in interfaceAutoCloseable
- Specified by:
close
in interfaceIDbResultSet
- Throws:
SQLException
-
getValue
Description copied from interface:IValueAccess
Get a value. Note: The use of this method is discouraged. Use a method that returns a specified type instead.- Specified by:
getValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.- Returns:
- The value.
- Throws:
SQLException
- If a database error occurred.
-
getValue
Description copied from interface:IValueAccess
Get a value. Note: The use of this method is discouraged. Use a method that returns a specified type instead.- Specified by:
getValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.p_valueIfNull
- The value to be returned if the database value wasNULL
.- Returns:
- The value, or
p_valueIfNull
. - Throws:
SQLException
- If a database error occurred.
-
getBooleanValue
Description copied from interface:IValueAccess
Get a boolean value.- Specified by:
getBooleanValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.- Returns:
- A boolean value, or
null
. - Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to boolean.
-
getBooleanValue
public Boolean getBooleanValue(int p_iIdx, Boolean p_valueIfNull) throws SQLException, ValueCastException Description copied from interface:IValueAccess
Get a boolean value.- Specified by:
getBooleanValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.p_valueIfNull
- The value to be returned if the database value wasNULL
.- Returns:
- A boolean value, or
p_valueIfNull
. - Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to boolean.
-
getByteValue
Description copied from interface:IValueAccess
Get a byte value.- Specified by:
getByteValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.- Returns:
- A byte value, or
null
. - Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to byte.
-
getByteValue
Description copied from interface:IValueAccess
Get a byte value.- Specified by:
getByteValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.p_valueIfNull
- The value to be returned if the database value wasNULL
.- Returns:
- A byte value, or
p_valueIfNull
. - Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to byte.
-
getShortValue
Description copied from interface:IValueAccess
Get a short value.- Specified by:
getShortValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.- Returns:
- A short value, or
null
. - Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to short.
-
getShortValue
Description copied from interface:IValueAccess
Get a short value.- Specified by:
getShortValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.p_valueIfNull
- The value to be returned if the database value wasNULL
.- Returns:
- A short value, or
p_valueIfNull
. - Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to short.
-
getIntValue
Description copied from interface:IValueAccess
Get an integer value.- Specified by:
getIntValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.- Returns:
- An integer value, or
null
. - Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to integer.
-
getIntValue
public Integer getIntValue(int p_iIdx, Integer p_valueIfNull) throws SQLException, ValueCastException Description copied from interface:IValueAccess
Get an integer value.- Specified by:
getIntValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.p_valueIfNull
- The value to be returned if the database value wasNULL
.- Returns:
- An integer value, or
p_valueIfNull
. - Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to integer.
-
getLongValue
Description copied from interface:IValueAccess
Get a long value.- Specified by:
getLongValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.- Returns:
- A long value, or
null
. - Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to long.
-
getLongValue
Description copied from interface:IValueAccess
Get a long value.- Specified by:
getLongValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.p_valueIfNull
- The value to be returned if the database value wasNULL
.- Returns:
- A long value, or
p_valueIfNull
. - Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to long.
-
getFloatValue
Description copied from interface:IValueAccess
Get a single precision float value.- Specified by:
getFloatValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.- Returns:
- A float value, or
null
. - Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to float.
-
getFloatValue
Description copied from interface:IValueAccess
Get a single precision float value.- Specified by:
getFloatValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.p_valueIfNull
- The value to be returned if the database value wasNULL
.- Returns:
- A float value, or
p_valueIfNull
. - Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to float.
-
getDoubleValue
Description copied from interface:IValueAccess
Get a double value.- Specified by:
getDoubleValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.- Returns:
- A double value, or
null
. - Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to double.
-
getDoubleValue
public Double getDoubleValue(int p_iIdx, Double p_valueIfNull) throws SQLException, ValueCastException Description copied from interface:IValueAccess
Get a double precision float value.- Specified by:
getDoubleValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.p_valueIfNull
- The value to be returned if the database value wasNULL
.- Returns:
- A double value, or
p_valueIfNull
. - Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to double.
-
getBigDecimalValue
Description copied from interface:IValueAccess
Get a decimal number value.- Specified by:
getBigDecimalValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.- Returns:
- A BigDecimal value, or
null
. - Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to BigDecimal.
-
getBigDecimalValue
public BigDecimal getBigDecimalValue(int p_iIdx, BigDecimal p_valueIfNull) throws SQLException, ValueCastException Description copied from interface:IValueAccess
Get a decimal number value.- Specified by:
getBigDecimalValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.p_valueIfNull
- The value to be returned if the database value wasNULL
.- Returns:
- A BigDecimal value, or
p_valueIfNull
. - Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to BigDecimal.
-
getStringValue
Description copied from interface:IValueAccess
Get a string value.- Specified by:
getStringValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.- Returns:
- A string value, or
null
. - Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to a string.
-
getStringValue
public String getStringValue(int p_iIdx, String p_valueIfNull) throws SQLException, ValueCastException Description copied from interface:IValueAccess
Get a string value.- Specified by:
getStringValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.p_valueIfNull
- The value to be returned if the database value wasNULL
.- Returns:
- A string value, or
p_valueIfNull
. - Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to string.
-
getTimestampValue
Description copied from interface:IValueAccess
Get a timestamp value.- Specified by:
getTimestampValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.- Returns:
- A timestamp value, or
null
. - Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to a timestamp.
-
getTimestampValue
public Timestamp getTimestampValue(int p_iIdx, Calendar p_cal) throws SQLException, ValueCastException - Specified by:
getTimestampValue
in interfaceIDbResultSet
- Throws:
SQLException
ValueCastException
-
getTimestampValue
public Timestamp getTimestampValue(int p_iIdx, TimeZone p_tz) throws SQLException, ValueCastException - Specified by:
getTimestampValue
in interfaceIDbResultSet
- Throws:
SQLException
ValueCastException
-
getTimestampValue
public Timestamp getTimestampValue(int p_iIdx, Timestamp p_valueIfNull) throws SQLException, ValueCastException Description copied from interface:IValueAccess
Get a timestamp value.- Specified by:
getTimestampValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.p_valueIfNull
- The value to be returned if the database value wasNULL
.- Returns:
- A timestamp value, or
p_valueIfNull
. - Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to timestamp.
-
getTimestampValue
public Timestamp getTimestampValue(int p_iIdx, Timestamp p_valueIfNull, TimeZone p_tz) throws SQLException, ValueCastException - Specified by:
getTimestampValue
in interfaceIDbResultSet
- Throws:
SQLException
ValueCastException
-
getTimestampValue
public Timestamp getTimestampValue(int p_iIdx, Timestamp p_valueIfNull, Calendar p_cal) throws SQLException, ValueCastException - Specified by:
getTimestampValue
in interfaceIDbResultSet
- Throws:
SQLException
ValueCastException
-
getDateValue
Description copied from interface:IValueAccess
Get a date value.- Specified by:
getDateValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.- Returns:
- A date value, or
null
. - Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to date.
-
getDateValue
- Specified by:
getDateValue
in interfaceIDbResultSet
- Throws:
SQLException
ValueCastException
-
getDateValue
- Specified by:
getDateValue
in interfaceIDbResultSet
- Throws:
SQLException
ValueCastException
-
getDateValue
Description copied from interface:IValueAccess
Get a date value.- Specified by:
getDateValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.p_valueIfNull
- The value to be returned if the database value wasNULL
.- Returns:
- A date value, or
p_valueIfNull
. - Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to date.
-
getDateValue
public Date getDateValue(int p_iIdx, Date p_valueIfNull, TimeZone p_tz) throws SQLException, ValueCastException - Specified by:
getDateValue
in interfaceIDbResultSet
- Throws:
SQLException
ValueCastException
-
getDateValue
public Date getDateValue(int p_iIdx, Date p_valueIfNull, Calendar p_cal) throws SQLException, ValueCastException - Specified by:
getDateValue
in interfaceIDbResultSet
- Throws:
SQLException
ValueCastException
-
getTimeValue
Description copied from interface:IValueAccess
Get a time value.- Specified by:
getTimeValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.- Returns:
- A time value, or
null
. - Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to time.
-
getTimeValue
- Specified by:
getTimeValue
in interfaceIDbResultSet
- Throws:
SQLException
ValueCastException
-
getTimeValue
- Specified by:
getTimeValue
in interfaceIDbResultSet
- Throws:
SQLException
ValueCastException
-
getTimeValue
Description copied from interface:IValueAccess
Get a time value.- Specified by:
getTimeValue
in interfaceIValueAccess
- Parameters:
p_iIdx
- The 1-based column index.p_valueIfNull
- The value to be returned if the database value wasNULL
.- Returns:
- A time value, or
p_valueIfNull
. - Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to time.
-
getTimeValue
public Date getTimeValue(int p_iIdx, Date p_valueIfNull, TimeZone p_tz) throws SQLException, ValueCastException - Specified by:
getTimeValue
in interfaceIDbResultSet
- Throws:
SQLException
ValueCastException
-
getTimeValue
public Date getTimeValue(int p_iIdx, Date p_valueIfNull, Calendar p_cal) throws SQLException, ValueCastException - Specified by:
getTimeValue
in interfaceIDbResultSet
- Throws:
SQLException
ValueCastException
-
getDisconnectedRowList
Create a list of disconnected rows from this result set.Note:
- The result set data are at once fetched into memory so that calling this method may result in excessive memory consumption.
- After this method has been called, subsequent iterations over this result set will give no result. However anew call to this method will return the previous returned rows.
- Rows that were consumed in previous iterations over this result set will not be present in this list.
- Returns:
- A list of disconnected rows.
-
iterator
-
findAll
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:
UnsupportedOperationException
- - If the result set does not provide disconnected rows.
-
grep
This method is not supported.
- Throws:
UnsupportedOperationException
-