com.mybatisflex.core.dialect

Interface LimitOffsetProcessor

public interface LimitOffsetProcessor

limit 和 offset 参数的处理器

Field Summary

Fields

Modifier and Type	Field and Description
static LimitOffsetProcessor	DERBY derby 的处理器 适合 DbType#DERBY,DbType#ORACLE_12C,DbType#SQLSERVER ,DbType#POSTGRE_SQL
static LimitOffsetProcessor	FIREBIRD Firebird 的处理器 适合 DbType.FIREBIRD
static LimitOffsetProcessor	INFORMIX Informix 的处理器 适合 DbType.INFORMIX 文档 https://www.ibm.com/docs/en/informix-servers/14.10?topic=clause-restricting-return-values-skip-limit-first-options
static LimitOffsetProcessor	MYSQL MySql 的处理器 适合 DbType#MYSQL,DbType#MARIADB,DbType#H2,DbType#CLICK_HOUSE,DbType#XCloud
static LimitOffsetProcessor	ORACLE Oracle11g及以下数据库的处理器 适合 DbType#ORACLE,DbType#DM,DbType#GAUSS
static LimitOffsetProcessor	POSTGRESQL Postgresql 的处理器 适合 DbType#POSTGRE_SQL,DbType#SQLITE,DbType#H2,DbType#HSQL,DbType#KINGBASE_ES,DbType#PHOENIX 适合 DbType#SAP_HANA,DbType#IMPALA,DbType#HIGH_GO,DbType#VERTICA,DbType#REDSHIFT 适合 DbType#OPENGAUSS,DbType#TDENGINE,DbType#UXDB,DbType#DUCKDB
static LimitOffsetProcessor	SINODB SINODB 的处理器 适合 DbType.SINODB
static LimitOffsetProcessor	SQLSERVER derby 的处理器 适合 DbType#DERBY,DbType#ORACLE_12C,DbType#SQLSERVER ,DbType#POSTGRE_SQL
static LimitOffsetProcessor	SQLSERVER_2005 SqlServer 2005 limit 处理器
static LimitOffsetProcessor	SYBASE Sybase 处理器 适合 DbType.SYBASE

Method Summary

Modifier and Type	Method and Description
StringBuilder	process(IDialect dialect, StringBuilder sql, QueryWrapper queryWrapper, Long limitRows, Long limitOffset) 处理构建 limit 和 offset

Field Detail

MYSQL

static final LimitOffsetProcessor MYSQL

MySql 的处理器 适合 DbType#MYSQL,DbType#MARIADB,DbType#H2,DbType#CLICK_HOUSE,DbType#XCloud

POSTGRESQL

static final LimitOffsetProcessor POSTGRESQL

Postgresql 的处理器 适合 DbType#POSTGRE_SQL,DbType#SQLITE,DbType#H2,DbType#HSQL,DbType#KINGBASE_ES,DbType#PHOENIX 适合 DbType#SAP_HANA,DbType#IMPALA,DbType#HIGH_GO,DbType#VERTICA,DbType#REDSHIFT 适合 DbType#OPENGAUSS,DbType#TDENGINE,DbType#UXDB,DbType#DUCKDB

DERBY

static final LimitOffsetProcessor DERBY

derby 的处理器 适合 DbType#DERBY,DbType#ORACLE_12C,DbType#SQLSERVER ,DbType#POSTGRE_SQL

SQLSERVER

static final LimitOffsetProcessor SQLSERVER

derby 的处理器 适合 DbType#DERBY,DbType#ORACLE_12C,DbType#SQLSERVER ,DbType#POSTGRE_SQL

SQLSERVER_2005

static final LimitOffsetProcessor SQLSERVER_2005

SqlServer 2005 limit 处理器

INFORMIX

static final LimitOffsetProcessor INFORMIX

Informix 的处理器 适合 DbType.INFORMIX 文档 https://www.ibm.com/docs/en/informix-servers/14.10?topic=clause-restricting-return-values-skip-limit-first-options

SINODB

static final LimitOffsetProcessor SINODB

SINODB 的处理器 适合 DbType.SINODB

FIREBIRD

static final LimitOffsetProcessor FIREBIRD

Firebird 的处理器 适合 DbType.FIREBIRD

ORACLE

static final LimitOffsetProcessor ORACLE

Oracle11g及以下数据库的处理器 适合 DbType#ORACLE,DbType#DM,DbType#GAUSS

SYBASE

static final LimitOffsetProcessor SYBASE

Sybase 处理器 适合 DbType.SYBASE

Method Detail

process

StringBuilder process(IDialect dialect,
                      StringBuilder sql,
                      QueryWrapper queryWrapper,
                      Long limitRows,
                      Long limitOffset)

处理构建 limit 和 offset

Parameters:

dialect - 数据方言

sql - 已经构建的 sql

queryWrapper - 参数内容

limitRows - 用户传入的 limit 参数 可能为 null

limitOffset - 用户传入的 offset 参数，可能为 null