com.github.fangjinuo.sqlhelper.dialect

接口 Dialect

所有超级接口:

UrlParser

所有已知实现类:

AbstractDialect, AbstractTransactSQLDialect, AccessDialect, ActorDBDialect, AgensGraphDialect, AltibaseDialect, AuroraDialect, AzureDialect, BigObjectDialect, BrytlytDialect, CacheDialect, ClickHouseDialect, ClustrixDialect, CobolDialect, CockroachDialect, ComDB2Dialect, CrateDialect, CTreeDialect, CubridDialect, DB2Dialect, DbfDialect, DerbyDialect, DmDialect, DorisDialect, DrillDialect, ElasticsearchDialect, EsgynDBDialect, FileMakerDialect, FirebirdDialect, GBaseDialect, GreenplumDialect, H2Dialect, HANADialect, HawqDialect, HighGoDialect, HiveDialect, HSQLDialect, IgniteDialect, ImpalaDialect, InformixDialect, IngresDialect, InterbaseDialect, IrisDialect, JDataStoreDialect, KDBDialect, KineticaDialect, KingbaseDialect, KognitioDialect, LeanXcaleDialect, MariaDBDialect, MaxComputeDialect, MaxDBDialect, MckoiDialect, MemSQLDialect, MimerSQLDialect, MonetDialect, MSQLDialect, MySQLDialect, NetezzaDialect, NexusDBDialect, NuodbDialect, OmnisciDialect, OpenbaseDialect, OpenEdgeDialect, OracleDialect, OscarDialect, ParadoxDialect, PerconaMysqlDialect, PhoenixDialect, PointbaseDialect, PostgreSQLDialect, RBaseDialect, RDMSOS2200Dialect, RedshiftDialect, SequoiaDBDialect, SnappyDataDialect, SnowflakeDialect, SpliceMachineDialect, SQLiteDialect, SQLServerDialect, SQReamDialect, SybaseDialect, TeradataDialect, TiDBDialect, TimesTenDialect, TransbaseDialect, ValentinaDialect, VerticaDialect, VirtuosoDialect, VistaDBDialect, VoltDBDialect, XmlDialect, XtremeSQLDialect

public interface Dialect
extends UrlParser

方法概要

限定符和类型	方法和说明
int	bindLimitParametersAtEndOfQuery(RowSelection paramRowSelection, PreparedStatement paramPreparedStatement, int paramInt)
int	bindLimitParametersAtStartOfQuery(RowSelection paramRowSelection, PreparedStatement paramPreparedStatement, int paramInt)
String	getDatabaseId()
String	getLimitSql(String query, RowSelection rowSelection) Given a limit and an offset, apply the limit clause to the query.
boolean	isBindLimitParametersFirst()
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 soI query.
boolean	isSupportsLimit() Does this dialect support some form of limiting query results via a soI 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	isUseMaxForLimit()
int	registerResultSetOutParameter(CallableStatement paramCallableStatement, int paramInt)
void	setMaxRows(RowSelection paramRowSelection, PreparedStatement paramPreparedStatement)

从接口继承的方法 com.github.fangjinuo.sqlhelper.dialect.internal.urlparser.UrlParser

getUrlSchemas, parse

方法详细资料

getDatabaseId

String getDatabaseId()

isSupportsLimit

boolean isSupportsLimit()

Does this dialect support some form of limiting query results via a soI clause?

返回:

True if this dialect supports some form of LIMIT.

isForceLimitUsage

boolean isForceLimitUsage()

Generally if there is no, limit applied to a query we do not apply any limits . to the soI query. This option forces that the limit be written to the sol query. s ereturn True to force limit into soL query even if none specified in query, false otherwise

isSupportsLimitOffset

boolean isSupportsLimitOffset()

Does this dialect ' s LIMIT support (if any) additionally support specifying an offset?

返回:

True if the dialect supports an offset within the limit support

isSupportsVariableLimit

boolean isSupportsVariableLimit()

Does this dialect support bind variables (i.e., prepared statement parameters) for its limit/offset?

返回:

True if bind variables can be used; false otherwise.

getLimitSql

String getLimitSql(String query,
                   RowSelection rowSelection)

Given a limit and an offset, apply the limit clause to the query.

参数:

query - The query to which to apply the limit.

返回:

The modified query statement with the limit applied.

isBindLimitParametersInReverseOrder

boolean isBindLimitParametersInReverseOrder()

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

返回:

isBindLimitParametersFirst

boolean isBindLimitParametersFirst()

bindLimitParametersAtStartOfQuery

int bindLimitParametersAtStartOfQuery(RowSelection paramRowSelection,
                                      PreparedStatement paramPreparedStatement,
                                      int paramInt)
                               throws SQLException

抛出:

SQLException

bindLimitParametersAtEndOfQuery

int bindLimitParametersAtEndOfQuery(RowSelection paramRowSelection,
                                    PreparedStatement paramPreparedStatement,
                                    int paramInt)
                             throws SQLException

抛出:

SQLException

isUseMaxForLimit

boolean isUseMaxForLimit()

registerResultSetOutParameter

int registerResultSetOutParameter(CallableStatement paramCallableStatement,
                                  int paramInt)
                           throws SQLException

抛出:

SQLException

setMaxRows

void setMaxRows(RowSelection paramRowSelection,
                PreparedStatement paramPreparedStatement)
         throws SQLException

抛出:

SQLException