常量字段值

目录

• org.jeecgframework.*

org.jeecgframework.*

org.jeecgframework.minidao.def.MiniDaoConstants

限定符和类型	常量字段	值
public static final String	INF_METHOD_ACTIVE	"insert,add,create,update,modify,store,delete,remove"
public static final String	INF_METHOD_BATCH	"batch"
public static final String	SQL_FTL_DTO	"dto"

org.jeecgframework.minidao.util.MiniDaoUtil

限定符和类型	常量字段	值
public static final String	DATABSE_TYPE_MYSQL	"mysql"
public static final String	DATABSE_TYPE_ORACLE	"oracle"
public static final String	DATABSE_TYPE_POSTGRE	"postgresql"
public static final String	DATABSE_TYPE_SQLSERVER	"sqlserver"
public static final String	MYSQL_SQL	"select * from ( {0}) sel_tab00 limit {1},{2}"
public static final String	ORACLE_SQL	"select * from (select row_.*,rownum rownum_ from ({0}) row_ where rownum <= {1}) where rownum_>{2}"
public static final String	POSTGRE_SQL	"select * from ( {0}) sel_tab00 limit {2} offset {1}"
public static final String	SQLSERVER_SQL	"select * from ( select row_number() over(order by tempColumn) tempRowNumber, * from (select top {1} tempColumn = 0, {0}) t ) tt where tempRowNumber > {2}"