| 程序包 | 说明 |
|---|---|
| org.opencms.db |
Low-level database connection and access functionality.
|
| org.opencms.db.generic |
Generic (ANSI-SQL) implementation of the OpenCms database connector.
|
| org.opencms.db.jpa |
| 限定符和类型 | 方法和说明 |
|---|---|
CmsSelectQuery.TableAlias |
CmsSelectQuery.addTable(java.lang.String table,
java.lang.String aliasPrefix)
Adds a table the query's FROM clause.
|
| 限定符和类型 | 方法和说明 |
|---|---|
protected void |
CmsUserQueryBuilder.addAllowedOuCondition(CmsSelectQuery select,
CmsSelectQuery.TableAlias users,
java.util.List<CmsOrganizationalUnit> allowedOus)
Adds OU conditions to an SQL query.
|
protected void |
CmsUserQueryBuilder.addFlagCondition(CmsSelectQuery select,
CmsSelectQuery.TableAlias users,
int flags,
boolean allowCore)
Adds flag checking conditions to an SQL query.
|
protected void |
CmsUserQueryBuilder.addGroupCondition(CmsSelectQuery select,
CmsSelectQuery.TableAlias users,
CmsUserSearchParameters searchParams)
Adds group conditions to an SQL query.
|
protected void |
CmsUserQueryBuilder.addOrgUnitCondition(CmsSelectQuery select,
CmsSelectQuery.TableAlias users,
CmsOrganizationalUnit orgUnit,
boolean recursive)
Adds a check for an OU to an SQL query.
|
protected void |
CmsUserQueryBuilder.addSearchFilterCondition(CmsSelectQuery select,
CmsSelectQuery.TableAlias users,
CmsUserSearchParameters searchParams)
Adds a search condition to a query.
|
protected void |
CmsUserQueryBuilder.addSorting(CmsSelectQuery select,
CmsSelectQuery.TableAlias users,
CmsUserSearchParameters searchParams)
Adds a sort order to an SQL query.
|
protected void |
CmsUserQueryBuilder.addWebuserCondition(CmsSelectQuery select,
CmsOrganizationalUnit orgUnit,
CmsSelectQuery.TableAlias users)
Adds a check for the web user condition to an SQL query.
|
protected I_CmsQueryFragment |
CmsUserQueryBuilder.createCoreCondition(CmsSelectQuery.TableAlias users)
Creates a core user check condition.
|
protected I_CmsQueryFragment |
CmsUserQueryBuilder.createFlagCondition(CmsSelectQuery.TableAlias users,
int flags)
Creates an SQL flag check condition.
|
protected java.lang.String |
CmsUserQueryBuilder.getSortExpression(CmsSelectQuery.TableAlias users,
CmsUserSearchParameters searchParams)
Returns the expression used for sorting the results.
|
protected java.lang.String |
CmsUserQueryBuilder.getUserActivatedExpression(CmsSelectQuery.TableAlias users)
Returns an expression for checking whether a user is activated.
|
protected java.lang.String |
CmsUserQueryBuilder.getUserFlagExpression(CmsSelectQuery.TableAlias users,
int flags)
Returns a bitwise AND expression with a fixed second operand.
|
protected java.lang.String |
CmsUserQueryBuilder.getUserFullNameExpression(CmsSelectQuery.TableAlias users)
Returns the SQL expression for generating the user's full name in the format
'firstname lastname (loginname)'.
|
| 限定符和类型 | 方法和说明 |
|---|---|
protected void |
CmsJpaUserQueryBuilder.addSorting(CmsSelectQuery select,
CmsSelectQuery.TableAlias users,
CmsUserSearchParameters searchParams)
Adds a sort order to an SQL query.
|
protected I_CmsQueryFragment |
CmsJpaUserQueryBuilder.createFlagCondition(CmsSelectQuery.TableAlias users,
int flags) |