Class TupleQueryBuilder<T>

java.lang.Object

io.leandev.appfuse.jpa.TupleQueryBuilder<T>

public class TupleQueryBuilder<T>
extends Object

Constructor Summary

Constructors

Constructor	Description
TupleQueryBuilder(jakarta.persistence.criteria.CriteriaBuilder criteriaBuilder)
TupleQueryBuilder(jakarta.persistence.EntityManager entityManager)

Method Summary

Modifier and Type	Method	Description
TupleQueryBuilder<T>	avg(String field, String alias)
jakarta.persistence.criteria.CriteriaQuery<jakarta.persistence.Tuple>	build()
jakarta.persistence.criteria.CriteriaQuery<Long>	buildCountQuery()	建構 count query，使用與 data query 相同的 filter。
TupleQueryBuilder<T>	count(String field)
TupleQueryBuilder<T>	count(String... fields)
TupleQueryBuilder<T>	countAs(String field, String alias)
TupleQueryBuilder<T>	distinct()
TupleQueryBuilder<T>	from(Class<T> entityType)
TupleQueryBuilder<T>	from(Class<T> entityType, String alias)
TupleQueryBuilder<T>	groupBy(String... fields)
TupleQueryBuilder<T>	having(Filter filter)
TupleQueryBuilder<T>	join(String property)
TupleQueryBuilder<T>	join(String property, jakarta.persistence.criteria.JoinType joinType)
TupleQueryBuilder<T>	join(String property, jakarta.persistence.criteria.JoinType joinType, String alias)
TupleQueryBuilder<T>	join(String property, String alias)
TupleQueryBuilder<T>	max(String field, String alias)
TupleQueryBuilder<T>	min(String field, String alias)
static <T> TupleQueryBuilder<T>	of(jakarta.persistence.criteria.CriteriaBuilder criteriaBuilder)
static <T> TupleQueryBuilder<T>	of(jakarta.persistence.EntityManager entityManager)
TupleQueryBuilder<T>	orderBy(org.springframework.data.domain.Sort sort)
TupleQueryBuilder<T>	select(String... fields)
TupleQueryBuilder<T>	selectAs(String field, String alias)
TupleQueryBuilder<T>	sum(String field, String alias)
TupleQueryBuilder<T>	where(Filter filter)

Methods inherited from class Object

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

Constructor Details

TupleQueryBuilder

public TupleQueryBuilder(jakarta.persistence.criteria.CriteriaBuilder criteriaBuilder)

TupleQueryBuilder

public TupleQueryBuilder(jakarta.persistence.EntityManager entityManager)

Method Details

of

public static <T> TupleQueryBuilder<T> of(jakarta.persistence.EntityManager entityManager)

of

public static <T> TupleQueryBuilder<T> of(jakarta.persistence.criteria.CriteriaBuilder criteriaBuilder)

from

public TupleQueryBuilder<T> from(Class<T> entityType)

from

public TupleQueryBuilder<T> from(Class<T> entityType,
 String alias)

join

public TupleQueryBuilder<T> join(String property,
 jakarta.persistence.criteria.JoinType joinType,
 String alias)

join

public TupleQueryBuilder<T> join(String property,
 jakarta.persistence.criteria.JoinType joinType)

join

public TupleQueryBuilder<T> join(String property,
 String alias)

join

public TupleQueryBuilder<T> join(String property)

where

public TupleQueryBuilder<T> where(Filter filter)

select

public TupleQueryBuilder<T> select(String... fields)

selectAs

public TupleQueryBuilder<T> selectAs(String field,
 String alias)

orderBy

public TupleQueryBuilder<T> orderBy(org.springframework.data.domain.Sort sort)

count

public TupleQueryBuilder<T> count(String field)

count

public TupleQueryBuilder<T> count(String... fields)

groupBy

public TupleQueryBuilder<T> groupBy(String... fields)

having

public TupleQueryBuilder<T> having(Filter filter)

countAs

public TupleQueryBuilder<T> countAs(String field,
 String alias)

distinct

public TupleQueryBuilder<T> distinct()

sum

public TupleQueryBuilder<T> sum(String field,
 String alias)

avg

public TupleQueryBuilder<T> avg(String field,
 String alias)

max

public TupleQueryBuilder<T> max(String field,
 String alias)

min

public TupleQueryBuilder<T> min(String field,
 String alias)

build

public jakarta.persistence.criteria.CriteriaQuery<jakarta.persistence.Tuple> build()

buildCountQuery

public jakarta.persistence.criteria.CriteriaQuery<Long> buildCountQuery()

建構 count query，使用與 data query 相同的 filter。

此方法建立獨立的 CriteriaQuery，避免 Hibernate 6 的 TableGroup 問題。

Returns:

count query