Class MySQLDialect

java.lang.Object

org.huiche.dialect.BaseDialect

org.huiche.dialect.MySQLDialect

All Implemented Interfaces:

Dialect

Direct Known Subclasses:

MariaDBDialect

public class MySQLDialect
extends BaseDialect

MySql方言实现

Author:

Maning

Field Summary

Fields inherited from class BaseDialect

keywords, quoteString

Constructor Summary

Constructors

Constructor	Description
MySQLDialect()	默认构造
MySQLDialect(String quoteString, Set<String> keywords)	默认构造

Method Summary

Modifier and Type	Method	Description
boolean	supportsNullsOrdering()	是否支持ORDER BY的NULLS FIRST/LAST语法
String	template(Template template)	获取模板,可重写
Translation	translatePaging(Integer limit, Integer offset)	转译分页

Methods inherited from class BaseDialect

quote, quoteIdentifier, quotePart, translate, translate, translateCustom

Methods inherited from class Object

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

Methods inherited from interface Dialect

processTemplateParams, requiresOrderByForPaging, setJsonValue, supportsSetOperandParenthesis, typeForSetNull, useNational

Constructor Details

MySQLDialect

public MySQLDialect()

默认构造

MySQLDialect

public MySQLDialect(String quoteString,
 Set<String> keywords)

默认构造

Parameters:

quoteString - 标识符转义字符串

keywords - 关键字(SQL2003内置除外)

Method Details

supportsNullsOrdering

public boolean supportsNullsOrdering()

Description copied from interface: Dialect

是否支持ORDER BY的NULLS FIRST/LAST语法

MySQL、MariaDB、SQL Server不支持该语法,但它们都把NULL视为最小值, 因此可以改写为CASE WHEN ... IS NULL实现等价排序。

Returns:

是否支持

template

public String template(Template template)

Description copied from interface: Dialect

获取模板,可重写

Parameters:

template - 模板

Returns:

重写后模板

translatePaging

public Translation translatePaging(Integer limit,
 Integer offset)

Description copied from interface: Dialect

转译分页

Specified by:

translatePaging in interface Dialect

Overrides:

translatePaging in class BaseDialect

Parameters:

limit - 限制条数

offset - 跳过条数

Returns:

分页语法