T
- The query result typepublic interface CriteriaBuilder<T> extends QueryBuilder<T,CriteriaBuilder<T>>, GroupByBuilder<T,CriteriaBuilder<T>>, DistinctBuilder<T,CriteriaBuilder<T>>
containsParameter, fetch, getMetamodel, getParameter, getParameters, getParameterValue, getQuery, getResultList, getSingleResult, innerJoinFetch, innerJoinFetchDefault, isParameterSet, join, joinDefault, leftJoinFetch, leftJoinFetchDefault, page, page, page, rightJoinFetch, rightJoinFetchDefault, selectNew, setParameter, setParameter, setParameter
afterKeyset, afterKeyset, afterKeyset, beforeKeyset, beforeKeyset, beforeKeyset, getQueryString, getResultType, innerJoin, innerJoinDefault, innerJoinDefaultOn, innerJoinOn, join, joinDefault, joinDefaultOn, joinOn, leftJoin, leftJoinDefault, leftJoinDefaultOn, leftJoinOn, rightJoin, rightJoinDefault, rightJoinDefaultOn, rightJoinOn
whereOr
where, whereCase, whereExists, whereNotExists, whereSimpleCase, whereSubquery, whereSubquery
orderBy, orderByAsc, orderByAsc, orderByDesc, orderByDesc
groupBy, groupBy
havingOr
having, havingCase, havingExists, havingNotExists, havingSimpleCase, havingSubquery, havingSubquery
distinct
CriteriaBuilder<T> from(Class<?> entityClass)
BaseQueryBuilder
BaseQueryBuilder.from(java.lang.Class, java.lang.String)
with the
alias equivalent to the camel cased result of what Class.getSimpleName()
of the entity class returns.from
in interface BaseQueryBuilder<T,CriteriaBuilder<T>>
entityClass
- The entity class which should be the root entityCriteriaBuilder<T> from(Class<?> entityClass, String alias)
BaseQueryBuilder
from
in interface BaseQueryBuilder<T,CriteriaBuilder<T>>
entityClass
- The entity class which should be the root entityalias
- The alias for the root entitySimpleCaseWhenStarterBuilder<CriteriaBuilder<T>> selectSimpleCase(String expression)
SelectBuilder
SelectBuilder.selectSimpleCase(java.lang.String, java.lang.String)
but without an alias.selectSimpleCase
in interface BaseQueryBuilder<T,CriteriaBuilder<T>>
selectSimpleCase
in interface QueryBuilder<T,CriteriaBuilder<T>>
selectSimpleCase
in interface SelectBuilder<T,CriteriaBuilder<T>>
expression
- The case operandSimpleCaseWhenStarterBuilder<CriteriaBuilder<T>> selectSimpleCase(String expression, String alias)
SelectBuilder
SimpleCaseWhenBuilder
with the given alias as select alias.
The expression is the case operand which will be compared to the when expressions defined in the subsequent SimpleCaseWhenBuilder.selectSimpleCase
in interface BaseQueryBuilder<T,CriteriaBuilder<T>>
selectSimpleCase
in interface QueryBuilder<T,CriteriaBuilder<T>>
selectSimpleCase
in interface SelectBuilder<T,CriteriaBuilder<T>>
expression
- The case operandalias
- The select alias for the simple case when expressionCaseWhenStarterBuilder<CriteriaBuilder<T>> selectCase()
SelectBuilder
SelectBuilder.selectCase(java.lang.String)
but without an alias.selectCase
in interface BaseQueryBuilder<T,CriteriaBuilder<T>>
selectCase
in interface QueryBuilder<T,CriteriaBuilder<T>>
selectCase
in interface SelectBuilder<T,CriteriaBuilder<T>>
CaseWhenStarterBuilder<CriteriaBuilder<T>> selectCase(String alias)
SelectBuilder
CaseWhenBuilder
with the given alias as select alias.selectCase
in interface BaseQueryBuilder<T,CriteriaBuilder<T>>
selectCase
in interface QueryBuilder<T,CriteriaBuilder<T>>
selectCase
in interface SelectBuilder<T,CriteriaBuilder<T>>
alias
- The select alias for the case when expression<Y> SelectObjectBuilder<CriteriaBuilder<Y>> selectNew(Class<Y> clazz)
QueryBuilder
SelectObjectBuilder
for the given class. The types of the parameter arguments used in the SelectObjectBuilder
must match a constructor of the given class.selectNew
in interface QueryBuilder<T,CriteriaBuilder<T>>
Y
- The new query result type specified by the given classclazz
- The class which should be used for the select new select clause<Y> CriteriaBuilder<Y> selectNew(ObjectBuilder<Y> builder)
QueryBuilder
selectNew
in interface QueryBuilder<T,CriteriaBuilder<T>>
Y
- The new query result type specified by the given classbuilder
- The object builder which transforms the result set into objects of type Y
CriteriaBuilder<T> select(String expression)
SelectBuilder
select
in interface BaseQueryBuilder<T,CriteriaBuilder<T>>
select
in interface QueryBuilder<T,CriteriaBuilder<T>>
select
in interface SelectBuilder<T,CriteriaBuilder<T>>
expression
- The expression for the select clauseCriteriaBuilder<T> select(String expression, String alias)
SelectBuilder
select
in interface BaseQueryBuilder<T,CriteriaBuilder<T>>
select
in interface QueryBuilder<T,CriteriaBuilder<T>>
select
in interface SelectBuilder<T,CriteriaBuilder<T>>
expression
- The expression for the select clausealias
- The alias for the expressionSubqueryInitiator<CriteriaBuilder<T>> selectSubquery()
SelectBuilder
SelectBuilder.selectSubquery(java.lang.String)
but without an alias.selectSubquery
in interface BaseQueryBuilder<T,CriteriaBuilder<T>>
selectSubquery
in interface QueryBuilder<T,CriteriaBuilder<T>>
selectSubquery
in interface SelectBuilder<T,CriteriaBuilder<T>>
SubqueryInitiator<CriteriaBuilder<T>> selectSubquery(String alias)
SelectBuilder
SubqueryInitiator
for the select item with the given alias.
When the builder finishes, the select item is added to the parent container represented by the type X
.selectSubquery
in interface BaseQueryBuilder<T,CriteriaBuilder<T>>
selectSubquery
in interface QueryBuilder<T,CriteriaBuilder<T>>
selectSubquery
in interface SelectBuilder<T,CriteriaBuilder<T>>
alias
- The select alias for the subquerySubqueryInitiator<CriteriaBuilder<T>> selectSubquery(String subqueryAlias, String expression, String selectAlias)
SelectBuilder
SubqueryInitiator
for a new select item with the given select alias.
All occurrences of
subqueryAlias
in expression
will be replaced by the subquery.
When the builder finishes, the select item is added to the parent container represented by the type X
.
selectSubquery
in interface BaseQueryBuilder<T,CriteriaBuilder<T>>
selectSubquery
in interface QueryBuilder<T,CriteriaBuilder<T>>
selectSubquery
in interface SelectBuilder<T,CriteriaBuilder<T>>
subqueryAlias
- The alias for the subquery which will be replaced by the actual subqueryexpression
- The expression which will be added as select item.
This expression contains the subqueryAlias
to define the insertion points for the subquery.selectAlias
- The select alias for the expressionSubqueryInitiator<CriteriaBuilder<T>> selectSubquery(String subqueryAlias, String expression)
SelectBuilder
SelectBuilder.selectSubquery(java.lang.String,java.lang.String,java.lang.String)
but without a select alias.selectSubquery
in interface BaseQueryBuilder<T,CriteriaBuilder<T>>
selectSubquery
in interface QueryBuilder<T,CriteriaBuilder<T>>
selectSubquery
in interface SelectBuilder<T,CriteriaBuilder<T>>
subqueryAlias
- The alias for the subquery which will be replaced by the actual subqueryexpression
- The expression which will be added as select itemCopyright © 2015 Blazebit. All Rights Reserved.