org.dromara.hutool.db.dialect.impl

Class MysqlDialect

java.lang.Object

org.dromara.hutool.db.dialect.impl.AnsiSqlDialect

org.dromara.hutool.db.dialect.impl.MysqlDialect

All Implemented Interfaces:

Serializable, Dialect

public class MysqlDialect
extends AnsiSqlDialect

MySQL方言

Author:

loolly

See Also:

Serialized Form

Field Summary

Fields inherited from class org.dromara.hutool.db.dialect.impl.AnsiSqlDialect

dbConfig, quoteWrapper

Constructor Summary

Constructors

Constructor and Description
MysqlDialect(DbConfig dbConfig) 构造

Method Summary

Modifier and Type	Method and Description
String	dialectName() 方言名
PreparedStatement	psForUpsert(Connection conn, Entity entity, String... keys) 构建用于upsert的PreparedStatement MySQL通过主键方式实现Upsert，故keys无效，生成SQL语法为： INSERT INTO demo(a,b,c) values(?
protected SqlBuilder	wrapPageSql(SqlBuilder find, Page page) 根据不同数据库在查询SQL语句基础上包装其分页的语句 各自数据库通过重写此方法实现最小改动情况下修改分页语句

Methods inherited from class org.dromara.hutool.db.dialect.impl.AnsiSqlDialect

getWrapper, psForDelete, psForFind, psForInsert, psForInsertBatch, psForPage, psForPage, psForUpdate, setWrapper

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.dromara.hutool.db.dialect.Dialect

psForCount, psForCount

Constructor Detail

MysqlDialect

public MysqlDialect(DbConfig dbConfig)

构造

Parameters:

dbConfig - 数据库配置

Method Detail

wrapPageSql

protected SqlBuilder wrapPageSql(SqlBuilder find,
                                 Page page)

Description copied from class: AnsiSqlDialect

根据不同数据库在查询SQL语句基础上包装其分页的语句
各自数据库通过重写此方法实现最小改动情况下修改分页语句

Overrides:

wrapPageSql in class AnsiSqlDialect

Parameters:

find - 标准查询语句

page - 分页对象

Returns:

分页语句

dialectName

public String dialectName()

Description copied from interface: Dialect

方言名

Specified by:

dialectName in interface Dialect

Overrides:

dialectName in class AnsiSqlDialect

Returns:

方言名

psForUpsert

public PreparedStatement psForUpsert(Connection conn,
                                     Entity entity,
                                     String... keys)

构建用于upsert的PreparedStatement
MySQL通过主键方式实现Upsert，故keys无效，生成SQL语法为：

     INSERT INTO demo(a,b,c) values(?, ?, ?) ON DUPLICATE KEY UPDATE a=values(a), b=values(b), c=values(c);
 

Specified by:

psForUpsert in interface Dialect

Overrides:

psForUpsert in class AnsiSqlDialect

Parameters:

conn - 数据库连接对象

entity - 数据实体类（包含表名）

keys - 此参数无效

Returns:

PreparedStatement

Since:

5.7.20