本文整理汇总了Java中org.jooq.SelectQuery.addLimit方法的典型用法代码示例。如果您正苦于以下问题:Java SelectQuery.addLimit方法的具体用法?Java SelectQuery.addLimit怎么用?Java SelectQuery.addLimit使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.jooq.SelectQuery
的用法示例。
在下文中一共展示了SelectQuery.addLimit方法的6个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: getSecretSeriesBatched
import org.jooq.SelectQuery; //导入方法依赖的package包/类
public ImmutableList<SecretSeries> getSecretSeriesBatched(int idx, int num, boolean newestFirst) {
SelectQuery<Record> select = dslContext
.select()
.from(SECRETS)
.join(SECRETS_CONTENT)
.on(SECRETS.CURRENT.equal(SECRETS_CONTENT.ID))
.where(SECRETS.CURRENT.isNotNull())
.getQuery();
if (newestFirst) {
select.addOrderBy(SECRETS.CREATEDAT.desc());
} else {
select.addOrderBy(SECRETS.CREATEDAT.asc());
}
select.addLimit(idx, num);
List<SecretSeries> r = select.fetchInto(SECRETS).map(secretSeriesMapper);
return ImmutableList.copyOf(r);
}
示例2: getQuestions
import org.jooq.SelectQuery; //导入方法依赖的package包/类
@Override
public List<QuestionView> getQuestions(final QuestionsOptions options) {
final Integer itemsPerPage = SecurityUtils.getItemsPerPage();
final SelectQuery<Record> questionSelect = getQuestionSelect(options);
if (options.isOwnOrPublic()) {
questionSelect.addConditions(
QUESTIONS.PRIVATE.eq(false).or(QUESTIONS.USER_ID.eq(getUserId(options.getCurrentUser())))
);
}
if (StringUtils.isNotEmpty(options.getProblemCode())) {
questionSelect.addConditions(QUESTIONS.TASK_ID.eq(getProblemId(options.getProblemCode())));
}
questionSelect.addOrderBy(QUESTIONS.QUESTION_ID.desc());
questionSelect.addLimit(options.getPage() * itemsPerPage, itemsPerPage);
return questionSelect.fetch(getQuestionMapper(QuestionContent.WITHOUT_CONTENT));
}
示例3: getProblems
import org.jooq.SelectQuery; //导入方法依赖的package包/类
@Override
public ProblemListView getProblems(@Nonnull final ProblemsOptions problemsOptions) {
final Integer itemsPerPage = SecurityUtils.getItemsPerPage();
final SelectQuery<Record> query = jooq.selectQuery();
query.addSelect(TASKS.TASK_ID, TASKS.NAME, TASKS.CODE);
query.addFrom(TASKS);
if (!Strings.isNullOrEmpty(problemsOptions.getQuery())) {
final String lowerQuery = problemsOptions.getQuery().toLowerCase();
query.addConditions(TASKS.CODE.lower().contains(lowerQuery)
.or(TASKS.NAME.lower().contains(lowerQuery)));
}
if (!Strings.isNullOrEmpty(problemsOptions.getAvailableForGroup())) {
query.addConditions(TASKS.TASK_ID.notIn(
jooq.select(CONTESTS_TASKS.TASK_ID)
.from(CONTESTS_TASKS)
.join(CONTESTS).on(CONTESTS.CONTEST_ID.eq(CONTESTS_TASKS.CONTEST_ID))
.where(CONTESTS.CODE.eq(problemsOptions.getAvailableForGroup()))
));
}
query.addOrderBy(TASKS.CODE, TASKS.NAME);
query.addLimit(problemsOptions.getPage() * itemsPerPage, itemsPerPage);
List<ProblemView> problems =
query.fetch()
.map(record -> {
final ProblemView problem = new ProblemView();
problem.setCode(record.getValue(TASKS.CODE));
problem.setName(record.getValue(TASKS.NAME));
return problem;
});
return new ProblemListView(problems);
}
示例4: addLimit
import org.jooq.SelectQuery; //导入方法依赖的package包/类
protected void addLimit(SchemaFactory schemaFactory, String type, Pagination pagination, SelectQuery<?> query) {
if (pagination == null || pagination.getLimit() == null) {
return;
}
int limit = pagination.getLimit() + 1;
int offset = getOffset(pagination);
query.addLimit(offset, limit);
}
示例5: addLimit
import org.jooq.SelectQuery; //导入方法依赖的package包/类
protected void addLimit(SchemaFactory schemaFactory, String type, Pagination pagination, SelectQuery<?> query) {
if ( pagination == null || pagination.getLimit() == null ) {
return;
}
int limit = pagination.getLimit() + 1;
int offset = getOffset(pagination);
query.addLimit(offset, limit);
}
示例6: getQuery
import org.jooq.SelectQuery; //导入方法依赖的package包/类
private SelectQuery<R> getQuery(Pageable pageable) {
SelectQuery<R> query = getQuery(pageable.getSort());
query.addLimit(pageable.getOffset(), pageable.getPageSize());
return query;
}