com.vaadin.data.util.sqlcontainer.query.generator.


Class OracleGenerator

java.lang.Object
  com.vaadin.data.util.sqlcontainer.query.generator.DefaultSQLGenerator
      com.vaadin.data.util.sqlcontainer.query.generator.OracleGenerator

All Implemented Interfaces:

SQLGenerator, Serializable

public class OracleGenerator
extends DefaultSQLGenerator

See Also:

Serialized Form

Constructor Summary
OracleGenerator()
           
OracleGenerator(Class<? extends StatementHelper> statementHelperClazz)
           
OracleGenerator(String quoteStart, String quoteEnd)
          Construct an OracleSQLGenerator with the specified identifiers for start and end of quoted strings.
OracleGenerator(String quoteStart, String quoteEnd, Class<? extends StatementHelper> statementHelperClazz)
           
 
Method Summary
 StatementHelper generateSelectQuery(String tableName, List<Container.Filter> filters, List<OrderBy> orderBys, int offset, int pagelength, String toSelect)
          Generates a SELECT query with the provided parameters.
 
Methods inherited from class com.vaadin.data.util.sqlcontainer.query.generator.DefaultSQLGenerator
generateColumnToValueMap, generateDeleteQuery, generateInsertQuery, generateLimits, generateOrderBy, generateRowIdentifiers, generateUpdateQuery, getStatementHelper
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

OracleGenerator

public OracleGenerator()

OracleGenerator

public OracleGenerator(Class<? extends StatementHelper> statementHelperClazz)

OracleGenerator

public OracleGenerator(String quoteStart,
                       String quoteEnd)

Construct an OracleSQLGenerator with the specified identifiers for start and end of quoted strings. The identifiers may be different depending on the database engine and it's settings.

Parameters:
quoteStart - the identifier (character) denoting the start of a quoted string
quoteEnd - the identifier (character) denoting the end of a quoted string

OracleGenerator

public OracleGenerator(String quoteStart,
                       String quoteEnd,
                       Class<? extends StatementHelper> statementHelperClazz)
Method Detail

generateSelectQuery

public StatementHelper generateSelectQuery(String tableName,
                                           List<Container.Filter> filters,
                                           List<OrderBy> orderBys,
                                           int offset,
                                           int pagelength,
                                           String toSelect)

Description copied from interface: SQLGenerator

Generates a SELECT query with the provided parameters. Uses default filtering mode (INCLUSIVE).

Specified by:
generateSelectQuery in interface SQLGenerator
Overrides:
generateSelectQuery in class DefaultSQLGenerator

Parameters:
tableName - Name of the table queried
filters - The filters, converted into a WHERE clause
orderBys - The the ordering conditions, converted into an ORDER BY clause
offset - The offset of the first row to be included
pagelength - The number of rows to be returned when the query executes
toSelect - String containing what to select, e.g. "*", "COUNT(*)"
Returns:
StatementHelper instance containing the query string for a PreparedStatement and the values required for the parameters