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
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
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
stringquoteEnd
- the identifier (character) denoting the end of a quoted string
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 queriedfilters
- The filters, converted into a WHERE clauseorderBys
- The the ordering conditions, converted into an ORDER BY clauseoffset
- The offset of the first row to be includedpagelength
- The number of rows to be returned when the query executestoSelect
- 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
Copyright © 2000-2011 Vaadin Ltd. All Rights Reserved.