Top Description Methods
org.jooq

public Interface Record

extends Fields, Attachable, Comparable<Record>, Formattable
Known Direct Subinterfaces
org.jooq.Record1, org.jooq.Record10, org.jooq.Record11, org.jooq.Record12, org.jooq.Record13, org.jooq.Record14, org.jooq.Record15, org.jooq.Record16, org.jooq.Record17, org.jooq.Record18, org.jooq.Record19, org.jooq.Record2, org.jooq.Record20, org.jooq.Record21, org.jooq.Record22, org.jooq.Record3, org.jooq.Record4, org.jooq.Record5, org.jooq.Record6, org.jooq.Record7, org.jooq.Record9, org.jooq.EmbeddableRecord, org.jooq.Record8, org.jooq.impl.InternalRecord, org.jooq.QualifiedRecord
Known Direct Implementers
org.jooq.impl.AbstractRecord
Imports
java.lang.reflect.Constructor, java.sql.PreparedStatement, .ResultSet, .SQLData, .Statement, java.util.List, .Map, java.util.stream.Stream, jakarta.persistence.Column, org.jooq.exception.DataTypeException, .MappingException, org.jooq.impl.DefaultRecordMapper, .DefaultRecordMapperProvider, org.jetbrains.annotations.NotNull, .Nullable
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.

Importing Record

Starting from Java 14, the Record type conflicts with java.lang.Record, which is always imported by default. According to Java Language Specification, this means that jOOQ's Record type can no longer be imported on demand. This is not sufficient: 


import org.jooq.*;
You have to do this instead: 

import org.jooq.*;
import org.jooq.Record;
Author
Lukas Eder
See Also
Result

Method Summary

Modifier and TypeMethod and Description
public boolean
changed()

Check if this record has been changed from its original as fetched from the database.

public boolean
changed(Field<?> field)

Deprecated as a consequence of Field being deprecated.
Check if a field's value has been changed from its original as fetched from the database, using field(Field) for lookup.
public boolean
changed(int
The 0-based field index in this record.
fieldIndex)

Check if a field's value has been changed from its original as fetched from the database.

public boolean
changed(String fieldName)

Check if a field's value has been changed from its original as fetched from the database, using field(String) for lookup.

public boolean
changed(Name fieldName)

Check if a field's value has been changed from its original as fetched from the database, using field(Name) for lookup.

public void
changed(boolean changed)

Set all of this record's internal changed flags to the supplied value.

public void
changed(Field<?> field, boolean changed)

Deprecated as a consequence of Field being deprecated.
Set this record's internal changed flag to the supplied value for a given field, using field(Field) for lookup.
public void
changed(int
The 0-based field index in this record.
fieldIndex, boolean changed)

Set this record's internal changed flag to the supplied value for a given field.

public void
changed(String fieldName, boolean changed)

Set this record's internal changed flag to the supplied value for a given field, using field(String) for lookup.

public void
changed(Name fieldName, boolean changed)

Set this record's internal changed flag to the supplied value for a given field, using field(Name) for lookup.

public int
compareTo(Record
the object to be compared.
record)

Redeclares java.lang.Comparable.compareTo.

Compares this Record with another Record according to their natural ordering.
public boolean

Returns:

Whether the two records are equal
equals(Object
The other record
other)

Compare this Record with another Record for equality.

public void
from(Object
The source object to copy data from
source)

Load data into this record from a source.

public void
from(Object
The source object to copy data from
source, Field<?>...
The record's fields to use for mapping
fields)

Deprecated as a consequence of Field being deprecated.
Load data into this record from a source, providing some fields, using field(Field) for lookup.
public void
from(Object
The source object to copy data from
source, String...
The record's fields names to use for mapping
fieldNames)

Load data into this record from a source, providing some field names, using field(String) for lookup.

public void
from(Object
The source object to copy data from
source, Name...
The record's fields names to use for mapping
fieldNames)

Load data into this record from a source, providing some field names, using field(Name) for lookup.

public void
from(Object
The source object to copy data from
source, int...
The record's 0-based field indexes to use for mapping
fieldIndexes)

Load data into this record from a source, providing some field indexes.

public void
fromArray(Object... array)

Load data from an array into this record.

public void
fromArray(Object[] array, Field<?>... fields)

Deprecated as a consequence of Field being deprecated.
Load data from an array into this record, providing some fields, using field(Field) for lookup.
public void
fromArray(Object[] array, String... fieldNames)

Load data from an array into this record, providing some fields names, using field(String) for lookup.

public void
fromArray(Object[] array, Name... fieldNames)

Load data from an array into this record, providing some fields names, using field(Name) for lookup.

public void
fromArray(Object[] array, int...
The 0-based field indexes in this record.
fieldIndexes)

Load data from an array into this record, providing some fields indexes.

public void
fromMap(Map<String, ?> map)

Load data from a map into this record, using field(String) for lookup.

public void
fromMap(Map<String, ?> map, Field<?>... fields)

Deprecated as a consequence of Field being deprecated.
Load data from a map into this record, providing some fields, using field(Field) for lookup.
public void
fromMap(Map<String, ?> map, String... fieldNames)

Load data from a map into this record, providing some field names, using field(String) for lookup.

public void
fromMap(Map<String, ?> map, Name... fieldNames)

Load data from a map into this record, providing some field names, using field(Name) for lookup.

public void
fromMap(Map<String, ?> map, int...
The 0-based field indexes in this record.
fieldIndexes)

Load data from a map into this record, providing some field indexes.

public <
The generic field parameter
T> T

Returns:

The value of a field contained in this record
get(Field<T>
The field
field)

Deprecated as a consequence of Field being deprecated.
Get a value from this Record, providing a field, using field(Field) for lookup.
public <
The conversion type parameter
U> U

Returns:

The value of a field contained in this record
get(Field<?>
The field
field, Class<? extends U>
The conversion type
type)

Deprecated as a consequence of Field being deprecated.
Get a converted value from this Record, providing a field, using field(Field) for lookup.
public <
The database type parameter
T,
The conversion type parameter
U> U

Returns:

The value of a field contained in this record
get(Field<T>
The field
field, Converter<? super T, ? extends U>
The data type converter
converter)

Deprecated as a consequence of Field being deprecated.
Get a converted value from this Record, providing a field, using field(Field) for lookup.
public @Nullable Object

Returns:

The value of a field's name contained in this record
get(String
The field's name
fieldName)

Get a value from this Record, providing a field name, using field(String) for lookup.

public <
The conversion type parameter
U> U

Returns:

The value of a field's name contained in this record
get(String
The field's name
fieldName, Class<? extends U>
The conversion type
type)

Get a converted value from this Record, providing a field name, using field(String) for lookup.

public <
The conversion type parameter
U> U

Returns:

The value of a field's name contained in this record
get(String
The field's name
fieldName, Converter<?, ? extends U>
The data type converter
converter)

Get a converted value from this Record, providing a field name, using field(String) for lookup.

public @Nullable Object

Returns:

The value of a field's name contained in this record
get(Name
The field's name
fieldName)

Get a value from this Record, providing a field name, using field(Name) for lookup.

public <
The conversion type parameter
U> U

Returns:

The value of a field's name contained in this record
get(Name
The field's name
fieldName, Class<? extends U>
The conversion type
type)

Get a converted value from this Record, providing a field name, using field(Name) for lookup.

public <
The conversion type parameter
U> U

Returns:

The value of a field's name contained in this record
get(Name
The field's name
fieldName, Converter<?, ? extends U>
The data type converter
converter)

Get a converted value from this Record, providing a field name, using field(Name) for lookup.

public @Nullable Object

Returns:

The value of a field's index contained in this record
get(int
The 0-based field index in this record.
index)

Get a value from this record, providing a field index.

public <
The conversion type parameter
U> U

Returns:

The value of a field's index contained in this record
get(int
The 0-based field index in this record.
index, Class<? extends U>
The conversion type
type)

Get a converted value from this record, providing a field index.

public <
The conversion type parameter
U> U

Returns:

The value of a field's index contained in this record
get(int
The 0-based field index in this record.
index, Converter<?, ? extends U>
The data type converter
converter)

Get a converted value from this record, providing a field index.

public <T> T
getValue(Field<T> field)

Deprecated as a consequence of Field being deprecated.
Get a value from this Record, providing a field, using field(Field) for lookup.
public <T> T
getValue(Field<?> field, Class<? extends T> type)

Deprecated as a consequence of Field being deprecated.
Get a converted value from this Record, providing a field, using field(Field) for lookup.
public <T, U> U
getValue(Field<T> field, Converter<? super T, ? extends U> converter)

Deprecated as a consequence of Field being deprecated.
Get a converted value from this Record, providing a field, using field(Field) for lookup.
public Object
getValue(String fieldName)

Get a value from this Record, providing a field name, using field(String) for lookup.

public <T> T
getValue(String fieldName, Class<? extends T> type)

Get a converted value from this Record, providing a field name, using field(String) for lookup.

public <U> U
getValue(String fieldName, Converter<?, ? extends U> converter)

Get a converted value from this Record, providing a field name, using field(String) for lookup.

public Object
getValue(Name fieldName)

Get a value from this Record, providing a field name, using field(Name) for lookup.

public <T> T
getValue(Name fieldName, Class<? extends T> type)

Get a converted value from this Record, providing a field name, using field(Name) for lookup.

public <U> U
getValue(Name fieldName, Converter<?, ? extends U> converter)

Get a converted value from this Record, providing a field name, using field(Name) for lookup.

public Object
getValue(int
The 0-based field index in this record.
index)

Get a value from this record, providing a field index.

public <T> T
getValue(int
The 0-based field index in this record.
index, Class<? extends T> type)

Get a converted value from this record, providing a field index.

public <U> U
getValue(int
The 0-based field index in this record.
index, Converter<?, ? extends U> converter)

Get a converted value from this record, providing a field index.

public int

Returns:

A hash code value for this record
hashCode()

Get a hash code of this Record, based on the underlying row value expression.

public @NotNull Record

Returns:

The new record
into(Field<?>...
The fields of the new record
fields)

Deprecated as a consequence of Field being deprecated.
Copy this record into a new record holding only a subset of the previous fields, using field(Field) for lookup.
public <T1> @NotNull Record1<T1>

Returns:

The new record
into(Field<T1> field1)

Deprecated as a consequence of Field being deprecated.
Copy this record into a new record holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2> @NotNull Record2<T1, T2>

Returns:

The new record
into(Field<T1> field1, Field<T2> field2)

Deprecated as a consequence of Field being deprecated.
Copy this record into a new record holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3> @NotNull Record3<T1, T2, T3>

Returns:

The new record
into(Field<T1> field1, Field<T2> field2, Field<T3> field3)

Deprecated as a consequence of Field being deprecated.
Copy this record into a new record holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4> @NotNull Record4<T1, T2, T3, T4>

Returns:

The new record
into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)

Deprecated as a consequence of Field being deprecated.
Copy this record into a new record holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5> @NotNull Record5<T1, T2, T3, T4, T5>

Returns:

The new record
into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)

Deprecated as a consequence of Field being deprecated.
Copy this record into a new record holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6> @NotNull Record6<T1, T2, T3, T4, T5, T6>

Returns:

The new record
into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)

Deprecated as a consequence of Field being deprecated.
Copy this record into a new record holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7> @NotNull Record7<T1, T2, T3, T4, T5, T6, T7>

Returns:

The new record
into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)

Deprecated as a consequence of Field being deprecated.
Copy this record into a new record holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8> @NotNull Record8<T1, T2, T3, T4, T5, T6, T7, T8>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Copy this record into a new record holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9> @NotNull Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Copy this record into a new record holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> @NotNull Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Copy this record into a new record holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> @NotNull Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Copy this record into a new record holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> @NotNull Record12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Copy this record into a new record holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> @NotNull Record13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Copy this record into a new record holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> @NotNull Record14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Copy this record into a new record holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> @NotNull Record15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Copy this record into a new record holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> @NotNull Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Copy this record into a new record holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> @NotNull Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Copy this record into a new record holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> @NotNull Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Copy this record into a new record holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> @NotNull Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Copy this record into a new record holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> @NotNull Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Copy this record into a new record holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> @NotNull Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Copy this record into a new record holding only a subset of the previous fields, using field(Field) for lookup.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> @NotNull Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>

Returns:

The new record
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)

Deprecated as a consequence of Field being deprecated.
Copy this record into a new record holding only a subset of the previous fields, using field(Field) for lookup.
public <
The generic entity type.
E> E
into(Class<? extends E>
The entity type.
type)

Map resulting records onto a custom type.

public <
The generic entity type.
E> E
into(E
The receiving POJO, array, record, etc.
object)

Map resulting records onto a custom type.

public <
The generic table record type.
R extends Record> R
into(Table<R>
The table type.
table)

Map resulting records onto a custom record type.

public @NotNull @Nullable Object[]

Returns:

This record as an array
intoArray()

Convert this record into an array.

public @NotNull List<Object>
intoList()

Convert this record into a list.

public @NotNull Map<String, Object>

Returns:

This record as a map
intoMap()

Return this record as a name/value map.

public @NotNull ResultSet

Returns:

A wrapper JDBC ResultSet
intoResultSet()

Generate an in-memory JDBC ResultSet containing the data of this Record.

public @NotNull Stream<Object>

Returns:

This record as a stream
intoStream()

Convert this record into a stream.

public <E> E

Returns:

The custom mapped record
map(RecordMapper<Record, E>
The mapper callback
mapper)

Map this record into a custom mapper callback.

public @NotNull Record
original()

Get this record containing the original values as fetched from the database.

public <T> T
original(Field<T> field)

Deprecated as a consequence of Field being deprecated.
Get an original value from this record as fetched from the database, using field(Field) for lookup.
public @Nullable Object
original(int
The 0-based field index in this record.
fieldIndex)

Get an original value from this record as fetched from the database.

public @Nullable Object
original(String fieldName)

Get an original value from this record as fetched from the database, using field(String) for lookup.

public @Nullable Object
original(Name fieldName)

Get an original value from this record as fetched from the database, using field(Name) for lookup.

public void
reset()

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

public void
reset(Field<?> field)

Deprecated as a consequence of Field being deprecated.
Reset a given value to its original(Field) value and its changed(Field) flag to false, using field(Field) for lookup.
public void
reset(int
The 0-based field index in this record.
fieldIndex)

Reset a given value to its original(int) value and its changed(int) flag to false.

public void
reset(String fieldName)

Reset a given value to its original(String) value and its changed(String) flag to false, using field(String) for lookup.

public void
reset(Name fieldName)

Reset a given value to its original(Name) value and its changed(Name) flag to false, using field(Name) for lookup.

public <
The generic field parameter
T> void
set(Field<T>
The field
field, T
The value
value)

Deprecated as a consequence of Field being deprecated.
Set a value into this record, using field(Field) for lookup.
public <
The generic field parameter
T,
The conversion type parameter
U> void
set(Field<T>
The field
field, U
The value
value, Converter<? extends T, ? super U>
The converter used to convert value into an appropriate type
converter)

Deprecated as a consequence of Field being deprecated.
Set a value into this record, using field(Field) for lookup.
public <T> void
setValue(Field<T> field, T value)

Deprecated as a consequence of Field being deprecated.
Set a value into this record, using field(Field) for lookup.
public <T, U> void
setValue(Field<T> field, U value, Converter<? extends T, ? super U> converter)

Deprecated as a consequence of Field being deprecated.
Set a value into this record, using field(Field) for lookup.
public int
size()

Get the number of fields of this record.

public @NotNull Row
valuesRow()

Get this record's values as a Row.

public <T> @NotNull Record
with(Field<T> field, T value)

Deprecated as a consequence of Field being deprecated.
Set a value into this record, using field(Field) for lookup.
public <T, U> @NotNull Record
with(Field<T> field, U value, Converter<? extends T, ? super U> converter)

Deprecated as a consequence of Field being deprecated.
Set a value into this record, using field(Field) for lookup.
Inherited from org.jooq.Attachable:
attachconfigurationdetach
Inherited from org.jooq.Fields:
dataTypedataTypedataTypedataTypesfieldfieldfieldfieldfieldfieldfieldfieldfieldfieldfieldsfieldsfieldsfieldsfieldsfieldsRowfieldStreamindexOfindexOfindexOftypetypetypetypes
Inherited from org.jooq.Formattable:
formatformatformatformatformatformatformatformatformatformatChartformatChartformatChartformatChartformatChartformatChartformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatCSVformatHTMLformatHTMLformatHTMLformatInsertformatInsertformatInsertformatInsertformatInsertformatInsertformatJSONformatJSONformatJSONformatJSONformatJSONformatJSONformatXMLformatXMLformatXMLformatXMLformatXMLformatXMLintoXMLintoXMLintoXMLintoXML