Interface RDBMSActionStrategyInterface

All Known Implementing Classes:

BaseRDBMSActionStrategy, MySQLFullTextIndexFieldStrategy, PostgreSQLRDBMSActionStrategy, SQLiteRDBMSActionStrategy

public interface RDBMSActionStrategyInterface

Nested Class Summary

Nested Classes

Modifier and Type	Interface	Description
static interface	RDBMSActionStrategyInterface.ResultSetProcessor

Method Summary

Modifier and Type	Method	Description
Integer	appendCriterionToWhereClause(QFilterCriteria criterion, StringBuilder clause, String column, List<Serializable> values, QFieldMetaData field)	modifies the clause StringBuilder (appending to it) returning the number of expected number of params to bind
void	executeBatchUpdate(Connection connection, String updateSQL, List<List<Serializable>> values)
List<Serializable>	executeInsertForGeneratedIds(Connection connection, String sql, List<Object> params, QFieldMetaData primaryKeyField)
void	executeStatement(PreparedStatement statement, CharSequence sql, RDBMSActionStrategyInterface.ResultSetProcessor processor, Object... params)
PreparedStatement	executeUpdate(Connection connection, String sql, List<Object> params)
Integer	executeUpdateForRowCount(Connection connection, String sql, Object... params)
Serializable	getFieldValueFromResultSet(QFieldType type, ResultSet resultSet, int i)
default String	getIdentifierQuoteString()	Get the string to use for quoting identifiers (table names, column names).
Integer	getPageSize(AbstractActionInput actionInput)

Method Details

appendCriterionToWhereClause

Integer appendCriterionToWhereClause(QFilterCriteria criterion,
 StringBuilder clause,
 String column,
 List<Serializable> values,
 QFieldMetaData field)

modifies the clause StringBuilder (appending to it) returning the number of expected number of params to bind

getFieldValueFromResultSet

Serializable getFieldValueFromResultSet(QFieldType type,
 ResultSet resultSet,
 int i)
                                 throws SQLException

Throws:

SQLException

executeUpdate

PreparedStatement executeUpdate(Connection connection,
 String sql,
 List<Object> params)
                         throws SQLException

Throws:

SQLException

executeBatchUpdate

void executeBatchUpdate(Connection connection,
 String updateSQL,
 List<List<Serializable>> values)
                 throws SQLException

Throws:

SQLException

executeInsertForGeneratedIds

List<Serializable> executeInsertForGeneratedIds(Connection connection,
 String sql,
 List<Object> params,
 QFieldMetaData primaryKeyField)
                                         throws SQLException

Throws:

SQLException

executeUpdateForRowCount

Integer executeUpdateForRowCount(Connection connection,
 String sql,
 Object... params)
                          throws SQLException

Throws:

SQLException

executeStatement

void executeStatement(PreparedStatement statement,
 CharSequence sql,
 RDBMSActionStrategyInterface.ResultSetProcessor processor,
 Object... params)
               throws SQLException,
QException

Throws:

SQLException

QException

getPageSize

Integer getPageSize(AbstractActionInput actionInput)

getIdentifierQuoteString

default String getIdentifierQuoteString()

Get the string to use for quoting identifiers (table names, column names). Default is backtick for MySQL/H2/SQLite. PostgreSQL should return empty string or double-quote.