- java.lang.Object
- 
- org.jooq.impl.TableRecordImpl<R>
- 
- org.jooq.impl.UpdatableRecordImpl<R>
 
 
- 
- All Implemented Interfaces:
- Serializable,- Comparable<Record>,- Attachable,- Formattable,- Record,- TableRecord<R>,- UpdatableRecord<R>
 
 @Internal public class UpdatableRecordImpl<R extends UpdatableRecord<R>> extends TableRecordImpl<R> implements UpdatableRecord<R> A record implementation for a record holding a primary keyThis type is for JOOQ INTERNAL USE only. Do not reference directly - Author:
- Lukas Eder
- See Also:
- Serialized Form
 
- 
- 
Constructor SummaryConstructors Constructor Description UpdatableRecordImpl(Table<R> table)
 - 
Method SummaryAll Methods Instance Methods Concrete Methods Deprecated Methods Modifier and Type Method Description voidattach(Configuration c)Attach this object to a newConfiguration.booleanchanged()Check if this record has been changed from its original as fetched from the database.voidchanged(boolean c)Set all of this record's internal changed flags to the supplied value.booleanchanged(int fieldIndex)Check if a field's value has been changed from its original as fetched from the database.voidchanged(int fieldIndex, boolean c)Set this record's internal changed flag to the supplied value for a given field.booleanchanged(String fieldName)Check if a field's value has been changed from its original as fetched from the database.voidchanged(String fieldName, boolean c)Set this record's internal changed flag to the supplied value for a given field.booleanchanged(Field<?> field)Check if a field's value has been changed from its original as fetched from the database.voidchanged(Field<?> field, boolean c)Set this record's internal changed flag to the supplied value for a given field.booleanchanged(Name fieldName)Check if a field's value has been changed from its original as fetched from the database.voidchanged(Name fieldName, boolean c)Set this record's internal changed flag to the supplied value for a given field.intcompareTo(Record that)Compares thisRecordwith anotherRecordaccording to their natural ordering.Configurationconfiguration()Rcopy()Duplicate this record (in memory) and reset all fields from the primary key or main unique key, such that a subsequent call toUpdatableRecord.store()will result in anINSERTstatement.protected DSLContextcreate()Deprecated.- 3.11.0 - [#6720] [#6721] - UseAttachable.configuration()andConfiguration.dsl()instead.intdelete()Deletes this record from the database, based on the value of the primary key or main unique key.voiddetach()Detach this object from its currentConfiguration.booleanequals(Object obj)<O extends TableRecord<O>>
 OfetchChild(ForeignKey<O,R> key)Fetch a child record of this record, given a foreign key.<O extends TableRecord<O>>
 Result<O>fetchChildren(ForeignKey<O,R> key)Fetch child records of this record, given a foreign key.Field<?>field(int index)Get a specific field from this Record.Field<?>field(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(String... fieldNames)Get all fields from this Record, providing some field names.Field<?>[]fields(Field<?>... f)Get all fields from this Record, providing some fields.Field<?>[]fields(Name... fieldNames)Get all fields from this Record, providing some field names.Stringformat()Get a simple formatted representation of this result.Stringformat(int maxRecords)Get a simple formatted representation of this result.voidformat(OutputStream stream)LikeFormattable.format(), but the data is output onto anOutputStream.voidformat(OutputStream stream, int maxRecords)LikeFormattable.format(int), but the data is output onto anOutputStream.voidformat(OutputStream stream, TXTFormat format)LikeFormattable.format(TXTFormat), but the data is output onto anOutputStream.voidformat(Writer writer)LikeFormattable.format(), but the data is output onto aWriter.voidformat(Writer writer, int maxRecords)LikeFormattable.format(int), but the data is output onto aWriter.voidformat(Writer writer, TXTFormat format)LikeFormattable.format(TXTFormat), but the data is output onto aWriter.Stringformat(TXTFormat format)Get a simple formatted representation of this result.StringformatChart()voidformatChart(OutputStream stream)LikeFormattable.formatChart(), but the data is output onto anOutputStream.voidformatChart(OutputStream stream, ChartFormat format)LikeFormattable.formatChart(ChartFormat), but the data is output onto anOutputStream.voidformatChart(Writer writer)LikeFormattable.formatChart(), but the data is output onto aWriter.voidformatChart(Writer writer, ChartFormat format)LikeFormattable.formatChart(ChartFormat), but the data is output onto aWriter.StringformatChart(ChartFormat format)StringformatCSV()Get a simple formatted representation of this result as CSV.StringformatCSV(boolean header)Get a simple formatted representation of this result as CSV.StringformatCSV(boolean header, char delimiter)Get a simple formatted representation of this result as CSV.StringformatCSV(boolean header, char delimiter, String nullString)Get a simple formatted representation of this result as CSV.StringformatCSV(char delimiter)Get a simple formatted representation of this result as CSV.StringformatCSV(char delimiter, String nullString)Get a simple formatted representation of this result as CSV.voidformatCSV(OutputStream stream)LikeFormattable.formatCSV(), but the data is output onto anOutputStream.voidformatCSV(OutputStream stream, boolean header)LikeFormattable.formatCSV(boolean), but the data is output onto anOutputStream.voidformatCSV(OutputStream stream, boolean header, char delimiter)LikeFormattable.formatCSV(boolean, char), but the data is output onto anOutputStream.voidformatCSV(OutputStream stream, boolean header, char delimiter, String nullString)LikeFormattable.formatCSV(boolean, char, String), but the data is output onto anOutputStream.voidformatCSV(OutputStream stream, char delimiter)LikeFormattable.formatCSV(char), but the data is output onto anOutputStream.voidformatCSV(OutputStream stream, char delimiter, String nullString)LikeFormattable.formatCSV(char, String), but the data is output onto anOutputStream.voidformatCSV(OutputStream stream, CSVFormat format)LikeFormattable.formatCSV(CSVFormat), but the data is output onto anOutputStream.voidformatCSV(Writer writer)LikeFormattable.formatCSV(), but the data is output onto aWriter.voidformatCSV(Writer writer, boolean header)LikeFormattable.formatCSV(boolean), but the data is output onto aWriter.voidformatCSV(Writer writer, boolean header, char delimiter)LikeFormattable.formatCSV(boolean, char), but the data is output onto aWriter.voidformatCSV(Writer writer, boolean header, char delimiter, String nullString)LikeFormattable.formatCSV(boolean, char, String), but the data is output onto aWriter.voidformatCSV(Writer writer, char delimiter)LikeFormattable.formatCSV(char), but the data is output onto aWriter.voidformatCSV(Writer writer, char delimiter, String nullString)LikeFormattable.formatCSV(char, String), but the data is output onto aWriter.voidformatCSV(Writer writer, CSVFormat format)LikeFormattable.formatCSV(CSVFormat), but the data is output onto aWriter.StringformatCSV(CSVFormat format)Get a simple formatted representation of this result as CSV.StringformatHTML()Get a simple formatted representation of this result as HTML.voidformatHTML(OutputStream stream)LikeFormattable.formatHTML(), but the data is output onto anOutputStream.voidformatHTML(Writer writer)LikeFormattable.formatHTML(), but the data is output onto aWriter.StringformatInsert()Get this result as a set ofINSERTstatements.voidformatInsert(OutputStream stream)LikeFormattable.formatInsert(), but the data is output onto anOutputStream.voidformatInsert(OutputStream stream, Table<?> table, Field<?>... f)LikeFormattable.formatInsert(Table, Field...), but the data is output onto anOutputStream.voidformatInsert(Writer writer)LikeFormattable.formatInsert(), but the data is output onto aWriter.voidformatInsert(Writer writer, Table<?> table, Field<?>... f)LikeFormattable.formatInsert(Table, Field...), but the data is output onto anWriter.StringformatInsert(Table<?> table, Field<?>... f)Get this result as a set ofINSERTstatements.StringformatJSON()Get a simple formatted representation of this result as a JSON array of array.voidformatJSON(OutputStream stream)LikeFormattable.formatJSON(), but the data is output onto anOutputStream.voidformatJSON(OutputStream stream, JSONFormat format)LikeFormattable.formatJSON(JSONFormat), but the data is output onto anOutputStream.voidformatJSON(Writer writer)LikeFormattable.formatJSON(), but the data is output onto aWriter.voidformatJSON(Writer writer, JSONFormat format)LikeFormattable.formatJSON(JSONFormat), but the data is output onto aWriter.StringformatJSON(JSONFormat format)Get a simple formatted representation of this result as a JSON data structure, according to the format.StringformatXML()Get this result formatted as XML.voidformatXML(OutputStream stream)LikeFormattable.formatXML(), but the data is output onto anOutputStream.voidformatXML(OutputStream stream, XMLFormat format)LikeFormattable.formatXML(XMLFormat), but the data is output onto anOutputStream.voidformatXML(Writer writer)LikeFormattable.formatXML(), but the data is output onto aWriter.voidformatXML(Writer writer, XMLFormat format)LikeFormattable.formatXML(XMLFormat), but the data is output onto aWriter.StringformatXML(XMLFormat format)Get this result formatted as XML.voidfrom(Object source)Load data into this record from a source.voidfrom(Object source, int... fieldIndexes)Load data into this record from a source, providing some field indexes.voidfrom(Object source, String... fieldNames)Load data into this record from a source, providing some field names.voidfrom(Object source, Field<?>... f)Load data into this record from a source, providing some fields.voidfrom(Object source, Name... fieldNames)Load data into this record from a source, providing some field names.protected voidfrom(Record source)This method was implemented with [#799].voidfromArray(Object... array)Load data from an array into this record.voidfromArray(Object[] array, int... fieldIndexes)Load data from an array into this record, providing some fields indexes.voidfromArray(Object[] array, String... fieldNames)Load data from an array into this record, providing some fields names.voidfromArray(Object[] array, Field<?>... f)Load data from an array into this record, providing some fields.voidfromArray(Object[] array, Name... fieldNames)Load data from an array into this record, providing some fields names.voidfromMap(Map<String,?> map)Load data from a map into this record.voidfromMap(Map<String,?> map, int... fieldIndexes)Load data from a map into this record, providing some field indexes.voidfromMap(Map<String,?> map, String... fieldNames)Load data from a map into this record, providing some field names.voidfromMap(Map<String,?> map, Field<?>... f)Load data from a map into this record, providing some fields.voidfromMap(Map<String,?> map, Name... fieldNames)Load data from a map into this record, providing some field names.Objectget(int index)Get a value from this record, providing a field index.<T> Tget(int index, Class<? extends T> type)Get a converted value from this record, providing a field index.<U> Uget(int index, Converter<?,? extends U> converter)Get a converted value from this record, providing a field index.Objectget(String fieldName)Get a value from this Record, providing a field name.<T> Tget(String fieldName, Class<? extends T> type)Get a converted value from this Record, providing a field name.<U> Uget(String fieldName, Converter<?,? extends U> converter)Get a converted value from this Record, providing a field name.<T> Tget(Field<?> field, Class<? extends T> type)Get a converted value from this Record, providing a field.<T> Tget(Field<T> field)Get a value from this Record, providing a field.<T,U>
 Uget(Field<T> field, Converter<? super T,? extends U> converter)Get a converted value from this Record, providing a field.Objectget(Name fieldName)Get a value from this Record, providing a field name.<T> Tget(Name fieldName, Class<? extends T> type)Get a converted value from this Record, providing a field name.<U> Uget(Name fieldName, Converter<?,? extends U> converter)Get a converted value from this Record, providing a field name.ObjectgetValue(int index)Get a value from this record, providing a field index.<T> TgetValue(int index, Class<? extends T> type)Get a converted value from this record, providing a field index.<T> TgetValue(int index, Class<? extends T> type, T defaultValue)Deprecated.ObjectgetValue(int index, Object defaultValue)Deprecated.<U> UgetValue(int index, Converter<?,? extends U> converter)Get a converted value from this record, providing a field index.<U> UgetValue(int index, Converter<?,? extends U> converter, U defaultValue)Deprecated.ObjectgetValue(String fieldName)Get a value from this Record, providing a field name.<T> TgetValue(String fieldName, Class<? extends T> type)Get a converted value from this Record, providing a field name.<T> TgetValue(String fieldName, Class<? extends T> type, T defaultValue)Deprecated.ObjectgetValue(String fieldName, Object defaultValue)Deprecated.<U> UgetValue(String fieldName, Converter<?,? extends U> converter)Get a converted value from this Record, providing a field name.<U> UgetValue(String fieldName, Converter<?,? extends U> converter, U defaultValue)Deprecated.<T> TgetValue(Field<?> field, Class<? extends T> type)Get a converted value from this Record, providing a field.<T> TgetValue(Field<?> field, Class<? extends T> type, T defaultValue)Deprecated.<T> TgetValue(Field<T> field)Get a value from this Record, providing a field.<T,U>
 UgetValue(Field<T> field, Converter<? super T,? extends U> converter)Get a converted value from this Record, providing a field.<T,U>
 UgetValue(Field<T> field, Converter<? super T,? extends U> converter, U defaultValue)Deprecated.<T> TgetValue(Field<T> field, T defaultValue)Deprecated.ObjectgetValue(Name fieldName)Get a value from this Record, providing a field name.<T> TgetValue(Name fieldName, Class<? extends T> type)Get a converted value from this Record, providing a field name.<U> UgetValue(Name fieldName, Converter<?,? extends U> converter)Get a converted value from this Record, providing a field name.inthashCode()intindexOf(String fieldName)Get a field's index from this record.intindexOf(Field<?> field)Get a field's index from this record.intindexOf(Name fieldName)Get a field's index from this record.<E> Einto(E object)Map resulting records onto a custom type.<E> Einto(Class<? extends E> type)Map resulting records onto a custom type.Recordinto(Field<?>... f)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>
 Rinto(Table<R> table)Map resulting records onto a custom record type.Object[]intoArray()Convert this record into an array.List<Object>intoList()Convert this record into a list.Map<String,Object>intoMap()Return this record as a name/value map.ResultSetintoResultSet()Generate an in-memory JDBCResultSetcontaining the data of thisRecord.Stream<Object>intoStream()Convert this record into a stream.DocumentintoXML()Get this result as XML.<H extends ContentHandler>
 HintoXML(H handler)Get this result as XML using a SAXContentHandler.<H extends ContentHandler>
 HintoXML(H handler, XMLFormat format)Get this result as XML using a SAXContentHandler.DocumentintoXML(XMLFormat format)Get this result as XML.Recordkey()A Record copy holding values for theTable.getPrimaryKey().<E> Emap(RecordMapper<Record,E> mapper)Map this record into a custom mapper callback.Objectoriginal(int fieldIndex)Get an original value from this record as fetched from the database.Objectoriginal(String fieldName)Get an original value from this record as fetched from the database.<T> Toriginal(Field<T> field)Get an original value from this record as fetched from the database.Objectoriginal(Name fieldName)Get an original value from this record as fetched from the database.voidrefresh()Refresh this record from the database.voidrefresh(Collection<? extends Field<?>> refreshFields)Refresh parts of this record from the database.voidrefresh(Field<?>... refreshFields)Refresh parts of this record from the database.voidreset()voidreset(int fieldIndex)voidreset(String fieldName)Reset a given value to itsRecord.original(String)value and itsRecord.changed(String)flag tofalse.voidreset(Field<?> field)Reset a given value to itsRecord.original(Field)value and itsRecord.changed(Field)flag tofalse.voidreset(Name fieldName)protected voidset(int index, Object value)<T> voidset(Field<T> field, T value)Set a value into this record.<T,U>
 voidset(Field<T> field, U value, Converter<? extends T,? super U> converter)Set a value into this record.protected voidsetValue(int index, Object value)Deprecated.- UseAbstractRecord.set(int, Object)instead<T> voidsetValue(Field<T> field, T value)Set a value into this record.<T,U>
 voidsetValue(Field<T> field, U value, Converter<? extends T,? super U> converter)Set a value into this record.intsize()Get the number of fields of this record.intstore()Store this record back to the database.intstore(Collection<? extends Field<?>> storeFields)Store parts of this record to the database.intstore(Field<?>... storeFields)Store parts of this record to the database.StringtoString()intupdate()Store this record back to the database using anUPDATEstatement.intupdate(Collection<? extends Field<?>> storeFields)Store parts of this record to the database using anUPDATEstatement.intupdate(Field<?>... storeFields)Store parts of this record to the database using anUPDATEstatement.- 
Methods inherited from class org.jooq.impl.TableRecordImplfetchParent, fieldsRow, getTable, insert, insert, insert, original, valuesRow, with, with
 - 
Methods inherited from class java.lang.Objectclone, finalize, getClass, notify, notifyAll, wait, wait, wait
 - 
Methods inherited from interface org.jooq.Attachableattach, configuration, detach
 - 
Methods inherited from interface org.jooq.Formattableformat, 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
 - 
Methods inherited from interface org.jooq.Recordchanged, changed, changed, changed, changed, changed, changed, changed, changed, changed, compareTo, equals, field, field, field, field, fields, fields, fields, fields, fields, fieldsRow, from, from, from, from, from, fromArray, fromArray, fromArray, fromArray, fromArray, fromMap, fromMap, fromMap, fromMap, fromMap, get, get, get, get, get, get, get, get, get, get, get, get, getValue, getValue, getValue, getValue, getValue, getValue, getValue, getValue, getValue, getValue, getValue, getValue, getValue, getValue, getValue, getValue, getValue, getValue, getValue, getValue, getValue, hashCode, indexOf, indexOf, indexOf, into, into, into, into, into, into, into, into, into, into, into, into, into, into, into, into, into, into, into, into, into, into, into, into, into, into, intoArray, intoList, intoMap, intoResultSet, intoStream, map, original, original, original, original, reset, reset, reset, reset, reset, set, set, setValue, setValue, size, valuesRow
 - 
Methods inherited from interface org.jooq.TableRecordfetchParent, getTable, original, with, with
 - 
Methods inherited from interface org.jooq.UpdatableRecordinsert, insert, insert
 
- 
 
- 
- 
- 
Method Detail- 
keypublic Record key() Description copied from interface:UpdatableRecordA Record copy holding values for theTable.getPrimaryKey().The returned record consists exactly of those fields as returned by the table's primary key: Key.getFields().Generated subtypes may covariantly override this method to add more record type information. For instance, they may return Record1,Record2, ...- Specified by:
- keyin interface- UpdatableRecord<R extends UpdatableRecord<R>>
 
 - 
fetchChildpublic final <O extends TableRecord<O>> O fetchChild(ForeignKey<O,R> key) Description copied from interface:UpdatableRecordFetch a child record of this record, given a foreign key.This returns a child record referencing this record through a given foreign key. If no child record was found, this returns null- Specified by:
- fetchChildin interface- UpdatableRecord<R extends UpdatableRecord<R>>
- See Also:
- ForeignKey.fetchChildren(java.util.Collection),- ForeignKey.fetchChildren(Record),- ForeignKey.fetchChildren(Record...)
 
 - 
fetchChildrenpublic final <O extends TableRecord<O>> Result<O> fetchChildren(ForeignKey<O,R> key) Description copied from interface:UpdatableRecordFetch child records of this record, given a foreign key.This returns childs record referencing this record through a given foreign key. - Specified by:
- fetchChildrenin interface- UpdatableRecord<R extends UpdatableRecord<R>>
- See Also:
- ForeignKey.fetchChildren(java.util.Collection),- ForeignKey.fetchChildren(Record),- ForeignKey.fetchChildren(Record...)
 
 - 
storepublic final int store() Description copied from interface:UpdatableRecordStore this record back to the database.Depending on the state of the primary key's value, an UpdatableRecord.insert()or anUpdatableRecord.update()statement is executed.Statement type- If this record was created by client code, an INSERTstatement is executed
- If this record was loaded by jOOQ and the primary key value was
 changed, an INSERTstatement is executed (unlessSettings.isUpdatablePrimaryKeys()is set). jOOQ expects that primary key values will never change due to the principle of normalisation in RDBMS. So if client code changes primary key values, this is interpreted by jOOQ as client code wanting to duplicate this record.
- If this record was loaded by jOOQ, and the primary key value was not
 changed, an UPDATEstatement is executed.
 In either statement type, only those fields are inserted/updated, which had been explicitly set by client code, in order to allow for DEFAULTvalues to be applied by the underlying RDBMS. If no fields were modified, neither anUPDATEnor anINSERTwill be executed.Automatic value generationUse UpdatableRecord.insert()orUpdatableRecord.update()to explicitly force either statement type.- IDENTITY columns
 If there is an IDENTITYcolumn defined on the record's underlying table (seeTable.getIdentity()), then the auto-generatedIDENTITYvalue is refreshed automatically onINSERT's. Refreshing is done usingStatement.getGeneratedKeys(), where this is supported by the JDBC driver. See alsoInsertQuery.getReturnedRecord()for more details
- VERSION and TIMESTAMP columns
 jOOQ can auto-generate "version" and "timestamp" values that can be used for optimistic locking. If this is an UpdatableRecordand if this record returns fields for eitherTable.getRecordVersion()orTable.getRecordTimestamp(), then these values are set onto theINSERTorUPDATEstatement being executed. On execution success, the generated values are set to this record. Use the code-generation configuration to specify naming patterns for auto-generated "version" and "timestamp" columns.Should you want to circumvent jOOQ-generated updates to these columns, you can render an INSERTorUPDATEstatement manually using the variousDSLContext.insertInto(Table),DSLContext.update(Table)methods.
 Optimistic lockingIf an UPDATEstatement is executed andSettings.isExecuteWithOptimisticLocking()is set totrue, then this record will first be compared with the latest state in the database. There are two modes of operation for optimistic locking:- With VERSION and/or TIMESTAMP columns configured
 This is the preferred way of using optimistic locking in jOOQ. If this is an UpdatableRecordand if this record returns fields for eitherTable.getRecordVersion()orTable.getRecordTimestamp(), then these values are compared to the corresponding value in the database in theWHEREclause of the executedDELETEstatement.
- Without any specific column configurations
 In order to compare this record with the latest state, the database record will be locked pessimistically using a SELECT .. FOR UPDATEstatement. Not all databases support theFOR UPDATEclause natively. Namely, the following databases will show slightly different behaviour:-  SQLDialect.SQLSERVER: jOOQ will try to lock the database record using JDBC'sResultSet.TYPE_SCROLL_SENSITIVEandResultSet.CONCUR_UPDATABLE.
-  SQLDialect.SQLITE: No pessimistic locking is possible. Client code must assure that no race-conditions can occur between jOOQ's checking of database record state and the actualUPDATE
 See SelectQuery.setForUpdate(boolean)for more details
-  
 Statement examplesPossible statements are - 
 INSERT INTO [table] ([modified fields, including keys]) VALUES ([modified values, including keys]) 
- 
 UPDATE [table] SET [modified fields = modified values, excluding keys] WHERE [key fields = key values] AND [version/timestamp fields = version/timestamp values] 
 Statement execution enforcementIf you want to enforce statement execution, regardless if the values in this record were changed, you can explicitly set the changed flags for all values with Record.changed(boolean)or for single values withRecord.changed(Field, boolean), prior to storing.This is the same as calling record.store(record.fields())- Specified by:
- storein interface- UpdatableRecord<R extends UpdatableRecord<R>>
- Returns:
- 1if the record was stored to the database.- 0if storing was not necessary.
- See Also:
- UpdatableRecord.insert(),- UpdatableRecord.update()
 
- If this record was created by client code, an 
 - 
storepublic final int store(Field<?>... storeFields) Description copied from interface:UpdatableRecordStore parts of this record to the database.- Specified by:
- storein interface- UpdatableRecord<R extends UpdatableRecord<R>>
- Returns:
- 1if the record was stored to the database.- 0if storing was not necessary.
- See Also:
- UpdatableRecord.store(),- UpdatableRecord.insert(Field...),- UpdatableRecord.update(Field...)
 
 - 
storepublic final int store(Collection<? extends Field<?>> storeFields) Description copied from interface:UpdatableRecordStore parts of this record to the database.- Specified by:
- storein interface- UpdatableRecord<R extends UpdatableRecord<R>>
- Returns:
- 1if the record was stored to the database.- 0if storing was not necessary.
- See Also:
- UpdatableRecord.store(),- UpdatableRecord.insert(Field...),- UpdatableRecord.update(Field...)
 
 - 
updatepublic final int update() Description copied from interface:UpdatableRecordStore this record back to the database using anUPDATEstatement.This is the same as UpdatableRecord.store(), except that anUPDATEstatement (or no statement) will always be executed.If you want to enforce statement execution, regardless if the values in this record were changed, you can explicitly set the changed flags for all values with Record.changed(boolean)or for single values withRecord.changed(Field, boolean), prior to updating.This is the same as calling record.update(record.fields())- Specified by:
- updatein interface- UpdatableRecord<R extends UpdatableRecord<R>>
- Returns:
- 1if the record was stored to the database.- 0if storing was not necessary.
- See Also:
- UpdatableRecord.store()
 
 - 
updatepublic int update(Field<?>... storeFields) Description copied from interface:UpdatableRecordStore parts of this record to the database using anUPDATEstatement.- Specified by:
- updatein interface- UpdatableRecord<R extends UpdatableRecord<R>>
- Returns:
- 1if the record was stored to the database.- 0if storing was not necessary.
- See Also:
- UpdatableRecord.update()
 
 - 
updatepublic final int update(Collection<? extends Field<?>> storeFields) Description copied from interface:UpdatableRecordStore parts of this record to the database using anUPDATEstatement.- Specified by:
- updatein interface- UpdatableRecord<R extends UpdatableRecord<R>>
- Returns:
- 1if the record was stored to the database.- 0if storing was not necessary.
- See Also:
- UpdatableRecord.update()
 
 - 
deletepublic final int delete() Description copied from interface:UpdatableRecordDeletes this record from the database, based on the value of the primary key or main unique key.Optimistic lockingIf a DELETEstatement is executed andSettings.isExecuteWithOptimisticLocking()is set totrue, then this record will first be compared with the latest state in the database. There are two modes of operation for optimistic locking:- With VERSION and/or TIMESTAMP columns configured
 This is the preferred way of using optimistic locking in jOOQ. If this is an UpdatableRecordand if this record returns fields for eitherTable.getRecordVersion()orTable.getRecordTimestamp(), then these values are compared to the corresponding value in the database in theWHEREclause of the executedDELETEstatement.
- Without any specific column configurations
 In order to compare this record with the latest state, the database record will be locked pessimistically using a SELECT .. FOR UPDATEstatement. Not all databases support theFOR UPDATEclause natively. Namely, the following databases will show slightly different behaviour:-  SQLDialect.SQLSERVER: jOOQ will try to lock the database record using JDBC'sResultSet.TYPE_SCROLL_SENSITIVEandResultSet.CONCUR_UPDATABLE.
-  SQLDialect.SQLITE: No pessimistic locking is possible. Client code must assure that no race-conditions can occur between jOOQ's checking of database record state and the actualDELETE
 See SelectQuery.setForUpdate(boolean)for more details
-  
 Statement examplesThe executed statement is DELETE FROM [table] WHERE [key fields = key values] AND [version/timestamp fields = version/timestamp values] This is in fact the same as calling delete(getTable().getPrimaryKey().getFieldsArray())- Specified by:
- deletein interface- UpdatableRecord<R extends UpdatableRecord<R>>
- Returns:
- 1if the record was deleted from the database.- 0if deletion was not necessary.
 
- With VERSION and/or TIMESTAMP columns configured
 
 - 
refreshpublic final void refresh() Description copied from interface:UpdatableRecordRefresh this record from the database.A successful refresh results in the following: - Record.valuesRow()will have been restored to the respective values from the database
- TableRecord.original()will match this record
- Record.changed()will be- false
 Refreshing can trigger any of the following actions: - Executing a new SELECTstatement, if this is anUpdatableRecord.
- Failing, otherwise
 This is the same as calling record.refresh(record.fields())- Specified by:
- refreshin interface- UpdatableRecord<R extends UpdatableRecord<R>>
 
 - 
refreshpublic final void refresh(Field<?>... refreshFields) Description copied from interface:UpdatableRecordRefresh parts of this record from the database.A successful refresh results in the following: - Record.valuesRow()will have been restored to the respective values from the database
- TableRecord.original()will match this record
- Record.changed()will be- false
 Refreshing can trigger any of the following actions: - Executing a new SELECTstatement, if this is anUpdatableRecord.
- Failing, otherwise
 This is the same as calling record.refresh(record.fields())- Specified by:
- refreshin interface- UpdatableRecord<R extends UpdatableRecord<R>>
 
 - 
refreshpublic final void refresh(Collection<? extends Field<?>> refreshFields) Description copied from interface:UpdatableRecordRefresh parts of this record from the database.A successful refresh results in the following: - Record.valuesRow()will have been restored to the respective values from the database
- TableRecord.original()will match this record
- Record.changed()will be- false
 Refreshing can trigger any of the following actions: - Executing a new SELECTstatement, if this is anUpdatableRecord.
- Failing, otherwise
 This is the same as calling record.refresh(record.fields())- Specified by:
- refreshin interface- UpdatableRecord<R extends UpdatableRecord<R>>
 
 - 
copypublic final R copy() Description copied from interface:UpdatableRecordDuplicate this record (in memory) and reset all fields from the primary key or main unique key, such that a subsequent call toUpdatableRecord.store()will result in anINSERTstatement.- Specified by:
- copyin interface- UpdatableRecord<R extends UpdatableRecord<R>>
- Returns:
- A new record, distinct from thisrecord.
 
 - 
fieldpublic final <T> Field<T> field(Field<T> field) Description copied from interface:RecordGet 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.
- nullotherwise.
 - Specified by:
- fieldin interface- Record
- See Also:
- Row.field(Field)
 
 - 
fieldpublic final Field<?> field(String name) Description copied from interface:RecordGet a specific field from this Record.- Specified by:
- fieldin interface- Record
- See Also:
- Row.field(String)
 
 - 
fieldpublic final Field<?> field(Name name) Description copied from interface:RecordGet a specific qualified field from this Record.- Specified by:
- fieldin interface- Record
- See Also:
- Row.field(Name)
 
 - 
fieldpublic final Field<?> field(int index) Description copied from interface:RecordGet a specific field from this Record.- Specified by:
- fieldin interface- Record
- See Also:
- Row.field(int)
 
 - 
fieldspublic final Field<?>[] fields() Description copied from interface:RecordGet all fields from this Record.- Specified by:
- fieldsin interface- Record
- See Also:
- Row.fields()
 
 - 
fieldspublic final Field<?>[] fields(Field<?>... f) Description copied from interface:RecordGet all fields from this Record, providing some fields.- Specified by:
- fieldsin interface- Record
- Returns:
- All available fields
- See Also:
- Row.fields(Field...)
 
 - 
fieldspublic final Field<?>[] fields(String... fieldNames) Description copied from interface:RecordGet all fields from this Record, providing some field names.- Specified by:
- fieldsin interface- Record
- Returns:
- All available fields
- See Also:
- Row.fields(String...)
 
 - 
fieldspublic final Field<?>[] fields(Name... fieldNames) Description copied from interface:RecordGet all fields from this Record, providing some field names.- Specified by:
- fieldsin interface- Record
- Returns:
- All available fields
- See Also:
- Row.fields(Name...)
 
 - 
fieldspublic final Field<?>[] fields(int... fieldIndexes) Description copied from interface:RecordGet all fields from this Record, providing some field indexes.- Specified by:
- fieldsin interface- Record
- Returns:
- All available fields
- See Also:
- Row.fields(int...)
 
 - 
indexOfpublic final int indexOf(Field<?> field) Description copied from interface:RecordGet a field's index from this record.
 - 
indexOfpublic final int indexOf(String fieldName) Description copied from interface:RecordGet a field's index from this record.
 - 
indexOfpublic final int indexOf(Name fieldName) Description copied from interface:RecordGet a field's index from this record.
 - 
sizepublic final int size() Description copied from interface:RecordGet the number of fields of this record.
 - 
getpublic final <T> T get(Field<T> field) Description copied from interface:RecordGet 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.
 - 
getpublic final <T> T get(Field<?> field, Class<? extends T> type) Description copied from interface:RecordGet 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.- Specified by:
- getin interface- Record
- 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
- See Also:
- Convert.convert(Object, Class)
 
 - 
getpublic final <T,U> U get(Field<T> field, Converter<? super T,? extends U> converter) Description copied from interface:RecordGet 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.- Specified by:
- getin interface- Record
- 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
- See Also:
- Convert.convert(Object, Converter)
 
 - 
getpublic final Object get(int index) Description copied from interface:RecordGet a value from this record, providing a field index.
 - 
getpublic final <T> T get(int index, Class<? extends T> type)Description copied from interface:RecordGet a converted value from this record, providing a field index.- Specified by:
- getin interface- Record
- 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
- See Also:
- Convert.convert(Object, Class)
 
 - 
getpublic final <U> U get(int index, Converter<?,? extends U> converter)Description copied from interface:RecordGet a converted value from this record, providing a field index.- Specified by:
- getin interface- Record
- 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
- See Also:
- Convert.convert(Object, Converter)
 
 - 
getpublic final Object get(String fieldName) Description copied from interface:RecordGet a value from this Record, providing a field name.
 - 
getpublic final <T> T get(String fieldName, Class<? extends T> type) Description copied from interface:RecordGet a converted value from this Record, providing a field name.- Specified by:
- getin interface- Record
- 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
- See Also:
- Convert.convert(Object, Class)
 
 - 
getpublic final <U> U get(String fieldName, Converter<?,? extends U> converter) Description copied from interface:RecordGet a converted value from this Record, providing a field name.- Specified by:
- getin interface- Record
- 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
- See Also:
- Convert.convert(Object, Converter)
 
 - 
getpublic final Object get(Name fieldName) Description copied from interface:RecordGet a value from this Record, providing a field name.
 - 
getpublic final <T> T get(Name fieldName, Class<? extends T> type) Description copied from interface:RecordGet a converted value from this Record, providing a field name.- Specified by:
- getin interface- Record
- 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
- See Also:
- Convert.convert(Object, Class)
 
 - 
getpublic final <U> U get(Name fieldName, Converter<?,? extends U> converter) Description copied from interface:RecordGet a converted value from this Record, providing a field name.- Specified by:
- getin interface- Record
- 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
- See Also:
- Convert.convert(Object, Converter)
 
 - 
setValue@Deprecated protected final void setValue(int index, Object value) Deprecated.- UseAbstractRecord.set(int, Object)insteadSubclasses may type-unsafely set a value to a record index. This method takes care of converting the value to the appropriate type.
 - 
setprotected final void set(int index, Object value)
 - 
setpublic final <T> void set(Field<T> field, T value) Description copied from interface:RecordSet a value into this record.This will always set the Record.changed(Field)flag for the givenfield, no matter if setting the value actually changes the value.Changing Table.getPrimaryKey()values will set allRecord.changed()flags to true, in order to produce completeINSERTstatements on subsequentUpdatableRecord.store()operations.
 - 
setpublic final <T,U> void set(Field<T> field, U value, Converter<? extends T,? super U> converter) Description copied from interface:RecordSet a value into this record.This will always set the Record.changed(Field)flag for the givenfield, no matter if setting the value actually changes the value.Changing Table.getPrimaryKey()values will set allRecord.changed()flags to true, in order to produce completeINSERTstatements on subsequentUpdatableRecord.store()operations.
 - 
originalpublic final <T> T original(Field<T> field) Description copied from interface:RecordGet 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. - Specified by:
- originalin interface- Record
- See Also:
- Record.original()
 
 - 
originalpublic final Object original(int fieldIndex) Description copied from interface:RecordGet 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. - Specified by:
- originalin interface- Record
- See Also:
- Record.original()
 
 - 
originalpublic final Object original(String fieldName) Description copied from interface:RecordGet 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. - Specified by:
- originalin interface- Record
- See Also:
- Record.original()
 
 - 
originalpublic final Object original(Name fieldName) Description copied from interface:RecordGet 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. - Specified by:
- originalin interface- Record
- See Also:
- Record.original()
 
 - 
changedpublic final boolean changed() Description copied from interface:RecordCheck if this record has been changed from its original as fetched from the database.If this returns false, then it can be said thatrecord.equals(record.original())is true.- Specified by:
- changedin interface- Record
- See Also:
- Record.original(),- Record.changed(Field),- Record.changed(int),- Record.changed(String)
 
 - 
changedpublic final boolean changed(Field<?> field) Description copied from interface:RecordCheck if a field's value has been changed from its original as fetched from the database.- Specified by:
- changedin interface- Record
- See Also:
- Record.changed(),- Record.original(Field)
 
 - 
changedpublic final boolean changed(int fieldIndex) Description copied from interface:RecordCheck if a field's value has been changed from its original as fetched from the database.- Specified by:
- changedin interface- Record
- See Also:
- Record.changed(),- Record.original(int)
 
 - 
changedpublic final boolean changed(String fieldName) Description copied from interface:RecordCheck if a field's value has been changed from its original as fetched from the database.- Specified by:
- changedin interface- Record
- See Also:
- Record.changed(),- Record.original(String)
 
 - 
changedpublic final boolean changed(Name fieldName) Description copied from interface:RecordCheck if a field's value has been changed from its original as fetched from the database.- Specified by:
- changedin interface- Record
- See Also:
- Record.changed(),- Record.original(Name)
 
 - 
changedpublic final void changed(boolean c) Description copied from interface:RecordSet all of this record's internal changed flags to the supplied value.If the changedargument isfalse, theRecord.original()values will be reset to the corresponding "current" values as well- Specified by:
- changedin interface- Record
- See Also:
- Record.changed(),- Record.changed(Field, boolean),- Record.changed(int, boolean),- Record.changed(String, boolean)
 
 - 
changedpublic final void changed(Field<?> field, boolean c) Description copied from interface:RecordSet this record's internal changed flag to the supplied value for a given field.If the changedargument isfalse, theRecord.original(Field)value will be reset to the corresponding "current" value as well- Specified by:
- changedin interface- Record
- See Also:
- Record.changed(),- Record.changed(Field)
 
 - 
changedpublic final void changed(int fieldIndex, boolean c)Description copied from interface:RecordSet this record's internal changed flag to the supplied value for a given field.If the changedargument isfalse, theRecord.original(int)value will be reset to the corresponding "current" value as well- Specified by:
- changedin interface- Record
- See Also:
- Record.changed(),- Record.changed(int)
 
 - 
changedpublic final void changed(String fieldName, boolean c) Description copied from interface:RecordSet this record's internal changed flag to the supplied value for a given field.If the changedargument isfalse, theRecord.original(String)value will be reset to the corresponding "current" value as well- Specified by:
- changedin interface- Record
- See Also:
- Record.changed(),- Record.changed(String)
 
 - 
changedpublic final void changed(Name fieldName, boolean c) Description copied from interface:RecordSet this record's internal changed flag to the supplied value for a given field.If the changedargument isfalse, theRecord.original(Name)value will be reset to the corresponding "current" value as well- Specified by:
- changedin interface- Record
- See Also:
- Record.changed(),- Record.changed(Name)
 
 - 
resetpublic final void reset() Description copied from interface:Record
 - 
resetpublic final void reset(Field<?> field) Description copied from interface:RecordReset a given value to itsRecord.original(Field)value and itsRecord.changed(Field)flag tofalse.
 - 
resetpublic final void reset(int fieldIndex) Description copied from interface:Record
 - 
resetpublic final void reset(String fieldName) Description copied from interface:RecordReset a given value to itsRecord.original(String)value and itsRecord.changed(String)flag tofalse.
 - 
intoArraypublic final Object[] intoArray() Description copied from interface:RecordConvert 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)- Specified by:
- intoArrayin interface- Record
- Returns:
- This record as an array
- See Also:
- Record.fromArray(Object...)
 
 - 
intoListpublic final List<Object> intoList() Description copied from interface:RecordConvert 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())
 - 
intoStreampublic final Stream<Object> intoStream() Description copied from interface:RecordConvert 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)- Specified by:
- intoStreamin interface- Record
- Returns:
- This record as a stream
 
 - 
intoMappublic final Map<String,Object> intoMap() Description copied from interface:RecordReturn this record as a name/value map.This is the inverse operation to Record.fromMap(Map)- Specified by:
- intoMapin interface- Record
- Returns:
- This record as a map
- See Also:
- Record.fromMap(Map)
 
 - 
intopublic final Record into(Field<?>... f) Description copied from interface:RecordCopy this record into a new record holding only a subset of the previous fields.
 - 
intopublic final <T1> Record1<T1> into(Field<T1> field1) Description copied from interface:RecordCopy this record into a new record holding only a subset of the previous fields.- Specified by:
- intoin interface- Record
- Returns:
- The new record
- See Also:
- Record.into(Table)
 
 - 
intopublic final <T1,T2> Record2<T1,T2> into(Field<T1> field1, Field<T2> field2) Description copied from interface:RecordCopy this record into a new record holding only a subset of the previous fields.- Specified by:
- intoin interface- Record
- Returns:
- The new record
- See Also:
- Record.into(Table)
 
 - 
intopublic final <T1,T2,T3> Record3<T1,T2,T3> into(Field<T1> field1, Field<T2> field2, Field<T3> field3) Description copied from interface:RecordCopy this record into a new record holding only a subset of the previous fields.- Specified by:
- intoin interface- Record
- Returns:
- The new record
- See Also:
- Record.into(Table)
 
 - 
intopublic final <T1,T2,T3,T4> Record4<T1,T2,T3,T4> into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4) Description copied from interface:RecordCopy this record into a new record holding only a subset of the previous fields.- Specified by:
- intoin interface- Record
- Returns:
- The new record
- See Also:
- Record.into(Table)
 
 - 
intopublic final <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) Description copied from interface:RecordCopy this record into a new record holding only a subset of the previous fields.- Specified by:
- intoin interface- Record
- Returns:
- The new record
- See Also:
- Record.into(Table)
 
 - 
intopublic final <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) Description copied from interface:RecordCopy this record into a new record holding only a subset of the previous fields.- Specified by:
- intoin interface- Record
- Returns:
- The new record
- See Also:
- Record.into(Table)
 
 - 
intopublic final <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) Description copied from interface:RecordCopy this record into a new record holding only a subset of the previous fields.- Specified by:
- intoin interface- Record
- Returns:
- The new record
- See Also:
- Record.into(Table)
 
 - 
intopublic final <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) Description copied from interface:RecordCopy this record into a new record holding only a subset of the previous fields.- Specified by:
- intoin interface- Record
- Returns:
- The new record
- See Also:
- Record.into(Table)
 
 - 
intopublic final <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) Description copied from interface:RecordCopy this record into a new record holding only a subset of the previous fields.- Specified by:
- intoin interface- Record
- Returns:
- The new record
- See Also:
- Record.into(Table)
 
 - 
intopublic final <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) Description copied from interface:RecordCopy this record into a new record holding only a subset of the previous fields.- Specified by:
- intoin interface- Record
- Returns:
- The new record
- See Also:
- Record.into(Table)
 
 - 
intopublic final <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) Description copied from interface:RecordCopy this record into a new record holding only a subset of the previous fields.- Specified by:
- intoin interface- Record
- Returns:
- The new record
- See Also:
- Record.into(Table)
 
 - 
intopublic final <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) Description copied from interface:RecordCopy this record into a new record holding only a subset of the previous fields.- Specified by:
- intoin interface- Record
- Returns:
- The new record
- See Also:
- Record.into(Table)
 
 - 
intopublic final <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) Description copied from interface:RecordCopy this record into a new record holding only a subset of the previous fields.- Specified by:
- intoin interface- Record
- Returns:
- The new record
- See Also:
- Record.into(Table)
 
 - 
intopublic final <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) Description copied from interface:RecordCopy this record into a new record holding only a subset of the previous fields.- Specified by:
- intoin interface- Record
- Returns:
- The new record
- See Also:
- Record.into(Table)
 
 - 
intopublic final <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) Description copied from interface:RecordCopy this record into a new record holding only a subset of the previous fields.- Specified by:
- intoin interface- Record
- Returns:
- The new record
- See Also:
- Record.into(Table)
 
 - 
intopublic final <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) Description copied from interface:RecordCopy this record into a new record holding only a subset of the previous fields.- Specified by:
- intoin interface- Record
- Returns:
- The new record
- See Also:
- Record.into(Table)
 
 - 
intopublic final <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) Description copied from interface:RecordCopy this record into a new record holding only a subset of the previous fields.- Specified by:
- intoin interface- Record
- Returns:
- The new record
- See Also:
- Record.into(Table)
 
 - 
intopublic final <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) Description copied from interface:RecordCopy this record into a new record holding only a subset of the previous fields.- Specified by:
- intoin interface- Record
- Returns:
- The new record
- See Also:
- Record.into(Table)
 
 - 
intopublic final <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) Description copied from interface:RecordCopy this record into a new record holding only a subset of the previous fields.- Specified by:
- intoin interface- Record
- Returns:
- The new record
- See Also:
- Record.into(Table)
 
 - 
intopublic final <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) Description copied from interface:RecordCopy this record into a new record holding only a subset of the previous fields.- Specified by:
- intoin interface- Record
- Returns:
- The new record
- See Also:
- Record.into(Table)
 
 - 
intopublic final <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) Description copied from interface:RecordCopy this record into a new record holding only a subset of the previous fields.- Specified by:
- intoin interface- Record
- Returns:
- The new record
- See Also:
- Record.into(Table)
 
 - 
intopublic final <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) Description copied from interface:RecordCopy this record into a new record holding only a subset of the previous fields.- Specified by:
- intoin interface- Record
- Returns:
- The new record
- See Also:
- Record.into(Table)
 
 - 
intopublic final <E> E into(Class<? extends E> type) Description copied from interface:RecordMap resulting records onto a custom type.This will map this record onto your custom type using a RecordMapperas provided byConfiguration.recordMapperProvider(). If no custom provider is specified, theDefaultRecordMapperProvideris used.- Specified by:
- intoin interface- Record
- Type Parameters:
- E- The generic entity type.
- Parameters:
- type- The entity type.
- See Also:
- Record.from(Object),- DefaultRecordMapper
 
 - 
intopublic final <E> E into(E object) Description copied from interface:RecordMap resulting records onto a custom type.This is the same as Record.into(Class), except that no new object is instantiated as a result. Instead, you can provide your own custom POJO instance.- Specified by:
- intoin interface- Record
- Type Parameters:
- E- The generic entity type.
- Parameters:
- object- The receiving bean.
- See Also:
- Record.from(Object)
 
 - 
intopublic final <R extends Record> R into(Table<R> table) Description copied from interface:RecordMap resulting records onto a custom record type.The mapping algorithm is this: jOOQ will mapRecordvalues by equal field names:- For every field in the tableargument withField.getName()"MY_field"(case-sensitive!), a corresponding field with the same name in this record will be searched.
- If several fields in this record share the same
 Field.getName(), then the first one returning true onField.equals(Object)will be returned. (e.g. qualified field names match)
 Other restrictions- Table.getRecordType()must return a class of type- TableRecord, which must provide a default constructor. Non-public default constructors are made accessible using- Constructor.setAccessible(boolean)
 
- For every field in the 
 - 
intoResultSetpublic final ResultSet intoResultSet() Description copied from interface:RecordGenerate an in-memory JDBCResultSetcontaining the data of thisRecord.Use this as an adapter for JDBC-compliant code that expects a ResultSetto operate on, rather than a jOOQResult. The returnedResultSetallows for the following behaviour according to the JDBC specification:-  ResultSet.CLOSE_CURSORS_AT_COMMIT: The cursors (i.e.Statementobject) are no longer available
-  ResultSet.CONCUR_READ_ONLY: You cannot update the database through thisResultSet, as the underlyingResultobject does not hold any open database refences anymore
-  ResultSet.FETCH_FORWARD: The fetch direction is forward only, and cannot be changed
-  ResultSet.TYPE_SCROLL_INSENSITIVE: You can use any of theResultSet's scrolling methods, e.g.ResultSet.next()orResultSet.previous(), etc.
 You may use DSLContext.fetch(ResultSet)to unwind this wrapper again.This is the same as creating a new Resultwith thisRecordonly, and then callingResult.intoResultSet()on thatResult- Specified by:
- intoResultSetin interface- Record
- Returns:
- A wrapper JDBC ResultSet
 
-  
 - 
mappublic final <E> E map(RecordMapper<Record,E> mapper) Description copied from interface:RecordMap this record into a custom mapper callback.
 - 
frompublic final void from(Object source) Description copied from interface:RecordLoad data into this record from a source.The mapping algorithm is this: Ifsourceis anarrayLoading of data is delegated to Record.fromArray(Object...)Ifsourceis aMapLoading of data is delegated to Record.fromMap(Map)Ifsourceis anIterableLoading of data is equivalent to loading Record.fromArray(Object...), transforming theIterableto an array, first.If any JPAColumnannotations are found on theClassof the providedsource, only those are used. Matching candidates are:- Public no-argument instance methods annotated with
 Column
- Public no-argument instance methods starting with getXXXorisXXX, if there exists a matching public single-argumentsetXXX()instance method that is annotated withColumn
- Public instance member fields annotated with Column
 - Column.name()must match- Field.getName(). All other annotation attributes are ignored
- Only the first match per field is used
- Matching methods have a higher priority than matching member fields
- Explicitly matching methods have a higher priority than implicitly matching methods (implicitly matching getter = setter is annotated)
- Static methods / member fields are ignored
 If there are no JPAColumnannotations, or jOOQ can't find thejavax.persistenceAPI on the classpath, jOOQ will map members by naming convention:If Field.getName()isMY_field(case-sensitive!), then this field's value will be fetched from the first of these:- Public no-argument instance method MY_field()
- Public no-argument instance method myField()
- Public no-argument instance method getMY_field()
- Public no-argument instance method getMyField()
- Public instance member field MY_field
- Public instance member field myField
 Other restrictions- primitive types are supported.
 General notesThe resulting record will have its internal "changed" flags set to true for all values. This means that UpdatableRecord.store()will perform anINSERTstatement. If you wish to store the record using anUPDATEstatement, useDSLContext.executeUpdate(UpdatableRecord)instead.This is the same as calling record.from(source, record.fields())- Specified by:
- fromin interface- Record
- Parameters:
- source- The source object to copy data from
- See Also:
- Record.into(Class),- Record.from(Object, Field...)
 
- Public no-argument instance methods annotated with
 
 - 
frompublic final void from(Object source, Field<?>... f) Description copied from interface:RecordLoad data into this record from a source, providing some fields.This is the same as Record.from(Object), except that only fields contained in thefieldsargument will be mapped.- Specified by:
- fromin interface- Record
- Parameters:
- source- The source object to copy data from
- f- The record's fields to use for mapping
- See Also:
- Record.into(Class),- Record.from(Object)
 
 - 
frompublic final void from(Object source, String... fieldNames) Description copied from interface:RecordLoad data into this record from a source, providing some field names.This is the same as Record.from(Object), except that only fields contained in thefieldNamesargument will be mapped.- Specified by:
- fromin interface- Record
- Parameters:
- source- The source object to copy data from
- fieldNames- The record's fields names to use for mapping
- See Also:
- Record.into(Class),- Record.from(Object)
 
 - 
frompublic final void from(Object source, Name... fieldNames) Description copied from interface:RecordLoad data into this record from a source, providing some field names.This is the same as Record.from(Object), except that only fields contained in thefieldNamesargument will be mapped.- Specified by:
- fromin interface- Record
- Parameters:
- source- The source object to copy data from
- fieldNames- The record's fields names to use for mapping
- See Also:
- Record.into(Class),- Record.from(Object)
 
 - 
frompublic final void from(Object source, int... fieldIndexes) Description copied from interface:RecordLoad data into this record from a source, providing some field indexes.This is the same as Record.from(Object), except that only fields contained in thefieldIndexesargument will be mapped.- Specified by:
- fromin interface- Record
- Parameters:
- source- The source object to copy data from
- fieldIndexes- The record's fields indexes to use for mapping
- See Also:
- Record.into(Class),- Record.from(Object)
 
 - 
fromMappublic final void fromMap(Map<String,?> map) Description copied from interface:RecordLoad data from a map into this record.The argument map is expected to hold field-name / value pairs where field-names correspond to actual field names as provided by Record.field(String). Missing fields will be left untouched. Excess fields will be ignored.This is the inverse operation to Record.intoMap(). This is the same as callingrecord.fromMap(map, record.fields())- Specified by:
- fromMapin interface- Record
- See Also:
- Record.intoMap(),- Record.fromMap(Map, Field...)
 
 - 
fromMappublic final void fromMap(Map<String,?> map, Field<?>... f) Description copied from interface:RecordLoad data from a map into this record, providing some fields.The argument map is expected to hold field-name / value pairs where field-names correspond to actual field names as provided by Record.field(String). Missing fields will be left untouched. Excess fields will be ignored.This is the same as Record.fromMap(Map), except that only fields contained in thefieldsargument will be mapped.- Specified by:
- fromMapin interface- Record
- See Also:
- Record.intoMap(),- Record.fromMap(Map)
 
 - 
fromMappublic final void fromMap(Map<String,?> map, String... fieldNames) Description copied from interface:RecordLoad data from a map into this record, providing some field names.The argument map is expected to hold field-name / value pairs where field-names correspond to actual field names as provided by Record.field(String). Missing fields will be left untouched. Excess fields will be ignored.This is the same as Record.fromMap(Map), except that only fields contained in thefieldNamesargument will be mapped.- Specified by:
- fromMapin interface- Record
- See Also:
- Record.intoMap(),- Record.fromMap(Map)
 
 - 
fromMappublic final void fromMap(Map<String,?> map, Name... fieldNames) Description copied from interface:RecordLoad data from a map into this record, providing some field names.The argument map is expected to hold field-name / value pairs where field-names correspond to actual field names as provided by Record.field(Name). Missing fields will be left untouched. Excess fields will be ignored.This is the same as Record.fromMap(Map), except that only fields contained in thefieldNamesargument will be mapped.- Specified by:
- fromMapin interface- Record
- See Also:
- Record.intoMap(),- Record.fromMap(Map)
 
 - 
fromMappublic final void fromMap(Map<String,?> map, int... fieldIndexes) Description copied from interface:RecordLoad data from a map into this record, providing some field indexes.The argument map is expected to hold field-name / value pairs where field-names correspond to actual field names as provided by Record.field(String). Missing fields will be left untouched. Excess fields will be ignored.This is the same as Record.fromMap(Map), except that only fields contained in thefieldIndexesargument will be mapped.- Specified by:
- fromMapin interface- Record
- See Also:
- Record.intoMap(),- Record.fromMap(Map)
 
 - 
fromArraypublic final void fromArray(Object... array) Description copied from interface:RecordLoad data from an array into this record.The argument array is expected to hold values for this record's field indexes. Missing values will be left untouched. Excess values will be ignored. This is the inverse operation to Record.intoArray()- Specified by:
- fromArrayin interface- Record
- See Also:
- Record.intoArray(),- Record.fromArray(Object[], Field...)
 
 - 
fromArraypublic final void fromArray(Object[] array, Field<?>... f) Description copied from interface:RecordLoad data from an array into this record, providing some fields.The argument array is expected to hold values for this record's field indexes. Missing values will be left untouched. Excess values will be ignored. This is the same as Record.fromArray(Object...), except that only fields contained in thefieldsargument will be mapped.- Specified by:
- fromArrayin interface- Record
- See Also:
- Record.intoArray(),- Record.fromArray(Object...)
 
 - 
fromArraypublic final void fromArray(Object[] array, String... fieldNames) Description copied from interface:RecordLoad data from an array into this record, providing some fields names.The argument array is expected to hold values for this record's field indexes. Missing values will be left untouched. Excess values will be ignored. This is the same as Record.fromArray(Object...), except that only fields contained in thefieldNamesargument will be mapped.- Specified by:
- fromArrayin interface- Record
- See Also:
- Record.intoArray(),- Record.fromArray(Object...)
 
 - 
fromArraypublic final void fromArray(Object[] array, Name... fieldNames) Description copied from interface:RecordLoad data from an array into this record, providing some fields names.The argument array is expected to hold values for this record's field indexes. Missing values will be left untouched. Excess values will be ignored. This is the same as Record.fromArray(Object...), except that only fields contained in thefieldNamesargument will be mapped.- Specified by:
- fromArrayin interface- Record
- See Also:
- Record.intoArray(),- Record.fromArray(Object...)
 
 - 
fromArraypublic final void fromArray(Object[] array, int... fieldIndexes) Description copied from interface:RecordLoad data from an array into this record, providing some fields indexes.The argument array is expected to hold values for this record's field indexes. Missing values will be left untouched. Excess values will be ignored. This is the same as Record.fromArray(Object...), except that only fields contained in thefieldIndexesargument will be mapped.- Specified by:
- fromArrayin interface- Record
- See Also:
- Record.intoArray(),- Record.fromArray(Object...)
 
 - 
fromprotected final void from(Record source) This method was implemented with [#799]. It may be useful to make it public for broader use...?
 - 
formatpublic final void format(Writer writer, TXTFormat format) Description copied from interface:FormattableLikeFormattable.format(TXTFormat), but the data is output onto aWriter.- Specified by:
- formatin interface- Formattable
 
 - 
formatCSVpublic final void formatCSV(Writer writer, CSVFormat format) Description copied from interface:FormattableLikeFormattable.formatCSV(CSVFormat), but the data is output onto aWriter.- Specified by:
- formatCSVin interface- Formattable
 
 - 
formatJSONpublic final void formatJSON(Writer writer, JSONFormat format) Description copied from interface:FormattableLikeFormattable.formatJSON(JSONFormat), but the data is output onto aWriter.- Specified by:
- formatJSONin interface- Formattable
 
 - 
formatXMLpublic final void formatXML(Writer writer, XMLFormat format) Description copied from interface:FormattableLikeFormattable.formatXML(XMLFormat), but the data is output onto aWriter.- Specified by:
- formatXMLin interface- Formattable
 
 - 
formatHTMLpublic final void formatHTML(Writer writer) Description copied from interface:FormattableLikeFormattable.formatHTML(), but the data is output onto aWriter.- Specified by:
- formatHTMLin interface- Formattable
 
 - 
formatChartpublic final void formatChart(Writer writer, ChartFormat format) Description copied from interface:FormattableLikeFormattable.formatChart(ChartFormat), but the data is output onto aWriter.- Specified by:
- formatChartin interface- Formattable
 
 - 
formatInsertpublic final void formatInsert(Writer writer) Description copied from interface:FormattableLikeFormattable.formatInsert(), but the data is output onto aWriter.- Specified by:
- formatInsertin interface- Formattable
 
 - 
formatInsertpublic final void formatInsert(Writer writer, Table<?> table, Field<?>... f) Description copied from interface:FormattableLikeFormattable.formatInsert(Table, Field...), but the data is output onto anWriter.- Specified by:
- formatInsertin interface- Formattable
 
 - 
intoXMLpublic final Document intoXML(XMLFormat format) Description copied from interface:FormattableGet this result as XML.- Specified by:
- intoXMLin interface- Formattable
- See Also:
- Formattable.formatXML(), http://www.jooq.org/xsd/jooq-export-3.10.0.xsd
 
 - 
intoXMLpublic final <H extends ContentHandler> H intoXML(H handler, XMLFormat format) throws SAXException Description copied from interface:FormattableGet this result as XML using a SAXContentHandler.- Specified by:
- intoXMLin interface- Formattable
- Parameters:
- handler- The custom content handler.
- Returns:
- The argument content handler is returned for convenience.
- Throws:
- SAXException
- See Also:
- Formattable.formatXML(), http://www.jooq.org/xsd/jooq-export-3.10.0.xsd
 
 - 
compareTopublic int compareTo(Record that) Description copied from interface:RecordCompares thisRecordwith anotherRecordaccording to their natural ordering.jOOQ Records implement Comparableto allow for naturally ordering Records in a "SQL way", i.e. according to the following rules:Records being compared must have the same ROW typeTwo Records are comparable if and only if they have the same ROWtype, i.e. if theirfieldsRow()methods return fields of the same type and degree.Comparison rulesAssume the following notations: - X[i]means- X.getValue(i)
- X = Ymeans- X.compareTo(Y) == 0
- X < Ymeans- X.compareTo(Y) < 0
- X[i] = Y[i]means- (X[i] == null && Y[i] == null) || X[i].compareTo(Y[i]) == 0
- X[i] < Y[i]means- Y[i] == null || X[i].compareTo(Y[i]) < 0. This corresponds to the SQL- NULLS LASTclause.
 r1andr2,x = r1.compareTo(r2)yields:- x = -1: if- (r1[0] < r2[0]) OR (r1[0] = r2[0] AND r1[1] < r2[1]) OR ... OR (r1[0] = r2[0] AND ... AND r1[N-1] = r2[N-1] AND r1[N] < r2[N])
- x = 0: if- OR (r1[0] = r2[0] AND ... AND r1[N-1] = r2[N-1] AND r1[N] = r2[N]) 
- x = 1: if- (r1[0] > r2[0]) OR (r1[0] = r2[0] AND r1[1] > r2[1]) OR ... OR (r1[0] = r2[0] AND ... AND r1[N-1] = r2[N-1] AND r1[N] > r2[N])
 Note, that the above rules correspond to the SQL ordering behaviour as illustrated in the following examples: -- A SQL ORDER BY clause, ordering all records by columns in their order SELECT a, b, c FROM my_table ORDER BY 1, 2, 3 -- A row value expression comparison predicate SELECT * FROM my_table WHERE (a, b, c) < (1, 2, 3) See Row1.lessThan(Row1),Row2.lessThan(Row2), ...,Row22.lessThan(Row22)for more details about row value expression comparison predicatesAlternative sorting behaviour can be achieved through Result.sortAsc(java.util.Comparator)and similar methods.- Specified by:
- compareToin interface- Comparable<Record>
- Specified by:
- compareToin interface- Record
 
 - 
getValuepublic final <T> T getValue(Field<T> field) Description copied from interface:RecordGet a value from this Record, providing a field.[#2211] Future versions of jOOQ might remove this method. It is recommended to use Record.get(Field)instead.- Specified by:
- getValuein interface- Record
- See Also:
- Record.get(Field)
 
 - 
getValue@Deprecated public final <T> T getValue(Field<T> field, T defaultValue) Deprecated.Description copied from interface:RecordGet a value from this record, providing a field.
 - 
getValuepublic final <T> T getValue(Field<?> field, Class<? extends T> type) Description copied from interface:RecordGet a converted value from this Record, providing a field.[#2211] Future versions of jOOQ might remove tthis method. It is recommended to use Record.get(Field, Class)instead.- Specified by:
- getValuein interface- Record
- See Also:
- Record.get(Field, Class)
 
 - 
getValue@Deprecated public final <T> T getValue(Field<?> field, Class<? extends T> type, T defaultValue) Deprecated.Description copied from interface:RecordGet a converted value from this record, providing a field.- Specified by:
- getValuein interface- Record
- Type Parameters:
- T- The conversion type parameter
- Parameters:
- field- The field
- type- The conversion type
- defaultValue- The default value instead of- null
- Returns:
- The value of a field contained in this record, or defaultValue,
         if null
- See Also:
- Convert.convert(Object, Class)
 
 - 
getValuepublic final <T,U> U getValue(Field<T> field, Converter<? super T,? extends U> converter) Description copied from interface:RecordGet a converted value from this Record, providing a field.[#2211] Future versions of jOOQ might remove this method. It is recommended to use Record.get(Field, Converter)instead.- Specified by:
- getValuein interface- Record
- See Also:
- Record.get(Field, Converter)
 
 - 
getValue@Deprecated public final <T,U> U getValue(Field<T> field, Converter<? super T,? extends U> converter, U defaultValue) Deprecated.Description copied from interface:RecordGet a converted value from this record, providing a field.- Specified by:
- getValuein interface- Record
- Type Parameters:
- T- The database type parameter
- U- The conversion type parameter
- Parameters:
- field- The field
- converter- The data type converter
- defaultValue- The default value instead of- null
- Returns:
- The value of a field contained in this record, or defaultValue,
         if null
- See Also:
- Convert.convert(Object, Converter)
 
 - 
getValuepublic final Object getValue(int index) Description copied from interface:RecordGet a value from this record, providing a field index.[#2211] Future versions of jOOQ might remove this method. It is recommended to use Record.get(int)instead.- Specified by:
- getValuein interface- Record
- See Also:
- Record.get(int)
 
 - 
getValue@Deprecated public final Object getValue(int index, Object defaultValue) Deprecated.Description copied from interface:RecordGet a value from this record, providing a field index.
 - 
getValuepublic final <T> T getValue(int index, Class<? extends T> type)Description copied from interface:RecordGet a converted value from this record, providing a field index.[#2211] Future versions of jOOQ might remove this method. It is recommended to use Record.get(int, Class)instead.- Specified by:
- getValuein interface- Record
- See Also:
- Record.get(int, Class)
 
 - 
getValue@Deprecated public final <T> T getValue(int index, Class<? extends T> type, T defaultValue) Deprecated.Description copied from interface:RecordGet a converted value from this record, providing a field index.- Specified by:
- getValuein interface- Record
- Type Parameters:
- T- The conversion type parameter
- Parameters:
- index- The field's index
- type- The conversion type
- defaultValue- The default value instead of- null
- Returns:
- The value of a field's index contained in this record, or
         defaultValue, if null
- See Also:
- Convert.convert(Object, Class)
 
 - 
getValuepublic final <U> U getValue(int index, Converter<?,? extends U> converter)Description copied from interface:RecordGet a converted value from this record, providing a field index.[#2211] Future versions of jOOQ might remove this method. It is recommended to use Record.get(int, Converter)instead.- Specified by:
- getValuein interface- Record
- See Also:
- Record.get(int, Converter)
 
 - 
getValue@Deprecated public final <U> U getValue(int index, Converter<?,? extends U> converter, U defaultValue) Deprecated.Description copied from interface:RecordGet a converted value from this record, providing a field index.- Specified by:
- getValuein interface- Record
- Type Parameters:
- U- The conversion type parameter
- Parameters:
- index- The field's index
- converter- The data type converter
- defaultValue- The default value instead of- null
- Returns:
- The value of a field's index contained in this record, or
         defaultValue, if null
- See Also:
- Convert.convert(Object, Converter)
 
 - 
getValuepublic final Object getValue(String fieldName) Description copied from interface:RecordGet a value from this Record, providing a field name.[#2211] Future versions of jOOQ might remove this method. It is recommended to use Record.get(String)instead.- Specified by:
- getValuein interface- Record
- See Also:
- Record.get(String)
 
 - 
getValue@Deprecated public final Object getValue(String fieldName, Object defaultValue) Deprecated.Description copied from interface:RecordGet a value from this record, providing a field name.
 - 
getValuepublic final <T> T getValue(String fieldName, Class<? extends T> type) Description copied from interface:RecordGet a converted value from this Record, providing a field name.[#2211] Future versions of jOOQ might remove this method. It is recommended to use Record.get(String, Class)instead.- Specified by:
- getValuein interface- Record
- See Also:
- Record.get(String, Class)
 
 - 
getValue@Deprecated public final <T> T getValue(String fieldName, Class<? extends T> type, T defaultValue) Deprecated.Description copied from interface:RecordGet a converted value from this record, providing a field name.- Specified by:
- getValuein interface- Record
- Type Parameters:
- T- The conversion type parameter
- Parameters:
- fieldName- The field's name
- type- The conversion type
- defaultValue- The default value instead of- null
- Returns:
- The value of a field's name contained in this record, or
         defaultValue, if null
- See Also:
- Convert.convert(Object, Class)
 
 - 
getValuepublic final <U> U getValue(String fieldName, Converter<?,? extends U> converter) Description copied from interface:RecordGet a converted value from this Record, providing a field name.[#2211] Future versions of jOOQ might remove this method. It is recommended to use Record.get(String, Converter)instead.- Specified by:
- getValuein interface- Record
- See Also:
- Record.get(String, Converter)
 
 - 
getValue@Deprecated public final <U> U getValue(String fieldName, Converter<?,? extends U> converter, U defaultValue) Deprecated.Description copied from interface:RecordGet a converted value from this record, providing a field name.- Specified by:
- getValuein interface- Record
- Type Parameters:
- U- The conversion type parameter
- Parameters:
- fieldName- The field's name
- converter- The data type converter
- defaultValue- The default value instead of- null
- Returns:
- The value of a field's name contained in this record, or
         defaultValue, if null
- See Also:
- Convert.convert(Object, Converter)
 
 - 
getValuepublic final Object getValue(Name fieldName) Description copied from interface:RecordGet a value from this Record, providing a field name.[#2211] Future versions of jOOQ might remove this method. It is recommended to use Record.get(Name)instead.- Specified by:
- getValuein interface- Record
- See Also:
- Record.get(Name)
 
 - 
getValuepublic final <T> T getValue(Name fieldName, Class<? extends T> type) Description copied from interface:RecordGet a converted value from this Record, providing a field name.[#2211] Future versions of jOOQ might remove this method. It is recommended to use Record.get(Name, Class)instead.- Specified by:
- getValuein interface- Record
- See Also:
- Record.get(Name, Class)
 
 - 
getValuepublic final <U> U getValue(Name fieldName, Converter<?,? extends U> converter) Description copied from interface:RecordGet a converted value from this Record, providing a field name.[#2211] Future versions of jOOQ might remove this method. It is recommended to use Record.get(Name, Converter)instead.- Specified by:
- getValuein interface- Record
- See Also:
- Record.get(Name, Converter)
 
 - 
setValuepublic final <T> void setValue(Field<T> field, T value) Description copied from interface:RecordSet a value into this record.[#2211] Future versions of jOOQ might remove this method. It is recommended to use Record.set(Field, Object)instead.- Specified by:
- setValuein interface- Record
- See Also:
- Record.set(Field, Object)
 
 - 
setValuepublic final <T,U> void setValue(Field<T> field, U value, Converter<? extends T,? super U> converter) Description copied from interface:RecordSet a value into this record.[#2211] Future versions of jOOQ might remove this method. It is recommended to use Record.set(Field, Object, Converter)instead.- Specified by:
- setValuein interface- Record
- See Also:
- Record.set(Field, Object, Converter)
 
 - 
attachpublic final void attach(Configuration c) Description copied from interface:AttachableAttach this object to a newConfiguration.- Specified by:
- attachin interface- Attachable
- Parameters:
- c- A configuration or- null, if you wish to detach this- Attachablefrom its previous configuration.
 
 - 
detachpublic final void detach() Description copied from interface:AttachableDetach this object from its currentConfiguration.This is the same as calling attach(null).- Specified by:
- detachin interface- Attachable
 
 - 
configurationpublic final Configuration configuration() Description copied from interface:Attachable- Specified by:
- configurationin interface- Attachable
 
 - 
create@Deprecated protected final DSLContext create() Deprecated.- 3.11.0 - [#6720] [#6721] - UseAttachable.configuration()andConfiguration.dsl()instead.This method is used in generated code!
 - 
formatpublic final String format() Description copied from interface:FormattableGet a simple formatted representation of this result.This is the same as calling Formattable.format(int)withmaxRows = Integer.MAX_VALUE- Specified by:
- formatin interface- Formattable
- Returns:
- The formatted result
 
 - 
formatpublic final String format(int maxRecords) Description copied from interface:FormattableGet a simple formatted representation of this result.- Specified by:
- formatin interface- Formattable
- Parameters:
- maxRecords- The maximum number of records to include in the formatted result
- Returns:
- The formatted result
 
 - 
formatpublic final String format(TXTFormat format) Description copied from interface:FormattableGet a simple formatted representation of this result.- Specified by:
- formatin interface- Formattable
- Parameters:
- format- The formatting information
- Returns:
- The formatted result
 
 - 
formatpublic final void format(OutputStream stream) Description copied from interface:FormattableLikeFormattable.format(), but the data is output onto anOutputStream.- Specified by:
- formatin interface- Formattable
 
 - 
formatpublic final void format(OutputStream stream, int maxRecords) Description copied from interface:FormattableLikeFormattable.format(int), but the data is output onto anOutputStream.- Specified by:
- formatin interface- Formattable
 
 - 
formatpublic final void format(OutputStream stream, TXTFormat format) Description copied from interface:FormattableLikeFormattable.format(TXTFormat), but the data is output onto anOutputStream.- Specified by:
- formatin interface- Formattable
 
 - 
formatpublic final void format(Writer writer) Description copied from interface:FormattableLikeFormattable.format(), but the data is output onto aWriter.- Specified by:
- formatin interface- Formattable
 
 - 
formatpublic final void format(Writer writer, int maxRecords) Description copied from interface:FormattableLikeFormattable.format(int), but the data is output onto aWriter.- Specified by:
- formatin interface- Formattable
 
 - 
formatCSVpublic final String formatCSV() Description copied from interface:FormattableGet a simple formatted representation of this result as CSV.This is the same as calling formatCSV(true, ',', "")- Specified by:
- formatCSVin interface- Formattable
- Returns:
- The formatted result
 
 - 
formatCSVpublic final String formatCSV(boolean header) Description copied from interface:FormattableGet a simple formatted representation of this result as CSV.This is the same as calling formatCSV(',', "")- Specified by:
- formatCSVin interface- Formattable
- Parameters:
- header- Whether to emit a CSV header line
- Returns:
- The formatted result
 
 - 
formatCSVpublic final void formatCSV(OutputStream stream) Description copied from interface:FormattableLikeFormattable.formatCSV(), but the data is output onto anOutputStream.- Specified by:
- formatCSVin interface- Formattable
 
 - 
formatCSVpublic final void formatCSV(OutputStream stream, boolean header) Description copied from interface:FormattableLikeFormattable.formatCSV(boolean), but the data is output onto anOutputStream.- Specified by:
- formatCSVin interface- Formattable
 
 - 
formatCSVpublic final void formatCSV(Writer writer) Description copied from interface:FormattableLikeFormattable.formatCSV(), but the data is output onto aWriter.- Specified by:
- formatCSVin interface- Formattable
 
 - 
formatCSVpublic final void formatCSV(Writer writer, boolean header) Description copied from interface:FormattableLikeFormattable.formatCSV(boolean), but the data is output onto aWriter.- Specified by:
- formatCSVin interface- Formattable
 
 - 
formatCSVpublic final String formatCSV(char delimiter) Description copied from interface:FormattableGet a simple formatted representation of this result as CSV.This is the same as calling formatCSV(true, delimiter, "")- Specified by:
- formatCSVin interface- Formattable
- Parameters:
- delimiter- The delimiter to use between records
- Returns:
- The formatted result
 
 - 
formatCSVpublic final String formatCSV(boolean header, char delimiter) Description copied from interface:FormattableGet a simple formatted representation of this result as CSV.This is the same as calling formatCSV(delimiter, "")- Specified by:
- formatCSVin interface- Formattable
- Parameters:
- header- Whether to emit a CSV header line
- delimiter- The delimiter to use between records
- Returns:
- The formatted result
 
 - 
formatCSVpublic final void formatCSV(OutputStream stream, char delimiter) Description copied from interface:FormattableLikeFormattable.formatCSV(char), but the data is output onto anOutputStream.- Specified by:
- formatCSVin interface- Formattable
 
 - 
formatCSVpublic final void formatCSV(OutputStream stream, boolean header, char delimiter) Description copied from interface:FormattableLikeFormattable.formatCSV(boolean, char), but the data is output onto anOutputStream.- Specified by:
- formatCSVin interface- Formattable
 
 - 
formatCSVpublic final void formatCSV(Writer writer, char delimiter) Description copied from interface:FormattableLikeFormattable.formatCSV(char), but the data is output onto aWriter.- Specified by:
- formatCSVin interface- Formattable
 
 - 
formatCSVpublic final void formatCSV(Writer writer, boolean header, char delimiter) Description copied from interface:FormattableLikeFormattable.formatCSV(boolean, char), but the data is output onto aWriter.- Specified by:
- formatCSVin interface- Formattable
 
 - 
formatCSVpublic final String formatCSV(char delimiter, String nullString) Description copied from interface:FormattableGet a simple formatted representation of this result as CSV.This is the same as calling formatCSV(true, delimiter, nullString)- Specified by:
- formatCSVin interface- Formattable
- Parameters:
- delimiter- The delimiter to use between records
- nullString- A special string for encoding- NULLvalues.
- Returns:
- The formatted result
 
 - 
formatCSVpublic final String formatCSV(boolean header, char delimiter, String nullString) Description copied from interface:FormattableGet a simple formatted representation of this result as CSV.- Specified by:
- formatCSVin interface- Formattable
- Parameters:
- header- Whether to emit a CSV header line
- delimiter- The delimiter to use between records
- nullString- A special string for encoding- NULLvalues.
- Returns:
- The formatted result
 
 - 
formatCSVpublic final String formatCSV(CSVFormat format) Description copied from interface:FormattableGet a simple formatted representation of this result as CSV.- Specified by:
- formatCSVin interface- Formattable
- Returns:
- The formatted result
 
 - 
formatCSVpublic final void formatCSV(OutputStream stream, char delimiter, String nullString) Description copied from interface:FormattableLikeFormattable.formatCSV(char, String), but the data is output onto anOutputStream.- Specified by:
- formatCSVin interface- Formattable
 
 - 
formatCSVpublic final void formatCSV(OutputStream stream, boolean header, char delimiter, String nullString) Description copied from interface:FormattableLikeFormattable.formatCSV(boolean, char, String), but the data is output onto anOutputStream.- Specified by:
- formatCSVin interface- Formattable
 
 - 
formatCSVpublic final void formatCSV(OutputStream stream, CSVFormat format) Description copied from interface:FormattableLikeFormattable.formatCSV(CSVFormat), but the data is output onto anOutputStream.- Specified by:
- formatCSVin interface- Formattable
 
 - 
formatCSVpublic final void formatCSV(Writer writer, char delimiter, String nullString) Description copied from interface:FormattableLikeFormattable.formatCSV(char, String), but the data is output onto aWriter.- Specified by:
- formatCSVin interface- Formattable
 
 - 
formatCSVpublic final void formatCSV(Writer writer, boolean header, char delimiter, String nullString) Description copied from interface:FormattableLikeFormattable.formatCSV(boolean, char, String), but the data is output onto aWriter.- Specified by:
- formatCSVin interface- Formattable
 
 - 
formatJSONpublic final String formatJSON() Description copied from interface:FormattableGet a simple formatted representation of this result as a JSON array of array.The format is the following: {"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]]}- Specified by:
- formatJSONin interface- Formattable
- Returns:
- The formatted result
 
 - 
formatJSONpublic final String formatJSON(JSONFormat format) Description copied from interface:FormattableGet a simple formatted representation of this result as a JSON data structure, according to the format.- Specified by:
- formatJSONin interface- Formattable
- Returns:
- The formatted result
- See Also:
- JSONFormat
 
 - 
formatJSONpublic final void formatJSON(OutputStream stream) Description copied from interface:FormattableLikeFormattable.formatJSON(), but the data is output onto anOutputStream.- Specified by:
- formatJSONin interface- Formattable
 
 - 
formatJSONpublic final void formatJSON(OutputStream stream, JSONFormat format) Description copied from interface:FormattableLikeFormattable.formatJSON(JSONFormat), but the data is output onto anOutputStream.- Specified by:
- formatJSONin interface- Formattable
 
 - 
formatJSONpublic final void formatJSON(Writer writer) Description copied from interface:FormattableLikeFormattable.formatJSON(), but the data is output onto aWriter.- Specified by:
- formatJSONin interface- Formattable
 
 - 
formatXMLpublic final String formatXML() Description copied from interface:FormattableGet this result formatted as XML.- Specified by:
- formatXMLin interface- Formattable
- See Also:
- http://www.jooq.org/xsd/jooq-export-3.10.0.xsd
 
 - 
formatXMLpublic final String formatXML(XMLFormat format) Description copied from interface:FormattableGet this result formatted as XML.- Specified by:
- formatXMLin interface- Formattable
- See Also:
- http://www.jooq.org/xsd/jooq-export-3.10.0.xsd
 
 - 
formatXMLpublic final void formatXML(OutputStream stream) Description copied from interface:FormattableLikeFormattable.formatXML(), but the data is output onto anOutputStream.- Specified by:
- formatXMLin interface- Formattable
 
 - 
formatXMLpublic final void formatXML(OutputStream stream, XMLFormat format) Description copied from interface:FormattableLikeFormattable.formatXML(XMLFormat), but the data is output onto anOutputStream.- Specified by:
- formatXMLin interface- Formattable
 
 - 
formatXMLpublic final void formatXML(Writer writer) Description copied from interface:FormattableLikeFormattable.formatXML(), but the data is output onto aWriter.- Specified by:
- formatXMLin interface- Formattable
 
 - 
formatChartpublic final String formatChart() - Specified by:
- formatChartin interface- Formattable
 
 - 
formatChartpublic final String formatChart(ChartFormat format) - Specified by:
- formatChartin interface- Formattable
 
 - 
formatChartpublic final void formatChart(OutputStream stream) Description copied from interface:FormattableLikeFormattable.formatChart(), but the data is output onto anOutputStream.- Specified by:
- formatChartin interface- Formattable
 
 - 
formatChartpublic final void formatChart(OutputStream stream, ChartFormat format) Description copied from interface:FormattableLikeFormattable.formatChart(ChartFormat), but the data is output onto anOutputStream.- Specified by:
- formatChartin interface- Formattable
 
 - 
formatChartpublic final void formatChart(Writer writer) Description copied from interface:FormattableLikeFormattable.formatChart(), but the data is output onto aWriter.- Specified by:
- formatChartin interface- Formattable
 
 - 
formatInsertpublic final String formatInsert() Description copied from interface:FormattableGet this result as a set ofINSERTstatements.This uses the the first record's TableRecord.getTable(), if the first record is aTableRecord. Otherwise, this generatesINSERTstatements into an"UNKNOWN_TABLE". In both cases, theResult.fields()are used for column names.- Specified by:
- formatInsertin interface- Formattable
 
 - 
formatInsertpublic final void formatInsert(OutputStream stream) Description copied from interface:FormattableLikeFormattable.formatInsert(), but the data is output onto anOutputStream.- Specified by:
- formatInsertin interface- Formattable
 
 - 
formatInsertpublic final String formatInsert(Table<?> table, Field<?>... f) Description copied from interface:FormattableGet this result as a set ofINSERTstatements.This explicitly specifies the table (and optionally the fields) to insert into. If the fieldsargument is left empty, theResult.fields()are used, instead.- Specified by:
- formatInsertin interface- Formattable
 
 - 
formatInsertpublic final void formatInsert(OutputStream stream, Table<?> table, Field<?>... f) Description copied from interface:FormattableLikeFormattable.formatInsert(Table, Field...), but the data is output onto anOutputStream.- Specified by:
- formatInsertin interface- Formattable
 
 - 
formatHTMLpublic final String formatHTML() Description copied from interface:FormattableGet a simple formatted representation of this result as HTML.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>- Specified by:
- formatHTMLin interface- Formattable
- Returns:
- The formatted result
 
 - 
formatHTMLpublic final void formatHTML(OutputStream stream) Description copied from interface:FormattableLikeFormattable.formatHTML(), but the data is output onto anOutputStream.- Specified by:
- formatHTMLin interface- Formattable
 
 - 
intoXMLpublic final Document intoXML() Description copied from interface:FormattableGet this result as XML.- Specified by:
- intoXMLin interface- Formattable
- See Also:
- Formattable.formatXML(), http://www.jooq.org/xsd/jooq-export-3.10.0.xsd
 
 - 
intoXMLpublic final <H extends ContentHandler> H intoXML(H handler) throws SAXException Description copied from interface:FormattableGet this result as XML using a SAXContentHandler.- Specified by:
- intoXMLin interface- Formattable
- Parameters:
- handler- The custom content handler.
- Returns:
- The argument content handler is returned for convenience.
- Throws:
- SAXException
- See Also:
- Formattable.formatXML(), http://www.jooq.org/xsd/jooq-export-3.10.0.xsd
 
 
- 
 
-