Class PostgreSQLDialect

java.lang.Object

org.huiche.dialect.BaseDialect

org.huiche.dialect.PostgreSQLDialect

All Implemented Interfaces:

Dialect

public class PostgreSQLDialect
extends BaseDialect

PostgreSQL 方言实现

Author:

Maning

Field Summary

Fields inherited from class BaseDialect

keywords, quoteString

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method	Description
void	setJsonValue(PreparedStatement ps, int parameterIndex, String jsonValue, Configuration configuration)	设置json值时实现
Translation	translatePaging(Integer limit, Integer offset)	转译分页

Methods inherited from class BaseDialect

quote, 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, template, typeForSetNull, useNational

Constructor Details

PostgreSQLDialect

public PostgreSQLDialect()

默认构造

PostgreSQLDialect

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

默认构造

Parameters:

quoteString - 标识符转义字符串

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

Method Details

setJsonValue

public void setJsonValue(PreparedStatement ps,
 int parameterIndex,
 String jsonValue,
 Configuration configuration)
                  throws SQLException

Description copied from interface: Dialect

设置json值时实现

Parameters:

ps - ps

parameterIndex - 参数下标

jsonValue - json值

configuration - 配置

Throws:

SQLException - sql异常

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:

分页语法