com.jfinal.plugin.activerecord.dialect

Class AnsiSqlDialect

java.lang.Object

com.jfinal.plugin.activerecord.dialect.Dialect

com.jfinal.plugin.activerecord.dialect.AnsiSqlDialect

public class AnsiSqlDialect
extends Dialect

AnsiSqlDialect. Try to use ANSI SQL dialect with ActiveRecordPlugin.

A clever person solves a problem. A wise person avoids it.

Nested Class Summary

Nested classes/interfaces inherited from class com.jfinal.plugin.activerecord.dialect.Dialect

Dialect.Holder

Field Summary

Fields inherited from class com.jfinal.plugin.activerecord.dialect.Dialect

keepByteAndShort, modelBuilder, recordBuilder

Constructor Summary

Constructors

Constructor and Description
AnsiSqlDialect()

Method Summary

Modifier and Type	Method and Description
<T> List<T>	buildModel(ResultSet rs, Class<? extends Model> modelClass, int pageSize)
void	fillStatement(PreparedStatement pst, List<Object> paras)
void	fillStatement(PreparedStatement pst, Object... paras)
String	forDbDeleteById(String tableName, String[] pKeys)
String	forDbFindById(String tableName, String[] pKeys)
void	forDbSave(String tableName, String[] pKeys, Record record, StringBuilder sql, List<Object> paras)
void	forDbUpdate(String tableName, String[] pKeys, Object[] ids, Record record, StringBuilder sql, List<Object> paras)
String	forModelDeleteById(Table table)
String	forModelFindById(Table table, String columns)
void	forModelSave(Table table, Map<String,Object> attrs, StringBuilder sql, List<Object> paras)
void	forModelUpdate(Table table, Map<String,Object> attrs, Set<String> modifyFlag, StringBuilder sql, List<Object> paras)
String	forPaginate(int pageNumber, int pageSize, StringBuilder findSql) SELECT * FROM subject t1 WHERE (SELECT count(*) FROM subject t2 WHERE t2.id < t1.id AND t2.key = '123') > = 10 AND (SELECT count(*) FROM subject t2 WHERE t2.id < t1.id AND t2.key = '123') < 20 AND t1.key = '123'
String	forTableBuilderDoBuild(String tableName)
boolean	isTakeOverDbPaginate()
boolean	isTakeOverModelPaginate()
Page<Record>	takeOverDbPaginate(Connection conn, int pageNumber, int pageSize, Boolean isGroupBySql, String totalRowSql, StringBuilder findSql, Object... paras)
Page<? extends Model>	takeOverModelPaginate(Connection conn, Class<? extends Model> modelClass, int pageNumber, int pageSize, Boolean isGroupBySql, String totalRowSql, StringBuilder findSql, Object... paras)

Methods inherited from class com.jfinal.plugin.activerecord.dialect.Dialect

buildModelList, buildRecordList, fillStatementHandleDateType, fillStatementHandleDateType, getDefaultPrimaryKey, getModelGeneratedKey, getRecordGeneratedKey, isKeepByteAndShort, isOracle, isPrimaryKey, processGeneratedBigIntegerKey, replaceOrderBy, setKeepByteAndShort, setModelBuilder, setRecordBuilder, trimPrimaryKeys

Methods inherited from class java.lang.Object

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

Constructor Detail

AnsiSqlDialect

public AnsiSqlDialect()

Method Detail

forTableBuilderDoBuild

public String forTableBuilderDoBuild(String tableName)

Specified by:

forTableBuilderDoBuild in class Dialect

forModelSave

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

Specified by:

forModelSave in class Dialect

forModelDeleteById

public String forModelDeleteById(Table table)

Specified by:

forModelDeleteById in class Dialect

forModelUpdate

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

Specified by:

forModelUpdate in class Dialect

forModelFindById

public String forModelFindById(Table table,
                               String columns)

Specified by:

forModelFindById in class Dialect

forDbFindById

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

Specified by:

forDbFindById in class Dialect

forDbDeleteById

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

Specified by:

forDbDeleteById in class Dialect

forDbSave

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

Specified by:

forDbSave in class Dialect

forDbUpdate

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

Specified by:

forDbUpdate in class Dialect

forPaginate

public String forPaginate(int pageNumber,
                          int pageSize,
                          StringBuilder findSql)

SELECT * FROM subject t1 WHERE (SELECT count(*) FROM subject t2 WHERE t2.id < t1.id AND t2.key = '123') > = 10 AND (SELECT count(*) FROM subject t2 WHERE t2.id < t1.id AND t2.key = '123') < 20 AND t1.key = '123'

Specified by:

forPaginate in class Dialect

isTakeOverDbPaginate

public boolean isTakeOverDbPaginate()

Overrides:

isTakeOverDbPaginate in class Dialect

takeOverDbPaginate

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

Overrides:

takeOverDbPaginate in class Dialect

Throws:

SQLException

isTakeOverModelPaginate

public boolean isTakeOverModelPaginate()

Overrides:

isTakeOverModelPaginate in class Dialect

takeOverModelPaginate

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

Overrides:

takeOverModelPaginate in class Dialect

Throws:

Exception

buildModel

public final <T> List<T> buildModel(ResultSet rs,
                                    Class<? extends Model> modelClass,
                                    int pageSize)
                             throws SQLException,
                                    InstantiationException,
                                    IllegalAccessException

Throws:

SQLException

InstantiationException

IllegalAccessException

fillStatement

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

Overrides:

fillStatement in class Dialect

Throws:

SQLException

fillStatement

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

Overrides:

fillStatement in class Dialect

Throws:

SQLException