Package org.jdbi.v3.sqlobject.customizer

Annotation Type Timestamped

@Target(METHOD)
@Retention(RUNTIME)
@Documented
public @interface 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:

• TimestampedConfig

Optional Element Summary

Optional Elements

Modifier and Type	Optional Element	Description
String	value	The parameter to bind in the SQL query.

Element Details

value

String value

The parameter to bind in the SQL query. If omitted, defaults to now and can be changed to customize the parameter bound to the current DateTime.

Returns:

the parameter name

Default:

"now"