Is there any way to work with JdbcTemplate and Query/Criteria Fluent API

Question

R2dbcEntityTemplate has a method called select that allows me to use org.springframework.data.relational.core.query.Query to build my query statement using a Fluent API. I'm looking for a way to use this Fluent API on spring-data-jdbc in a non reactive project. I din't find any method in JdbcTemplate that I can pass a Query or CriteriaDefinition as parameter.

This is an example using R2dbcEntityTemplate:

r2dbcTemplate.select(OrderItem.class)
    .matching(query(where("order_id").is(orderId)))
    .all();

Any thoughts on how to use this with JdbcTemplate?

`JdbcTemplate` doesn't have similar functionality. – Kayaman Sep 06 '20 at 17:53 — Kayaman, Sep 06 '20 at 17:53

score 1 · Accepted Answer · answered Oct 01 '20 at 13:30

1

Spring Data JDBC doesn't have such an API.

You might want to look into Querydsl or jOOQ.

answered Oct 01 '20 at 13:30

Jens Schauder

77,657
34
181
348

Is there any way to work with JdbcTemplate and Query/Criteria Fluent API

1 Answers1