Menu

Query Single Record In JooqTemplate
📰

Query Single Record In JooqTemplate

DEV Community: java·ts5432·4 days ago
#EB7223Lj
#devtojava#devto#dev#condition#record
Reading 0:00
15s threshold

Using JooqTemplate requires no code generation and no XML configuration.

Add Dependency

gradle:

implementation 'net.sf.sprtool:sprtool-jooq:1.7.0'

Enter fullscreen mode

Exit fullscreen mode

maven:

<dependency> <groupId> net.sf.sprtool </groupId> <artifactId> sprtool-jooq </artifactId> <version> 1.7.0 </version> </dependency>

Enter fullscreen mode

Exit fullscreen mode

Inject JooqTemplate

import net . sf . sprtool . jooq . JooqTemplate ;

@Autowired private JooqTemplate jt ;

// Inject JooqMapperTemplate when using RecordMapper for custom mapping import net . sf . sprtool . jooq . JooqMapperTemplate ;

@Autowired private JooqMapperTemplate jmt ;

Enter fullscreen mode

Exit fullscreen mode

Using JooqTemplate

v Methods (Recommended, More Concise)

The v -suffixed loadv / loadRecordv / loadLowerCaseRecordv pass conditions and ordering directly as varargs, with operators embedded in field names — no need to build jOOQ Condition objects.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.