Class Select

java.lang.Object
mdbtools.dbengine.sql.Select
All Implemented Interfaces:
SQL

public class Select extends Object implements SQL
Select is the parse tree for a select sql statement. A simple select is handled by: converting a from clause to Data applying the where clause returning Data as the result In the case of an aggregate the above is done to get the data then the aggregate functions are exectuted to filter the data
  • Constructor Details

    • Select

      public Select()
  • Method Details

    • toString

      public String toString()
      Overrides:
      toString in class Object
    • getColumnCount

      public int getColumnCount()
    • getColumn

      public Object getColumn(int index)
    • getTableCount

      public int getTableCount()
    • getTable

      public Object getTable(int index)
    • addColumn

      public void addColumn(Object column)
    • addTable

      public void addTable(Object table)
    • addGroupBy

      public void addGroupBy(FQColumn column)
    • getGroupByCount

      public int getGroupByCount()
    • getGroupBy

      public Object getGroupBy(int index)
    • addOrderBy

      public void addOrderBy(OrderBy o)
    • getOrderByCount

      public int getOrderByCount()
    • getOrderBy

      public OrderBy getOrderBy(int index)
    • setWhere

      public void setWhere(Object where)
    • getWhere

      public Object getWhere()