Query parameter types

Supported types

Queries accept the following types as parameters:

• standard jdbc supported types (like Integer, Long, String, BigDecimal, java.sql.Date, primitives, ...)
• java.time types
• any custom types - requires custom ParamSetters

Eg:

query
	.update("UPDATE CUSTOMER SET DEADLINE = ?, UPDATED = ?")
	.params(LocalDate.of(2015, Month.MARCH, 5), Instant.now())
	.run();

Custom types

Support for more types - eg value objects - can be implemented using the ParamSetter interface and can be configured with FluentJdbcBuilder:

Map<Class, ParamSetter> paramSetters = ...
FluentJdbc fluentJdbc = new FluentJdbcBuilder()
    .paramSetters(paramSetters)
    ... // other configuration
    .build();

Example: support for the UUID class - by setting it as a String

ParamSetter uuidParamSetter = (param, preparedStatement, i) -> {
    preparedStatement.setString(i, param.toString());
}

Map<Class, ParamSetter> paramSetters = new HashMap<>();
paramSetters.put(UUID.class, uuidParamSetter);
... // add any other setters

FluentJdbc fluentJdbc = new FluentJdbcBuilder()
    .paramSetters(paramSetters)
    ... // other configuration
    .build();

The Query API initialized by this FluentJdbc instance will support the UUID class

query.update("UPDATE CUSTOMER SET CUSTOMER_KEY = ?").params(UUID.randomUUID).run();