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


Class MSSQLGenerator

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

All Implemented Interfaces:

SQLGenerator, Serializable

public class MSSQLGenerator
extends DefaultSQLGenerator

See Also:

Serialized Form

Constructor Summary
MSSQLGenerator()
           
MSSQLGenerator(String quoteStart, String quoteEnd)
          Construct a MSSQLGenerator with the specified identifiers for start and end of quoted strings.
 
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

MSSQLGenerator

public MSSQLGenerator()

MSSQLGenerator

public MSSQLGenerator(String quoteStart,
                      String quoteEnd)

Construct a MSSQLGenerator 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

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