com.fr.general.jsqlparser.util

类 SelectUtils

java.lang.Object

com.fr.general.jsqlparser.util.SelectUtils

public final class SelectUtils
extends java.lang.Object

Utility function for select statements.

作者:

toben

方法概要

方法

限定符和类型	方法和说明
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, java.lang.String... expr) Builds select expr1, expr2 from table.
static Select	buildSelectFromTableAndSelectItems(Table table, SelectItem... selectItems)

从类继承的方法 java.lang.Object

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

方法详细资料

buildSelectFromTableAndExpressions

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

Builds select expr1, expr2 from table.

参数:

table -

expr -

返回:

buildSelectFromTableAndExpressions

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

Builds select expr1, expr2 from table.

参数:

table -

expr -

返回:

抛出:

JSQLParserException

buildSelectFromTableAndSelectItems

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

buildSelectFromTable

public static Select buildSelectFromTable(Table table)

Builds select * from table.

参数:

table -

返回:

addExpression

public static void addExpression(Select select,
                 Expression expr)

Adds an expression to select statements. E.g. a simple column is an expression.

参数:

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).

参数:

select -

table -

onExpression -

返回:

addGroupBy

public static void addGroupBy(Select select,
              Expression expr)

Adds group by to a plain select statement.

参数:

select -

expr -