Package net.sf.jsqlparser.util
Class SelectUtils
- java.lang.Object
-
- net.sf.jsqlparser.util.SelectUtils
-
public final class SelectUtils extends java.lang.Object
-
-
Field Summary
Fields Modifier and Type Field Description private static java.lang.String
NOT_SUPPORTED_YET
-
Constructor Summary
Constructors Modifier Constructor Description private
SelectUtils()
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method 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, java.lang.String... expr)
static Select
buildSelectFromTableAndExpressions(Table table, Expression... expr)
static Select
buildSelectFromTableAndSelectItems(Table table, SelectItem... selectItems)
-
-
-
Field Detail
-
NOT_SUPPORTED_YET
private static final java.lang.String NOT_SUPPORTED_YET
- See Also:
- Constant Field Values
-
-
Method Detail
-
buildSelectFromTableAndExpressions
public static Select buildSelectFromTableAndExpressions(Table table, Expression... expr)
-
buildSelectFromTableAndExpressions
public static Select buildSelectFromTableAndExpressions(Table table, java.lang.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
-
-
-