| 程序包 | 说明 |
|---|---|
| com.jn.sqlhelper.dialect | |
| com.jn.sqlhelper.dialect.orderby |
| 限定符和类型 | 方法和说明 |
|---|---|
static <C,E> PagingRequest<C,E> |
SqlRequests.preparePagination(int pageNo,
int pageSize,
String sort,
OrderByBuilder<String> orderByBuilder) |
static <C,E> PagingRequest<C,E> |
SqlRequests.preparePagination(int pageNo,
int pageSize,
String sort,
OrderByBuilder<String> orderByBuilder,
boolean count) |
static <C,E> PagingRequest<C,E> |
SqlRequests.preparePagination(int pageNo,
int pageSize,
String sort,
OrderByBuilder<String> orderByBuilder,
String dialect) |
static <C,E> PagingRequest<C,E> |
SqlRequests.preparePagination(int pageNo,
int pageSize,
String sort,
OrderByBuilder<String> orderByBuilder,
String dialect,
boolean count,
String countColumn) |
static SelectRequest |
SqlRequests.prepareSelect(Boolean escapeLikeParameter,
LikeEscaper likeEscaper,
String sort,
OrderByBuilder<String> orderByBuilder) |
static SelectRequest |
SqlRequests.prepareSelect(Boolean escapeLikeParameter,
LikeEscaper likeEscaper,
String sort,
OrderByBuilder<String> orderByBuilder,
Integer timeout,
Integer fetchSize,
int maxRows) |
| 限定符和类型 | 类和说明 |
|---|---|
class |
ProgramStyleOrderByBuilder
Usage:
OrderBy orderBy = new ProgramStyleOrderByBuilder()
.column("timeline")
.asc("userXXX")
.desc("userYYY")
.column("userZZZ", DESC)
.sqlSymbolMapper(new CamelToUnderlineSymbolMapper())
.build();
|
class |
SqlStyleOrderByBuilder
expression1, expression2 desc, expression3 asc;
|
class |
SymbolStyleOrderByBuilder
1) +expression1, -expression2
2) expression1+, expression2-
|
Copyright © 2020. All rights reserved.