Package org.jdbi.v3.sqlobject.customizer
Annotation Type Timestamped
Binds the named parameter
:now
or a custom named parameter with
the current DateTime as an OffsetDateTime
.
Common use cases:
public interface PersonDAO {
@SqlUpdate("INSERT INTO people(id, firstName, lastName, email, created, modified) VALUES (:p.id, :p.firstName, :p.lastName, :p.email, :now, :now)")
@Timestamped
@GetGeneratedKeys
int insert(@BindBean("p") Person person);
@SqlUpdate("UPDATE people SET modified = :now, firstName = :p.firstName, lastName = :p.lastName, email = :p.email WHERE id = :p.id")
@Timestamped
void update(@BindBean("p") Person person);
}
- See Also:
-
Optional Element Summary
-
Element Details
-
value
String valueThe parameter to bind in the SQL query. If omitted, defaults tonow
and can be changed to customize the parameter bound to the current DateTime.- Returns:
- the parameter name
- Default:
- "now"
-