org.dromara.hutool.db.dialect.impl

Class PostgresqlDialect

java.lang.Object

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

org.dromara.hutool.db.dialect.impl.PostgresqlDialect

All Implemented Interfaces:

Serializable, Dialect

public class PostgresqlDialect
extends AnsiSqlDialect

Postgree方言

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
PostgresqlDialect(DbConfig dbConfig) 构造

Method Summary

Modifier and Type	Method and Description
String	dialectName() 方言名
PreparedStatement	psForUpsert(Connection conn, Entity entity, String... keys) 构建用于upsert的PreparedStatement 方言实现需实现此默认方法，如果没有实现，抛出DbException

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

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

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

PostgresqlDialect

public PostgresqlDialect(DbConfig dbConfig)

构造

Parameters:

dbConfig - 数据库配置

Method Detail

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)

Description copied from interface: Dialect

构建用于upsert的PreparedStatement
方言实现需实现此默认方法，如果没有实现，抛出DbException

Specified by:

psForUpsert in interface Dialect

Overrides:

psForUpsert in class AnsiSqlDialect

Parameters:

conn - 数据库连接对象

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

keys - 查找字段，某些数据库此字段必须，如H2，某些数据库无需此字段，如MySQL（通过主键）

Returns:

PreparedStatement