CODEWITHSUNDEEP
javasqljooq
genechu
genechu

Reputation: 97

how to use jOOQ (or something else) in such condition

jOOQ runs on generated classes (from database schema). In my apps, there are many tables created while excuting. Then how can I query them using jOOQ? Or can I use something else to do this?

We just use jOOQ to generate SQL, not doing any CRUD operation.

Upvotes: 1

Views: 1022

Answers (1)

Lukas Eder
Lukas Eder

Reputation: 221076

While being the main use case for using jOOQ, you do not have to generate any source code with jOOQ. Several users have used jOOQ the way you do, by supplying dynamic table/column names at runtime to Factory methods such as:

These methods take care of correctly escaping your schema, table, field, alias names, etc, in order to guarantee SQL syntax correctness and SQL injection protection.

Some related discussions on the jOOQ User Group are here:

Upvotes: 1

Related Questions