com.jn.sqlhelper.dialect.pagination

类 SqlPaginations

java.lang.Object

com.jn.sqlhelper.dialect.pagination.SqlPaginations

public class SqlPaginations
extends Object

构造器概要

构造器

构造器和说明
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 int	findPlaceholderParameterCount(String sqlsegment)
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)

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

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

构造器详细资料

SqlPaginations

public SqlPaginations()

方法详细资料

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)

findPlaceholderParameterCount

public static int findPlaceholderParameterCount(String sqlsegment)

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)