Package jetbrains.buildServer.serverSide.db.queries

Class CachingGenericQuery<T>

java.lang.Object

jetbrains.buildServer.serverSide.db.queries.GenericQuery<T>

jetbrains.buildServer.serverSide.db.queries.CachingGenericQuery<T>

public class CachingGenericQuery<T>
extends GenericQuery<T>

Author:

Pavel.Sher Date: 01.06.2006

Nested Class Summary

Nested classes/interfaces inherited from class jetbrains.buildServer.serverSide.db.queries.GenericQuery

GenericQuery.CheckExists, GenericQuery.CollectionBatchParamsIterator<I>, GenericQuery.CollectStrings, GenericQuery.ResultSetProcessor<T>, GenericQuery.ReturnListOfLongs, GenericQuery.ReturnSetOfInteger, GenericQuery.ReturnSetOfLongs, GenericQuery.ReturnSetOfStrings, GenericQuery.ReturnSingle<T>, GenericQuery.ReturnSingleBoolean, GenericQuery.ReturnSingleInteger, GenericQuery.ReturnSingleLong, GenericQuery.ReturnSingleString, GenericQuery.ReturnSmallSetOfInteger

Constructor Summary

Constructors

Constructor	Description
CachingGenericQuery(String sqlStatement)
CachingGenericQuery(String name, String sqlStatement, GenericQuery.ResultSetProcessor<T> processor)
CachingGenericQuery(String sqlStatement, GenericQuery.ResultSetProcessor<T> processor)

Method Summary

Modifier and Type	Method	Description
void	clearCache()
void	clearCache(Object... params)
T	execute(DBFunctions dbf, Object... params)	Executes statement as query with given parameters
T	execute(DBFunctions dbf, GenericQuery.ResultSetProcessor<T> processor, Object... params)	Executes statement as query with given parameters and specific result set processor instance.
T	execute(SQLRunnerEx runner, Object... params)	Executes statement as query with given parameters and specific result set processor instance.
T	execute(SQLRunnerEx runner, GenericQuery.ResultSetProcessor<T> processor, Object... params)	Executes statement as query with given parameters and specific result set processor instance.

Methods inherited from class jetbrains.buildServer.serverSide.db.queries.GenericQuery

executeBatch, executeBatch, executeUpdate, executeUpdate, getOriginalSqlStatement, getResultSetProcessor, setOptions, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

CachingGenericQuery

public CachingGenericQuery(@NotNull
                           String sqlStatement)

CachingGenericQuery

public CachingGenericQuery(@NotNull
                           String sqlStatement,
                           @NotNull
                           GenericQuery.ResultSetProcessor<T> processor)

CachingGenericQuery

public CachingGenericQuery(@NotNull
                           String name,
                           @NotNull
                           String sqlStatement,
                           @NotNull
                           GenericQuery.ResultSetProcessor<T> processor)

Method Detail

execute

public T execute(@NotNull
                 DBFunctions dbf,
                 Object... params)

Description copied from class: GenericQuery

Executes statement as query with given parameters

Overrides:

execute in class GenericQuery<T>

Parameters:

dbf - database access object

params - parameters

Returns:

result as declared

execute

public T execute(@NotNull
                 DBFunctions dbf,
                 @NotNull
                 GenericQuery.ResultSetProcessor<T> processor,
                 @Nullable
                 Object... params)

Description copied from class: GenericQuery

Executes statement as query with given parameters and specific result set processor instance.

Overrides:

execute in class GenericQuery<T>

Parameters:

dbf - database access object

processor - result set processor instance

params - parameters

Returns:

result as declared

execute

public T execute(@NotNull
                 SQLRunnerEx runner,
                 Object... params)

Description copied from class: GenericQuery

Executes statement as query with given parameters and specific result set processor instance.

Overrides:

execute in class GenericQuery<T>

Parameters:

runner - SQL runner

params - parameters

Returns:

result as declared

execute

public T execute(@NotNull
                 SQLRunnerEx runner,
                 @NotNull
                 GenericQuery.ResultSetProcessor<T> processor,
                 @Nullable
                 Object... params)

Description copied from class: GenericQuery

Executes statement as query with given parameters and specific result set processor instance.

Overrides:

execute in class GenericQuery<T>

Parameters:

runner - SQL runner

processor - result set processor instance

params - parameters

Returns:

result as declared

clearCache

public void clearCache()

clearCache

public void clearCache(Object... params)