public interface JDBCDialect extends Serializable
| 限定符和类型 | 方法和说明 |
|---|---|
boolean |
canHandle(String url)
Check if this dialect instance can handle a certain jdbc url.
|
default Optional<String> |
defaultDriverName() |
default String |
getDeleteStatement(String tableName,
String[] conditionFields)
Get delete one row statement by condition fields, default not use limit 1,
because limit 1 is a sql dialect.
|
default String |
getInsertIntoStatement(String tableName,
String[] fieldNames)
Get insert into statement.
|
default String |
getRowExistsStatement(String tableName,
String[] conditionFields)
Get row exists statement by condition fields.
|
default String |
getSelectFromStatement(String tableName,
String[] selectFields,
String[] conditionFields)
Get select fields statement by condition fields.
|
default String |
getUpdateStatement(String tableName,
String[] fieldNames,
String[] conditionFields)
Get update one row statement by condition fields, default not use limit 1,
because limit 1 is a sql dialect.
|
default Optional<String> |
getUpsertStatement(String tableName,
String[] fieldNames,
String[] uniqueKeyFields)
Get dialect upsert statement, the database has its own upsert syntax, such as Mysql
using DUPLICATE KEY UPDATE, and PostgresSQL using ON CONFLICT...
|
default String |
quoteIdentifier(String identifier)
Quotes the identifier.
|
boolean canHandle(String url)
url - the jdbc url.default Optional<String> defaultDriverName()
default String quoteIdentifier(String identifier)
" to quote.default Optional<String> getUpsertStatement(String tableName, String[] fieldNames, String[] uniqueKeyFields)
default String getRowExistsStatement(String tableName, String[] conditionFields)
default String getInsertIntoStatement(String tableName, String[] fieldNames)
default String getUpdateStatement(String tableName, String[] fieldNames, String[] conditionFields)
default String getDeleteStatement(String tableName, String[] conditionFields)
Copyright © 2014–2021 The Apache Software Foundation. All rights reserved.