com.jolbox.bonecp

接口 IStatementCache

所有已知实现类:

StatementCache

public interface IStatementCache

Interface to the JDBC statement cache.

作者:

wallacew

方法概要

方法

限定符和类型	方法和说明
java.lang.String	calculateCacheKey(java.lang.String sql, int autoGeneratedKeys) Returns a cache key.
java.lang.String	calculateCacheKey(java.lang.String sql, int[] columnIndexes) Returns a cache key.
java.lang.String	calculateCacheKey(java.lang.String sql, int resultSetType, int resultSetConcurrency) Returns a cache key.
java.lang.String	calculateCacheKey(java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) Returns a cache key.
java.lang.String	calculateCacheKey(java.lang.String sql, java.lang.String[] columnNames) Calculates a cache key.
void	checkForProperClosure() Checks that the entries in the cache have been properly closed when the connection dies down.
void	clear() Clears the cache
StatementHandle	get(java.lang.String sql) Retrieves the cached statement identified by the given key
StatementHandle	get(java.lang.String sql, int autoGeneratedKeys) Retrieves the cached statement identified by the given key
StatementHandle	get(java.lang.String sql, int[] columnIndexes) Retrieves the cached statement identified by the given key
StatementHandle	get(java.lang.String sql, int resultSetType, int resultSetConcurrency) Retrieves the cached statement identified by the given key
StatementHandle	get(java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) Retrieves the cached statement identified by the given key
StatementHandle	get(java.lang.String sql, java.lang.String[] columnNames) Retrieves the cached statement identified by the given key
void	putIfAbsent(java.lang.String cacheKey, StatementHandle statementHandle) Wrapper for map putIfAbsent.
int	size() Returns size of the cache.

方法详细资料

get

StatementHandle get(java.lang.String sql)

Retrieves the cached statement identified by the given key

参数:

sql - SQL statement

返回:

Statement, or null if not found.

size

int size()

Returns size of the cache.

返回:

cache size

clear

void clear()

Clears the cache

get

StatementHandle get(java.lang.String sql,
                  int resultSetType,
                  int resultSetConcurrency,
                  int resultSetHoldability)

Retrieves the cached statement identified by the given key

参数:

sql - SQL Statement

resultSetType - a result set type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE

resultSetConcurrency - a concurrency type; one of ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE

resultSetHoldability - a ResultSet holdability constant; one of ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT

返回:

Statement, or null if not found.

get

StatementHandle get(java.lang.String sql,
                  int resultSetType,
                  int resultSetConcurrency)

Retrieves the cached statement identified by the given key

参数:

sql - SQL Statement

resultSetType - a result set type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE

resultSetConcurrency - a concurrency type; one of ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE

返回:

Statement, or null if not found.

get

StatementHandle get(java.lang.String sql,
                  int autoGeneratedKeys)

Retrieves the cached statement identified by the given key

参数:

sql - SQL Statement

autoGeneratedKeys - a flag indicating whether auto-generated keys should be returned; one of Statement.RETURN_GENERATED_KEYS or Statement.NO_GENERATED_KEYS

返回:

Statement, or null if not found.

get

StatementHandle get(java.lang.String sql,
                  int[] columnIndexes)

Retrieves the cached statement identified by the given key

参数:

sql - SQL Statement

columnIndexes - an array of column indexes indicating the columns that should be returned from the inserted row or rows

返回:

Statement, or null if not found.

get

StatementHandle get(java.lang.String sql,
                  java.lang.String[] columnNames)

Retrieves the cached statement identified by the given key

参数:

sql - SQL Statement

columnNames - an array of column names indicating the columns that should be returned from the inserted row or rows

返回:

Statement, or null if not found.

calculateCacheKey

java.lang.String calculateCacheKey(java.lang.String sql,
                                 java.lang.String[] columnNames)

Calculates a cache key.

参数:

sql - SQL Statement

columnNames - an array of column names indicating the columns that should be returned from the inserted row or rows

返回:

cache key

calculateCacheKey

java.lang.String calculateCacheKey(java.lang.String sql,
                                 int[] columnIndexes)

Returns a cache key.

参数:

sql - SQL Statement

columnIndexes - an array of column indexes indicating the columns that should be returned from the inserted row or rows

返回:

cache key

calculateCacheKey

java.lang.String calculateCacheKey(java.lang.String sql,
                                 int autoGeneratedKeys)

Returns a cache key.

参数:

sql - SQL Statement

autoGeneratedKeys -

返回:

cache key.

calculateCacheKey

java.lang.String calculateCacheKey(java.lang.String sql,
                                 int resultSetType,
                                 int resultSetConcurrency)

Returns a cache key.

参数:

sql - SQL Statement

resultSetType - a result set type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE

resultSetConcurrency - a concurrency type; one of ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE

返回:

cache key.

calculateCacheKey

java.lang.String calculateCacheKey(java.lang.String sql,
                                 int resultSetType,
                                 int resultSetConcurrency,
                                 int resultSetHoldability)

Returns a cache key.

参数:

sql - SQL Statement

resultSetType - a result set type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE

resultSetConcurrency - a concurrency type; one of ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE

resultSetHoldability - a ResultSet holdability constant; one of ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT

返回:

cache key.

checkForProperClosure

void checkForProperClosure()

Checks that the entries in the cache have been properly closed when the connection dies down.

putIfAbsent

void putIfAbsent(java.lang.String cacheKey,
               StatementHandle statementHandle)

Wrapper for map putIfAbsent.

参数:

cacheKey -

statementHandle -