org.openanzo.jdbc.utils.sqlcache
Interface PreparedStatementCache

All Known Implementing Classes:

SQLCache

public interface PreparedStatementCache

Interface enabling access to SQL statements from some source.

Author:

Joe Betz

Method Summary

java.sql.PreparedStatement	getPreparedSQLStatement(java.lang.String name) Retrieve a prepared statement with the given name
java.sql.PreparedStatement	getPreparedSQLStatement(java.lang.String name, java.lang.String[] templateParams) Retrieve a prepared statement with the given name and arguments
java.sql.PreparedStatement	prepareStatement(java.lang.String sql) Prepare the given string into a prepared statement
void	returnPreparedSQLStatement(java.sql.PreparedStatement ps) Return the prepared statement to the cache

Method Detail

getPreparedSQLStatement

java.sql.PreparedStatement getPreparedSQLStatement(java.lang.String name)
                                                   throws java.sql.SQLException

Retrieve a prepared statement with the given name

Parameters:

name - name of the prepared statement

Returns:

prepared statement with given name

Throws:

java.sql.SQLException

getPreparedSQLStatement

java.sql.PreparedStatement getPreparedSQLStatement(java.lang.String name,
                                                   java.lang.String[] templateParams)
                                                   throws java.sql.SQLException

Retrieve a prepared statement with the given name and arguments

Parameters:

name - name of the prepared statement

templateParams - parameters to the prepared statements template

Returns:

prepared statement with given name

Throws:

java.sql.SQLException

returnPreparedSQLStatement

void returnPreparedSQLStatement(java.sql.PreparedStatement ps)
                                throws java.sql.SQLException

Return the prepared statement to the cache

Parameters:

ps - prepared statement to return

Throws:

java.sql.SQLException

prepareStatement

java.sql.PreparedStatement prepareStatement(java.lang.String sql)
                                            throws java.sql.SQLException

Prepare the given string into a prepared statement

Parameters:

sql - String to prepare into a prepared statement

Returns:

a prepared statement for the given sql string

Throws:

java.sql.SQLException