本文整理汇总了Java中com.querydsl.sql.SQLQuery.orderBy方法的典型用法代码示例。如果您正苦于以下问题:Java SQLQuery.orderBy方法的具体用法?Java SQLQuery.orderBy怎么用?Java SQLQuery.orderBy使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类com.querydsl.sql.SQLQuery
的用法示例。
在下文中一共展示了SQLQuery.orderBy方法的4个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: addToQuery
import com.querydsl.sql.SQLQuery; //导入方法依赖的package包/类
public void addToQuery(OrderBy orderBy, Expression<?> sqlExpression, SQLQuery<Tuple> sqlQuery) {
if (sqlExpression instanceof ComparableExpressionBase) {
ComparableExpressionBase comparable = (ComparableExpressionBase) sqlExpression;
Expression<?> projection = sqlQuery.getMetadata().getProjection();
if (projection instanceof QTuple) {
QTuple qTuple = (QTuple) projection;
List<Expression<?>> args = new ArrayList<>(qTuple.getArgs());
args.add(comparable);
sqlQuery.select(args.toArray(new Expression[args.size()]));
}
if (orderBy.getType() == OrderBy.OrderType.Ascending) {
sqlQuery.orderBy(comparable.asc());
} else {
sqlQuery.orderBy(comparable.desc());
}
}
}
示例2: versionsAndParentsSince
import com.querydsl.sql.SQLQuery; //导入方法依赖的package包/类
protected List<Group> versionsAndParentsSince(Id docId, Revision since) {
SQLQuery<?> qry = options.queryFactory.from(options.sinceVersion);
// Left join version version on version.ordinal > since.ordinal and version.doc_id = since.doc_id
qry.leftJoin(options.version).on(
options.version.ordinal.gt(options.sinceVersion.ordinal),
predicate(EQ, options.version.docId, options.sinceVersion.docId));
// Left join parents
qry.leftJoin(options.parent).on(options.parent.revision.eq(options.version.revision));
qry.where(options.sinceVersion.revision.eq(since),
// Return "since" row even if there is no newer versions
versionsOf(docId).or(predicate(IS_NULL, options.version.docId)));
qry.orderBy(options.version.ordinal.asc());
return verifyVersionsAndParentsSince(qry.transform(groupBy(options.version.revision).list(versionAndParentsSince)), since);
}
示例3: versionsAndParentsSince
import com.querydsl.sql.SQLQuery; //导入方法依赖的package包/类
protected List<Group> versionsAndParentsSince(Id docId, Revision since) {
SQLQuery<?> qry = options.queryFactory.from(options.sinceVersion);
// Left join version version on version.ordinal > since.ordinal and version.doc_id = since.doc_id
qry.leftJoin(options.version).on(
options.version.localOrdinal.gt(options.sinceVersion.localOrdinal),
predicate(EQ, options.version.docId, options.sinceVersion.docId));
// Left join parents
qry.leftJoin(options.parent).on(options.parent.revision.eq(options.version.revision));
qry.where(options.sinceVersion.revision.eq(since),
versionsOf(docId).or(predicate(IS_NULL, options.version.docId)));
qry.orderBy(options.version.localOrdinal.asc());
return verifyVersionsAndParentsSince(qry.transform(versionAndParentsSince), since);
}
示例4: selectFrom
import com.querydsl.sql.SQLQuery; //导入方法依赖的package包/类
protected SQLQuery<T> selectFrom() {
SQLQuery<T> query = transactionManager
.selectQuery()
.select(table)
.from(table);
if(defaultOrder != null) {
query.orderBy(defaultOrder);
}
return query;
}