AbstractDialect (sqlhelper-dialect 3.2.2 API)

java.lang.Object
- com.jn.sqlhelper.dialect.internal.AbstractDialect<T>

所有已实现的接口:

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

直接已知子类:

AbstractTransactSQLDialect, AccessDialect, ActorDBDialect, AgensGraphDialect, AltibaseDialect, AntDBDialect, AuroraDialect, AzureDialect, BigObjectDialect, BrytlytDialect, CacheDialect, CirroDBDialect, CitusDialect, ClickHouseDialect, CobolDialect, CockroachDialect, ComDB2Dialect, CovenantSQLDialect, CrateDialect, CTreeDialect, CubridDialect, DB2Dialect, DbfDialect, DerbyDialect, DmDialect, DorisDialect, DrillDialect, ElasticsearchDialect, EsgynDBDialect, FileMakerDialect, GaussDbDialect, GBase8sDialect, GBaseDialect, GoldenDBDialect, GreenplumDialect, H2Dialect, HANADialect, HawqDialect, HerdDBDialect, HhDbDialect, HighGoDialect, HiveDialect, HSQLDialect, IgniteDialect, ImpalaDialect, InformixDialect, IngresDialect, InterbaseDialect, IrisDialect, JDataStoreDialect, KarelDBDialect, KDBDialect, KineticaDialect, KingbaseDialect, KognitioDialect, LeanXcaleDialect, LinterDialect, MaxComputeDialect, MaxDBDialect, MckoiDialect, MemSQLDialect, MimerSQLDialect, MonetDialect, MSQLDialect, MySQLDialect, Neo4jDialect, NetezzaDialect, NexusDBDialect, NuodbDialect, OBaseDialect, OmnisciDialect, OpenbaseDialect, OpenEdgeDialect, OracleDialect, OrientDBDialect, OscarDialect, ParadoxDialect, PhoenixDialect, PointbaseDialect, PostgreSQLDialect, PrestoDialect, RadonDBDialect, RaimaDialect, RBaseDialect, RDMSOS2200Dialect, RedshiftDialect, SadasDialect, SequoiaDBDialect, SinoDBDialect, SmallDialect, SnappyDataDialect, SnowflakeDialect, SpliceMachineDialect, SQLiteDialect, SQReamDialect, TajoDialect, TeradataDialect, TiDBDialect, TimesTenDialect, TrafodionDialect, TransbaseDialect, UxDBDialect, ValentinaDialect, VerticaDialect, VirtuosoDialect, VistaDBDialect, VoltDBDialect, XmlDialect, XtremeSQLDialect, YaacomoDialect, YugabyteDBDialect
```
public abstract class AbstractDialect<T extends AbstractDialect>
extends Object
implements Dialect
```

构造器概要

构造器
构造器和说明

AbstractDialect()

AbstractDialect(Driver driver)

构造器
构造器和说明
`AbstractDialect()`
`AbstractDialect(Driver driver)`

方法概要

所有方法实例方法具体方法
限定符和类型	方法和说明
`String`	`appendmentAfterLikeClause()`
`int`	`bindLimitParametersAtEndOfQuery(RowSelection selection, PreparedStatement statement, int index)`
`int`	`bindLimitParametersAtStartOfQuery(RowSelection selection, PreparedStatement statement, int index)`
`protected TableGenerator`	`createTableGenerator(DatabaseDescription databaseDescription)`
`String`	`escape(String string)`
`String`	`generateTableDDL(DatabaseDescription database, String catalog, String schema, String tableName)`
`char`	`getAfterQuote()` Get quote for symbol (e.g. table name, field name)
`char`	`getBeforeQuote()` Get quote for symbol (e.g. table name, field name)
`String`	`getDatabaseId()`
`Properties`	`getDefaultProperties()`
`List<Character>`	`getLikeKeyChars()` %, _, \ 等
`LimitHandler`	`getLimitHandler()`
`String`	`getLimitSql(String sql, RowSelection selection)` Given a limit and an offset, apply the limit clause to the query.
`String`	`getQuotedIdentifier(String identifier)` Database identifier: tableName, columnName, schema, keyword.
`protected AbstractDialect`	`getRealDialect()`
`UrlParser`	`getUrlParser()`
`boolean`	`isBindLimitParametersFirst()` limit parameter will be bind in the first or not, if first ,the `Dialect.bindLimitParametersAtStartOfQuery(RowSelection, PreparedStatement, int)` will be execute else the `Dialect.bindLimitParametersAtEndOfQuery(RowSelection, PreparedStatement, int)` will be execute
`boolean`	`isBindLimitParametersInReverseOrder()` Whether bind parameter in reverse or not.
`boolean`	`isForceLimitUsage()` Generally if there is no, limit applied to a query we do not apply any limits to the sql query.
`boolean`	`isSupportsBatchSql()`
`boolean`	`isSupportsBatchUpdates()`
`boolean`	`isSupportsDistinct()` Whether supports distinct keyword
`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?
`boolean`	`isSupportsVariableLimit()` Does this dialect support bind variables (i.e., prepared statement parameters) for its limit/offset?
`boolean`	`isUseLimitInVariableMode()` Whether set limit or offset with placeholder '?'
`boolean`	`isUseMaxForLimit()`
`int`	`registerResultSetOutParameter(CallableStatement statement, int position)`
`protected void`	`setDelegate(T delegate)`
`protected void`	`setLikeEscaper(LikeEscaper likeEscaper)`
`protected void`	`setLimitHandler(LimitHandler limitHandler)`
`void`	`setMaxRows(RowSelection selection, PreparedStatement statement)`
`protected void`	`setUrlParser(UrlParser urlParser)`
`void`	`setUseLimitInVariableMode(boolean variableMode)` Whether set limit or offset with placeholder '?'
`String`	`toString()`

从类继承的方法 java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- 构造器详细资料
  - AbstractDialect
```
public AbstractDialect()
```
  - AbstractDialect
```
public AbstractDialect(Driver driver)
```
- 方法详细资料
  - getDatabaseId
```
public String getDatabaseId()
```
    指定者:
    
    getDatabaseId 在接口中 Dialect
  - getDefaultProperties
```
public final Properties getDefaultProperties()
```
  - toString
```
public String toString()
```
    覆盖:
    
    toString 在类中 Object
  - getLimitHandler
```
public LimitHandler getLimitHandler()
```
  - setLimitHandler
```
protected void setLimitHandler(LimitHandler limitHandler)
```
  - setDelegate
```
protected void setDelegate(@Nullable
                           T delegate)
```
  - setUrlParser
```
protected void setUrlParser(@NonNull
                            UrlParser urlParser)
```
  - setLikeEscaper
```
protected void setLikeEscaper(@NonNull
                              LikeEscaper likeEscaper)
```
  - isSupportsLimit
```
public boolean isSupportsLimit()
```
    从接口复制的说明: Dialect
    
    Does this dialect support some form of limiting query results via a sql clause?
    
    指定者:
    
    isSupportsLimit 在接口中 Dialect
    
    返回:
    
    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
    
    返回:
    
    True if the dialect supports an offset within the limit support
  - isSupportsVariableLimit
```
public boolean isSupportsVariableLimit()
```
    从接口复制的说明: Dialect
    
    Does this dialect support bind variables (i.e., prepared statement parameters) for its limit/offset?
    
    指定者:
    
    isSupportsVariableLimit 在接口中 Dialect
    
    返回:
    
    True if bind variables can be used; false otherwise.
  - setUseLimitInVariableMode
```
public void setUseLimitInVariableMode(boolean variableMode)
```
    从接口复制的说明: Dialect
    
    Whether set limit or offset with placeholder '?'
    
    指定者:
    
    setUseLimitInVariableMode 在接口中 Dialect
  - isUseLimitInVariableMode
```
public boolean isUseLimitInVariableMode()
```
    从接口复制的说明: Dialect
    
    Whether set limit or offset with placeholder '?'
    
    指定者:
    
    isUseLimitInVariableMode 在接口中 Dialect
    
    返回:
    
    true if use '?' for limit or offset variable, else false
  - 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
  - isBindLimitParametersFirst
```
public boolean isBindLimitParametersFirst()
```
    从接口复制的说明: Dialect
    
    limit parameter will be bind in the first or not, if first ,the Dialect.bindLimitParametersAtStartOfQuery(RowSelection, PreparedStatement, int) will be execute else the Dialect.bindLimitParametersAtEndOfQuery(RowSelection, PreparedStatement, int) will be execute
    
    指定者:
    
    isBindLimitParametersFirst 在接口中 Dialect
  - isUseMaxForLimit
```
public boolean isUseMaxForLimit()
```
    指定者:
    
    isUseMaxForLimit 在接口中 Dialect
  - isForceLimitUsage
```
public boolean isForceLimitUsage()
```
    从接口复制的说明: Dialect
    
    Generally if there is no, limit applied to a query we do not apply any limits to the sql query. This option forces that the limit be written to the sql query.
    
    指定者:
    
    isForceLimitUsage 在接口中 Dialect
    
    返回:
    
    True to force limit into soL query even if none specified in query, false otherwise
  - getRealDialect
```
protected AbstractDialect getRealDialect()
```
  - registerResultSetOutParameter
```
public int registerResultSetOutParameter(CallableStatement statement,
                                         int position)
                                  throws SQLException
```
    指定者:
    
    registerResultSetOutParameter 在接口中 Dialect
    
    抛出:
    
    SQLException
  - getLimitSql
```
public String getLimitSql(String sql,
                          RowSelection selection)
```
    从接口复制的说明: Dialect
    
    Given a limit and an offset, apply the limit clause to the query.
    
    指定者:
    
    getLimitSql 在接口中 Dialect
    
    参数:
    
    sql - The query to which to apply the limit.
    
    返回:
    
    The modified query statement with the limit applied.
  - setMaxRows
```
public void setMaxRows(RowSelection selection,
                       PreparedStatement statement)
                throws SQLException
```
    指定者:
    
    setMaxRows 在接口中 Dialect
    
    抛出:
    
    SQLException
  - bindLimitParametersAtEndOfQuery
```
public int bindLimitParametersAtEndOfQuery(RowSelection selection,
                                           PreparedStatement statement,
                                           int index)
                                    throws SQLException
```
    指定者:
    
    bindLimitParametersAtEndOfQuery 在接口中 Dialect
    
    抛出:
    
    SQLException
  - bindLimitParametersAtStartOfQuery
```
public int bindLimitParametersAtStartOfQuery(RowSelection selection,
                                             PreparedStatement statement,
                                             int index)
                                      throws SQLException
```
    指定者:
    
    bindLimitParametersAtStartOfQuery 在接口中 Dialect
    
    抛出:
    
    SQLException
  - getUrlParser
```
public UrlParser getUrlParser()
```
    指定者:
    
    getUrlParser 在接口中 Dialect
  - createTableGenerator
```
protected TableGenerator createTableGenerator(DatabaseDescription databaseDescription)
```
  - generateTableDDL
```
public final String generateTableDDL(@NonNull
                                     DatabaseDescription database,
                                     String catalog,
                                     String schema,
                                     @NonNull
                                     String tableName)
                              throws SQLException
```
    指定者:
    
    generateTableDDL 在接口中 Dialect
    
    抛出:
    
    SQLException
  - getQuotedIdentifier
```
public String getQuotedIdentifier(String identifier)
```
    从接口复制的说明: Dialect
    
    Database identifier: tableName, columnName, schema, keyword.
    
    指定者:
    
    getQuotedIdentifier 在接口中 Dialect
    
    参数:
    
    identifier - the name can be one of them: tableName, columnName, schemaName etc..
    
    返回:
    
    `identifier`
  - getBeforeQuote
```
public char getBeforeQuote()
```
    从接口复制的说明: Dialect
    
    Get quote for symbol (e.g. table name, field name)
    
    指定者:
    
    getBeforeQuote 在接口中 Dialect
    
    返回:
    
    the quote
  - getAfterQuote
```
public char getAfterQuote()
```
    从接口复制的说明: Dialect
    
    Get quote for symbol (e.g. table name, field name)
    
    指定者:
    
    getAfterQuote 在接口中 Dialect
    
    返回:
    
    the quote
  - isSupportsDistinct
```
public boolean isSupportsDistinct()
```
    从接口复制的说明: Dialect
    
    Whether supports distinct keyword
    
    指定者:
    
    isSupportsDistinct 在接口中 Dialect
  - isSupportsBatchUpdates
```
public boolean isSupportsBatchUpdates()
```
    指定者:
    
    isSupportsBatchUpdates 在接口中 Dialect
  - isSupportsBatchSql
```
public boolean isSupportsBatchSql()
```
    指定者:
    
    isSupportsBatchSql 在接口中 Dialect
  - getLikeKeyChars
```
public List<Character> getLikeKeyChars()
```
    从接口复制的说明: LikeEscaper
    
    %, _, \ 等
    
    指定者:
    
    getLikeKeyChars 在接口中 LikeEscaper
    
    返回:
    
    all key characters
  - escape
```
public String escape(String string)
```
    指定者:
    
    escape 在接口中 com.jn.langx.escape.Escaper
  - appendmentAfterLikeClause
```
public String appendmentAfterLikeClause()
```
    指定者:
    
    appendmentAfterLikeClause 在接口中 LikeEscaper

类 AbstractDialect<T extends AbstractDialect>

构造器概要

方法概要

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

构造器详细资料

AbstractDialect

AbstractDialect

方法详细资料

getDatabaseId

getDefaultProperties

toString

getLimitHandler

setLimitHandler

setDelegate

setUrlParser

setLikeEscaper

isSupportsLimit

isSupportsLimitOffset

isSupportsVariableLimit

setUseLimitInVariableMode

isUseLimitInVariableMode

isBindLimitParametersInReverseOrder

isBindLimitParametersFirst

isUseMaxForLimit

isForceLimitUsage

getRealDialect

registerResultSetOutParameter

getLimitSql

setMaxRows

bindLimitParametersAtEndOfQuery

bindLimitParametersAtStartOfQuery

getUrlParser

createTableGenerator

generateTableDDL

getQuotedIdentifier

getBeforeQuote

getAfterQuote

isSupportsDistinct

isSupportsBatchUpdates

isSupportsBatchSql

getLikeKeyChars

escape

appendmentAfterLikeClause