| 程序包 | 说明 |
|---|---|
| com.jn.sqlhelper.dialect.internal | |
| com.jn.sqlhelper.dialect.internal.limit |
| 限定符和类型 | 方法和说明 |
|---|---|
LimitHandler |
AbstractDialect.getLimitHandler() |
| 限定符和类型 | 方法和说明 |
|---|---|
protected void |
AbstractDialect.setLimitHandler(LimitHandler limitHandler) |
| 限定符和类型 | 类和说明 |
|---|---|
class |
AbstractLimitHandler |
class |
DefaultLimitHandler |
class |
FirstLimitHandler |
class |
FirstOrderLimitHandler |
class |
LegacyFirstLimitHandler |
class |
LimitCommaLimitHandler
select * from TABLE where xxx
limit $offset, $limit
[for update]
every dialect use the limitHandler should set bindLimitParameterInReverseOrder = false
|
class |
LimitOffsetLimitHandler
select * from
where xxxx
limit $limit offset $Offset
every dialect use the limitHandler should set bindLimitParameterInReverseOrder = true
|
class |
LimitOnlyLimitHandler
select *
from table
where xxx
limit ?
|
class |
NoopLimitHandler |
class |
OffsetFetchFirstOnlyLimitHandler
select *
from xx
where ...
|
class |
OracleXLimitHandler |
class |
ReturnResultsLimitHandler
select * from table return results $limit
select * from table return results $offset TO $limit
every dialect use the limitHandler should set bindLimitParameterInReverseOrder = false
|
class |
SkipLimitHandler |
class |
SQLServer2005LimitHandler |
class |
TopLimitHandler |
Copyright © 2020. All rights reserved.