R
- The record type contained in this resultpublic interface Result<R extends Record> extends FieldProvider, List<R>, Attachable
SelectQuery
ResultQuery.getResult()
Modifier and Type | Method and Description |
---|---|
Document |
exportXML()
Deprecated.
- 2.0.5 - Use
intoXML() instead |
String |
format()
Get a simple formatted representation of this result.
|
String |
format(int maxRecords)
Get a simple formatted representation of this result.
|
String |
formatCSV()
Get a simple formatted representation of this result as CSV.
|
String |
formatCSV(char delimiter)
Get a simple formatted representation of this result as CSV.
|
String |
formatCSV(char delimiter,
String nullString)
Get a simple formatted representation of this result as CSV.
|
String |
formatHTML()
Get a simple formatted representation of this result as HTML.
|
String |
formatJSON()
Get a simple formatted representation of this result as a JSON array of
array.
|
String |
formatXML()
Get this result formatted as XML
|
<T> T |
getValue(int index,
Field<T> field)
Convenience method to fetch a value at a given position in the result.
|
<T> T |
getValue(int index,
Field<T> field,
T defaultValue)
Convenience method to fetch a value at a given position in the result.
|
Object |
getValue(int index,
int fieldIndex)
Convenience method to fetch a value at a given position in the result.
|
Object |
getValue(int index,
int fieldIndex,
Object defaultValue)
Convenience method to fetch a value at a given position in the result.
|
Object |
getValue(int index,
String fieldName)
Convenience method to fetch a value at a given position in the result.
|
Object |
getValue(int index,
String fieldName,
Object defaultValue)
Convenience method to fetch a value at a given position in the result.
|
<A extends ArrayRecord<T>,T> |
getValueAsArray(int index,
Field<A> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse
|
<A extends ArrayRecord<T>,T> |
getValueAsArray(int index,
Field<A> field,
T[] defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse
|
BigDecimal |
getValueAsBigDecimal(int index,
Field<?> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
BigDecimal |
getValueAsBigDecimal(int index,
Field<?> field,
BigDecimal defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
BigDecimal |
getValueAsBigDecimal(int index,
int fieldIndex)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
BigDecimal |
getValueAsBigDecimal(int index,
int fieldIndex,
BigDecimal defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
BigDecimal |
getValueAsBigDecimal(int index,
String fieldName)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
BigDecimal |
getValueAsBigDecimal(int index,
String fieldName,
BigDecimal defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
BigInteger |
getValueAsBigInteger(int index,
Field<?> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
BigInteger |
getValueAsBigInteger(int index,
Field<?> field,
BigInteger defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
BigInteger |
getValueAsBigInteger(int index,
int fieldIndex)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
BigInteger |
getValueAsBigInteger(int index,
int fieldIndex,
BigInteger defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
BigInteger |
getValueAsBigInteger(int index,
String fieldName)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
BigInteger |
getValueAsBigInteger(int index,
String fieldName,
BigInteger defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
Boolean |
getValueAsBoolean(int index,
Field<?> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
Boolean |
getValueAsBoolean(int index,
Field<?> field,
Boolean defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
Boolean |
getValueAsBoolean(int index,
int fieldIndex)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
Boolean |
getValueAsBoolean(int index,
int fieldIndex,
Boolean defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
Boolean |
getValueAsBoolean(int index,
String fieldName)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
Boolean |
getValueAsBoolean(int index,
String fieldName,
Boolean defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
Byte |
getValueAsByte(int index,
Field<?> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
Byte |
getValueAsByte(int index,
Field<?> field,
Byte defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
Byte |
getValueAsByte(int index,
int fieldIndex)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
Byte |
getValueAsByte(int index,
int fieldIndex,
Byte defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
Byte |
getValueAsByte(int index,
String fieldName)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
Byte |
getValueAsByte(int index,
String fieldName,
Byte defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
Date |
getValueAsDate(int index,
Field<?> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
Date |
getValueAsDate(int index,
Field<?> field,
Date defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
Date |
getValueAsDate(int index,
int fieldIndex)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
Date |
getValueAsDate(int index,
int fieldIndex,
Date defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
Date |
getValueAsDate(int index,
String fieldName)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
Date |
getValueAsDate(int index,
String fieldName,
Date defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
Double |
getValueAsDouble(int index,
Field<?> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
Double |
getValueAsDouble(int index,
Field<?> field,
Double defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
Double |
getValueAsDouble(int index,
int fieldIndex)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
Double |
getValueAsDouble(int index,
int fieldIndex,
Double defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
Double |
getValueAsDouble(int index,
String fieldName)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
Double |
getValueAsDouble(int index,
String fieldName,
Double defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
Float |
getValueAsFloat(int index,
Field<?> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
Float |
getValueAsFloat(int index,
Field<?> field,
Float defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
Float |
getValueAsFloat(int index,
int fieldIndex)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
Float |
getValueAsFloat(int index,
int fieldIndex,
Float defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
Float |
getValueAsFloat(int index,
String fieldName)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
Float |
getValueAsFloat(int index,
String fieldName,
Float defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
Integer |
getValueAsInteger(int index,
Field<?> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
Integer |
getValueAsInteger(int index,
Field<?> field,
Integer defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
Integer |
getValueAsInteger(int index,
int fieldIndex)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
Integer |
getValueAsInteger(int index,
int fieldIndex,
Integer defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
Integer |
getValueAsInteger(int index,
String fieldName)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
Integer |
getValueAsInteger(int index,
String fieldName,
Integer defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
Long |
getValueAsLong(int index,
Field<?> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
Long |
getValueAsLong(int index,
Field<?> field,
Long defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
Long |
getValueAsLong(int index,
int fieldIndex)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
Long |
getValueAsLong(int index,
int fieldIndex,
Long defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
Long |
getValueAsLong(int index,
String fieldName)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
Long |
getValueAsLong(int index,
String fieldName,
Long defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
Short |
getValueAsShort(int index,
Field<?> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
Short |
getValueAsShort(int index,
Field<?> field,
Short defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
Short |
getValueAsShort(int index,
int fieldIndex)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
Short |
getValueAsShort(int index,
int fieldIndex,
Short defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
Short |
getValueAsShort(int index,
String fieldName)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
Short |
getValueAsShort(int index,
String fieldName,
Short defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
String |
getValueAsString(int index,
Field<?> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
String |
getValueAsString(int index,
Field<?> field,
String defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
String |
getValueAsString(int index,
int fieldIndex)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
String |
getValueAsString(int index,
int fieldIndex,
String defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
String |
getValueAsString(int index,
String fieldName)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
String |
getValueAsString(int index,
String fieldName,
String defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
Time |
getValueAsTime(int index,
Field<?> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
Time |
getValueAsTime(int index,
Field<?> field,
Time defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
Time |
getValueAsTime(int index,
int fieldIndex)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
Time |
getValueAsTime(int index,
int fieldIndex,
Time defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
Time |
getValueAsTime(int index,
String fieldName)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
Time |
getValueAsTime(int index,
String fieldName,
Time defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
Timestamp |
getValueAsTimestamp(int index,
Field<?> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
Timestamp |
getValueAsTimestamp(int index,
Field<?> field,
Timestamp defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(Field, Class) instead. |
Timestamp |
getValueAsTimestamp(int index,
int fieldIndex)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
Timestamp |
getValueAsTimestamp(int index,
int fieldIndex,
Timestamp defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(int, Class)
instead. |
Timestamp |
getValueAsTimestamp(int index,
String fieldName)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
Timestamp |
getValueAsTimestamp(int index,
String fieldName,
Timestamp defaultValue)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
Record.getValue(String, Class) instead. |
<T> List<T> |
getValues(Field<?> field,
Class<? extends T> type)
Convenience method to fetch all values for a given field.
|
<T> List<T> |
getValues(Field<T> field)
Convenience method to fetch all values for a given field.
|
<T,U> List<U> |
getValues(Field<T> field,
Converter<? super T,U> converter)
Convenience method to fetch all values for a given field.
|
List<?> |
getValues(int fieldIndex)
Convenience method to fetch all values for a given field.
|
<T> List<T> |
getValues(int fieldIndex,
Class<? extends T> type)
Convenience method to fetch all values for a given field.
|
<U> List<U> |
getValues(int fieldIndex,
Converter<?,U> converter)
Convenience method to fetch all values for a given field.
|
List<?> |
getValues(String fieldName)
Convenience method to fetch all values for a given field.
|
<T> List<T> |
getValues(String fieldName,
Class<? extends T> type)
Convenience method to fetch all values for a given field.
|
<U> List<U> |
getValues(String fieldName,
Converter<?,U> converter)
Convenience method to fetch all values for a given field.
|
List<BigDecimal> |
getValuesAsBigDecimal(Field<?> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(Field, Class)
instead. |
List<BigDecimal> |
getValuesAsBigDecimal(int fieldIndex)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(int, Class)
instead. |
List<BigDecimal> |
getValuesAsBigDecimal(String fieldName)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(String, Class)
instead. |
List<BigInteger> |
getValuesAsBigInteger(Field<?> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(Field, Class)
instead. |
List<BigInteger> |
getValuesAsBigInteger(int fieldIndex)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(int, Class)
instead. |
List<BigInteger> |
getValuesAsBigInteger(String fieldName)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(String, Class)
instead. |
List<Byte> |
getValuesAsByte(Field<?> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(Field, Class)
instead. |
List<Byte> |
getValuesAsByte(int fieldIndex)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(int, Class)
instead. |
List<Byte> |
getValuesAsByte(String fieldName)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(String, Class)
instead. |
List<Date> |
getValuesAsDate(Field<?> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(Field, Class)
instead. |
List<Date> |
getValuesAsDate(int fieldIndex)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(int, Class)
instead. |
List<Date> |
getValuesAsDate(String fieldName)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(String, Class)
instead. |
List<Double> |
getValuesAsDouble(Field<?> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(Field, Class)
instead. |
List<Double> |
getValuesAsDouble(int fieldIndex)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(int, Class)
instead. |
List<Double> |
getValuesAsDouble(String fieldName)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(String, Class)
instead. |
List<Float> |
getValuesAsFloat(Field<?> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(Field, Class)
instead. |
List<Float> |
getValuesAsFloat(int fieldIndex)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(int, Class)
instead. |
List<Float> |
getValuesAsFloat(String fieldName)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(String, Class)
instead. |
List<Integer> |
getValuesAsInteger(Field<?> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(Field, Class)
instead. |
List<Integer> |
getValuesAsInteger(int fieldIndex)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(int, Class)
instead. |
List<Integer> |
getValuesAsInteger(String fieldName)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(String, Class)
instead. |
List<Long> |
getValuesAsLong(Field<?> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(Field, Class)
instead. |
List<Long> |
getValuesAsLong(int fieldIndex)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(int, Class)
instead. |
List<Long> |
getValuesAsLong(String fieldName)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(String, Class)
instead. |
List<Short> |
getValuesAsShort(Field<?> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(Field, Class)
instead. |
List<Short> |
getValuesAsShort(int fieldIndex)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(int, Class)
instead. |
List<Short> |
getValuesAsShort(String fieldName)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(String, Class)
instead. |
List<String> |
getValuesAsString(Field<?> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(Field, Class)
instead. |
List<String> |
getValuesAsString(int fieldIndex)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(int, Class)
instead. |
List<String> |
getValuesAsString(String fieldName)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(String, Class)
instead. |
List<Time> |
getValuesAsTime(Field<?> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(Field, Class)
instead. |
List<Time> |
getValuesAsTime(int fieldIndex)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(int, Class)
instead. |
List<Time> |
getValuesAsTime(String fieldName)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(String, Class)
instead. |
List<Timestamp> |
getValuesAsTimestamp(Field<?> field)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(Field, Class)
instead. |
List<Timestamp> |
getValuesAsTimestamp(int fieldIndex)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(int, Class)
instead. |
List<Timestamp> |
getValuesAsTimestamp(String fieldName)
Deprecated.
- 2.6.0 [#1839] - These methods will be removed in the
future. Do not reuse. Use
getValues(String, Class)
instead. |
<E> List<E> |
into(Class<? extends E> type)
Map resulting records onto a custom type.
|
<H extends RecordHandler<R>> |
into(H handler)
Map results into a custom handler callback
|
<Z extends Record> |
into(Table<Z> table)
Map resulting records onto a custom record.
|
Object[][] |
intoArray()
Convert this result into an array of arrays
The resulting array has the same number of first-dimension elements as
this result has records.
|
<T> T[] |
intoArray(Field<?> field,
Class<? extends T> type)
Return all values for a field from the result.
|
<T> T[] |
intoArray(Field<T> field)
Return all values for a field from the result.
|
<T,U> U[] |
intoArray(Field<T> field,
Converter<? super T,U> converter)
Return all values for a field from the result.
|
Object[] |
intoArray(int fieldIndex)
Return all values for a field index from the result.
|
<T> T[] |
intoArray(int fieldIndex,
Class<? extends T> type)
Return all values for a field index from the result.
|
<U> U[] |
intoArray(int fieldIndex,
Converter<?,U> converter)
Return all values for a field index from the result.
|
Object[] |
intoArray(String fieldName)
Return all values for a field name from the result.
|
<T> T[] |
intoArray(String fieldName,
Class<? extends T> type)
Return all values for a field name from the result.
|
<U> U[] |
intoArray(String fieldName,
Converter<?,U> converter)
Return all values for a field name from the result.
|
Map<Record,Result<R>> |
intoGroups(Field<?>[] keys)
Return a
Map with the result grouped by the given keys. |
<E> Map<Record,List<E>> |
intoGroups(Field<?>[] keys,
Class<? extends E> type)
Return a
Map with results grouped by the given keys and mapped
into the given entity type. |
<K> Map<K,Result<R>> |
intoGroups(Field<K> key)
Return a
Map with one of the result's columns as key and a list
of corresponding records as value. |
<K,E> Map<K,List<E>> |
intoGroups(Field<K> key,
Class<? extends E> type)
Return a
Map with results grouped by the given key and mapped
into the given entity type. |
<K,V> Map<K,List<V>> |
intoGroups(Field<K> key,
Field<V> value)
Return a
Map with one of the result's columns as key and another
one of the result's columns as value
Unlike intoMap(Field, Field) , this method allows for non-unique
keys in the result set. |
Map<Record,R> |
intoMap(Field<?>[] keys)
Return a
Map with the given keys as a map key and the
corresponding record as value. |
<E> Map<List<?>,E> |
intoMap(Field<?>[] keys,
Class<? extends E> type)
Return a
Map with results grouped by the given keys and mapped
into the given entity type. |
<K> Map<K,R> |
intoMap(Field<K> key)
Return a
Map with one of the result's columns as key and the
corresponding records as value. |
<K,E> Map<K,E> |
intoMap(Field<K> key,
Class<? extends E> type)
Return a
Map with results grouped by the given key and mapped
into the given entity type. |
<K,V> Map<K,V> |
intoMap(Field<K> key,
Field<V> value)
Return a
Map with one of the result's columns as key and another
one of the result's columns as value
An InvalidResultException is thrown, if the key turns out to be
non-unique in the result set. |
List<Map<String,Object>> |
intoMaps()
Return the generated result as a list of name/value maps.
|
ResultSet |
intoResultSet()
Generate an in-memory JDBC
ResultSet containing the data of this
Result . |
Document |
intoXML()
Get this result as XML
|
boolean |
isEmpty()
Whether there are any records contained in this
Result |
boolean |
isNotEmpty()
Whether there are any records contained in this
Result |
<E> List<E> |
map(RecordMapper<? super R,E> mapper)
Map results into a custom mapper callback
|
Result<R> |
sortAsc(Comparator<? super R> comparator)
Sort this result using a comparator that can compare records.
|
<T extends Comparable<? super T>> |
sortAsc(Field<T> field)
Sort this result by one of its contained fields.
|
<T> Result<R> |
sortAsc(Field<T> field,
Comparator<? super T> comparator)
Sort this result by one of its contained fields using a comparator.
|
Result<R> |
sortDesc(Comparator<? super R> comparator)
Reverse-sort this result using a comparator that can compare records.
|
<T extends Comparable<? super T>> |
sortDesc(Field<T> field)
Reverse-sort this result by one of its contained fields.
|
<T> Result<R> |
sortDesc(Field<T> field,
Comparator<? super T> comparator)
Reverse-sort this result by one of its contained fields using a
comparator.
|
getField, getField, getField, getFields, getIndex
add, add, addAll, addAll, clear, contains, containsAll, equals, get, hashCode, indexOf, iterator, lastIndexOf, listIterator, listIterator, remove, remove, removeAll, retainAll, set, size, subList, toArray, toArray
attach
internalAPI
<T> T getValue(int index, Field<T> field) throws IndexOutOfBoundsException
T
- The value's field's generic type parameterindex
- The record's indexfield
- The value's fieldIndexOutOfBoundsException
<T> T getValue(int index, Field<T> field, T defaultValue) throws IndexOutOfBoundsException
T
- The value's field's generic type parameterindex
- The record's indexfield
- The value's fielddefaultValue
- The default value if the value was null
IndexOutOfBoundsException
Object getValue(int index, int fieldIndex) throws IndexOutOfBoundsException
index
- The record's indexfieldIndex
- The value's field indexIndexOutOfBoundsException
Object getValue(int index, int fieldIndex, Object defaultValue) throws IndexOutOfBoundsException
index
- The record's indexfieldIndex
- The value's field indexdefaultValue
- The default value if the value was null
IndexOutOfBoundsException
Object getValue(int index, String fieldName) throws IndexOutOfBoundsException
index
- The record's indexfieldName
- The value's field nameIndexOutOfBoundsException
Object getValue(int index, String fieldName, Object defaultValue) throws IndexOutOfBoundsException
index
- The record's indexfieldName
- The value's field namedefaultValue
- The default value if the value was null
IndexOutOfBoundsException
@Deprecated <A extends ArrayRecord<T>,T> T[] getValueAsArray(int index, Field<A> field) throws IndexOutOfBoundsException
A
- The value's field's generic type parameterT
- The ArrayRecord
type parameterindex
- The record's indexfield
- The value's fieldIndexOutOfBoundsException
@Deprecated <A extends ArrayRecord<T>,T> T[] getValueAsArray(int index, Field<A> field, T[] defaultValue) throws IndexOutOfBoundsException
A
- The value's field's generic type parameterT
- The ArrayRecord
type parameterindex
- The record's indexfield
- The value's fielddefaultValue
- The default value if the value was null
IndexOutOfBoundsException
@Deprecated String getValueAsString(int index, Field<?> field) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.index
- The record's indexfield
- The fieldIllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated String getValueAsString(int index, Field<?> field, String defaultValue) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.index
- The record's indexfield
- The fielddefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated String getValueAsString(int index, int fieldIndex) throws IllegalArgumentException
Record.getValue(int, Class)
instead.index
- The record's indexfieldIndex
- The field's indexIllegalArgumentException
- If the argument index is not contained
in the record@Deprecated String getValueAsString(int index, int fieldIndex, String defaultValue) throws IllegalArgumentException
Record.getValue(int, Class)
instead.index
- The record's indexfieldIndex
- The field's indexdefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument index is not contained
in the record@Deprecated String getValueAsString(int index, String fieldName) throws IllegalArgumentException
Record.getValue(String, Class)
instead.index
- The record's indexfieldName
- The field's nameIllegalArgumentException
- If the argument name is not contained in
the record@Deprecated String getValueAsString(int index, String fieldName, String defaultValue) throws IllegalArgumentException
Record.getValue(String, Class)
instead.index
- The record's indexfieldName
- The field's namedefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument name is not contained in
the record@Deprecated Byte getValueAsByte(int index, Field<?> field) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.index
- The record's indexfield
- The fieldIllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated Byte getValueAsByte(int index, Field<?> field, Byte defaultValue) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.index
- The record's indexfield
- The fielddefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated Byte getValueAsByte(int index, int fieldIndex) throws IllegalArgumentException
Record.getValue(int, Class)
instead.index
- The record's indexfieldIndex
- The field's indexIllegalArgumentException
- If the argument index is not contained
in the record@Deprecated Byte getValueAsByte(int index, int fieldIndex, Byte defaultValue) throws IllegalArgumentException
Record.getValue(int, Class)
instead.index
- The record's indexfieldIndex
- The field's indexdefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument index is not contained
in the record@Deprecated Byte getValueAsByte(int index, String fieldName) throws IllegalArgumentException
Record.getValue(String, Class)
instead.index
- The record's indexfieldName
- The field's nameIllegalArgumentException
- If the argument name is not contained in
the record@Deprecated Byte getValueAsByte(int index, String fieldName, Byte defaultValue) throws IllegalArgumentException
Record.getValue(String, Class)
instead.index
- The record's indexfieldName
- The field's namedefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument name is not contained in
the record@Deprecated Short getValueAsShort(int index, Field<?> field) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.index
- The record's indexfield
- The fieldIllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated Short getValueAsShort(int index, Field<?> field, Short defaultValue) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.index
- The record's indexfield
- The fielddefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated Short getValueAsShort(int index, int fieldIndex) throws IllegalArgumentException
Record.getValue(int, Class)
instead.index
- The record's indexfieldIndex
- The field's indexIllegalArgumentException
- If the argument index is not contained
in the record@Deprecated Short getValueAsShort(int index, int fieldIndex, Short defaultValue) throws IllegalArgumentException
Record.getValue(int, Class)
instead.index
- The record's indexfieldIndex
- The field's indexdefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument index is not contained
in the record@Deprecated Short getValueAsShort(int index, String fieldName) throws IllegalArgumentException
Record.getValue(String, Class)
instead.index
- The record's indexfieldName
- The field's nameIllegalArgumentException
- If the argument name is not contained in
the record@Deprecated Short getValueAsShort(int index, String fieldName, Short defaultValue) throws IllegalArgumentException
Record.getValue(String, Class)
instead.index
- The record's indexfieldName
- The field's namedefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument name is not contained in
the record@Deprecated Integer getValueAsInteger(int index, Field<?> field) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.index
- The record's indexfield
- The fieldIllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated Integer getValueAsInteger(int index, Field<?> field, Integer defaultValue) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.index
- The record's indexfield
- The fielddefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated Integer getValueAsInteger(int index, int fieldIndex) throws IllegalArgumentException
Record.getValue(int, Class)
instead.index
- The record's indexfieldIndex
- The field's indexIllegalArgumentException
- If the argument index is not contained
in the record@Deprecated Integer getValueAsInteger(int index, int fieldIndex, Integer defaultValue) throws IllegalArgumentException
Record.getValue(int, Class)
instead.index
- The record's indexfieldIndex
- The field's indexdefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument index is not contained
in the record@Deprecated Integer getValueAsInteger(int index, String fieldName) throws IllegalArgumentException
Record.getValue(String, Class)
instead.index
- The record's indexfieldName
- The field's nameIllegalArgumentException
- If the argument name is not contained in
the record@Deprecated Integer getValueAsInteger(int index, String fieldName, Integer defaultValue) throws IllegalArgumentException
Record.getValue(String, Class)
instead.index
- The record's indexfieldName
- The field's namedefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument name is not contained in
the record@Deprecated Long getValueAsLong(int index, Field<?> field) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.index
- The record's indexfield
- The fieldIllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated Long getValueAsLong(int index, Field<?> field, Long defaultValue) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.index
- The record's indexfield
- The fielddefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated Long getValueAsLong(int index, int fieldIndex) throws IllegalArgumentException
Record.getValue(int, Class)
instead.index
- The record's indexfieldIndex
- The field's indexIllegalArgumentException
- If the argument index is not contained
in the record@Deprecated Long getValueAsLong(int index, int fieldIndex, Long defaultValue) throws IllegalArgumentException
Record.getValue(int, Class)
instead.index
- The record's indexfieldIndex
- The field's indexdefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument index is not contained
in the record@Deprecated Long getValueAsLong(int index, String fieldName) throws IllegalArgumentException
Record.getValue(String, Class)
instead.index
- The record's indexfieldName
- The field's nameIllegalArgumentException
- If the argument name is not contained in
the record@Deprecated Long getValueAsLong(int index, String fieldName, Long defaultValue) throws IllegalArgumentException
Record.getValue(String, Class)
instead.index
- The record's indexfieldName
- The field's namedefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument name is not contained in
the record@Deprecated BigInteger getValueAsBigInteger(int index, Field<?> field) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.index
- The record's indexfield
- The fieldIllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated BigInteger getValueAsBigInteger(int index, Field<?> field, BigInteger defaultValue) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.index
- The record's indexfield
- The fielddefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated BigInteger getValueAsBigInteger(int index, int fieldIndex) throws IllegalArgumentException
Record.getValue(int, Class)
instead.index
- The record's indexfieldIndex
- The field's indexIllegalArgumentException
- If the argument index is not contained
in the record@Deprecated BigInteger getValueAsBigInteger(int index, int fieldIndex, BigInteger defaultValue) throws IllegalArgumentException
Record.getValue(int, Class)
instead.index
- The record's indexfieldIndex
- The field's indexdefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument index is not contained
in the record@Deprecated BigInteger getValueAsBigInteger(int index, String fieldName) throws IllegalArgumentException
Record.getValue(String, Class)
instead.index
- The record's indexfieldName
- The field's nameIllegalArgumentException
- If the argument name is not contained in
the record@Deprecated BigInteger getValueAsBigInteger(int index, String fieldName, BigInteger defaultValue) throws IllegalArgumentException
Record.getValue(String, Class)
instead.index
- The record's indexfieldName
- The field's namedefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument name is not contained in
the record@Deprecated Float getValueAsFloat(int index, Field<?> field) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.index
- The record's indexfield
- The fieldIllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated Float getValueAsFloat(int index, Field<?> field, Float defaultValue) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.index
- The record's indexfield
- The fielddefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated Float getValueAsFloat(int index, int fieldIndex) throws IllegalArgumentException
Record.getValue(int, Class)
instead.index
- The record's indexfieldIndex
- The field's indexIllegalArgumentException
- If the argument index is not contained
in the record@Deprecated Float getValueAsFloat(int index, int fieldIndex, Float defaultValue) throws IllegalArgumentException
Record.getValue(int, Class)
instead.index
- The record's indexfieldIndex
- The field's indexdefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument index is not contained
in the record@Deprecated Float getValueAsFloat(int index, String fieldName) throws IllegalArgumentException
Record.getValue(String, Class)
instead.index
- The record's indexfieldName
- The field's nameIllegalArgumentException
- If the argument name is not contained in
the record@Deprecated Float getValueAsFloat(int index, String fieldName, Float defaultValue) throws IllegalArgumentException
Record.getValue(String, Class)
instead.index
- The record's indexfieldName
- The field's namedefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument name is not contained in
the record@Deprecated Double getValueAsDouble(int index, Field<?> field) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.index
- The record's indexfield
- The fieldIllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated Double getValueAsDouble(int index, Field<?> field, Double defaultValue) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.index
- The record's indexfield
- The fielddefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated Double getValueAsDouble(int index, int fieldIndex) throws IllegalArgumentException
Record.getValue(int, Class)
instead.index
- The record's indexfieldIndex
- The field's indexIllegalArgumentException
- If the argument index is not contained
in the record@Deprecated Double getValueAsDouble(int index, int fieldIndex, Double defaultValue) throws IllegalArgumentException
Record.getValue(int, Class)
instead.index
- The record's indexfieldIndex
- The field's indexdefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument index is not contained
in the record@Deprecated Double getValueAsDouble(int index, String fieldName) throws IllegalArgumentException
Record.getValue(String, Class)
instead.index
- The record's indexfieldName
- The field's nameIllegalArgumentException
- If the argument name is not contained in
the record@Deprecated Double getValueAsDouble(int index, String fieldName, Double defaultValue) throws IllegalArgumentException
Record.getValue(String, Class)
instead.index
- The record's indexfieldName
- The field's namedefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument name is not contained in
the record@Deprecated BigDecimal getValueAsBigDecimal(int index, Field<?> field) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.index
- The record's indexfield
- The fieldIllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated BigDecimal getValueAsBigDecimal(int index, Field<?> field, BigDecimal defaultValue) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.index
- The record's indexfield
- The fielddefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated BigDecimal getValueAsBigDecimal(int index, int fieldIndex) throws IllegalArgumentException
Record.getValue(int, Class)
instead.index
- The record's indexfieldIndex
- The field's indexIllegalArgumentException
- If the argument index is not contained
in the record@Deprecated BigDecimal getValueAsBigDecimal(int index, int fieldIndex, BigDecimal defaultValue) throws IllegalArgumentException
Record.getValue(int, Class)
instead.index
- The record's indexfieldIndex
- The field's indexdefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument index is not contained
in the record@Deprecated BigDecimal getValueAsBigDecimal(int index, String fieldName) throws IllegalArgumentException
Record.getValue(String, Class)
instead.index
- The record's indexfieldName
- The field's nameIllegalArgumentException
- If the argument name is not contained in
the record@Deprecated BigDecimal getValueAsBigDecimal(int index, String fieldName, BigDecimal defaultValue) throws IllegalArgumentException
Record.getValue(String, Class)
instead.index
- The record's indexfieldName
- The field's namedefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument name is not contained in
the record@Deprecated Boolean getValueAsBoolean(int index, Field<?> field) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.
boolean values for true
are any of these case-insensitive
strings:
1
y
yes
true
on
enabled
boolean values for false
are any of these case-insensitive
strings:
0
n
no
false
off
disabled
All other values evaluate to null
index
- The record's indexfield
- The fieldIllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated Boolean getValueAsBoolean(int index, Field<?> field, Boolean defaultValue) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.
boolean values for true
are any of these case-insensitive
strings:
1
y
yes
true
on
enabled
boolean values for false
are any of these case-insensitive
strings:
0
n
no
false
off
disabled
All other values evaluate to null
index
- The record's indexfield
- The fielddefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated Boolean getValueAsBoolean(int index, int fieldIndex) throws IllegalArgumentException
Record.getValue(int, Class)
instead.
boolean values for true
are any of these case-insensitive
strings:
1
y
yes
true
on
enabled
boolean values for false
are any of these case-insensitive
strings:
0
n
no
false
off
disabled
All other values evaluate to null
index
- The record's indexfieldIndex
- The field's indexIllegalArgumentException
- If the argument index is not contained
in the record@Deprecated Boolean getValueAsBoolean(int index, int fieldIndex, Boolean defaultValue) throws IllegalArgumentException
Record.getValue(int, Class)
instead.
boolean values for true
are any of these case-insensitive
strings:
1
y
yes
true
on
enabled
boolean values for false
are any of these case-insensitive
strings:
0
n
no
false
off
disabled
All other values evaluate to null
index
- The record's indexfieldIndex
- The field's indexdefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument index is not contained
in the record@Deprecated Boolean getValueAsBoolean(int index, String fieldName) throws IllegalArgumentException
Record.getValue(String, Class)
instead.
boolean values for true
are any of these case-insensitive
strings:
1
y
yes
true
on
enabled
boolean values for false
are any of these case-insensitive
strings:
0
n
no
false
off
disabled
All other values evaluate to null
index
- The record's indexfieldName
- The field's nameIllegalArgumentException
- If the argument name is not contained in
the record@Deprecated Boolean getValueAsBoolean(int index, String fieldName, Boolean defaultValue) throws IllegalArgumentException
Record.getValue(String, Class)
instead.
boolean values for true
are any of these case-insensitive
strings:
1
y
yes
true
on
enabled
boolean values for false
are any of these case-insensitive
strings:
0
n
no
false
off
disabled
All other values evaluate to null
index
- The record's indexfieldName
- The field's namedefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument name is not contained in
the record@Deprecated Timestamp getValueAsTimestamp(int index, Field<?> field) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.index
- The record's indexfield
- The fieldIllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated Timestamp getValueAsTimestamp(int index, Field<?> field, Timestamp defaultValue) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.index
- The record's indexfield
- The fielddefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated Timestamp getValueAsTimestamp(int index, int fieldIndex) throws IllegalArgumentException
Record.getValue(int, Class)
instead.index
- The record's indexfieldIndex
- The field's indexIllegalArgumentException
- If the argument index is not contained
in the record@Deprecated Timestamp getValueAsTimestamp(int index, int fieldIndex, Timestamp defaultValue) throws IllegalArgumentException
Record.getValue(int, Class)
instead.index
- The record's indexfieldIndex
- The field's indexdefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument index is not contained
in the record@Deprecated Timestamp getValueAsTimestamp(int index, String fieldName) throws IllegalArgumentException
Record.getValue(String, Class)
instead.index
- The record's indexfieldName
- The field's nameIllegalArgumentException
- If the argument name is not contained in
the record@Deprecated Timestamp getValueAsTimestamp(int index, String fieldName, Timestamp defaultValue) throws IllegalArgumentException
Record.getValue(String, Class)
instead.index
- The record's indexfieldName
- The field's namedefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument name is not contained in
the record@Deprecated Date getValueAsDate(int index, Field<?> field) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.index
- The record's indexfield
- The fieldIllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated Date getValueAsDate(int index, Field<?> field, Date defaultValue) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.index
- The record's indexfield
- The fielddefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated Date getValueAsDate(int index, int fieldIndex) throws IllegalArgumentException
Record.getValue(int, Class)
instead.index
- The record's indexfieldIndex
- The field's indexIllegalArgumentException
- If the argument index is not contained
in the record@Deprecated Date getValueAsDate(int index, int fieldIndex, Date defaultValue) throws IllegalArgumentException
Record.getValue(int, Class)
instead.index
- The record's indexfieldIndex
- The field's indexdefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument index is not contained
in the record@Deprecated Date getValueAsDate(int index, String fieldName) throws IllegalArgumentException
Record.getValue(String, Class)
instead.index
- The record's indexfieldName
- The field's nameIllegalArgumentException
- If the argument name is not contained in
the record@Deprecated Date getValueAsDate(int index, String fieldName, Date defaultValue) throws IllegalArgumentException
Record.getValue(String, Class)
instead.index
- The record's indexfieldName
- The field's namedefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument name is not contained in
the record@Deprecated Time getValueAsTime(int index, Field<?> field) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.index
- The record's indexfield
- The fieldIllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated Time getValueAsTime(int index, Field<?> field, Time defaultValue) throws IllegalArgumentException
Record.getValue(Field, Class)
instead.index
- The record's indexfield
- The fielddefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument field is not contained
in FieldProvider.getFields()
@Deprecated Time getValueAsTime(int index, int fieldIndex) throws IllegalArgumentException
Record.getValue(int, Class)
instead.index
- The record's indexfieldIndex
- The field's indexIllegalArgumentException
- If the argument index is not contained
in the record@Deprecated Time getValueAsTime(int index, int fieldIndex, Time defaultValue) throws IllegalArgumentException
Record.getValue(int, Class)
instead.index
- The record's indexfieldIndex
- The field's indexdefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument index is not contained
in the record@Deprecated Time getValueAsTime(int index, String fieldName) throws IllegalArgumentException
Record.getValue(String, Class)
instead.index
- The record's indexfieldName
- The field's nameIllegalArgumentException
- If the argument name is not contained in
the record@Deprecated Time getValueAsTime(int index, String fieldName, Time defaultValue) throws IllegalArgumentException
Record.getValue(String, Class)
instead.index
- The record's indexfieldName
- The field's namedefaultValue
- The default value instead of null
null
IllegalArgumentException
- If the argument name is not contained in
the record<T> List<T> getValues(Field<T> field)
T
- The values' field's generic type parameterfield
- The values' field<T> List<T> getValues(Field<?> field, Class<? extends T> type)
field
- The values' fieldtype
- The type used for type conversionRecord.getValue(Field, Class)
,
Convert.convert(Object, Class)
<T,U> List<U> getValues(Field<T> field, Converter<? super T,U> converter)
field
- The values' fieldconverter
- The data type converter used for type conversionRecord.getValue(Field, Converter)
,
Convert.convert(Object, Converter)
List<?> getValues(int fieldIndex)
fieldIndex
- The values' field index<T> List<T> getValues(int fieldIndex, Class<? extends T> type)
fieldIndex
- The values' field indextype
- The type used for type conversionRecord.getValue(int, Class)
,
Convert.convert(Object, Class)
<U> List<U> getValues(int fieldIndex, Converter<?,U> converter)
fieldIndex
- The values' field indexconverter
- The data type converter used for type conversionRecord.getValue(int, Converter)
,
Convert.convert(Object, Converter)
List<?> getValues(String fieldName)
fieldName
- The values' field name<T> List<T> getValues(String fieldName, Class<? extends T> type)
fieldName
- The values' field nametype
- The type used for type conversionRecord.getValue(String, Class)
,
Convert.convert(Object, Class)
<U> List<U> getValues(String fieldName, Converter<?,U> converter)
fieldName
- The values' field nameconverter
- The data type converter used for type conversionRecord.getValue(String, Converter)
,
Convert.convert(Object, Converter)
@Deprecated List<BigDecimal> getValuesAsBigDecimal(Field<?> field)
getValues(Field, Class)
instead.field
- The values' field@Deprecated List<BigDecimal> getValuesAsBigDecimal(int fieldIndex)
getValues(int, Class)
instead.fieldIndex
- The values' field index@Deprecated List<BigDecimal> getValuesAsBigDecimal(String fieldName)
getValues(String, Class)
instead.fieldName
- The values' field name@Deprecated List<BigInteger> getValuesAsBigInteger(Field<?> field)
getValues(Field, Class)
instead.field
- The values' field@Deprecated List<BigInteger> getValuesAsBigInteger(int fieldIndex)
getValues(int, Class)
instead.fieldIndex
- The values' field index@Deprecated List<BigInteger> getValuesAsBigInteger(String fieldName)
getValues(String, Class)
instead.fieldName
- The values' field name@Deprecated List<Byte> getValuesAsByte(Field<?> field)
getValues(Field, Class)
instead.field
- The values' field@Deprecated List<Byte> getValuesAsByte(int fieldIndex)
getValues(int, Class)
instead.fieldIndex
- The values' field index@Deprecated List<Byte> getValuesAsByte(String fieldName)
getValues(String, Class)
instead.fieldName
- The values' field name@Deprecated List<Date> getValuesAsDate(Field<?> field)
getValues(Field, Class)
instead.field
- The values' field@Deprecated List<Date> getValuesAsDate(int fieldIndex)
getValues(int, Class)
instead.fieldIndex
- The values' field index@Deprecated List<Date> getValuesAsDate(String fieldName)
getValues(String, Class)
instead.fieldName
- The values' field name@Deprecated List<Double> getValuesAsDouble(Field<?> field)
getValues(Field, Class)
instead.field
- The values' field@Deprecated List<Double> getValuesAsDouble(int fieldIndex)
getValues(int, Class)
instead.fieldIndex
- The values' field index@Deprecated List<Double> getValuesAsDouble(String fieldName)
getValues(String, Class)
instead.fieldName
- The values' field name@Deprecated List<Float> getValuesAsFloat(Field<?> field)
getValues(Field, Class)
instead.field
- The values' field@Deprecated List<Float> getValuesAsFloat(int fieldIndex)
getValues(int, Class)
instead.fieldIndex
- The values' field index@Deprecated List<Float> getValuesAsFloat(String fieldName)
getValues(String, Class)
instead.fieldName
- The values' field name@Deprecated List<Integer> getValuesAsInteger(Field<?> field)
getValues(Field, Class)
instead.field
- The values' field@Deprecated List<Integer> getValuesAsInteger(int fieldIndex)
getValues(int, Class)
instead.fieldIndex
- The values' field index@Deprecated List<Integer> getValuesAsInteger(String fieldName)
getValues(String, Class)
instead.fieldName
- The values' field name@Deprecated List<Long> getValuesAsLong(Field<?> field)
getValues(Field, Class)
instead.field
- The values' field@Deprecated List<Long> getValuesAsLong(int fieldIndex)
getValues(int, Class)
instead.fieldIndex
- The values' field index@Deprecated List<Long> getValuesAsLong(String fieldName)
getValues(String, Class)
instead.fieldName
- The values' field name@Deprecated List<Short> getValuesAsShort(Field<?> field)
getValues(Field, Class)
instead.field
- The values' field@Deprecated List<Short> getValuesAsShort(int fieldIndex)
getValues(int, Class)
instead.fieldIndex
- The values' field index@Deprecated List<Short> getValuesAsShort(String fieldName)
getValues(String, Class)
instead.fieldName
- The values' field name@Deprecated List<String> getValuesAsString(Field<?> field)
getValues(Field, Class)
instead.field
- The values' field@Deprecated List<String> getValuesAsString(int fieldIndex)
getValues(int, Class)
instead.fieldIndex
- The values' field index@Deprecated List<String> getValuesAsString(String fieldName)
getValues(String, Class)
instead.fieldName
- The values' field name@Deprecated List<Time> getValuesAsTime(Field<?> field)
getValues(Field, Class)
instead.field
- The values' field@Deprecated List<Time> getValuesAsTime(int fieldIndex)
getValues(int, Class)
instead.fieldIndex
- The values' field index@Deprecated List<Time> getValuesAsTime(String fieldName)
getValues(String, Class)
instead.fieldName
- The values' field name@Deprecated List<Timestamp> getValuesAsTimestamp(Field<?> field)
getValues(Field, Class)
instead.field
- The values' field@Deprecated List<Timestamp> getValuesAsTimestamp(int fieldIndex)
getValues(int, Class)
instead.fieldIndex
- The values' field index@Deprecated List<Timestamp> getValuesAsTimestamp(String fieldName)
getValues(String, Class)
instead.fieldName
- The values' field nameboolean isEmpty()
Result
boolean isNotEmpty()
Result
String format()
This is the same as calling format(int)
with
maxRows = 50
String format(int maxRecords)
maxRecords
- The maximum number of records to include in the
formatted resultString formatHTML()
The HTML code is formatted as follows:
<table>
<thead>
<tr>
<th>field-1</th>
<th>field-2</th>
...
<th>field-n</th>
</tr>
</thead>
<tbody>
<tr>
<th>value-1-1</th>
<th>value-1-2</th>
...
<th>value-1-n</th>
</tr>
<tr>
<th>value-2-1</th>
<th>value-2-2</th>
...
<th>value-2-n</th>
</tr>
...
</tbody>
</table>
String formatCSV()
This is the same as calling formatCSV(',', "")
String formatCSV(char delimiter)
This is the same as calling formatCSV(delimiter, "")
delimiter
- The delimiter to use between recordsString formatCSV(char delimiter, String nullString)
delimiter
- The delimiter to use between recordsnullString
- A special string for encoding NULL
values.String formatJSON()
{"fields":[{"name":"field-1","type":"type-1"},
{"name":"field-2","type":"type-2"},
...,
{"name":"field-n","type":"type-n"}],
"records":[[value-1-1,value-1-2,...,value-1-n],
[value-2-1,value-2-2,...,value-2-n]]}
String formatXML()
@Deprecated Document exportXML()
intoXML()
insteadDocument intoXML()
List<Map<String,Object>> intoMaps()
Record.intoMap()
<K> Map<K,R> intoMap(Field<K> key)
Map
with one of the result's columns as key and the
corresponding records as value.
An InvalidResultException
is thrown, if the key turns out to be
non-unique in the result set. Use intoGroups(Field)
instead, if
your keys are non-unique
K
- The key's generic field typekey
- The key field. Client code must assure that this field is
unique in the result set.InvalidResultException
- if the key field returned two or more
equal values from the result set.<K,V> Map<K,V> intoMap(Field<K> key, Field<V> value)
Map
with one of the result's columns as key and another
one of the result's columns as value
An InvalidResultException
is thrown, if the key turns out to be
non-unique in the result set. Use intoGroups(Field, Field)
instead, if your keys are non-unique
K
- The key's generic field typeV
- The value's generic field typekey
- The key field. Client code must assure that this field is
unique in the result set.value
- The value fieldInvalidResultException
- if the key field returned two or more
equal values from the result set.Map<Record,R> intoMap(Field<?>[] keys)
Map
with the given keys as a map key and the
corresponding record as value.
An InvalidResultException
is thrown, if the keys are non-unique
in the result set. Use intoGroups(Field[])
instead, if your keys
are non-unique.
keys
- The keys. Client code must assure that keys are unique in the
result set. If this is null
or an empty array,
the resulting map will contain at most one entry.InvalidResultException
- if the keys are non-unique in the result
set.<K,E> Map<K,E> intoMap(Field<K> key, Class<? extends E> type) throws MappingException
Map
with results grouped by the given key and mapped
into the given entity type.
An InvalidResultException
is thrown, if the key is non-unique in
the result set. Use intoGroups(Field, Class)
instead, if your
key is non-unique.
key
- The key. Client code must assure that key is unique in the
result set.InvalidResultException
- if the key is non-unique in the result
set.MappingException
- wrapping any reflection or data type conversion
exception that might have occurred while mapping records<E> Map<List<?>,E> intoMap(Field<?>[] keys, Class<? extends E> type) throws MappingException
Map
with results grouped by the given keys and mapped
into the given entity type.
An InvalidResultException
is thrown, if the keys are non-unique
in the result set. Use intoGroups(Field[], Class)
instead, if
your keys are non-unique.
keys
- The keys. Client code must assure that keys are unique in the
result set. If this is null
or an empty array,
the resulting map will contain at most one entry.InvalidResultException
- if the keys are non-unique in the result
set.MappingException
- wrapping any reflection or data type conversion
exception that might have occurred while mapping records<K> Map<K,Result<R>> intoGroups(Field<K> key)
Map
with one of the result's columns as key and a list
of corresponding records as value.
Unlike intoMap(Field)
, this method allows for non-unique keys in
the result set.
K
- The key's generic field typekey
- The key field.<K,V> Map<K,List<V>> intoGroups(Field<K> key, Field<V> value)
Map
with one of the result's columns as key and another
one of the result's columns as value
Unlike intoMap(Field, Field)
, this method allows for non-unique
keys in the result set.
K
- The key's generic field typeV
- The value's generic field typekey
- The key field.value
- The value fieldMap<Record,Result<R>> intoGroups(Field<?>[] keys)
Map
with the result grouped by the given keys.
Unlike intoMap(Field[])
, this method allows for non-unique keys
in the result set.
keys
- The keys. If this is null
or an empty array, the
resulting map will contain at most one entry.<K,E> Map<K,List<E>> intoGroups(Field<K> key, Class<? extends E> type) throws MappingException
Map
with results grouped by the given key and mapped
into the given entity type.
K
- The key's generic field typeE
- The generic entity type.key
- The key field.type
- The entity type.MappingException
- wrapping any reflection or data type conversion
exception that might have occurred while mapping records<E> Map<Record,List<E>> intoGroups(Field<?>[] keys, Class<? extends E> type) throws MappingException
Map
with results grouped by the given keys and mapped
into the given entity type.
Unlike intoMap(Field[], Class)
, this method allows for
non-unique keys in the result set.
keys
- The keys. If this is null
or an empty array, the
resulting map will contain at most one entry.MappingException
- wrapping any reflection or data type conversion
exception that might have occurred while mapping recordsObject[][] intoArray()
The resulting array has the same number of first-dimension elements as this result has records. It has the same number of second-dimension elements as this result's records have fields. The resulting array contains data as such:
// For arbitrary values of i, j
result.getValue(i, j) == result.intoArray()[i][j]
This is the same as calling into(Object[].class)
Record.intoArray()
Object[] intoArray(int fieldIndex)
You can access data like this
result.intoArray(fieldIndex)[recordIndex]
Object[]
, depending on whether jOOQ has any
knowledge about fieldIndex
's actual type.getValues(int)
<T> T[] intoArray(int fieldIndex, Class<? extends T> type)
You can access data like this
result.intoArray(fieldIndex)[recordIndex]
getValues(int, Class)
<U> U[] intoArray(int fieldIndex, Converter<?,U> converter)
You can access data like this
result.intoArray(fieldIndex)[recordIndex]
getValues(int, Converter)
Object[] intoArray(String fieldName)
You can access data like this
result.intoArray(fieldName)[recordIndex]
Object[]
, depending on whether jOOQ has any
knowledge about fieldName
's actual type.getValues(String)
<T> T[] intoArray(String fieldName, Class<? extends T> type)
You can access data like this
result.intoArray(fieldName)[recordIndex]
getValues(String, Class)
<U> U[] intoArray(String fieldName, Converter<?,U> converter)
You can access data like this
result.intoArray(fieldName)[recordIndex]
getValues(String, Converter)
<T> T[] intoArray(Field<T> field)
You can access data like this
result.intoArray(field)[recordIndex]
getValues(Field)
<T> T[] intoArray(Field<?> field, Class<? extends T> type)
You can access data like this
result.intoArray(field)[recordIndex]
getValues(Field, Class)
<T,U> U[] intoArray(Field<T> field, Converter<? super T,U> converter)
You can access data like this
result.intoArray(field)[recordIndex]
getValues(Field, Converter)
<E> List<E> into(Class<? extends E> type) throws MappingException
This is the same as calling record.into(type)
on every
record contained in this Result
. See
Record.into(Class)
for more details
E
- The generic entity type.type
- The entity type.MappingException
- wrapping any reflection or data type conversion
exception that might have occurred while mapping recordsRecord.into(Class)
<Z extends Record> Result<Z> into(Table<Z> table) throws MappingException
This is the same as calling record.into(table)
on every
record contained in this Result
. See
Record.into(Table)
for more details
Z
- The generic table record type.table
- The table type.MappingException
- wrapping any reflection or data type conversion
exception that might have occurred while mapping recordsRecord.into(Table)
<H extends RecordHandler<R>> H into(H handler)
handler
- The handler callback<E> List<E> map(RecordMapper<? super R,E> mapper)
mapper
- The mapper callbackResultSet intoResultSet()
ResultSet
containing the data of this
Result
.
Use this as an adapter for JDBC-compliant code that expects a
ResultSet
to operate on, rather than a jOOQ Result
. The
returned ResultSet
allows for the following behaviour
according to the JDBC specification:
ResultSet.CLOSE_CURSORS_AT_COMMIT
: The cursors (i.e.
Statement
object) are no longer availableResultSet.CONCUR_READ_ONLY
: You cannot update the database
through this ResultSet
, as the underlying Result
object does not hold any open database refences anymoreResultSet.FETCH_FORWARD
: The fetch direction is forward only,
and cannot be changedResultSet.TYPE_SCROLL_INSENSITIVE
: You can use any of the
ResultSet
's scrolling methods, e.g. ResultSet.next()
or ResultSet.previous()
, etc.
You may use FactoryOperations.fetch(ResultSet)
to unwind this
wrapper again.
ResultSet
<T extends Comparable<? super T>> Result<R> sortAsc(Field<T> field)
nulls
are sorted last by this method.
field
- The sort field<T extends Comparable<? super T>> Result<R> sortDesc(Field<T> field)
nulls
are sorted last by this method.
field
- The sort field<T> Result<R> sortAsc(Field<T> field, Comparator<? super T> comparator)
null
sorting must be handled by the supplied
comparator
.
field
- The sort fieldcomparator
- The comparator used to sort this result.<T> Result<R> sortDesc(Field<T> field, Comparator<? super T> comparator)
null
sorting must be handled by the supplied
comparator
.
field
- The sort fieldcomparator
- The comparator used to sort this result.Result<R> sortAsc(Comparator<? super R> comparator)
comparator
- The comparator used to sort this result.Result<R> sortDesc(Comparator<? super R> comparator)
comparator
- The comparator used to sort this result.Copyright © 2013. All Rights Reserved.