org.opencms.db

类 CmsSelectQuery

java.lang.Object

org.opencms.db.CmsSelectQuery

所有已实现的接口:

I_CmsQueryFragment

public class CmsSelectQuery
extends java.lang.Object
implements I_CmsQueryFragment

A class for generating SQL SELECT statements.

从以下版本开始:

8.0.0

嵌套类概要

嵌套类

限定符和类型	类和说明
class	CmsSelectQuery.TableAlias Helper class which wraps a table alias.

构造器概要

构造器

构造器和说明
CmsSelectQuery() Creates a new instance.

方法概要

方法

限定符和类型	方法和说明
void	addClause(I_CmsQueryFragment clause) Adds another clause to the query.
void	addColumn(I_CmsQueryFragment node) Adds an expression which should be added as a column in the result set.
void	addColumn(java.lang.String column) Adds an expression which should be added as a column in the result set.
void	addCondition(I_CmsQueryFragment node) Adds a new condition to the query.
void	addCondition(java.lang.String fragment, java.lang.Object... params) Adds a new condition to the query.
void	addTable(java.lang.String table) Adds a table to the query's FROM clause.
CmsSelectQuery.TableAlias	addTable(java.lang.String table, java.lang.String aliasPrefix) Adds a table the query's FROM clause.
I_CmsQueryFragment	getOrdering() Returns the fragment for the ORDER BY clause.
void	setOrdering(java.lang.String ordering) Sets the SQL used for the ORDER BY clause.
void	visit(CmsStatementBuilder builder) Generates the SQL and parameters and sends them to the statement builder .

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

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

构造器详细资料

CmsSelectQuery

public CmsSelectQuery()

Creates a new instance.

方法详细资料

addClause

public void addClause(I_CmsQueryFragment clause)

Adds another clause to the query.

参数:

clause - the clause to add

addColumn

public void addColumn(I_CmsQueryFragment node)

Adds an expression which should be added as a column in the result set.

参数:

node - the expression which should be added as a column

addColumn

public void addColumn(java.lang.String column)

Adds an expression which should be added as a column in the result set.

参数:

column - the expression which should be added as a column

addCondition

public void addCondition(I_CmsQueryFragment node)

Adds a new condition to the query.

参数:

node - the condition to add to the query

addCondition

public void addCondition(java.lang.String fragment,
                java.lang.Object... params)

Adds a new condition to the query.

参数:

fragment - the condition SQL

params - the condition parameters

addTable

public void addTable(java.lang.String table)

Adds a table to the query's FROM clause.

参数:

table - the table to add

addTable

public CmsSelectQuery.TableAlias addTable(java.lang.String table,
                                 java.lang.String aliasPrefix)

Adds a table the query's FROM clause.

参数:

table - the table to add

aliasPrefix - the prefix used to generate the alias

返回:

an alias for the table

getOrdering

public I_CmsQueryFragment getOrdering()

Returns the fragment for the ORDER BY clause.

返回:

the fragment for the ORDER BY clause

setOrdering

public void setOrdering(java.lang.String ordering)

Sets the SQL used for the ORDER BY clause.

参数:

ordering - the SQL used for the ORDER BY clause

visit

public void visit(CmsStatementBuilder builder)

从接口复制的说明: I_CmsQueryFragment

Generates the SQL and parameters and sends them to the statement builder .

指定者:

visit 在接口中 I_CmsQueryFragment

参数:

builder - the statement builder

另请参阅:

I_CmsQueryFragment.visit(org.opencms.db.CmsStatementBuilder)