com.jn.sqlhelper.dialect.internal

类 NuodbDialect

java.lang.Object

com.jn.sqlhelper.dialect.internal.AbstractDialect

com.jn.sqlhelper.dialect.internal.NuodbDialect

所有已实现的接口:

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

public class NuodbDialect
extends AbstractDialect

http://doc.nuodb.com/Latest/Default.htm#SELECT.htm

     SELECT  [ optimizer_hint ]
 [ ALL | DISTINCT ]
 { select_item [ [AS] output_name ] } [, ...]
 FROM from_item
 [ WHERE condition ]
 [ GROUP BY expression [, ...] [ HAVING condition [, ...] ] ]
 [ UNION [ ALL | DISTINCT ] select ]
 [ ORDER BY { order_list [ COLLATE collation_name ] [ ASC | DESC] } [, ...] ]
 [ LIMIT { count [ OFFSET start ] | start [ , count ] }
 [ OFFSET start [ ROW | ROWS ] [ FETCH {FIRST | NEXT}
 count [ROW | ROWS] [ONLY] ] ]
 [ FETCH {FIRST | NEXT } count [ROW | ROWS] [ONLY] ]
 [ FOR UPDATE [NOWAIT] ]
 

supports: 1) LIMIT count 2) LIMIT start, count 3) LIMIT count OFFSET START

we use LIMIT start, count

构造器概要

构造器

构造器和说明
NuodbDialect()

方法概要

限定符和类型	方法和说明
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

构造器详细资料

NuodbDialect

public NuodbDialect()

方法详细资料

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

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.