Java HibernateQuery类代码示例

import com.querydsl.jpa.hibernate.HibernateQuery; //导入依赖的package包/类
public T findRequirementByRootRequirementAndType(Long rootRequirement, String type) {
    QRequirementEntity requirement = new QRequirementEntity("requirement");
    QFormRequirementEntity formRequirement = new QFormRequirementEntity("formRequirement");
    QFormEntity form = new QFormEntity("form");
    QFormTypeEntity formTypeEntity = new QFormTypeEntity("formType");

    HibernateQuery<RequirementEntity> hibernateQuery = new HibernateQueryFactory(getSession())
            .selectFrom(requirement)
            .innerJoin(requirement.formRequirementEntities, formRequirement)
            .innerJoin(formRequirement.form, form)
            .innerJoin(form.formType, formTypeEntity)
            .where(formRequirement.mainForm.eq(SimNao.SIM)
                    .and(requirement.rootRequirement.cod.eq(rootRequirement))
                    .and(formTypeEntity.abbreviation.eq(type)));
    hibernateQuery.getMetadata().setLimit(1L);

    return (T) hibernateQuery.fetchOne();
}
 

import com.querydsl.jpa.hibernate.HibernateQuery; //导入依赖的package包/类
protected<R> R withPredicate(Function<HibernateQuery<T>, R> toResult, Predicate... predicates) {
	return transactionManager.queryDslExecuteAndReturn(query -> {
		HibernateQuery<T> fetchQuery = query.selectFrom(queryDslEntity);

		if(predicates != null && predicates.length > 0) {
			fetchQuery.where(predicates);
		}

		return toResult.apply(fetchQuery);
	});
}
 

import com.querydsl.jpa.hibernate.HibernateQuery; //导入依赖的package包/类
public List<FeedSubscription> findByCategory(User user, FeedCategory category) {
	HibernateQuery<FeedSubscription> query = query().selectFrom(sub).where(sub.user.eq(user));
	if (category == null) {
		query.where(sub.category.isNull());
	} else {
		query.where(sub.category.eq(category));
	}
	return initRelations(query.fetch());
}
 

import com.querydsl.jpa.hibernate.HibernateQuery; //导入依赖的package包/类
public List<Feed> findNextUpdatable(int count, Date lastLoginThreshold) {
	HibernateQuery<Feed> query = query().selectFrom(feed);
	query.where(feed.disabledUntil.isNull().or(feed.disabledUntil.lt(new Date())));

	if (lastLoginThreshold != null) {
		QFeedSubscription subs = QFeedSubscription.feedSubscription;
		QUser user = QUser.user;

		JPQLQuery<Integer> subQuery = JPAExpressions.selectOne().from(subs);
		subQuery.join(subs.user, user).where(user.lastLogin.gt(lastLoginThreshold));
		query.where(subQuery.exists());
	}

	return query.orderBy(feed.disabledUntil.asc()).limit(count).distinct().fetch();
}
 

import com.querydsl.jpa.hibernate.HibernateQuery; //导入依赖的package包/类
protected long searchCount(Predicate... predicates) {
	return withPredicate(HibernateQuery::fetchCount, predicates);
}
 

import com.querydsl.jpa.hibernate.HibernateQuery; //导入依赖的package包/类
protected T searchOne(Predicate... predicates) {
	return withPredicate(HibernateQuery::fetchOne, predicates);
}
 

import com.querydsl.jpa.hibernate.HibernateQuery; //导入依赖的package包/类
public HibernateQueryDslPaginable(TransactionManagerHibernate dbExecutor, Function<HibernateQueryFactory, HibernateQuery<T>> baseQuery) {
	this.dbExecutor = dbExecutor;
	this.baseQuery = baseQuery;
}
 

import com.querydsl.jpa.hibernate.HibernateQuery; //导入依赖的package包/类
public <T> Paginable<T> queryDslPaginate(Function<HibernateQueryFactory, HibernateQuery<T>> toExecuteOnDb) {
	return new HibernateQueryDslPaginable<>(this, toExecuteOnDb);
}