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

Class MSSQLGenerator

    • 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