com.jn.sqlhelper.dialect.internal

类 BesMagicDataDialect

java.lang.Object

com.jn.sqlhelper.dialect.internal.AbstractDialect

com.jn.sqlhelper.dialect.internal.BesMagicDataDialect

所有已实现的接口:

com.jn.langx.util.escape.Escaper, Dialect, LikeEscaper

public class BesMagicDataDialect
extends AbstractDialect

基于OpenGauss改造

     select 语法：

     [ WITH [ RECURSIVE ] with_query [, ...] ]
 SELECT [/*+ plan_hint *\/][ALL|DISTINCT[ON(expression[,...])]]
{*|{expression[[AS]output_name]}[,...]}
[FROM from_item[,...]]
[WHERE condition]
[GROUP BY grouping_element[,...]]
[HAVING condition[,...]]
[WINDOW{window_name AS(window_definition)}[,...]]
[{UNION|INTERSECT|EXCEPT|MINUS}[ALL|DISTINCT]select]
[ORDER BY{expression[[ASC|DESC|USING operator]|nlssort_expression_clause][NULLS{FIRST|LAST}]}[,...]]
[LIMIT{[offset,]count|ALL}]
[OFFSET start[ROW|ROWS]]
[FETCH{FIRST|NEXT}[count]{ROW|ROWS}ONLY]
[{FOR{UPDATE|SHARE}[OF table_name[,...]][NOWAIT]}[...]];
 

构造器概要

构造器

构造器和说明
BesMagicDataDialect()

方法概要

限定符和类型	方法和说明
boolean	isBindLimitParametersInReverseOrder() Whether bind parameter in reverse or not.
boolean	isSupportsLimit() Does this dialect support some form of limiting query results via a sql clause?
boolean	isSupportsLimitOffset() Does this dialect's LIMIT support (if any) additionally support specifying an offset?

从类继承的方法 com.jn.sqlhelper.dialect.internal.AbstractDialect

appendmentAfterLikeClause, bindLimitParametersAtEndOfQuery, bindLimitParametersAtStartOfQuery, createTableGenerator, escape, generateTableDDL, getAfterQuote, getBeforeQuote, getDatabaseId, getDefaultProperties, getLikeKeyChars, getLimitHandler, getLimitSql, getPlainSqlScriptParser, getQuotedIdentifier, getRealDialect, getUrlParser, isBindLimitParametersFirst, isForceLimitUsage, isSupportsBatchSql, isSupportsBatchUpdates, isSupportsDistinct, isSupportsVariableLimit, isUseLimitInVariableMode, isUseMaxForLimit, registerResultSetOutParameter, setDelegate, setLikeEscaper, setLimitHandler, setMaxRows, setPlainSqlScriptParser, setUrlParser, setUseLimitInVariableMode, toString

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

构造器详细资料

BesMagicDataDialect

public BesMagicDataDialect()

方法详细资料

isSupportsLimit

public boolean isSupportsLimit()

从接口复制的说明: Dialect

Does this dialect support some form of limiting query results via a sql clause?

指定者:

isSupportsLimit 在接口中 Dialect

覆盖:

isSupportsLimit 在类中 AbstractDialect

返回:

True if this dialect supports some form of LIMIT.

isSupportsLimitOffset

public boolean isSupportsLimitOffset()

从接口复制的说明: Dialect

Does this dialect's LIMIT support (if any) additionally support specifying an offset?

指定者:

isSupportsLimitOffset 在接口中 Dialect

覆盖:

isSupportsLimitOffset 在类中 AbstractDialect

返回:

True if the dialect supports an offset within the limit support

isBindLimitParametersInReverseOrder

public boolean isBindLimitParametersInReverseOrder()

从接口复制的说明: Dialect

Whether bind parameter in reverse or not.

Here assume the normal order is: $offset, $limit so the reverse order is: $limit, $offset

Based on the assume, case 1: limit $offset, $limit ==> reverse = false case 2: limit $limit offset $offset ==> reverse = true

指定者:

isBindLimitParametersInReverseOrder 在接口中 Dialect

覆盖:

isBindLimitParametersInReverseOrder 在类中 AbstractDialect