Module org.seasar.doma.core

Package org.seasar.doma.jdbc.criteria.statement

Class UnifiedSelectTerminal<ENTITY>

java.lang.Object

org.seasar.doma.jdbc.criteria.statement.AbstractStatement<UnifiedSelectTerminal<ENTITY>,List<ENTITY>>

org.seasar.doma.jdbc.criteria.statement.UnifiedSelectTerminal<ENTITY>

Type Parameters:

ENTITY - the type of the entity

All Implemented Interfaces:

Buildable<Statement<List<ENTITY>>>, EntityQueryable<ENTITY>, Listable<ENTITY>, Statement<List<ENTITY>>

public class UnifiedSelectTerminal<ENTITY>
extends AbstractStatement<UnifiedSelectTerminal<ENTITY>,List<ENTITY>>
implements EntityQueryable<ENTITY>

Represents a SELECT statement terminal.

Note: project(EntityMetamodel) and projectTo(EntityMetamodel, PropertyMetamodel[]) will remove duplicate entities from the results.

Field Summary

Fields inherited from class org.seasar.doma.jdbc.criteria.statement.AbstractStatement

config, EXECUTE_METHOD, EXECUTE_METHOD_NAME

Method Summary

Modifier and Type	Method	Description
<ENTITY1, ENTITY2> EntityQueryable<ENTITY>	associate(EntityMetamodel<ENTITY1> first, EntityMetamodel<ENTITY2> second, BiConsumer<ENTITY1,ENTITY2> associator)	Associates the entities.
<ENTITY1, ENTITY2> EntityQueryable<ENTITY>	associate(EntityMetamodel<ENTITY1> first, EntityMetamodel<ENTITY2> second, BiConsumer<ENTITY1,ENTITY2> associator, AssociationOption option)	Associates the entities with the option.
<ENTITY1, ENTITY2> EntityQueryable<ENTITY>	associateWith(EntityMetamodel<ENTITY1> first, EntityMetamodel<ENTITY2> second, BiFunction<ENTITY1,ENTITY2,ENTITY1> associator)	Associates the immutable entities.
<ENTITY1, ENTITY2> EntityQueryable<ENTITY>	associateWith(EntityMetamodel<ENTITY1> first, EntityMetamodel<ENTITY2> second, BiFunction<ENTITY1,ENTITY2,ENTITY1> associator, AssociationOption option)	Associates the immutable entities with the option.
protected Command<List<ENTITY>>	createCommand()
EntityQueryable<ENTITY>	distinct()	Specifies the distinct keyword.
EntityQueryable<ENTITY>	distinct(DistinctOption distinctOption)	Specifies the distinct keyword with the specified option.
EntityQueryable<ENTITY>	forUpdate()	Specifies the for update clause.
EntityQueryable<ENTITY>	forUpdate(ForUpdateOption option)	Specifies the for update clause with the specified option.
EntityQueryable<ENTITY>	innerJoin(EntityMetamodel<?> entityMetamodel, Consumer<JoinDeclaration> block)	Specifies the inner join clause.
EntityQueryable<ENTITY>	leftJoin(EntityMetamodel<?> entityMetamodel, Consumer<JoinDeclaration> block)	Specifies the left join clause.
EntityQueryable<ENTITY>	limit(Integer limit)	Specifies the limit clause.
EntityQueryable<ENTITY>	offset(Integer offset)	Specifies the offset clause.
EntityQueryable<ENTITY>	orderBy(Consumer<OrderByNameDeclaration> block)	Specifies the order by clause.
<RESULT> Listable<RESULT>	project(EntityMetamodel<RESULT> entityMetamodel)	Projects the result to the entity.
<RESULT> Listable<RESULT>	projectTo(EntityMetamodel<RESULT> entityMetamodel, PropertyMetamodel<?>... propertyMetamodels)	Projects the result to the entity with the specified properties.
EntityQueryable<ENTITY>	where(Consumer<WhereDeclaration> block)	Specifies the where clause.

Methods inherited from class org.seasar.doma.jdbc.criteria.statement.AbstractStatement

asSql, createCommenter, execute, peek

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.seasar.doma.jdbc.criteria.statement.Buildable

asSql

Methods inherited from interface org.seasar.doma.jdbc.criteria.statement.Listable

fetch, fetchOne, fetchOptional, peek, stream

Methods inherited from interface org.seasar.doma.jdbc.criteria.statement.Statement

execute

Method Details

distinct

public EntityQueryable<ENTITY> distinct()

Description copied from interface: EntityQueryable

Specifies the distinct keyword.

Specified by:

distinct in interface EntityQueryable<ENTITY>

Returns:

the select statement

distinct

public EntityQueryable<ENTITY> distinct(DistinctOption distinctOption)

Description copied from interface: EntityQueryable

Specifies the distinct keyword with the specified option.

Specified by:

distinct in interface EntityQueryable<ENTITY>

Parameters:

distinctOption - the distinct option

Returns:

the select statement

innerJoin

public EntityQueryable<ENTITY> innerJoin(EntityMetamodel<?> entityMetamodel,
 Consumer<JoinDeclaration> block)

Description copied from interface: EntityQueryable

Specifies the inner join clause.

Specified by:

innerJoin in interface EntityQueryable<ENTITY>

Parameters:

entityMetamodel - the entity metamodel

block - the block that describes the join condition

Returns:

the select statement

leftJoin

public EntityQueryable<ENTITY> leftJoin(EntityMetamodel<?> entityMetamodel,
 Consumer<JoinDeclaration> block)

Description copied from interface: EntityQueryable

Specifies the left join clause.

Specified by:

leftJoin in interface EntityQueryable<ENTITY>

Parameters:

entityMetamodel - the entity metamodel

block - the block that describes the join condition

Returns:

the select statement

where

public EntityQueryable<ENTITY> where(Consumer<WhereDeclaration> block)

Description copied from interface: EntityQueryable

Specifies the where clause.

Specified by:

where in interface EntityQueryable<ENTITY>

Parameters:

block - the block that describes the where condition

Returns:

the select statement

orderBy

public EntityQueryable<ENTITY> orderBy(Consumer<OrderByNameDeclaration> block)

Description copied from interface: EntityQueryable

Specifies the order by clause.

Specified by:

orderBy in interface EntityQueryable<ENTITY>

Parameters:

block - the block that describes the order by condition

Returns:

the select statement

limit

public EntityQueryable<ENTITY> limit(Integer limit)

Description copied from interface: EntityQueryable

Specifies the limit clause.

Specified by:

limit in interface EntityQueryable<ENTITY>

Parameters:

limit - the limit

Returns:

the select statement

offset

public EntityQueryable<ENTITY> offset(Integer offset)

Description copied from interface: EntityQueryable

Specifies the offset clause.

Specified by:

offset in interface EntityQueryable<ENTITY>

Parameters:

offset - the offset

Returns:

the select statement

forUpdate

public EntityQueryable<ENTITY> forUpdate()

Description copied from interface: EntityQueryable

Specifies the for update clause.

Specified by:

forUpdate in interface EntityQueryable<ENTITY>

Returns:

the select statement

forUpdate

public EntityQueryable<ENTITY> forUpdate(ForUpdateOption option)

Description copied from interface: EntityQueryable

Specifies the for update clause with the specified option.

Specified by:

forUpdate in interface EntityQueryable<ENTITY>

Parameters:

option - the for update option

Returns:

the select statement

associate

public <ENTITY1,
ENTITY2> EntityQueryable<ENTITY> associate(EntityMetamodel<ENTITY1> first,
 EntityMetamodel<ENTITY2> second,
 BiConsumer<ENTITY1,ENTITY2> associator)

Description copied from interface: EntityQueryable

Associates the entities.

Specified by:

associate in interface EntityQueryable<ENTITY>

Parameters:

first - the first entity metamodel

second - the second entity metamodel

associator - the associator

Returns:

the select statement

associate

public <ENTITY1,
ENTITY2> EntityQueryable<ENTITY> associate(EntityMetamodel<ENTITY1> first,
 EntityMetamodel<ENTITY2> second,
 BiConsumer<ENTITY1,ENTITY2> associator,
 AssociationOption option)

Description copied from interface: EntityQueryable

Associates the entities with the option.

Specified by:

associate in interface EntityQueryable<ENTITY>

Parameters:

first - the first entity metamodel

second - the second entity metamodel

associator - the associator

option - the association option

Returns:

the select statement

associateWith

public <ENTITY1,
ENTITY2> EntityQueryable<ENTITY> associateWith(EntityMetamodel<ENTITY1> first,
 EntityMetamodel<ENTITY2> second,
 BiFunction<ENTITY1,ENTITY2,ENTITY1> associator)

Description copied from interface: EntityQueryable

Associates the immutable entities.

Specified by:

associateWith in interface EntityQueryable<ENTITY>

Parameters:

first - the first entity metamodel

second - the second entity metamodel

associator - the associator

Returns:

the select statement

associateWith

public <ENTITY1,
ENTITY2> EntityQueryable<ENTITY> associateWith(EntityMetamodel<ENTITY1> first,
 EntityMetamodel<ENTITY2> second,
 BiFunction<ENTITY1,ENTITY2,ENTITY1> associator,
 AssociationOption option)

Description copied from interface: EntityQueryable

Associates the immutable entities with the option.

Specified by:

associateWith in interface EntityQueryable<ENTITY>

Parameters:

first - the first entity metamodel

second - the second entity metamodel

associator - the associator

Returns:

the select statement

project

public <RESULT> Listable<RESULT> project(EntityMetamodel<RESULT> entityMetamodel)

Description copied from interface: EntityQueryable

Projects the result to the entity. The duplicated entities are removed from the result.

Specified by:

project in interface EntityQueryable<ENTITY>

Parameters:

entityMetamodel - the entity metamodel

Returns:

the select statement

projectTo

public <RESULT> Listable<RESULT> projectTo(EntityMetamodel<RESULT> entityMetamodel,
 PropertyMetamodel<?>... propertyMetamodels)

Description copied from interface: EntityQueryable

Projects the result to the entity with the specified properties. The duplicated entities are removed from the result.

Specified by:

projectTo in interface EntityQueryable<ENTITY>

Parameters:

entityMetamodel - the entity metamodel

propertyMetamodels - the property metamodels to project

Returns:

the select statement

createCommand

protected Command<List<ENTITY>> createCommand()

Specified by:

createCommand in class AbstractStatement<UnifiedSelectTerminal<ENTITY>,List<ENTITY>>