Client.java

class SomeClientOfJdbcSession {

  private SomeEntity loadTheEntity() {
    JdbcSession jdbcSession = ...;

    String sql = ...;
    boolean callable;

    Type[] parameterTypes = ...;
    Object[] parameterValues = ...;
    int offset = ...;
    int limit = ...;
    int timeout = ...;

    return jdbcSession.accept(
        new PreparedStatementQueryOperationSpec<SomeEntity>() {
          @Override
          public QueryStatementBuilder getQueryStatementBuilder() {
            return callable 
                ? CallableQueryStatementBuilderImpl.INSTANCE
                : StandardQueryStatementBuilderImpl.INSTANCE
          }
          
          @Override
          public String getSql() {
            return sql;
          }

          @Override
          public int getResultSetType() {
            return ResultSet.TYPE_FORWARD_ONLY;
          }
          
          @Override
          public int getResultSetConcurrency() {
            return ResultSet.CONCUR_READ_ONLY;
          }
          
          @Override
          public int getTimeout() {
            return timeout;
          }
          ...
        }
    );
  }

  
}

JdbcSessionImpl.java

class JdbcSessionImpl ... {
  @Override
  public <R> R accept(PreparedStatementQueryOperationSpec<R> spec) {
    try {
        Statement statement = spec.getQueryStatementBuilder().buildStatement( 
          spec.getSql(),
          spec.getResultSetType(),
          spec.getResultSetConcurrency()
        );
        statement.setQueryTimeout( spec.getTimeout() );
        // todo : register the statement
        try {
            ResultSet resultSet = ...;
            // todo : register the resultset
            try {
                return ...;
            }
            finally {
                if ( !operationSpec.holdOpenResources() ) {
                    release( resultSet, statement );
                }
            }
        }
        finally {
            if ( !operationSpec.holdOpenResources() ) {
                release( statement );
            }
        }
    }
    finally {
        afterStatement( !operationSpec.holdOpenResources() );
    }
  }
}

QueryStatementBuilder.java

interface QueryStatementBuilder {
  PreparedStatement buildStatement(String sql, int resultSetType, int resultSetConcurrency, int timeout, ...);
}