类的使用
com.jn.sqlhelper.dialect.internal.AbstractDialect

使用AbstractDialect的程序包

程序包	说明
com.jn.sqlhelper.dialect.internal
com.jn.sqlhelper.dialect.internal.limit

com.jn.sqlhelper.dialect.internal中AbstractDialect的使用

类型参数类型为AbstractDialect的com.jn.sqlhelper.dialect.internal中的类

限定符和类型	类和说明
class	AbstractDialect<T extends AbstractDialect>

com.jn.sqlhelper.dialect.internal中AbstractDialect的子类

限定符和类型	类和说明
class	AbstractTransactSQLDialect
class	AccessDialect
class	ActorDBDialect http://www.actordb.com/docs-howitworks.html#dbengine depend on SQLite
class	AgensGraphDialect https://bitnine.net/documentations/manual/agens_graph_developer_manual_en.html#sql-language
class	AltibaseDialect http://altibase.com/resources/manuals/
class	AntDBDialect
class	AuroraDialect Amazon Aurora
class	AzureDialect Microsoft Azure Cloud Database
class	BigObjectDialect http://docs.bigobject.io/Basic_Data_Management/SELECT/index.html * supports 2 styles limit syntax: 1) limit $limit offset $offset 2) limit $offset, $limit We use 1)
class	BrytlytDialect https://www.brytlyt.com/documentation/data-manipulation-dml/select/ supports 2 styles limit syntax: 1) limit $limit offset $offset 2) offset $offset ROWS fetch FIRST|NEXT $limit ROWS ONLY
class	CacheDialect
class	CirroDBDialect select * from table where xxx order by xxx limit (start, end) start based on 1
class	CitusDialect https://docs.citusdata.com/en/v9.1/develop/reference_sql.html
class	ClickHouseDialect https://clickhouse.yandex/docs/en/query_language/select/ https://clickhouse.yandex/docs/en/query_language/functions/string_search_functions/
class	ClustrixDialect http://docs.clustrix.com/display/CLXDOC/MySQL+Compatibility
class	CobolDialect
class	CockroachDialect https://www.cockroachlabs.com/docs/stable/limit-offset.html
class	ComDB2Dialect https://bloomberg.github.io/comdb2/sql.html#select-statement supports 2 styles limit syntax: 1) limit $limit offset $offset 2) limit $offset, $limit We use 1) https://bloomberg.github.io/comdb2/sql.html
class	CovenantSQLDialect
class	CrateDialect https://crate.io/docs/sql-99/en/latest/chapters/29.html#retrieval-with-like
class	CTreeDialect https://docs.faircom.com/doc/sqlref/select.htm
class	CubridDialect https://www.cubrid.org/manual/en/10.2/sql/query/select.html https://www.cubrid.org/manual/en/10.2/sql/function/condition_op.html#like
class	DB2Dialect https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.5.0/com.ibm.db2.luw.sql.ref.doc/doc/r0061832.html https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.5.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000751.html
class	DbfDialect
class	DerbyDialect http://db.apache.org/derby/docs/10.14/ref/index.html
class	DmDialect
class	DorisDialect
class	DrillDialect http://drill.apache.org/docs/select/
class	ElasticsearchDialect
class	EsgynDBDialect
class	FileMakerDialect // https://fmhelp.filemaker.com/docs/16/en/fm16_sql_reference.pdf
class	FirebirdDialect http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-dml-select.html#fblangref25-dml-select-first-skip http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-commons-predicates.html
class	GaussDbDialect
class	GBase8sDialect https://www.it610.com/article/1281786034576703488.htm
class	GBaseDialect http://www.gbase.cn/download/&pageNo=4&pageSize=10.html MySQL Syntax Compatible 适应于 GBase 8a
class	GoldenDBDialect
class	GreenplumDialect
class	H2Dialect
class	HANADialect
class	HawqDialect http://hawq.apache.org/docs/userguide/2.3.0.0-incubating/reference/sql/SELECT.html SELECT [ALL | DISTINCT [ON ( [,
class	HerdDBDialect
class	HhDbDialect based on PostgreSQL
class	HighGoDialect http://www.highgo.com/content.php?
class	HiveDialect
class	HSQLDialect HyperSQL http://hsqldb.org/doc/2.0/guide/dataaccess-chapt.html#dac_sql_select_statement
class	IgniteDialect
class	ImpalaDialect
class	InformixDialect https://www.ibm.com/support/knowledgecenter/en/SSGU8G_11.50.0/com.ibm.sqls.doc/ids_sqs_0987.htm
class	IngresDialect
class	InterbaseDialect
class	IrisDialect https://irisdocs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?
class	JDataStoreDialect
class	KarelDBDialect
class	KDBDialect
class	KineticaDialect https://www.kinetica.com/docs/concepts/sql.html#query
class	KingbaseDialect
class	KognitioDialect https://kognitio.com/documentation/latest/sqlref/select.html
class	LeanXcaleDialect LeanXcale Query Engine was forked from Apache Derby, so the Lx-DB SQL dialect is very similar to Apache Derby https://s3-eu-west-1.amazonaws.com/doc-html/doc/latest/develop/index.html#_schemas_and_metadata
class	LinterDialect https://linter.ru/ru/documentations/6.0.17.86/manual/spravochnik-po-sql-ogranichenie-vyborki/ limit offset, limit
class	MariaDBDialect
class	MaxComputeDialect https://www.alibabacloud.com/help/doc-detail/73777.htm?
class	MaxDBDialect
class	MckoiDialect
class	MemSQLDialect
class	MimerSQLDialect https://download.mimer.com/pub/developer/docs/html_101/Mimer_SQL_Engine_DocSet/index.htm
class	MonetDialect
class	MSQLDialect https://hughes.com.au/products/msql/msql-4.0-manual.pdf
class	MySQLDialect
class	Neo4jDialect
class	NetezzaDialect
class	NexusDBDialect https://www.nexusdb.com/support/index.php?
class	NuodbDialect http://doc.nuodb.com/Latest/Default.htm#SELECT.htm SELECT [ optimizer_hint ] [ ALL | DISTINCT ] { select_item [ [AS] output_name ] } [, ...]
class	OBaseDialect SELECT [ ALL | DISTINCT ] select_list [AS other_name] FROM table_name [WHERE where_conditions ] [GROUP BY group_by_list ] [HAVING search_confitions ] [ORDER BY order_list [ASC | DESC ] ] [LIMIT {[offset,] row_count | row_count OFFSET offset}];
class	OmnisciDialect https://www.omnisci.com/docs/latest/5_dml.html#select
class	OpenbaseDialect http://openbase.wikidot.com/openbase-sql:select-statements
class	OpenEdgeDialect reference: https://documentation.progress.com/output/ua/OpenEdge_latest/#page/dmsrf%2Fselect.html%23wwID0E4QHQ Select Syntax: SELECT [ ALL | DISTINCT ] [TOP n] { * |{table_name|alias} * [ , {table_name| alias} * ]
class	OracleDialect
class	OrientDBDialect
class	OscarDialect
class	ParadoxDialect
class	PerconaMysqlDialect
class	PhoenixDialect
class	PointbaseDialect
class	PostgreSQLDialect https://www.postgresql.org/docs/current/queries-limit.html
class	PrestoDialect reference: https://prestodb.github.io/docs/current/sql/select.html
class	RadonDBDialect https://docs.qingcloud.com/product/database_cache/radondb/supported_sql.html#1-select-%E8%AF%AD%E5%8F%A5
class	RaimaDialect
class	RBaseDialect
class	RDMSOS2200Dialect
class	RedshiftDialect Amazon Redshift, based on PostgreSQL
class	SadasDialect https://www.sadasengine.com/SQL_Reference/index.html
class	SequoiaDBDialect http://doc.sequoiadb.com/cn/sequoiadb-cat_id-1432190960-edition_id-0 support mysql sql syntax support PostgreSQL sql syntax
class	SinoDBDialect
class	SmallDialect http://www.smallsql.de/doc/sqlsyntax.html#SELECT
class	SnappyDataDialect
class	SnowflakeDialect https://docs.snowflake.net/manuals/sql-reference/constructs/limit.html support two limit syntax: SELECT ...
class	SpliceMachineDialect https://doc.splicemachine.com/sqlref_clauses_resultoffset.html
class	SQLiteDialect https://www.sqlite.org/lang_select.html
class	SQLServerDialect SQLServer 版本说明 version | Year | Release Name 1.0 1989 SQL Server 1.0 (16-bit) 1.1 1991 SQL Server 1.1 (16-bit) 4.2A 1992 SQL Server 4.2A (16-bit) 4.2B 1993 SQL Server 4.2B (16-bit) 4.21a 1993 SQL Server 4.21a 6.0 1995 SQL Server 6.0 6.5 1996 SQL Server 6.5 7.0 1998 SQL Server 7.0 8.0 2000 SQL Server 2000 8.0 2003 SQL Server 2000 64-bit 9.0 2005 SQL Server 2005 10.0 2008 SQL Server 2008 10.25 2010 Azure SQL database 10.50 2010 SQL Server 2008 R2 11.0 2012 SQL Server 2012 12.0 2014 SQL Server 2014 13.0 2016 SQL Server 2016 14.0 2017 SQL Server 2017
static class	SQLServerDialect.SQLServer2000Dialect
static class	SQLServerDialect.SQLServer2005Dialect
static class	SQLServerDialect.SQLServer2008Dialect
static class	SQLServerDialect.SQLServer2012Dialect
static class	SQLServerDialect.SQLServer2014Dialect
static class	SQLServerDialect.SQLServer2016Dialect
static class	SQLServerDialect.SQLServer2017Dialect
class	SQReamDialect http://docs.sqream.com/latest/manual/Content/SQL_Reference_Guide/19_2.4_Queries.htm?
class	SybaseDialect
class	TajoDialect
class	TeradataDialect
class	TiDBDialect https://pingcap.com/docs/dev/reference/sql/statements/select/ https://www.pingcap.com/docs-cn/sql/dml/ supports two style： 1) limit $offset, $limit 2) limit $limit offset $offset we use 2)
class	TimesTenDialect
class	TrafodionDialect http://trafodion.apache.org/docs/sql_reference/index.html#select_syntax
class	TransbaseDialect https://www.transaction.de/fileadmin/downloads/Transbase/sql.xhtml#sql_select_expression select * from $table where $condition group by $group having $having FIRST $offset TO $endNum Order by $order by
class	UxDBDialect https://www.postgresql.org/docs/current/queries-limit.html
class	ValentinaDialect http://valentina-db.com/docs/dokuwiki/v5/doku.php?
class	VerticaDialect
class	VirtuosoDialect
class	VistaDBDialect
class	VoltDBDialect https://docs.voltdb.com/UsingVoltDB/sqlref_select.php
class	XmlDialect
class	XtremeSQLDialect https://www.mcobject.com/docs/eXtremeDB.htm#Users_Guides/SQL/SQL_Features/Limit.htm?
class	YaacomoDialect
class	YugabyteDBDialect

返回AbstractDialect的com.jn.sqlhelper.dialect.internal中的方法

限定符和类型	方法和说明
protected AbstractDialect	AbstractDialect.getRealDialect()

com.jn.sqlhelper.dialect.internal.limit中AbstractDialect的使用

参数类型为AbstractDialect的com.jn.sqlhelper.dialect.internal.limit中的构造器

构造器和说明
DefaultLimitHandler(AbstractDialect dialect)