com.jn.sqlhelper.dialect.internal

类 PostgreSQLDialect

java.lang.Object

com.jn.sqlhelper.dialect.internal.AbstractDialect

com.jn.sqlhelper.dialect.internal.PostgreSQLDialect

所有已实现的接口:

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

public class PostgreSQLDialect
extends AbstractDialect

https://www.postgresql.org/docs/current/queries-limit.html

构造器概要

构造器

构造器和说明
PostgreSQLDialect()

方法概要

限定符和类型	方法和说明
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?
int	registerResultSetOutParameter(CallableStatement statement, int col)

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

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

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

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

构造器详细资料

PostgreSQLDialect

public PostgreSQLDialect()

方法详细资料

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

registerResultSetOutParameter

public int registerResultSetOutParameter(CallableStatement statement,
                                         int col)
                                  throws SQLException

指定者:

registerResultSetOutParameter 在接口中 Dialect

覆盖:

registerResultSetOutParameter 在类中 AbstractDialect

抛出:

SQLException