I've been moving an existing project from jdbc to jdbi, and I've been making much use out of jdbi's beautiful SQL Object API. We're using mysql.
While the SQL Object API can construct handled queries that are known at compile time, I couldn't find a way of generating queries at run time.
Specifically, I want to be able to do something like this:
"UPDATE record SET "+
@IfNotZero("foo") "foo=:foo" +
@IfNotNull("bar") "bar=:bar" +
@IfNotNull("baz") "baz=:baz" +
public abstract int updateRecord(
@Bind("id") int id,
@Bind("foo") int foo,
@Bind("bar") String bar,
@Bind("baz") String baz
JDBI is not very well suited for constructing dynamic queries. IMO the whole point of this library is to separate code and SQL queries as much as possible.
However, your particular case might be solved by means of SQL:
if 'foo' is the name of the column in the table, and :foo will resolve to NULL, then mysql SET will be effectively
i.e. it will do nothing (which is desired beaviour in your case). If :foo is not null, it will be equivalent to