Available in versions: Dev (3.17) | Latest (3.16) | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10 | 3.9 | 3.8 | 3.7
Generated DAOs
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
Generated DAOs
Every table and view in your database will generate a org.jooq.DAO implementation that looks like this:
public class BookDao extends DAOImpl<BookRecord, Book, Integer> {
// Generated constructors
public BookDao() {
super(BOOK, Book.class);
}
public BookDao(Configuration configuration) {
super(BOOK, Book.class, configuration);
}
// Every column generates at least one fetch method
public List<Book> fetchById(Integer... values) {
return fetch(BOOK.ID, values);
}
public Book fetchOneById(Integer value) {
return fetchOne(BOOK.ID, value);
}
public List<Book> fetchByAuthorId(Integer... values) {
return fetch(BOOK.AUTHOR_ID, values);
}
// [...]
}
XML (standalone and maven)
Programmatic
Gradle
<configuration xmlns="http://www.jooq.org/xsd/jooq-codegen-3.8.7.xsd">
<generator>
<generate>
<!-- Generate the DAO classes -->
<daos>true</daos>
<!-- Annotate DAOs (and other types) with spring annotations, such as @Repository and @Autowired
for auto-wiring the Configuration instance, e.g. from Spring Boot's jOOQ starter -->
<springAnnotations>true</springAnnotations>
</generate>
</generator>
</configuration>
new org.jooq.util.jaxb.Configuration()
.withGenerator(
new Generate()
// Generate the DAO classes
.withDaos(true)
// Annotate DAOs (and other types) with spring annotations, such as @Repository and @Autowired
// for auto-wiring the Configuration instance, e.g. from Spring Boot's jOOQ starter
.withSpringAnnotations(true)
)
myConfigurationName(sourceSets.main) {
generator {
generate {
// Generate the DAO classes
daos = true
// Annotate DAOs (and other types) with spring annotations, such as @Repository and @Autowired
// for auto-wiring the Configuration instance, e.g. from Spring Boot's jOOQ starter
springAnnotations = true
}
}
}
See generation annotations for more information about the annotation specific flags, above.
Feedback
Do you have any feedback about this page? We'd love to hear it!