APIdia Launch Partner
Top Description Constructors Methods
io.github.spannm.jackcess.impl.query

public Class CrossTabQueryImpl

extends BaseSelectQueryImpl
implements CrossTabQuery
Class Inheritance
All Implemented Interfaces
io.github.spannm.jackcess.query.CrossTabQuery, io.github.spannm.jackcess.query.BaseSelectQuery, io.github.spannm.jackcess.query.Query
Static Imports
io.github.spannm.jackcess.impl.query.QueryFormat.CROSSTAB_NORMAL_FLAG, .QueryFormat.CROSSTAB_PIVOT_FLAG, .QueryFormat.NEWLINE
Concrete Query subclass which represents a crosstab/pivot query, e.g.: TRANSFORM <expr> SELECT <query> PIVOT <expr>

Constructor Summary

AccessConstructor and Description
public
CrossTabQueryImpl(String name, List<QueryImpl.Row> rows, int objectId, int objectFlag)

Method Summary

Modifier and TypeMethod and Description
protected List<QueryImpl.Row>
getColumnRows()

Overrides io.github.spannm.jackcess.impl.query.QueryImpl.getColumnRows.

protected List<QueryImpl.Row>
getGroupByRows()

Overrides io.github.spannm.jackcess.impl.query.QueryImpl.getGroupByRows.

public String
getPivotExpression()

Implements io.github.spannm.jackcess.query.CrossTabQuery.getPivotExpression.

protected QueryImpl.Row
getPivotRow()

public String
getTransformExpression()

Implements io.github.spannm.jackcess.query.CrossTabQuery.getTransformExpression.

protected QueryImpl.Row
getTransformRow()

protected void
toSQLString(StringBuilder builder)

Implements abstract io.github.spannm.jackcess.impl.query.QueryImpl.toSQLString.

Inherited from io.github.spannm.jackcess.impl.query.BaseSelectQueryImpl:
getFromRemoteDbPathgetFromRemoteDbTypegetFromTablesgetGroupingsgetHavingExpressiongetOrderingsgetSelectColumnsgetSelectTypegetWhereExpressiontoSelectIntotoSQLSelectString

Constructor Detail

CrossTabQueryImplback to summary
public CrossTabQueryImpl(String name, List<QueryImpl.Row> rows, int objectId, int objectFlag)

Method Detail

getColumnRowsback to summary
protected List<QueryImpl.Row> getColumnRows()

Overrides io.github.spannm.jackcess.impl.query.QueryImpl.getColumnRows.

Annotations
@Override
getGroupByRowsback to summary
protected List<QueryImpl.Row> getGroupByRows()

Overrides io.github.spannm.jackcess.impl.query.QueryImpl.getGroupByRows.

Annotations
@Override
getPivotExpressionback to summary
public String getPivotExpression()

Implements io.github.spannm.jackcess.query.CrossTabQuery.getPivotExpression.

Annotations
@Override
getPivotRowback to summary
protected QueryImpl.Row getPivotRow()
getTransformExpressionback to summary
public String getTransformExpression()

Implements io.github.spannm.jackcess.query.CrossTabQuery.getTransformExpression.

Annotations
@Override
getTransformRowback to summary
protected QueryImpl.Row getTransformRow()
toSQLStringback to summary
protected void toSQLString(StringBuilder builder)

Implements abstract io.github.spannm.jackcess.impl.query.QueryImpl.toSQLString.

Annotations
@Override