- All Implemented Interfaces:
- Serializable,- Iterable<BigDecimal>,- Collection<BigDecimal>,- List<BigDecimal>,- SequencedCollection<BigDecimal>,- ArrayOrAssociativeArrayRecord<BigDecimal>,- ArrayRecord<BigDecimal>,- Attachable,- Formattable
- Enclosing class:
- DefaultBinding<T,- U> 
- See Also:
- 
Constructor SummaryConstructors
- 
Method SummaryModifier and TypeMethodDescriptionfinal voidAttach this object to a newConfiguration.final Configurationprotected final DSLContextcreate()Deprecated.final voiddetach()Detach this object from its currentConfiguration.final Stringformat()Get a simple formatted representation of this result.final Stringformat(int maxRecords) Get a simple formatted representation of this result.final voidformat(OutputStream stream) LikeFormattable.format(), but the data is output onto anOutputStream.final voidformat(OutputStream stream, int maxRecords) LikeFormattable.format(int), but the data is output onto anOutputStream.final voidformat(OutputStream stream, TXTFormat format) LikeFormattable.format(TXTFormat), but the data is output onto anOutputStream.final voidLikeFormattable.format(), but the data is output onto aWriter.final voidLikeFormattable.format(int), but the data is output onto aWriter.final StringGet a simple formatted representation of this result.final StringGet this result as an ASCII chart.final voidformatChart(OutputStream stream) LikeFormattable.formatChart(), but the data is output onto anOutputStream.final voidformatChart(OutputStream stream, ChartFormat format) LikeFormattable.formatChart(ChartFormat), but the data is output onto anOutputStream.final voidformatChart(Writer writer) LikeFormattable.formatChart(), but the data is output onto aWriter.final StringformatChart(ChartFormat format) Get this result as an ASCII chart.final StringGet a simple formatted representation of this result as CSV.final StringformatCSV(boolean header) Get a simple formatted representation of this result as CSV.final StringformatCSV(boolean header, char delimiter) Get a simple formatted representation of this result as CSV.final StringGet a simple formatted representation of this result as CSV.final StringformatCSV(char delimiter) Get a simple formatted representation of this result as CSV.final StringGet a simple formatted representation of this result as CSV.final voidformatCSV(OutputStream stream) LikeFormattable.formatCSV(), but the data is output onto anOutputStream.final voidformatCSV(OutputStream stream, boolean header) LikeFormattable.formatCSV(boolean), but the data is output onto anOutputStream.final voidformatCSV(OutputStream stream, boolean header, char delimiter) LikeFormattable.formatCSV(boolean, char), but the data is output onto anOutputStream.final voidformatCSV(OutputStream stream, boolean header, char delimiter, String nullString) LikeFormattable.formatCSV(boolean, char, String), but the data is output onto anOutputStream.final voidformatCSV(OutputStream stream, char delimiter) LikeFormattable.formatCSV(char), but the data is output onto anOutputStream.final voidformatCSV(OutputStream stream, char delimiter, String nullString) LikeFormattable.formatCSV(char, String), but the data is output onto anOutputStream.final voidformatCSV(OutputStream stream, CSVFormat format) LikeFormattable.formatCSV(CSVFormat), but the data is output onto anOutputStream.final voidLikeFormattable.formatCSV(), but the data is output onto aWriter.final voidLikeFormattable.formatCSV(boolean), but the data is output onto aWriter.final voidLikeFormattable.formatCSV(boolean, char), but the data is output onto aWriter.final voidLikeFormattable.formatCSV(boolean, char, String), but the data is output onto aWriter.final voidLikeFormattable.formatCSV(char), but the data is output onto aWriter.final voidLikeFormattable.formatCSV(char, String), but the data is output onto aWriter.final StringGet a simple formatted representation of this result as CSV.final StringGet a simple formatted representation of this result as HTML.final voidformatHTML(OutputStream stream) LikeFormattable.formatHTML(), but the data is output onto anOutputStream.final StringGet this result as a set ofINSERTstatements.final voidformatInsert(OutputStream stream) LikeFormattable.formatInsert(), but the data is output onto anOutputStream.final voidformatInsert(OutputStream stream, Table<?> table, Field<?>... f) LikeFormattable.formatInsert(Table, Field...), but the data is output onto anOutputStream.final StringformatInsert(Table<?> table, Field<?>... f) Get this result as a set ofINSERTstatements.final StringGet a simple formatted representation of this result as a JSON array of array.final voidformatJSON(OutputStream stream) LikeFormattable.formatJSON(), but the data is output onto anOutputStream.final voidformatJSON(OutputStream stream, JSONFormat format) LikeFormattable.formatJSON(JSONFormat), but the data is output onto anOutputStream.final voidformatJSON(Writer writer) LikeFormattable.formatJSON(), but the data is output onto aWriter.final StringformatJSON(JSONFormat format) Get a simple formatted representation of this result as a JSON data structure, according to the format.final StringGet this result formatted as XML.final voidformatXML(OutputStream stream) LikeFormattable.formatXML(), but the data is output onto anOutputStream.final voidformatXML(OutputStream stream, XMLFormat format) LikeFormattable.formatXML(XMLFormat), but the data is output onto anOutputStream.final voidLikeFormattable.formatXML(), but the data is output onto aWriter.final StringGet this result formatted as XML.final DocumentintoXML()Get this result as XML.final <H extends ContentHandler>
 HintoXML(H handler) Get this result as XML using a SAXContentHandler.Methods inherited from class org.jooq.impl.ArrayRecordImpladd, add, addAll, addAll, clear, contains, containsAll, equals, format, formatChart, formatCSV, formatHTML, formatInsert, formatInsert, formatJSON, formatXML, get, getArrayType, getCatalog, getDataType, getName, getPackage, getSchema, hashCode, indexOf, intoXML, intoXML, isEmpty, isSQLUsable, iterator, lastIndexOf, listIterator, listIterator, remove, remove, removeAll, retainAll, set, size, subList, toArray, toArray, toList, toStringMethods inherited from class java.lang.Objectclone, finalize, getClass, notify, notifyAll, wait, wait, waitMethods inherited from interface org.jooq.Attachableattach, configuration, detachMethods inherited from interface java.util.CollectionparallelStream, removeIf, stream, toArrayMethods inherited from interface org.jooq.Formattableformat, format, format, format, format, format, format, format, 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, formatHTML, formatHTML, formatInsert, formatInsert, formatInsert, formatInsert, formatJSON, formatJSON, formatJSON, formatJSON, formatJSON, formatXML, formatXML, formatXML, formatXML, formatXML, intoXML, intoXMLMethods inherited from interface java.util.ListaddFirst, addLast, getFirst, getLast, removeFirst, removeLast, replaceAll, reversed, sort, spliterator
- 
Constructor Details- 
SdoElemInfoArraypublic SdoElemInfoArray()
 
- 
- 
Method Details- 
createDeprecated.- 3.11.0 - [#6720] [#6721] - UseAttachable.configuration()andConfiguration.dsl()instead.This method is used in generated code!
- 
attachDescription 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
 
- 
configurationDescription copied from interface:Attachable- Specified by:
- configurationin interface- Attachable
 
- 
formatDescription 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
 
- 
formatDescription 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
 
- 
formatDescription 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
 
- 
formatDescription copied from interface:FormattableLikeFormattable.format(), but the data is output onto anOutputStream.- Specified by:
- formatin interface- Formattable
 
- 
formatDescription copied from interface:FormattableLikeFormattable.format(int), but the data is output onto anOutputStream.- Specified by:
- formatin interface- Formattable
 
- 
formatDescription copied from interface:FormattableLikeFormattable.format(TXTFormat), but the data is output onto anOutputStream.- Specified by:
- formatin interface- Formattable
 
- 
formatDescription copied from interface:FormattableLikeFormattable.format(), but the data is output onto aWriter.- Specified by:
- formatin interface- Formattable
 
- 
formatDescription copied from interface:FormattableLikeFormattable.format(int), but the data is output onto aWriter.- Specified by:
- formatin interface- Formattable
 
- 
formatCSVDescription 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
 
- 
formatCSVDescription 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
 
- 
formatCSVDescription 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
 
- 
formatCSVDescription 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
 
- 
formatCSVDescription 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
 
- 
formatCSVDescription 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
 
- 
formatCSVDescription copied from interface:FormattableGet a simple formatted representation of this result as CSV.- Specified by:
- formatCSVin interface- Formattable
- Returns:
- The formatted result
 
- 
formatCSVDescription copied from interface:FormattableLikeFormattable.formatCSV(), but the data is output onto anOutputStream.- Specified by:
- formatCSVin interface- Formattable
 
- 
formatCSVDescription copied from interface:FormattableLikeFormattable.formatCSV(boolean), but the data is output onto anOutputStream.- Specified by:
- formatCSVin interface- Formattable
 
- 
formatCSVDescription copied from interface:FormattableLikeFormattable.formatCSV(char), but the data is output onto anOutputStream.- Specified by:
- formatCSVin interface- Formattable
 
- 
formatCSVDescription copied from interface:FormattableLikeFormattable.formatCSV(boolean, char), but the data is output onto anOutputStream.- Specified by:
- formatCSVin interface- Formattable
 
- 
formatCSVDescription copied from interface:FormattableLikeFormattable.formatCSV(char, String), but the data is output onto anOutputStream.- Specified by:
- formatCSVin interface- Formattable
 
- 
formatCSVDescription copied from interface:FormattableLikeFormattable.formatCSV(boolean, char, String), but the data is output onto anOutputStream.- Specified by:
- formatCSVin interface- Formattable
 
- 
formatCSVDescription copied from interface:FormattableLikeFormattable.formatCSV(CSVFormat), but the data is output onto anOutputStream.- Specified by:
- formatCSVin interface- Formattable
 
- 
formatCSVDescription copied from interface:FormattableLikeFormattable.formatCSV(), but the data is output onto aWriter.- Specified by:
- formatCSVin interface- Formattable
 
- 
formatCSVDescription copied from interface:FormattableLikeFormattable.formatCSV(boolean), but the data is output onto aWriter.- Specified by:
- formatCSVin interface- Formattable
 
- 
formatCSVDescription copied from interface:FormattableLikeFormattable.formatCSV(char), but the data is output onto aWriter.- Specified by:
- formatCSVin interface- Formattable
 
- 
formatCSVDescription copied from interface:FormattableLikeFormattable.formatCSV(boolean, char), but the data is output onto aWriter.- Specified by:
- formatCSVin interface- Formattable
 
- 
formatCSVDescription copied from interface:FormattableLikeFormattable.formatCSV(char, String), but the data is output onto aWriter.- Specified by:
- formatCSVin interface- Formattable
 
- 
formatCSVDescription copied from interface:FormattableLikeFormattable.formatCSV(boolean, char, String), but the data is output onto aWriter.- Specified by:
- formatCSVin interface- Formattable
 
- 
formatJSONDescription 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
 
- 
formatJSONDescription 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:
 
- 
formatJSONDescription copied from interface:FormattableLikeFormattable.formatJSON(), but the data is output onto anOutputStream.- Specified by:
- formatJSONin interface- Formattable
 
- 
formatJSONDescription copied from interface:FormattableLikeFormattable.formatJSON(JSONFormat), but the data is output onto anOutputStream.- Specified by:
- formatJSONin interface- Formattable
 
- 
formatJSONDescription copied from interface:FormattableLikeFormattable.formatJSON(), but the data is output onto aWriter.- Specified by:
- formatJSONin interface- Formattable
 
- 
formatXMLDescription copied from interface:FormattableGet this result formatted as XML.- Specified by:
- formatXMLin interface- Formattable
- See Also:
 
- 
formatXMLDescription copied from interface:FormattableGet this result formatted as XML.- Specified by:
- formatXMLin interface- Formattable
- See Also:
 
- 
formatXMLDescription copied from interface:FormattableLikeFormattable.formatXML(), but the data is output onto anOutputStream.- Specified by:
- formatXMLin interface- Formattable
 
- 
formatXMLDescription copied from interface:FormattableLikeFormattable.formatXML(XMLFormat), but the data is output onto anOutputStream.- Specified by:
- formatXMLin interface- Formattable
 
- 
formatXMLDescription copied from interface:FormattableLikeFormattable.formatXML(), but the data is output onto aWriter.- Specified by:
- formatXMLin interface- Formattable
 
- 
formatChartDescription copied from interface:FormattableGet this result as an ASCII chart.- Specified by:
- formatChartin interface- Formattable
- See Also:
 
- 
formatChartDescription copied from interface:FormattableGet this result as an ASCII chart.When running a query like this: 
 Where the formatted result would look like this:String chart = create.select( BOOK_TO_BOOK_STORE.BOOK_STORE_NAME, count(BOOK_TO_BOOK_STORE.BOOK_ID).as("books") ) .from(BOOK_TO_BOOK_STORE) .groupBy(BOOK_TO_BOOK_STORE.BOOK_STORE_NAME) .fetch() .formatChart();+-------------------------+-----+ |BOOK_STORE_NAME |books| +-------------------------+-----+ |Buchhandlung im Volkshaus| 1| |Ex Libris | 2| |Orell Füssli | 3| +-------------------------+-----+ Then the chart might look something like this:3.00| █████████████████████████ 2.91| █████████████████████████ 2.82| █████████████████████████ 2.73| █████████████████████████ 2.64| █████████████████████████ 2.55| █████████████████████████ 2.45| █████████████████████████ 2.36| █████████████████████████ 2.27| █████████████████████████ 2.18| █████████████████████████ 2.09| █████████████████████████ 2.00| ██████████████████████████████████████████████████ 1.91| ██████████████████████████████████████████████████ 1.82| ██████████████████████████████████████████████████ 1.73| ██████████████████████████████████████████████████ 1.64| ██████████████████████████████████████████████████ 1.55| ██████████████████████████████████████████████████ 1.45| ██████████████████████████████████████████████████ 1.36| ██████████████████████████████████████████████████ 1.27| ██████████████████████████████████████████████████ 1.18| ██████████████████████████████████████████████████ 1.09| ██████████████████████████████████████████████████ 1.00|███████████████████████████████████████████████████████████████████████████ ----+--------------------------------------------------------------------------- | Buchhandlung im Volkshaus Ex Libris Orell FüssliIt is possible to specify a variety ofChartFormatformatting specifications, such as the width, height, display type (default, stacked, 100% stacked), the column index of the category and value columns, etc.- Specified by:
- formatChartin interface- Formattable
- See Also:
 
- 
formatChartDescription copied from interface:FormattableLikeFormattable.formatChart(), but the data is output onto anOutputStream.- Specified by:
- formatChartin interface- Formattable
 
- 
formatChartDescription copied from interface:FormattableLikeFormattable.formatChart(ChartFormat), but the data is output onto anOutputStream.- Specified by:
- formatChartin interface- Formattable
 
- 
formatChartDescription copied from interface:FormattableLikeFormattable.formatChart(), but the data is output onto aWriter.- Specified by:
- formatChartin interface- Formattable
 
- 
formatInsertDescription 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, theFields.fields()are used for column names.- Specified by:
- formatInsertin interface- Formattable
 
- 
formatInsertDescription copied from interface:FormattableLikeFormattable.formatInsert(), but the data is output onto anOutputStream.- Specified by:
- formatInsertin interface- Formattable
 
- 
formatInsertDescription 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, theFields.fields()are used, instead.- Specified by:
- formatInsertin interface- Formattable
 
- 
formatInsertDescription copied from interface:FormattableLikeFormattable.formatInsert(Table, Field...), but the data is output onto anOutputStream.- Specified by:
- formatInsertin interface- Formattable
 
- 
formatHTMLDescription 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
 
- 
formatHTMLDescription copied from interface:FormattableLikeFormattable.formatHTML(), but the data is output onto anOutputStream.- Specified by:
- formatHTMLin interface- Formattable
 
- 
intoXMLDescription copied from interface:FormattableGet this result as XML.- Specified by:
- intoXMLin interface- Formattable
- See Also:
 
- 
intoXMLDescription 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:
 
 
- 
Attachable.configuration()andConfiguration.dsl()instead.