com.jn.sqlhelper.dialect.internal

类 OpenEdgeDialect

java.lang.Object

com.jn.sqlhelper.dialect.internal.AbstractDialect

com.jn.sqlhelper.dialect.internal.OpenEdgeDialect

所有已实现的接口:

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

public class OpenEdgeDialect
extends AbstractDialect

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} * ]...
 | expr [[ AS ][ ' ] column_title [ ' ]]
 [,  expr [[ AS ][ ' ] column_title [' ]]]...
 }
 FROM table_ref [, table_ref]...[{ NO REORDER }] [ WITH (NOLOCK )]
 [ WHERE search_condition]
 [ GROUP BY [ table ]column_name
 [,[table]column_name ]...
 [HAVING search_condition];

 [ORDER BY ordering_condition]
 [OFFSET offset_value {ROW | ROWS }
 [FETCH {FIRST | NEXT}fetch_value {ROW | ROWS} ONLY ]]
 [WITH locking_hints]
 [FOR UPDATE update_condition];
 

作者:

f1194361820

构造器概要

构造器

构造器和说明
OpenEdgeDialect()

方法概要

限定符和类型	方法和说明
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, getQuotedIdentifier, getRealDialect, getUrlParser, isBindLimitParametersFirst, isBindLimitParametersInReverseOrder, isForceLimitUsage, isSupportsBatchSql, isSupportsBatchUpdates, isSupportsDistinct, isSupportsVariableLimit, isUseLimitInVariableMode, isUseMaxForLimit, registerResultSetOutParameter, setDelegate, setLikeEscaper, setLimitHandler, setMaxRows, setUrlParser, setUseLimitInVariableMode, toString

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

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

构造器详细资料

OpenEdgeDialect

public OpenEdgeDialect()

方法详细资料

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