程序包 com.fr.general.jsqlparser.statement.select
的使用

使用com.fr.general.jsqlparser.statement.select的程序包

程序包	说明
com.fr.general.jsqlparser.expression
com.fr.general.jsqlparser.expression.operators.relational
com.fr.general.jsqlparser.parser
com.fr.general.jsqlparser.schema
com.fr.general.jsqlparser.statement
com.fr.general.jsqlparser.statement.create.table
com.fr.general.jsqlparser.statement.create.view
com.fr.general.jsqlparser.statement.delete
com.fr.general.jsqlparser.statement.insert
com.fr.general.jsqlparser.statement.merge
com.fr.general.jsqlparser.statement.select
com.fr.general.jsqlparser.statement.update
com.fr.general.jsqlparser.statement.upsert
com.fr.general.jsqlparser.util
com.fr.general.jsqlparser.util.deparser
com.fr.general.sql.converter

com.fr.general.jsqlparser.expression使用的com.fr.general.jsqlparser.statement.select中的类

类和说明
AllColumns All the columns (as in "SELECT * FROM ...")
AllTableColumns
OrderByElement An element (column reference) in an "ORDER BY" clause.
Pivot
PivotVisitor
PivotXml
SelectExpressionItem An expression as in "SELECT expr1 AS EXPR"
SelectItemVisitor
SelectVisitor
SubSelect A subselect followed by an optional alias.

com.fr.general.jsqlparser.expression.operators.relational使用的com.fr.general.jsqlparser.statement.select中的类

类和说明
SubSelect A subselect followed by an optional alias.

com.fr.general.jsqlparser.parser使用的com.fr.general.jsqlparser.statement.select中的类

类和说明
AllTableColumns
ExpressionListItem
Fetch A fetch clause in the form FETCH (FIRST | NEXT) row_count (ROW | ROWS) ONLY
First A FIRST clause in the form [FIRST row_count] the alternative form [LIMIT row_count] is also supported.
FromItem An item in a "SELECT [...]
FunctionItem
Join A join clause
LateralSubSelect A lateral subselect followed by an alias.
Limit A limit clause in the form [LIMIT {[offset,] row_count) | (row_count | ALL) OFFSET offset}]
Offset An offset clause in the form OFFSET offset or in the form OFFSET offset (ROW | ROWS)
OrderByElement An element (column reference) in an "ORDER BY" clause.
Pivot
PivotXml
PlainSelect The core of a "SELECT" statement (no UNION, no ORDER BY)
Select
SelectBody
SelectExpressionItem An expression as in "SELECT expr1 AS EXPR"
SelectItem Anything between "SELECT" and "FROM" (that is, any column or expression etc to be retrieved with the query)
Skip A skip clause in the form [SKIP row_count] Initial implementation was done for informix special syntax: http://www-01.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_0156.htm
SubSelect A subselect followed by an optional alias.
TableFunction
Top A top clause in the form [TOP (row_count) or TOP row_count]
Wait A timeout applied to SELECT to specify how long to wait for the row on the lock to be released.
WithItem One of the parts of a "WITH" clause of a "SELECT" statement

com.fr.general.jsqlparser.schema使用的com.fr.general.jsqlparser.statement.select中的类

类和说明
FromItem An item in a "SELECT [...]
FromItemVisitor
IntoTableVisitor
Pivot

com.fr.general.jsqlparser.statement使用的com.fr.general.jsqlparser.statement.select中的类

类和说明
Select

com.fr.general.jsqlparser.statement.create.table使用的com.fr.general.jsqlparser.statement.select中的类

类和说明
Select

com.fr.general.jsqlparser.statement.create.view使用的com.fr.general.jsqlparser.statement.select中的类

类和说明
SelectBody

com.fr.general.jsqlparser.statement.delete使用的com.fr.general.jsqlparser.statement.select中的类

类和说明
Join A join clause
Limit A limit clause in the form [LIMIT {[offset,] row_count) | (row_count | ALL) OFFSET offset}]
OrderByElement An element (column reference) in an "ORDER BY" clause.

com.fr.general.jsqlparser.statement.insert使用的com.fr.general.jsqlparser.statement.select中的类

类和说明
Select
SelectExpressionItem An expression as in "SELECT expr1 AS EXPR"

com.fr.general.jsqlparser.statement.merge使用的com.fr.general.jsqlparser.statement.select中的类

类和说明
SubSelect A subselect followed by an optional alias.

com.fr.general.jsqlparser.statement.select使用的com.fr.general.jsqlparser.statement.select中的类

类和说明
AllColumns All the columns (as in "SELECT * FROM ...")
AllTableColumns
Distinct A DISTINCT [ON (expression, ...)] clause
ExpressionListItem
Fetch A fetch clause in the form FETCH (FIRST | NEXT) row_count (ROW | ROWS) ONLY
First A FIRST clause in the form [FIRST row_count] the alternative form [LIMIT row_count] is also supported.
First.Keyword
FromItem An item in a "SELECT [...]
FromItemVisitor
FunctionItem
IntoTableVisitor
Join A join clause
LateralSubSelect A lateral subselect followed by an alias.
Limit A limit clause in the form [LIMIT {[offset,] row_count) | (row_count | ALL) OFFSET offset}]
Offset An offset clause in the form OFFSET offset or in the form OFFSET offset (ROW | ROWS)
OrderByElement An element (column reference) in an "ORDER BY" clause.
OrderByElement.NullOrdering
OrderByVisitor
Pivot
PivotVisitor
PivotXml
PlainSelect The core of a "SELECT" statement (no UNION, no ORDER BY)
SelectBody
SelectExpressionItem An expression as in "SELECT expr1 AS EXPR"
SelectItem Anything between "SELECT" and "FROM" (that is, any column or expression etc to be retrieved with the query)
SelectItemVisitor
SelectVisitor
SetOperation Single Set-Operation (name).
SetOperationList A database set operation.
SetOperationList.SetOperationType list of set operations.
Skip A skip clause in the form [SKIP row_count] Initial implementation was done for informix special syntax: http://www-01.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_0156.htm
SubJoin A table created by "(tab1 join tab2)".
SubSelect A subselect followed by an optional alias.
TableFunction
Top A top clause in the form [TOP (row_count) or TOP row_count]
ValuesList This is a container for a values item within a select statement.
Wait A timeout applied to SELECT to specify how long to wait for the row on the lock to be released.
WithItem One of the parts of a "WITH" clause of a "SELECT" statement

com.fr.general.jsqlparser.statement.update使用的com.fr.general.jsqlparser.statement.select中的类

类和说明
FromItem An item in a "SELECT [...]
Join A join clause
Limit A limit clause in the form [LIMIT {[offset,] row_count) | (row_count | ALL) OFFSET offset}]
OrderByElement An element (column reference) in an "ORDER BY" clause.
Select
SelectExpressionItem An expression as in "SELECT expr1 AS EXPR"

com.fr.general.jsqlparser.statement.upsert使用的com.fr.general.jsqlparser.statement.select中的类

类和说明
Select

com.fr.general.jsqlparser.util使用的com.fr.general.jsqlparser.statement.select中的类

类和说明
AllColumns All the columns (as in "SELECT * FROM ...")
AllTableColumns
FromItemVisitor
Join A join clause
LateralSubSelect A lateral subselect followed by an alias.
PlainSelect The core of a "SELECT" statement (no UNION, no ORDER BY)
Select
SelectExpressionItem An expression as in "SELECT expr1 AS EXPR"
SelectItem Anything between "SELECT" and "FROM" (that is, any column or expression etc to be retrieved with the query)
SelectItemVisitor
SelectVisitor
SetOperationList A database set operation.
SubJoin A table created by "(tab1 join tab2)".
SubSelect A subselect followed by an optional alias.
TableFunction
ValuesList This is a container for a values item within a select statement.
WithItem One of the parts of a "WITH" clause of a "SELECT" statement

com.fr.general.jsqlparser.util.deparser使用的com.fr.general.jsqlparser.statement.select中的类

类和说明
AllColumns All the columns (as in "SELECT * FROM ...")
AllTableColumns
Fetch A fetch clause in the form FETCH (FIRST | NEXT) row_count (ROW | ROWS) ONLY
FromItemVisitor
Join A join clause
LateralSubSelect A lateral subselect followed by an alias.
Limit A limit clause in the form [LIMIT {[offset,] row_count) | (row_count | ALL) OFFSET offset}]
Offset An offset clause in the form OFFSET offset or in the form OFFSET offset (ROW | ROWS)
OrderByElement An element (column reference) in an "ORDER BY" clause.
OrderByVisitor
Pivot
PivotVisitor
PivotXml
PlainSelect The core of a "SELECT" statement (no UNION, no ORDER BY)
Select
SelectExpressionItem An expression as in "SELECT expr1 AS EXPR"
SelectItemVisitor
SelectVisitor
SetOperationList A database set operation.
SubJoin A table created by "(tab1 join tab2)".
SubSelect A subselect followed by an optional alias.
TableFunction
ValuesList This is a container for a values item within a select statement.
WithItem One of the parts of a "WITH" clause of a "SELECT" statement

com.fr.general.sql.converter使用的com.fr.general.jsqlparser.statement.select中的类

类和说明
SelectBody