| 类 | 说明 |
|---|---|
| AbstractLimitHandler | |
| DefaultLimitHandler | |
| FirstLimitHandler | |
| FirstOrderLimitHandler | |
| LegacyFirstLimitHandler | |
| LimitCommaLimitHandler |
select * from TABLE where xxx
limit $offset, $limit
[for update]
every dialect use the limitHandler should set bindLimitParameterInReverseOrder = false
|
| LimitHandler | |
| LimitHelper | |
| LimitOffsetLimitHandler |
select * from
where xxxx
limit $limit offset $Offset
every dialect use the limitHandler should set bindLimitParameterInReverseOrder = true
|
| LimitOnlyLimitHandler |
select *
from table
where xxx
limit ?
|
| NoopLimitHandler | |
| OffsetFetchFirstOnlyLimitHandler |
select *
from xx
where ...
|
| OracleXLimitHandler | |
| ReturnResultsLimitHandler |
select * from table return results $limit
select * from table return results $offset TO $limit
every dialect use the limitHandler should set bindLimitParameterInReverseOrder = false
|
| SkipLimitHandler | |
| SQLServer2005LimitHandler | |
| TopLimitHandler |
Copyright © 2020. All rights reserved.