com.jfinal.plugin.activerecord.dialect

类 Dialect

java.lang.Object

com.jfinal.plugin.activerecord.dialect.Dialect

直接已知子类:

AnsiSqlDialect, MysqlDialect, OracleDialect, PostgreSqlDialect, Sqlite3Dialect, SqlServerDialect

public abstract class Dialect
extends Object

Dialect.

嵌套类概要

嵌套类

限定符和类型	类和说明
protected static class	Dialect.Holder

构造器概要

构造器

构造器和说明
Dialect()

方法概要

方法

限定符和类型	方法和说明
void	fillStatement(PreparedStatement pst, List<Object> paras)
void	fillStatement(PreparedStatement pst, Object... paras)
abstract String	forDbDeleteById(String tableName, String[] pKeys)
abstract String	forDbFindById(String tableName, String[] pKeys)
abstract void	forDbSave(String tableName, String[] pKeys, Record record, StringBuilder sql, List<Object> paras)
abstract void	forDbUpdate(String tableName, String[] pKeys, Object[] ids, Record record, StringBuilder sql, List<Object> paras)
abstract String	forModelDeleteById(Table table)
abstract String	forModelFindById(Table table, String columns)
abstract void	forModelSave(Table table, Map<String,Object> attrs, StringBuilder sql, List<Object> paras)
abstract void	forModelUpdate(Table table, Map<String,Object> attrs, Set<String> modifyFlag, StringBuilder sql, List<Object> paras)
abstract String	forPaginate(int pageNumber, int pageSize, String select, String sqlExceptSelect)
abstract String	forTableBuilderDoBuild(String tableName)
String	getDefaultPrimaryKey()
boolean	isOracle()
boolean	isPrimaryKey(String colName, String[] pKeys)
boolean	isTakeOverDbPaginate()
boolean	isTakeOverModelPaginate()
String	replaceOrderBy(String sql)
Page<Record>	takeOverDbPaginate(Connection conn, int pageNumber, int pageSize, Boolean isGroupBySql, String select, String sqlExceptSelect, Object... paras)
Page	takeOverModelPaginate(Connection conn, Class<? extends Model> modelClass, int pageNumber, int pageSize, Boolean isGroupBySql, String select, String sqlExceptSelect, Object... paras)
void	trimPrimaryKeys(String[] pKeys) 一、forDbXxx 系列方法中若有如下两种情况之一，则需要调用此方法对 pKeys 数组进行 trim(): 1：方法中调用了 isPrimaryKey(...)

从类继承的方法 java.lang.Object

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

构造器详细资料

Dialect

public Dialect()

方法详细资料

forTableBuilderDoBuild

public abstract String forTableBuilderDoBuild(String tableName)

forPaginate

public abstract String forPaginate(int pageNumber,
                 int pageSize,
                 String select,
                 String sqlExceptSelect)

forModelFindById

public abstract String forModelFindById(Table table,
                      String columns)

forModelDeleteById

public abstract String forModelDeleteById(Table table)

forModelSave

public abstract void forModelSave(Table table,
                Map<String,Object> attrs,
                StringBuilder sql,
                List<Object> paras)

forModelUpdate

public abstract void forModelUpdate(Table table,
                  Map<String,Object> attrs,
                  Set<String> modifyFlag,
                  StringBuilder sql,
                  List<Object> paras)

forDbFindById

public abstract String forDbFindById(String tableName,
                   String[] pKeys)

forDbDeleteById

public abstract String forDbDeleteById(String tableName,
                     String[] pKeys)

forDbSave

public abstract void forDbSave(String tableName,
             String[] pKeys,
             Record record,
             StringBuilder sql,
             List<Object> paras)

forDbUpdate

public abstract void forDbUpdate(String tableName,
               String[] pKeys,
               Object[] ids,
               Record record,
               StringBuilder sql,
               List<Object> paras)

isOracle

public boolean isOracle()

isTakeOverDbPaginate

public boolean isTakeOverDbPaginate()

takeOverDbPaginate

public Page<Record> takeOverDbPaginate(Connection conn,
                              int pageNumber,
                              int pageSize,
                              Boolean isGroupBySql,
                              String select,
                              String sqlExceptSelect,
                              Object... paras)
                                throws SQLException

抛出:

SQLException

isTakeOverModelPaginate

public boolean isTakeOverModelPaginate()

takeOverModelPaginate

public Page takeOverModelPaginate(Connection conn,
                         Class<? extends Model> modelClass,
                         int pageNumber,
                         int pageSize,
                         Boolean isGroupBySql,
                         String select,
                         String sqlExceptSelect,
                         Object... paras)
                           throws Exception

抛出:

Exception

fillStatement

public void fillStatement(PreparedStatement pst,
                 List<Object> paras)
                   throws SQLException

抛出:

SQLException

fillStatement

public void fillStatement(PreparedStatement pst,
                 Object... paras)
                   throws SQLException

抛出:

SQLException

getDefaultPrimaryKey

public String getDefaultPrimaryKey()

isPrimaryKey

public boolean isPrimaryKey(String colName,
                   String[] pKeys)

trimPrimaryKeys

public void trimPrimaryKeys(String[] pKeys)

一、forDbXxx 系列方法中若有如下两种情况之一，则需要调用此方法对 pKeys 数组进行 trim(): 1：方法中调用了 isPrimaryKey(...)：为了防止在主键相同情况下，由于前后空串造成 isPrimaryKey 返回 false 2：为了防止 tableName、colName 与数据库保留字冲突的，添加了包裹字符的：为了防止串包裹区内存在空串 如 mysql 使用的 "`" 字符以及 PostgreSql 使用的 "\"" 字符 不满足以上两个条件之一的 forDbXxx 系列方法也可以使用 trimPrimaryKeys(...) 方法让 sql 更加美观，但不是必须 二、forModelXxx 由于在映射时已经trim()，故不再需要调用此方法

replaceOrderBy

public String replaceOrderBy(String sql)