Class SelectUtils

java.lang.Object
net.sf.jsqlparser.util.SelectUtils

public final class SelectUtils extends Object
  • Field Details

  • Constructor Details

    • SelectUtils

      private SelectUtils()
  • Method Details

    • buildSelectFromTableAndExpressions

      public static Select buildSelectFromTableAndExpressions(Table table, Expression... expr)
    • buildSelectFromTableAndExpressions

      public static Select buildSelectFromTableAndExpressions(Table table, String... expr) throws JSQLParserException
      Throws:
      JSQLParserException
    • buildSelectFromTableAndSelectItems

      public static Select buildSelectFromTableAndSelectItems(Table table, SelectItem... selectItems)
    • buildSelectFromTable

      public static Select buildSelectFromTable(Table table)
      Builds select * from table.
      Parameters:
      table -
      Returns:
    • addExpression

      public static void addExpression(Select select, Expression expr)
      Adds an expression to select statements. E.g. a simple column is an expression.
      Parameters:
      select -
      expr -
    • addJoin

      public static Join addJoin(Select select, Table table, Expression onExpression)
      Adds a simple join to a select statement. The introduced join is returned for more configuration settings on it (e.g. left join, right join).
      Parameters:
      select -
      table -
      onExpression -
      Returns:
    • addGroupBy

      public static void addGroupBy(Select select, Expression expr)
      Adds group by to a plain select statement.
      Parameters:
      select -
      expr -