com.jn.sqlhelper.dialect.internal

类 SQLiteDialect

java.lang.Object

com.jn.sqlhelper.dialect.internal.AbstractDialect

com.jn.sqlhelper.dialect.internal.SQLiteDialect

所有已实现的接口:

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

public class SQLiteDialect
extends AbstractDialect

https://www.sqlite.org/lang_select.html

构造器概要

构造器

构造器和说明
SQLiteDialect()

方法概要

限定符和类型	方法和说明
char	getAfterQuote() Get quote for symbol (e.g. table name, field name)
char	getBeforeQuote() Get quote for symbol (e.g. table name, field name)
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, getDatabaseId, getDefaultProperties, getLikeKeyChars, getLimitHandler, getLimitSql, getQuotedIdentifier, getRealDialect, getUrlParser, isBindLimitParametersFirst, 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

构造器详细资料

SQLiteDialect

public SQLiteDialect()

方法详细资料

getBeforeQuote

public char getBeforeQuote()

从接口复制的说明: Dialect

Get quote for symbol (e.g. table name, field name)

指定者:

getBeforeQuote 在接口中 Dialect

覆盖:

getBeforeQuote 在类中 AbstractDialect

返回:

the quote

getAfterQuote

public char getAfterQuote()

从接口复制的说明: Dialect

Get quote for symbol (e.g. table name, field name)

指定者:

getAfterQuote 在接口中 Dialect

覆盖:

getAfterQuote 在类中 AbstractDialect

返回:

the quote

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