com.jn.sqlhelper.dialect.pagination

类 SqlPaginations

java.lang.Object

com.jn.sqlhelper.common.utils.SQLs

com.jn.sqlhelper.dialect.SqlRequests

com.jn.sqlhelper.dialect.pagination.SqlPaginations

public class SqlPaginations
extends SqlRequests

字段概要

从类继承的字段 com.jn.sqlhelper.common.utils.SQLs

SQL_FILE_SUFFIX, WHITESPACE

构造器概要

构造器

构造器和说明
SqlPaginations()

方法概要

限定符和类型	方法和说明
static String	extractAfterSubqueryPartition(String sql, String endFlag)
static String	extractBeforeSubqueryPartition(String sql, String startFlag)
static String	extractSubqueryPartition(String sql, String startFlag, String endFlag)
static String	getSubqueryPaginationEndFlag(PagingRequest request)
static String	getSubqueryPaginationEndFlag(PagingRequest request, SQLStatementInstrumentor instrumentor)
static String	getSubqueryPaginationStartFlag(PagingRequest request)
static String	getSubqueryPaginationStartFlag(PagingRequest request, SQLStatementInstrumentor instrumentor)
static boolean	isSubqueryPagingRequest(PagingRequest request)
static boolean	isValidSubQueryPagination(PagingRequest request, SQLStatementInstrumentor instrumentor)
static <C,E> PagingRequest<C,E>	preparePagination(int pageNo, int pageSize)
static <C,E> PagingRequest<C,E>	preparePagination(int pageNo, int pageSize, String sort)
static <C,E> PagingRequest<C,E>	preparePagination(int pageNo, int pageSize, String sort, OrderByBuilder<String> orderByBuilder)
static <C,E> PagingRequest<C,E>	preparePagination(int pageNo, int pageSize, String sort, OrderByBuilder<String> orderByBuilder, boolean count)
static <C,E> PagingRequest<C,E>	preparePagination(int pageNo, int pageSize, String sort, OrderByBuilder<String> orderByBuilder, String dialect)
static <C,E> PagingRequest<C,E>	preparePagination(int pageNo, int pageSize, String sort, OrderByBuilder<String> orderByBuilder, String dialect, boolean count, String countColumn)

从类继承的方法 com.jn.sqlhelper.dialect.SqlRequests

prepareSelect, prepareSelect, prepareSelect, prepareSelect

从类继承的方法 com.jn.sqlhelper.common.utils.SQLs

findPlaceholderParameterCount, getTableFQN, getTableFQN, getTableFQN, getTableFQN, getTableFQN, isCreateStatement, isDeleteStatement, isDropTableStatement, isInsertStatement, isQuote, isSelectCountStatement, isSelectStatement, isSupportsBatchUpdates, isUpdateStatement

从类继承的方法 java.lang.Object

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

构造器详细资料

SqlPaginations

public SqlPaginations()

方法详细资料

extractBeforeSubqueryPartition

public static String extractBeforeSubqueryPartition(@NonNull
                                                    String sql,
                                                    @NonNull
                                                    String startFlag)

extractSubqueryPartition

public static String extractSubqueryPartition(@NonNull
                                              String sql,
                                              @NonNull
                                              String startFlag,
                                              @NonNull
                                              String endFlag)

extractAfterSubqueryPartition

public static String extractAfterSubqueryPartition(@NonNull
                                                   String sql,
                                                   @NonNull
                                                   String endFlag)

isSubqueryPagingRequest

public static boolean isSubqueryPagingRequest(@Nullable
                                              PagingRequest request)

isValidSubQueryPagination

public static boolean isValidSubQueryPagination(@Nullable
                                                PagingRequest request,
                                                @NonNull
                                                SQLStatementInstrumentor instrumentor)

getSubqueryPaginationStartFlag

public static String getSubqueryPaginationStartFlag(@Nullable
                                                    PagingRequest request)

getSubqueryPaginationStartFlag

public static String getSubqueryPaginationStartFlag(@Nullable
                                                    PagingRequest request,
                                                    @NonNull
                                                    SQLStatementInstrumentor instrumentor)

getSubqueryPaginationEndFlag

public static String getSubqueryPaginationEndFlag(@Nullable
                                                  PagingRequest request)

getSubqueryPaginationEndFlag

public static String getSubqueryPaginationEndFlag(@Nullable
                                                  PagingRequest request,
                                                  @NonNull
                                                  SQLStatementInstrumentor instrumentor)

preparePagination

public static <C,E> PagingRequest<C,E> preparePagination(int pageNo,
                                                         int pageSize)

preparePagination

public static <C,E> PagingRequest<C,E> preparePagination(int pageNo,
                                                         int pageSize,
                                                         String sort)

preparePagination

public static <C,E> PagingRequest<C,E> preparePagination(int pageNo,
                                                         int pageSize,
                                                         String sort,
                                                         OrderByBuilder<String> orderByBuilder)

preparePagination

public static <C,E> PagingRequest<C,E> preparePagination(int pageNo,
                                                         int pageSize,
                                                         String sort,
                                                         OrderByBuilder<String> orderByBuilder,
                                                         String dialect)

preparePagination

public static <C,E> PagingRequest<C,E> preparePagination(int pageNo,
                                                         int pageSize,
                                                         String sort,
                                                         OrderByBuilder<String> orderByBuilder,
                                                         boolean count)

preparePagination

public static <C,E> PagingRequest<C,E> preparePagination(int pageNo,
                                                         int pageSize,
                                                         String sort,
                                                         OrderByBuilder<String> orderByBuilder,
                                                         String dialect,
                                                         boolean count,
                                                         String countColumn)