org.araneaframework.backend.list.helper
Class OracleListSqlHelper

java.lang.Object
  org.araneaframework.backend.list.helper.BaseListSqlHelper
      org.araneaframework.backend.list.helper.ListSqlHelper
          org.araneaframework.backend.list.helper.OracleListSqlHelper

public class OracleListSqlHelper

extends ListSqlHelper

Author:

Rein Raudjärv

Nested Class Summary

Nested classes inherited from class org.araneaframework.backend.list.helper.BaseListSqlHelper

BaseListSqlHelper.BeanResultReader, BaseListSqlHelper.CountSqlCallback, BaseListSqlHelper.ItemRangeSqlCallback, BaseListSqlHelper.ListItemsDataCallback

Field Summary

protected String	countSqlQuery
protected SqlStatement	statement

Fields inherited from class org.araneaframework.backend.list.helper.ListSqlHelper

converterBasedColumnReader, log, mappingNamingStrategyAndFields, prefixMapNamingStrategy, standardFields, standardValueConverter

Fields inherited from class org.araneaframework.backend.list.helper.BaseListSqlHelper

DEFAULT_RANGE_START, ds, fields, filterExpr, filterSqlExpr, itemRangeCount, itemRangeStart, namingStrategy, orderExpr, orderSqlExpr, resultSetColumnReader, valueConverter, variableResolver

Constructor Summary

OracleListSqlHelper()

OracleListSqlHelper(DataSource dataSource)

OracleListSqlHelper(DataSource dataSource, ListQuery query)

OracleListSqlHelper(ListQuery query)

Method Summary

void	addNullParam(int valueType) Adds a NULL PreparedStatement parameter for later setting.
void	addStatementParam(Object param) Adds a PreparedStatement parameter for later setting.
void	addStatementParams(List params) Adds PreparedStatement parameters for later setting.
protected SqlStatement	getCountSqlStatement() Returns the total count SQL query String and parameters.
protected SqlStatement	getRangeSqlStatement() Returns the itme range SQL query String and parameters.
void	setCountSqlQuery(String countSqlQuery) Sets the SQL query used to count the items in the database.
void	setSqlQuery(String sqlQuery) Sets the SQL query that will be used to retrieve the item range from the list and count the items.

Methods inherited from class org.araneaframework.backend.list.helper.ListSqlHelper

addDatabaseFieldConverter, addDatabaseFieldMapping, addDatabaseFieldMapping, addFields, addMapping, addMapping, addNamingStrategy, addNamingStrategy, addNamingStrategyAsFirst, addResultSetDeconverterForBeanField, addResultSetDeconverterForColumn, addResultSetMapping, getConverterBasedColumnReader, getMappingNamingStrategyAndFields, getPrefixMapNamingStrategy, getStandardFields, getStandardValueConverter, init, setConverterBasedColumnReader, setMappingNamingStrategyAndFields, setPrefixMapNamingStrategy, setStandardFields, setStandardValueConverter

Methods inherited from class org.araneaframework.backend.list.helper.BaseListSqlHelper

createBeanResultReader, createExpressionBuilderResolver, createFilterSqlExpressionBuilder, createOrderSqlExpressionBuilder, createQueryFailedException, execute, execute, execute, executeCountSql, executeItemRangeSql, executeItemRangeSql, getCountSqlCallback, getDatabaseFields, getDatabaseFilter, getDatabaseFilterParams, getDatabaseFilterWith, getDatabaseOrder, getDatabaseOrderParams, getDatabaseOrderWith, getFields, getFieldsSqlExpression, getFilterSqlExpression, getItemRangeSqlCallback, getListItemsDataCallback, getNamingStrategy, getOrderSqlExpression, getResultSetColumnReader, getValueConverter, setDataSource, setFields, setFilterExpression, setItemRangeCount, setItemRangeStart, setListQuery, setNamingStrategy, setOrderExpression, setResultSetColumnReader, setSimpleSqlQuery, setSimpleSqlQuery, setSimpleSqlQuery, setValueConverter

Methods inherited from class java.lang.Object

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

Field Detail

statement

protected SqlStatement statement

countSqlQuery

protected String countSqlQuery

Constructor Detail

OracleListSqlHelper

public OracleListSqlHelper(DataSource dataSource,
                           ListQuery query)

OracleListSqlHelper

public OracleListSqlHelper(DataSource dataSource)

OracleListSqlHelper

public OracleListSqlHelper(ListQuery query)

OracleListSqlHelper

public OracleListSqlHelper()

Method Detail

getCountSqlStatement

protected SqlStatement getCountSqlStatement()

Description copied from class: BaseListSqlHelper

Returns the total count SQL query String and parameters.

Specified by:

getCountSqlStatement in class BaseListSqlHelper

getRangeSqlStatement

protected SqlStatement getRangeSqlStatement()

Description copied from class: BaseListSqlHelper

Returns the itme range SQL query String and parameters.

Specified by:

getRangeSqlStatement in class BaseListSqlHelper

setSqlQuery

public void setSqlQuery(String sqlQuery)

Sets the SQL query that will be used to retrieve the item range from the list and count the items. The SQL query must start with SELECT expression including the word "SELECT".

Specified by:

setSqlQuery in class BaseListSqlHelper

Parameters:

sqlQuery - the SQL query that will be used to retrieve the item range from the list and count the items.

setCountSqlQuery

public void setCountSqlQuery(String countSqlQuery)

Sets the SQL query used to count the items in the database.

Specified by:

setCountSqlQuery in class BaseListSqlHelper

Parameters:

countSqlQuery - the SQL query used to count the items in the database.

addNullParam

public void addNullParam(int valueType)

Adds a NULL PreparedStatement parameter for later setting.

Specified by:

addNullParam in class BaseListSqlHelper

Parameters:

valueType - the type of the NULL value.

addStatementParam

public void addStatementParam(Object param)

Adds a PreparedStatement parameter for later setting.

Specified by:

addStatementParam in class BaseListSqlHelper

Parameters:

param - a PreparedStatement parameter.

addStatementParams

public void addStatementParams(List params)

Adds PreparedStatement parameters for later setting.

Specified by:

addStatementParams in class BaseListSqlHelper

Parameters:

params - PreparedStatement parameters.