net.sf.jsqlparser.util

Class SelectUtils

java.lang.Object

net.sf.jsqlparser.util.SelectUtils

public final class SelectUtils
extends Object

Utility function for select statements.

Author:

toben

Method Summary

Methods

Modifier and Type	Method and Description
static void	addExpression(Select select, Expression expr) Adds an expression to select statements.
static void	addGroupBy(Select select, Expression expr) Adds group by to a plain select statement.
static Join	addJoin(Select select, Table table, Expression onExpression) Adds a simple join to a select statement.
static Select	buildSelectFromTable(Table table) Builds select * from table.
static Select	buildSelectFromTableAndExpressions(Table table, Expression... expr) Builds select expr1, expr2 from table.
static Select	buildSelectFromTableAndExpressions(Table table, String... expr) Builds select expr1, expr2 from table.
static Select	buildSelectFromTableAndSelectItems(Table table, SelectItem... selectItems)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

buildSelectFromTableAndExpressions

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

Builds select expr1, expr2 from table.

Parameters:

table -

expr -

Returns:

buildSelectFromTableAndExpressions

public static Select buildSelectFromTableAndExpressions(Table table,
                                        String... expr)
                                                 throws JSQLParserException

Builds select expr1, expr2 from table.

Parameters:

table -

expr -

Returns:

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 -