All Superinterfaces:

Attachable, java.lang.Comparable<Record>, Formattable, java.io.Serializable

All Known Subinterfaces:

EmbeddableRecord<R>, Record1<T1>, Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>, Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>, Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>, Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>, Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>, Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>, Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>, Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>, Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>, Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>, Record2<T1,T2>, Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>, Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>, Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>, Record3<T1,T2,T3>, Record4<T1,T2,T3,T4>, Record5<T1,T2,T3,T4,T5>, Record6<T1,T2,T3,T4,T5,T6>, Record7<T1,T2,T3,T4,T5,T6,T7>, Record8<T1,T2,T3,T4,T5,T6,T7,T8>, Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>, TableRecord<R>, UDTRecord<R>, UpdatableRecord<R>

All Known Implementing Classes:

CustomRecord, EmbeddableRecordImpl, TableRecordImpl, UDTRecordImpl, UpdatableRecordImpl
```
public interface Record
extends Attachable, java.lang.Comparable<Record>, Formattable
```
A database result record.
A record essentially combines a list of columns (Field) with a corresponding list of values, each value being of the respective field's type.
While records can be seen as generic column / value mappings, their concrete implementations often specialise the above description in any of the following ways:

Table records

Records originating from a concrete database table (or view) are modelled by jOOQ as TableRecord or UpdatableRecord, if they contain a primary key. If you're using jOOQ's code generator, you can generate even more concrete types of table records, i.e. one table record per table.

UDT records

SQLDialect.ORACLE and SQLDialect.POSTGRES formally support user defined types (UDT), which are modelled by jOOQ as UDTRecord. In addition to being regular records (column / value mappings), they also implement the JDBC SQLData API in order to be streamed to a JDBC PreparedStatement or from a JDBC ResultSet

Records of well-defined degree

When projecting custom record types in SQL, new ad-hoc types of a certain degree are formed on the fly. Records with degree <= 22 are reflected by jOOQ through the Record1, Record2, ... Record22 classes, which cover the respective row value expressions Row1, Row2, ... Row22
Note that generated TableRecords and UDTRecords also implement a Record[N] interface, if N <= 22

Record implements Comparable

jOOQ records have a natural ordering implemented in the same way as this is defined in the SQL standard. For more details, see the compareTo(Record) method

Author:

Lukas Eder

See Also:

Result

Method Summary

All Methods Instance Methods Abstract Methods Deprecated Methods
Modifier and Type	Method	Description
`boolean`	`changed()`	Check if this record has been changed from its original as fetched from the database.
`void`	`changed(boolean changed)`	Set all of this record's internal changed flags to the supplied value.
`boolean`	`changed(int fieldIndex)`	Check if a field's value has been changed from its original as fetched from the database.
`void`	`changed(int fieldIndex, boolean changed)`	Set this record's internal changed flag to the supplied value for a given field.
`boolean`	`changed(java.lang.String fieldName)`	Check if a field's value has been changed from its original as fetched from the database.
`void`	`changed(java.lang.String fieldName, boolean changed)`	Set this record's internal changed flag to the supplied value for a given field.
`boolean`	`changed(Field<?> field)`	Check if a field's value has been changed from its original as fetched from the database.
`void`	`changed(Field<?> field, boolean changed)`	Set this record's internal changed flag to the supplied value for a given field.
`boolean`	`changed(Name fieldName)`	Check if a field's value has been changed from its original as fetched from the database.
`void`	`changed(Name fieldName, boolean changed)`	Set this record's internal changed flag to the supplied value for a given field.
`int`	`compareTo(Record record)`	Compares this `Record` with another `Record` according to their natural ordering.
`boolean`	`equals(java.lang.Object other)`	Compare this `Record` with another `Record` for equality.
`Field<?>`	`field(int index)`	Get a specific field from this Record.
`Field<?>`	`field(java.lang.String name)`	Get a specific field from this Record.
`<T> Field<T>`	`field(Field<T> field)`	Get a specific field from this Record.
`Field<?>`	`field(Name name)`	Get a specific qualified field from this Record.
`Field<?>[]`	`fields()`	Get all fields from this Record.
`Field<?>[]`	`fields(int... fieldIndexes)`	Get all fields from this Record, providing some field indexes.
`Field<?>[]`	`fields(java.lang.String... fieldNames)`	Get all fields from this Record, providing some field names.
`Field<?>[]`	`fields(Field<?>... fields)`	Get all fields from this Record, providing some fields.
`Field<?>[]`	`fields(Name... fieldNames)`	Get all fields from this Record, providing some field names.
`Row`	`fieldsRow()`	Get this record's fields as a `Row`.
`void`	`from(java.lang.Object source)`	Load data into this record from a source.
`void`	`from(java.lang.Object source, int... fieldIndexes)`	Load data into this record from a source, providing some field indexes.
`void`	`from(java.lang.Object source, java.lang.String... fieldNames)`	Load data into this record from a source, providing some field names.
`void`	`from(java.lang.Object source, Field<?>... fields)`	Load data into this record from a source, providing some fields.
`void`	`from(java.lang.Object source, Name... fieldNames)`	Load data into this record from a source, providing some field names.
`void`	`fromArray(java.lang.Object... array)`	Load data from an array into this record.
`void`	`fromArray(java.lang.Object[] array, int... fieldIndexes)`	Load data from an array into this record, providing some fields indexes.
`void`	`fromArray(java.lang.Object[] array, java.lang.String... fieldNames)`	Load data from an array into this record, providing some fields names.
`void`	`fromArray(java.lang.Object[] array, Field<?>... fields)`	Load data from an array into this record, providing some fields.
`void`	`fromArray(java.lang.Object[] array, Name... fieldNames)`	Load data from an array into this record, providing some fields names.
`void`	`fromMap(java.util.Map<java.lang.String,?> map)`	Load data from a map into this record.
`void`	`fromMap(java.util.Map<java.lang.String,?> map, int... fieldIndexes)`	Load data from a map into this record, providing some field indexes.
`void`	`fromMap(java.util.Map<java.lang.String,?> map, java.lang.String... fieldNames)`	Load data from a map into this record, providing some field names.
`void`	`fromMap(java.util.Map<java.lang.String,?> map, Field<?>... fields)`	Load data from a map into this record, providing some fields.
`void`	`fromMap(java.util.Map<java.lang.String,?> map, Name... fieldNames)`	Load data from a map into this record, providing some field names.
`java.lang.Object`	`get(int index)`	Get a value from this record, providing a field index.
`<T> T`	`get(int index, java.lang.Class<? extends T> type)`	Get a converted value from this record, providing a field index.
`<U> U`	`get(int index, Converter<?,? extends U> converter)`	Get a converted value from this record, providing a field index.
`java.lang.Object`	`get(java.lang.String fieldName)`	Get a value from this Record, providing a field name.
`<T> T`	`get(java.lang.String fieldName, java.lang.Class<? extends T> type)`	Get a converted value from this Record, providing a field name.
`<U> U`	`get(java.lang.String fieldName, Converter<?,? extends U> converter)`	Get a converted value from this Record, providing a field name.
`<T> T`	`get(Field<?> field, java.lang.Class<? extends T> type)`	Get a converted value from this Record, providing a field.
`<T> T`	`get(Field<T> field)`	Get a value from this Record, providing a field.
`<T,U> U`	`get(Field<T> field, Converter<? super T,? extends U> converter)`	Get a converted value from this Record, providing a field.
`java.lang.Object`	`get(Name fieldName)`	Get a value from this Record, providing a field name.
`<T> T`	`get(Name fieldName, java.lang.Class<? extends T> type)`	Get a converted value from this Record, providing a field name.
`<U> U`	`get(Name fieldName, Converter<?,? extends U> converter)`	Get a converted value from this Record, providing a field name.
`java.lang.Object`	`getValue(int index)`	Get a value from this record, providing a field index.
`<T> T`	`getValue(int index, java.lang.Class<? extends T> type)`	Get a converted value from this record, providing a field index.
`<T> T`	`getValue(int index, java.lang.Class<? extends T> type, T defaultValue)`	Deprecated. - 3.3.0 - [#2878] - This method will be removed in jOOQ 4.0
`java.lang.Object`	`getValue(int index, java.lang.Object defaultValue)`	Deprecated. - 3.3.0 - [#2878] - This method will be removed in jOOQ 4.0
`<U> U`	`getValue(int index, Converter<?,? extends U> converter)`	Get a converted value from this record, providing a field index.
`<U> U`	`getValue(int index, Converter<?,? extends U> converter, U defaultValue)`	Deprecated. - 3.3.0 - [#2878] - This method will be removed in jOOQ 4.0
`java.lang.Object`	`getValue(java.lang.String fieldName)`	Get a value from this Record, providing a field name.
`<T> T`	`getValue(java.lang.String fieldName, java.lang.Class<? extends T> type)`	Get a converted value from this Record, providing a field name.
`<T> T`	`getValue(java.lang.String fieldName, java.lang.Class<? extends T> type, T defaultValue)`	Deprecated. - 3.3.0 - [#2878] - This method will be removed in jOOQ 4.0
`java.lang.Object`	`getValue(java.lang.String fieldName, java.lang.Object defaultValue)`	Deprecated. - 3.3.0 - [#2878] - This method will be removed in jOOQ 4.0
`<U> U`	`getValue(java.lang.String fieldName, Converter<?,? extends U> converter)`	Get a converted value from this Record, providing a field name.
`<U> U`	`getValue(java.lang.String fieldName, Converter<?,? extends U> converter, U defaultValue)`	Deprecated. - 3.3.0 - [#2878] - This method will be removed in jOOQ 4.0
`<T> T`	`getValue(Field<?> field, java.lang.Class<? extends T> type)`	Get a converted value from this Record, providing a field.
`<T> T`	`getValue(Field<?> field, java.lang.Class<? extends T> type, T defaultValue)`	Deprecated. - 3.3.0 - [#2878] - This method will be removed in jOOQ 4.0
`<T> T`	`getValue(Field<T> field)`	Get a value from this Record, providing a field.
`<T,U> U`	`getValue(Field<T> field, Converter<? super T,? extends U> converter)`	Get a converted value from this Record, providing a field.
`<T,U> U`	`getValue(Field<T> field, Converter<? super T,? extends U> converter, U defaultValue)`	Deprecated. - 3.3.0 - [#2878] - This method will be removed in jOOQ 4.0
`<T> T`	`getValue(Field<T> field, T defaultValue)`	Deprecated. - 3.3.0 - [#2878] - This method will be removed in jOOQ 4.0
`java.lang.Object`	`getValue(Name fieldName)`	Get a value from this Record, providing a field name.
`<T> T`	`getValue(Name fieldName, java.lang.Class<? extends T> type)`	Get a converted value from this Record, providing a field name.
`<U> U`	`getValue(Name fieldName, Converter<?,? extends U> converter)`	Get a converted value from this Record, providing a field name.
`int`	`hashCode()`	Get a hash code of this `Record`, based on the underlying row value expression.
`int`	`indexOf(java.lang.String fieldName)`	Get a field's index from this record.
`int`	`indexOf(Field<?> field)`	Get a field's index from this record.
`int`	`indexOf(Name fieldName)`	Get a field's index from this record.
`<E> E`	`into(E object)`	Map resulting records onto a custom type.
`<E> E`	`into(java.lang.Class<? extends E> type)`	Map resulting records onto a custom type.
`Record`	`into(Field<?>... fields)`	Copy this record into a new record holding only a subset of the previous fields.
`<T1> Record1<T1>`	`into(Field<T1> field1)`	Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2> Record2<T1,T2>`	`into(Field<T1> field1, Field<T2> field2)`	Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3> Record3<T1,T2,T3>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3)`	Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4> Record4<T1,T2,T3,T4>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)`	Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5> Record5<T1,T2,T3,T4,T5>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)`	Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6> Record6<T1,T2,T3,T4,T5,T6>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)`	Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7> Record7<T1,T2,T3,T4,T5,T6,T7>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)`	Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8> Record8<T1,T2,T3,T4,T5,T6,T7,T8>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)`	Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9> Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)`	Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)`	Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)`	Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)`	Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)`	Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)`	Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)`	Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)`	Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)`	Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)`	Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)`	Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)`	Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)`	Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)`	Copy this record into a new record holding only a subset of the previous fields.
`<R extends Record> R`	`into(Table<R> table)`	Map resulting records onto a custom record type.
`java.lang.Object[]`	`intoArray()`	Convert this record into an array.
`java.util.List<java.lang.Object>`	`intoList()`	Convert this record into a list.
`java.util.Map<java.lang.String,java.lang.Object>`	`intoMap()`	Return this record as a name/value map.
`java.sql.ResultSet`	`intoResultSet()`	Generate an in-memory JDBC `ResultSet` containing the data of this `Record`.
`java.util.stream.Stream<java.lang.Object>`	`intoStream()`	Convert this record into a stream.
`<E> E`	`map(RecordMapper<Record,E> mapper)`	Map this record into a custom mapper callback.
`Record`	`original()`	Get this record containing the original values as fetched from the database.
`java.lang.Object`	`original(int fieldIndex)`	Get an original value from this record as fetched from the database.
`java.lang.Object`	`original(java.lang.String fieldName)`	Get an original value from this record as fetched from the database.
`<T> T`	`original(Field<T> field)`	Get an original value from this record as fetched from the database.
`java.lang.Object`	`original(Name fieldName)`	Get an original value from this record as fetched from the database.
`void`	`reset()`	Reset all values to their `original()` values and all `changed()` flags to `false`.
`void`	`reset(int fieldIndex)`	Reset a given value to its `original(int)` value and its `changed(int)` flag to `false`.
`void`	`reset(java.lang.String fieldName)`	Reset a given value to its `original(String)` value and its `changed(String)` flag to `false`.
`void`	`reset(Field<?> field)`	Reset a given value to its `original(Field)` value and its `changed(Field)` flag to `false`.
`void`	`reset(Name fieldName)`	Reset a given value to its `original(Name)` value and its `changed(Name)` flag to `false`.
`<T> void`	`set(Field<T> field, T value)`	Set a value into this record.
`<T,U> void`	`set(Field<T> field, U value, Converter<? extends T,? super U> converter)`	Set a value into this record.
`<T> void`	`setValue(Field<T> field, T value)`	Set a value into this record.
`<T,U> void`	`setValue(Field<T> field, U value, Converter<? extends T,? super U> converter)`	Set a value into this record.
`int`	`size()`	Get the number of fields of this record.
`Row`	`valuesRow()`	Get this record's values as a `Row`.
`<T> Record`	`with(Field<T> field, T value)`	Set a value into this record.
`<T,U> Record`	`with(Field<T> field, U value, Converter<? extends T,? super U> converter)`	Set a value into this record.

Methods inherited from interface org.jooq.Attachable
attach, configuration, detach

Methods inherited from interface org.jooq.Formattable
format, format, format, format, format, format, format, format, format, formatChart, formatChart, formatChart, formatChart, formatChart, formatChart, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatHTML, formatHTML, formatHTML, formatInsert, formatInsert, formatInsert, formatInsert, formatInsert, formatInsert, formatJSON, formatJSON, formatJSON, formatJSON, formatJSON, formatJSON, formatXML, formatXML, formatXML, formatXML, formatXML, formatXML, intoXML, intoXML, intoXML, intoXML

Method Detail

fieldsRow
```
Row fieldsRow()
```
Get this record's fields as a Row.

field
```
<T> Field<T> field(Field<T> field)
```
Get a specific field from this Record.
This will return:
- A field that is the same as the argument field (by identity comparison).
- A field that is equal to the argument field (exact matching fully qualified name).
- A field that is equal to the argument field (partially matching qualified name).
- A field whose name is equal to the name of the argument field.
- null otherwise.
If several fields have the same name, the first one is returned and a warning is logged.
See Also:

Row.field(Field)

field
```
Field<?> field(java.lang.String name)
```
Get a specific field from this Record.

See Also:

Row.field(String)

field
```
Field<?> field(Name name)
```
Get a specific qualified field from this Record.

See Also:

Row.field(Name)

field
```
Field<?> field(int index)
```
Get a specific field from this Record.

See Also:

Row.field(int)

fields
```
Field<?>[] fields()
```
Get all fields from this Record.

See Also:

Row.fields()

fields
```
Field<?>[] fields(Field<?>... fields)
```
Get all fields from this Record, providing some fields.

Returns:

All available fields

See Also:

Row.fields(Field...)

fields
```
Field<?>[] fields(java.lang.String... fieldNames)
```
Get all fields from this Record, providing some field names.

Returns:

All available fields

See Also:

Row.fields(String...)

fields
```
Field<?>[] fields(Name... fieldNames)
```
Get all fields from this Record, providing some field names.

Returns:

All available fields

See Also:

Row.fields(Name...)

fields
```
Field<?>[] fields(int... fieldIndexes)
```
Get all fields from this Record, providing some field indexes.

Returns:

All available fields

See Also:

Row.fields(int...)

indexOf
```
int indexOf(Field<?> field)
```
Get a field's index from this record.

Parameters:

field - The field to look for

Returns:

The field's index or -1 if the field is not contained in this record.

indexOf
```
int indexOf(java.lang.String fieldName)
```
Get a field's index from this record.

Parameters:

fieldName - The field name to look for

Returns:

The field's index or -1 if the field is not contained in this record.

indexOf
```
int indexOf(Name fieldName)
```
Get a field's index from this record.

Parameters:

fieldName - The field name to look for

Returns:

The field's index or -1 if the field is not contained in this record

valuesRow
```
Row valuesRow()
```
Get this record's values as a Row.

get
```
<T> T get(Field<T> field)
 throws java.lang.IllegalArgumentException
```
Get a value from this Record, providing a field.
If this record contains a field with the same Field.getName() as the argument field, that value is retrieved.

Type Parameters:

T - The generic field parameter

Parameters:

field - The field

Returns:

The value of a field contained in this record

Throws:

java.lang.IllegalArgumentException - If the argument field is not contained in fieldsRow()

get
```
<T> T get(Field<?> field,
 java.lang.Class<? extends T> type)
 throws java.lang.IllegalArgumentException,
 DataTypeException
```
Get a converted value from this Record, providing a field.
If this record contains a field with the same Field.getName() as the argument field, that value is retrieved.

Type Parameters:

T - The conversion type parameter

Parameters:

field - The field

type - The conversion type

Returns:

The value of a field contained in this record

Throws:

java.lang.IllegalArgumentException - If the argument field is not contained in fieldsRow()

DataTypeException - wrapping any data type conversion exception that might have occurred

DataTypeException - wrapping any data type conversion exception that might have occurred

See Also:

Convert.convert(Object, Class)

get
```
<T,U> U get(Field<T> field,
 Converter<? super T,? extends U> converter)
 throws java.lang.IllegalArgumentException,
 DataTypeException
```
Get a converted value from this Record, providing a field.
If this record contains a field with the same Field.getName() as the argument field, that value is retrieved.

Type Parameters:

T - The database type parameter

U - The conversion type parameter

Parameters:

field - The field

converter - The data type converter

Returns:

The value of a field contained in this record

Throws:

java.lang.IllegalArgumentException - If the argument field is not contained in fieldsRow()

DataTypeException - wrapping any data type conversion exception that might have occurred

See Also:

Convert.convert(Object, Converter)

get
```
java.lang.Object get(java.lang.String fieldName)
              throws java.lang.IllegalArgumentException
```
Get a value from this Record, providing a field name.

Parameters:

fieldName - The field's name

Returns:

The value of a field's name contained in this record

Throws:

java.lang.IllegalArgumentException - If the argument fieldName is not contained in the record

get
```
<T> T get(java.lang.String fieldName,
 java.lang.Class<? extends T> type)
 throws java.lang.IllegalArgumentException,
 DataTypeException
```
Get a converted value from this Record, providing a field name.

Type Parameters:

T - The conversion type parameter

Parameters:

fieldName - The field's name

type - The conversion type

Returns:

The value of a field's name contained in this record

Throws:

java.lang.IllegalArgumentException - If the argument fieldName is not contained in the record

DataTypeException - wrapping any data type conversion exception that might have occurred

See Also:

Convert.convert(Object, Class)

get
```
 U get(java.lang.String fieldName,
 Converter<?,? extends U> converter)
 throws java.lang.IllegalArgumentException,
 DataTypeException
```
Get a converted value from this Record, providing a field name.

Type Parameters:

U - The conversion type parameter

Parameters:

fieldName - The field's name

converter - The data type converter

Returns:

The value of a field's name contained in this record

Throws:

java.lang.IllegalArgumentException - If the argument fieldName is not contained in the record

DataTypeException - wrapping any data type conversion exception that might have occurred

See Also:

Convert.convert(Object, Converter)

get
```
java.lang.Object get(Name fieldName)
              throws java.lang.IllegalArgumentException
```
Get a value from this Record, providing a field name.

Parameters:

fieldName - The field's name

Returns:

The value of a field's name contained in this record

Throws:

java.lang.IllegalArgumentException - If the argument fieldName is not contained in the record

get
```
<T> T get(Name fieldName,
 java.lang.Class<? extends T> type)
 throws java.lang.IllegalArgumentException,
 DataTypeException
```
Get a converted value from this Record, providing a field name.

Type Parameters:

T - The conversion type parameter

Parameters:

fieldName - The field's name

type - The conversion type

Returns:

The value of a field's name contained in this record

Throws:

java.lang.IllegalArgumentException - If the argument fieldName is not contained in the record

DataTypeException - wrapping any data type conversion exception that might have occurred

See Also:

Convert.convert(Object, Class)

get
```
 U get(Name fieldName,
 Converter<?,? extends U> converter)
 throws java.lang.IllegalArgumentException,
 DataTypeException
```
Get a converted value from this Record, providing a field name.

Type Parameters:

U - The conversion type parameter

Parameters:

fieldName - The field's name

converter - The data type converter

Returns:

The value of a field's name contained in this record

Throws:

java.lang.IllegalArgumentException - If the argument fieldName is not contained in the record

DataTypeException - wrapping any data type conversion exception that might have occurred

See Also:

Convert.convert(Object, Converter)

get
```
java.lang.Object get(int index)
              throws java.lang.IllegalArgumentException
```
Get a value from this record, providing a field index.

Parameters:

index - The field's index

Returns:

The value of a field's index contained in this record

Throws:

java.lang.IllegalArgumentException - If the argument index is not contained in the record

get
```
<T> T get(int index,
 java.lang.Class<? extends T> type)
 throws java.lang.IllegalArgumentException,
 DataTypeException
```
Get a converted value from this record, providing a field index.

Type Parameters:

T - The conversion type parameter

Parameters:

index - The field's index

type - The conversion type

Returns:

The value of a field's index contained in this record

Throws:

java.lang.IllegalArgumentException - If the argument index is not contained in the record

DataTypeException - wrapping data type conversion exception that might have occurred

See Also:

Convert.convert(Object, Class)

get
```
 U get(int index,
 Converter<?,? extends U> converter)
 throws java.lang.IllegalArgumentException,
 DataTypeException
```
Get a converted value from this record, providing a field index.

Type Parameters:

U - The conversion type parameter

Parameters:

index - The field's index

converter - The data type converter

Returns:

The value of a field's index contained in this record

Throws:

java.lang.IllegalArgumentException - If the argument index is not contained in the record

DataTypeException - wrapping data type conversion exception that might have occurred

See Also:

Convert.convert(Object, Converter)

set
```
<T> void set(Field<T> field,
 T value)
```
Set a value into this record.
This will always set the changed(Field) flag for the given field, no matter if setting the value actually changes the value.
Changing Table.getPrimaryKey() values will set all changed() flags to true, in order to produce complete INSERT statements on subsequent UpdatableRecord.store() operations.

Type Parameters:

T - The generic field parameter

Parameters:

field - The field

value - The value

set
```
<T,U> void set(Field<T> field,
 U value,
 Converter<? extends T,? super U> converter)
```
Set a value into this record.
This will always set the changed(Field) flag for the given field, no matter if setting the value actually changes the value.
Changing Table.getPrimaryKey() values will set all changed() flags to true, in order to produce complete INSERT statements on subsequent UpdatableRecord.store() operations.

Type Parameters:

T - The generic field parameter

U - The conversion type parameter

Parameters:

field - The field

value - The value

converter - The converter used to convert value into an appropriate type

with
```
<T> Record with(Field<T> field,
 T value)
```
Set a value into this record.
Like set(Field, Object) but returning this for fluent setting of multiple values.

with

<T,U> Record with(Field<T> field,
                        U value,
                        Converter<? extends T,? super U> converter)

Set a value into this record.

Like set(Field, Object, Converter) but returning this for fluent setting of multiple values.

size
```
int size()
```
Get the number of fields of this record.

original
```
Record original()
```
Get this record containing the original values as fetched from the database.
Record values can be freely modified after having fetched a record from the database. Every record also references the originally fetched values. This method returns a new record containing those original values.

See Also:

original(Field), original(int), original(String)

original
```
<T> T original(Field<T> field)
```
Get an original value from this record as fetched from the database.
Record values can be freely modified after having fetched a record from the database. Every record also references the originally fetched values. This method returns such an original value for a field.

See Also:

original()

original
```
java.lang.Object original(int fieldIndex)
```
Get an original value from this record as fetched from the database.
Record values can be freely modified after having fetched a record from the database. Every record also references the originally fetched values. This method returns such an original value for a field.

See Also:

original()

original
```
java.lang.Object original(java.lang.String fieldName)
```
Get an original value from this record as fetched from the database.
Record values can be freely modified after having fetched a record from the database. Every record also references the originally fetched values. This method returns such an original value for a field.

See Also:

original()

original
```
java.lang.Object original(Name fieldName)
```
Get an original value from this record as fetched from the database.
Record values can be freely modified after having fetched a record from the database. Every record also references the originally fetched values. This method returns such an original value for a field.

See Also:

original()

changed
```
boolean changed()
```
Check if this record has been changed from its original as fetched from the database.
If this returns false, then it can be said that record.equals(record.original()) is true.

See Also:

original(), changed(Field), changed(int), changed(String)

changed
```
boolean changed(Field<?> field)
```
Check if a field's value has been changed from its original as fetched from the database.

See Also:

changed(), original(Field)

changed
```
boolean changed(int fieldIndex)
```
Check if a field's value has been changed from its original as fetched from the database.

See Also:

changed(), original(int)

changed
```
boolean changed(java.lang.String fieldName)
```
Check if a field's value has been changed from its original as fetched from the database.

See Also:

changed(), original(String)

changed
```
boolean changed(Name fieldName)
```
Check if a field's value has been changed from its original as fetched from the database.

See Also:

changed(), original(Name)

changed
```
void changed(boolean changed)
```
Set all of this record's internal changed flags to the supplied value.
If the changed argument is false, the original() values will be reset to the corresponding "current" values as well

See Also:

changed(), changed(Field, boolean), changed(int, boolean), changed(String, boolean)

changed
```
void changed(Field<?> field,
 boolean changed)
```
Set this record's internal changed flag to the supplied value for a given field.
If the changed argument is false, the original(Field) value will be reset to the corresponding "current" value as well

See Also:

changed(), changed(Field)

changed
```
void changed(int fieldIndex,
             boolean changed)
```
Set this record's internal changed flag to the supplied value for a given field.
If the changed argument is false, the original(int) value will be reset to the corresponding "current" value as well

See Also:

changed(), changed(int)

changed
```
void changed(java.lang.String fieldName,
             boolean changed)
```
Set this record's internal changed flag to the supplied value for a given field.
If the changed argument is false, the original(String) value will be reset to the corresponding "current" value as well

See Also:

changed(), changed(String)

changed
```
void changed(Name fieldName,
             boolean changed)
```
Set this record's internal changed flag to the supplied value for a given field.
If the changed argument is false, the original(Name) value will be reset to the corresponding "current" value as well

See Also:

changed(), changed(Name)

reset
```
void reset()
```
Reset all values to their original() values and all changed() flags to false.

reset
```
void reset(Field<?> field)
```
Reset a given value to its original(Field) value and its changed(Field) flag to false.

reset
```
void reset(int fieldIndex)
```
Reset a given value to its original(int) value and its changed(int) flag to false.

reset
```
void reset(java.lang.String fieldName)
```
Reset a given value to its original(String) value and its changed(String) flag to false.

reset
```
void reset(Name fieldName)
```
Reset a given value to its original(Name) value and its changed(Name) flag to false.

intoArray
```
java.lang.Object[] intoArray()
```
Convert this record into an array.
The resulting array has the same number of elements as this record has fields. The resulting array contains data as such:
```
 // For arbitrary values of i
 record.getValue(i) == record.intoArray()[i]
 
```
This is the same as calling into(Object[].class)
Returns:

This record as an array

See Also:

fromArray(Object...)

intoList
```
java.util.List<java.lang.Object> intoList()
```
Convert this record into a list.
The resulting list has the same number of elements as this record has fields. The resulting array contains data as such:
```
 // For arbitrary values of i
 record.getValue(i) == record.intoList().get(i)
 
```
This is the same as calling Arrays.asList(intoArray())

intoStream
```
java.util.stream.Stream<java.lang.Object> intoStream()
```
Convert this record into a stream.
The resulting stream has the same number of elements as this record has fields. The resulting stream contains data as such:
This is the same as calling into(Stream.class)

Returns:

This record as a stream

intoMap
```
java.util.Map<java.lang.String,java.lang.Object> intoMap()
```
Return this record as a name/value map.
This is the inverse operation to fromMap(Map)

Returns:

This record as a map

See Also:

fromMap(Map)

into
```
Record into(Field<?>... fields)
```
Copy this record into a new record holding only a subset of the previous fields.

Parameters:

fields - The fields of the new record

Returns:

The new record

into
```
<T1> Record1<T1> into(Field<T1> field1)
```
Copy this record into a new record holding only a subset of the previous fields.

Returns:

The new record

See Also:

into(Table)