import org.jooq.*; import static org.jooq.impl.DSL.*; Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password"); DSLContext create = DSL.using(conn, SQLDialect.MYSQL); Result<Record> result = create.select().from(table("mytable")).fetch(); for (Record r : result) { String value = r.getValue("mycolumn"); System.out.println(value); } conn.close();