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

Constructors

Constructor and Description
MSSQLGenerator()
MSSQLGenerator(String quoteStart, String quoteEnd) Construct a MSSQLGenerator with the specified identifiers for start and end of quoted strings.

Method Summary

Modifier and Type	Method and Description
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