com.jn.sqlhelper.dialect

类 SqlRequests

java.lang.Object

com.jn.sqlhelper.common.utils.SQLs

com.jn.sqlhelper.dialect.SqlRequests

直接已知子类:

SqlPaginations

public class SqlRequests
extends SQLs

字段概要

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

SQL_FILE_SUFFIX, WHITESPACE

构造器概要

构造器

构造器和说明
SqlRequests()

方法概要

限定符和类型	方法和说明
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)
static SelectRequest	prepareSelect(boolean escapeLikeParameter)
static SelectRequest	prepareSelect(Boolean escapeLikeParameter, LikeEscaper likeEscaper)
static SelectRequest	prepareSelect(Boolean escapeLikeParameter, LikeEscaper likeEscaper, String sort, OrderByBuilder<String> orderByBuilder)
static SelectRequest	prepareSelect(Boolean escapeLikeParameter, LikeEscaper likeEscaper, String sort, OrderByBuilder<String> orderByBuilder, Integer timeout, Integer fetchSize, int maxRows)

从类继承的方法 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

构造器详细资料

SqlRequests

public SqlRequests()

方法详细资料

prepareSelect

public static SelectRequest prepareSelect(@Nullable
                                          boolean escapeLikeParameter)

prepareSelect

public static SelectRequest prepareSelect(@Nullable
                                          Boolean escapeLikeParameter,
                                          @Nullable
                                          LikeEscaper likeEscaper)

prepareSelect

public static SelectRequest prepareSelect(@Nullable
                                          Boolean escapeLikeParameter,
                                          @Nullable
                                          LikeEscaper likeEscaper,
                                          @Nullable
                                          String sort,
                                          @Nullable
                                          OrderByBuilder<String> orderByBuilder)

prepareSelect

public static SelectRequest prepareSelect(@Nullable
                                          Boolean escapeLikeParameter,
                                          @Nullable
                                          LikeEscaper likeEscaper,
                                          @Nullable
                                          String sort,
                                          @Nullable
                                          OrderByBuilder<String> orderByBuilder,
                                          @Nullable
                                          Integer timeout,
                                          @Nullable
                                          Integer fetchSize,
                                          int maxRows)

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)