com.jn.sqlhelper.dialect.internal.limit

类 OffsetFetchFirstOnlyLimitHandler

java.lang.Object

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

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

com.jn.sqlhelper.dialect.internal.limit.OffsetFetchFirstOnlyLimitHandler

public class OffsetFetchFirstOnlyLimitHandler
extends AbstractLimitHandler

select * from xx where ... group by ... order by ... offset ? rows fetch next ? rows only

every dialect use the limitHandler should set bindLimitParameterInReverseOrder = false

构造器概要

构造器

构造器和说明
OffsetFetchFirstOnlyLimitHandler()

方法概要

限定符和类型	方法和说明
protected String	getLimitString(String sql, long offset, int limit)
boolean	isSupportForUpdate()
boolean	isSupportUsingIndexClauseInSelectEnd()
boolean	isSupportWithInSelectEnd()
String	processSql(String sql, RowSelection rowSelection)
OffsetFetchFirstOnlyLimitHandler	setSupportForUpdate(boolean supportForUpdate)
OffsetFetchFirstOnlyLimitHandler	setSupportUsingIndexClauseInSelectEnd(boolean supportUsingIndexClauseInSelectEnd)
OffsetFetchFirstOnlyLimitHandler	setSupportWithInSelectEnd(boolean supportWithInSelectEnd)

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

构造器详细资料

OffsetFetchFirstOnlyLimitHandler

public OffsetFetchFirstOnlyLimitHandler()

方法详细资料

processSql

public String processSql(String sql,
                         RowSelection rowSelection)

指定者:

processSql 在类中 LimitHandler

getLimitString

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

覆盖:

getLimitString 在类中 LimitHandler

isSupportUsingIndexClauseInSelectEnd

public boolean isSupportUsingIndexClauseInSelectEnd()

setSupportUsingIndexClauseInSelectEnd

public OffsetFetchFirstOnlyLimitHandler setSupportUsingIndexClauseInSelectEnd(boolean supportUsingIndexClauseInSelectEnd)

isSupportForUpdate

public boolean isSupportForUpdate()

setSupportForUpdate

public OffsetFetchFirstOnlyLimitHandler setSupportForUpdate(boolean supportForUpdate)

isSupportWithInSelectEnd

public boolean isSupportWithInSelectEnd()

setSupportWithInSelectEnd

public OffsetFetchFirstOnlyLimitHandler setSupportWithInSelectEnd(boolean supportWithInSelectEnd)