com.jn.sqlhelper.dialect.internal.limit

类 LimitOffsetLimitHandler

java.lang.Object

com.jn.sqlhelper.dialect.internal.limit.LimitHandler

com.jn.sqlhelper.dialect.internal.limit.AbstractLimitHandler

com.jn.sqlhelper.dialect.internal.limit.LimitOffsetLimitHandler

public class LimitOffsetLimitHandler
extends AbstractLimitHandler

select * from where xxxx limit $limit offset $Offset

every dialect use the limitHandler should set bindLimitParameterInReverseOrder = true

构造器概要

构造器

构造器和说明
LimitOffsetLimitHandler()

方法概要

限定符和类型	方法和说明
protected String	getLimitString(String sql, long offset, int limit)
boolean	isHasOffsetRowsSuffix()
boolean	isSupportForUpdate()
boolean	isSupportLockInModeClause()
String	processSql(String sql, RowSelection rowSelection)
LimitOffsetLimitHandler	setHasOffsetRowsSuffix(boolean hasOffsetRowsSuffix)
LimitOffsetLimitHandler	setSupportForUpdate(boolean supportForUpdate)
LimitOffsetLimitHandler	setSupportLockInModeClause(boolean supportLockInModeClause)

从类继承的方法 com.jn.sqlhelper.dialect.internal.limit.AbstractLimitHandler

bindLimitParametersAtEndOfQuery, bindLimitParametersAtStartOfQuery, convertToFirstRowValue, getMaxOrLimit, setMaxRows

从类继承的方法 com.jn.sqlhelper.dialect.internal.limit.LimitHandler

getDialect, getLimitString, setDialect

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

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

构造器详细资料

LimitOffsetLimitHandler

public LimitOffsetLimitHandler()

方法详细资料

processSql

public String processSql(String sql,
                         RowSelection rowSelection)

指定者:

processSql 在类中 LimitHandler

getLimitString

protected String getLimitString(String sql,
                                long offset,
                                int limit)

覆盖:

getLimitString 在类中 LimitHandler

isHasOffsetRowsSuffix

public boolean isHasOffsetRowsSuffix()

setHasOffsetRowsSuffix

public LimitOffsetLimitHandler setHasOffsetRowsSuffix(boolean hasOffsetRowsSuffix)

isSupportForUpdate

public boolean isSupportForUpdate()

setSupportForUpdate

public LimitOffsetLimitHandler setSupportForUpdate(boolean supportForUpdate)

isSupportLockInModeClause

public boolean isSupportLockInModeClause()

setSupportLockInModeClause

public LimitOffsetLimitHandler setSupportLockInModeClause(boolean supportLockInModeClause)