<dependency>
<groupId>org.jooq</groupId>
<artifactId>jooq</artifactId>
<version>3.14.6</version>
</dependency>
<configuration xmlns="http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd">
<jdbc>
<driver>com.mysql.jdbc.Driver</driver>
<url>jdbc:mysql://localhost:3306/mydatabase</url>
<user>myuser</user>
<password>mypassword</password>
</jdbc>
<generator>
<database>
<name>org.jooq.meta.mysql.MySQLDatabase</name>
<includes>.*</includes>
<excludes></excludes>
<inputSchema>public</inputSchema>
</database>
<target>
<packageName>com.example.model</packageName>
<directory>src/main/java</directory>
</target>
</generator>
</configuration>
java -cp jooq.jar:jdbc.jar:codegen.jar org.jooq.codegen.GenerationTool jooq-codegen.xml
Result<Record> result = DSL.using(connection, SQLDialect.MYSQL)
.select()
.from(Tables.CUSTOMER)
.where(Tables.CUSTOMER.ID.eq(1))
.fetch();
for (Record record : result) {
System.out.println(record.get(Tables.CUSTOMER.NAME));
}