How to use many optional query parameters in Spring Data JDBC?

Question

We want to query a table using many optional search criteria that are stored in a POJO.

public class TemperatureMeterCriteria {

    private String state;
    private String title;
    private LocalDate date;
    private Year year;
    private Integer month;
    private Integer week;
    private LocalDate startDate;
    private LocalDate endDate;
    private DateQuery dateQuery;
    private AlertLevel alertLevel;
    ...

}

It's super easy with MyBatis : https://mybatis.org/mybatis-3/dynamic-sql.html

<select id="findTemperatureMeter" resultType="TemperatureMeter">
    SELECT * FROM TEMPERATURE_METER
    <where>
        <if test="state != null">
            state = #{state}
        </if>
        <if test="title != null">
            AND title like #{title}
        </if>
    ...
    </where>

However, how to do the same thing with Spring Data JDBC ?

https://docs.spring.io/spring-data/jdbc/docs/current/reference/html

Jens Schauder · Accepted Answer · 2021-01-21 14:41:08Z

1

Currently the only option is to create a custom method and inside use a third party library like Querydsl, jOOQ or MyBatis.

There is work in progress though to offer methods via JdbcAggregateTemplate which will accept a Condition, which could be used for such a purpose. The first steps (delete only) will arrive as a side effect of https://github.com/spring-projects/spring-data-jdbc/issues/771

answered Jan 21, 2021 at 14:41

Jens Schauder

82.6k35 gold badges199 silver badges379 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to use many optional query parameters in Spring Data JDBC?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related