Exporting XML

// Fetch books and format them as XML
String xml = create.selectFrom(BOOK).fetch().formatXML();

<result xmlns="http://www.jooq.org/xsd/jooq-export-2.6.0.xsd">
  <fields>
    <field name="ID" type="INTEGER"/>
    <field name="AUTHOR_ID" type="INTEGER"/>
    <field name="TITLE" type="VARCHAR"/>
  </fields>
  <records>
    <record>
      <value field="ID">1</value>
      <value field="AUTHOR_ID">1</value>
      <value field="TITLE">1984</value>
    </record>
    <record>
      <value field="ID">2</value>
      <value field="AUTHOR_ID">1</value>
      <value field="TITLE">Animal Farm</value>
    </record>
  </records>
</result>

// Fetch books and format them as XML
Document xml = create.selectFrom(BOOK).fetch().intoXML();