| 程序包 | 说明 |
|---|---|
| com.jn.sqlhelper.dialect | |
| com.jn.sqlhelper.dialect.internal | |
| com.jn.sqlhelper.dialect.internal.urlparser |
| 限定符和类型 | 接口和说明 |
|---|---|
interface |
Dialect |
| 限定符和类型 | 类和说明 |
|---|---|
class |
AbstractDialect<T extends 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 |
class |
ClickHouseDialect
https://clickhouse.yandex/docs/en/query_language/select/
|
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)
|
class |
CovenantSQLDialect |
class |
CrateDialect |
class |
CTreeDialect
https://docs.faircom.com/doc/sqlref/select.htm
|
class |
CubridDialect |
class |
DB2Dialect |
class |
DbfDialect |
class |
DerbyDialect |
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 |
class |
GaussDbDialect |
class |
GBaseDialect
MySQL Syntax Compatible
|
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 |
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 |
class |
SQLServerDialect |
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 |
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 |
| 限定符和类型 | 方法和说明 |
|---|---|
protected UrlParser |
AbstractDialect.getUrlParser() |
| 限定符和类型 | 方法和说明 |
|---|---|
protected void |
ComDB2Dialect.setUrlParser(UrlParser urlParser) |
protected void |
AbstractDialect.setUrlParser(UrlParser urlParser) |
| 限定符和类型 | 类和说明 |
|---|---|
class |
CommonUrlParser |
class |
CubridUrlParser |
class |
DmUrlParser |
class |
InformixUrlParser |
class |
JtdsUrlParser |
class |
KingbaseUrlParser |
class |
MariaDBUrlParser |
class |
MySqlUrlParser |
class |
NoopUrlParser |
class |
OracleUrlParser |
class |
OscarUrlParser |
class |
PostgreSQLUrlParser |
class |
SqlServerUrlParser |
Copyright © 2019. All rights reserved.