JDBI generic CrudDao interface with dynamic table names

Question

I have a parent JDBI interface that my daos inherit from (as seen in JDBI's docs):

@UseClasspathSqlLocator
public interface CrudDao<T, ID> {
  @SqlUpdate 
  void insert(@BindBean T entity);

  @SqlQuery 
  Optional<T> findById(ID id);

  @SqlQuery
  List<T> list();

  @SqlUpdate
  void update(@BindBean T entity);

  @SqlUpdate
  void deleteById(ID id);
}

The technique above requires me to create insert.sql, update.sql, deleteById.sql, list.sql, and findById.sql, for each DAO that I create. Since these latter three sql statements would be identical among all the DAO classes (except for the table name), is it possible to specify the sql statement only once and have all the inheriting CrudDao classes use them?

I'm reminded of how Spring JPA's SpEL supports the #{#entityName} syntax for queries.

Answer 1

Maybe this is something that could help you.

Check out the @define annotation.

How to dynamically bind a table name in JDBI