com.fastchar.database.sql

类 FastSql

java.lang.Object

com.fastchar.database.sql.FastSql

直接已知子类:

FastMySql, FastOracle, FastSqlServer

public abstract class FastSql
extends Object

字段概要

字段

限定符和类型	字段和说明
protected String	type

构造器概要

构造器

构造器和说明
FastSql()

方法概要

限定符和类型	方法和说明
FastSqlInfo	appendWhere(String sqlStr, FastEntity<?> entity) 条件属性 转为 sql语句 条件属性格式： 分组符号+连接符号+属性名+比较符号（例如：&name?
FastSqlInfo	buildCopySql(FastEntity<?> entity)
FastSqlInfo	buildCountSql(FastEntity<?> entity, String... checks)
FastSqlInfo	buildDeleteSql(FastEntity<?> entity, String... checks)
FastSqlInfo	buildDeleteSqlByIds(FastEntity<?> entity, Object... ids)
abstract FastSqlInfo	buildInsertSql(FastEntity<?> entity, String... checks)
abstract String	buildPageSql(String selectSql, int page, int pageSize)
FastSqlInfo	buildSelectSql(FastEntity<?> entity)
FastSqlInfo	buildSelectSql(String selectSql, FastEntity<?> entity)
FastSqlInfo	buildSelectSqlByIds(FastEntity<?> entity, Object... ids)
FastSqlInfo	buildUpdateSql(FastEntity<?> entity, String... checks)
FastSqlInfo	buildUpdateSqlByIds(FastEntity<?> entity, Object... ids)
protected String	convertInPlaceholder(Object value, List<Object> values)
protected String	getAlias(String sql)
protected Object	getAttrValue(FastEntity<?> entity, String attr)
protected Object	getColumnValue(FastEntity<?> entity, FastColumnInfo<?> columnInfo)
String	getCountSql(String selectSql, String alias)
static FastSql	getInstance(String type)
protected int[]	getTokenIndex(String token, String sql, String... endToken)
protected String	getTokenValue(String token, String sql)
String	getType()
protected FastSqlInfo	newSqlInfo()

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

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

字段详细资料

type

protected String type

构造器详细资料

FastSql

public FastSql()

方法详细资料

getInstance

public static FastSql getInstance(String type)

buildInsertSql

public abstract FastSqlInfo buildInsertSql(FastEntity<?> entity,
                                           String... checks)

buildCopySql

public FastSqlInfo buildCopySql(FastEntity<?> entity)

buildDeleteSql

public FastSqlInfo buildDeleteSql(FastEntity<?> entity,
                                  String... checks)

buildDeleteSqlByIds

public FastSqlInfo buildDeleteSqlByIds(FastEntity<?> entity,
                                       Object... ids)

buildUpdateSql

public FastSqlInfo buildUpdateSql(FastEntity<?> entity,
                                  String... checks)

buildUpdateSqlByIds

public FastSqlInfo buildUpdateSqlByIds(FastEntity<?> entity,
                                       Object... ids)

buildSelectSqlByIds

public FastSqlInfo buildSelectSqlByIds(FastEntity<?> entity,
                                       Object... ids)

buildSelectSql

public FastSqlInfo buildSelectSql(String selectSql,
                                  FastEntity<?> entity)

buildSelectSql

public FastSqlInfo buildSelectSql(FastEntity<?> entity)

buildPageSql

public abstract String buildPageSql(String selectSql,
                                    int page,
                                    int pageSize)

buildCountSql

public FastSqlInfo buildCountSql(FastEntity<?> entity,
                                 String... checks)

getCountSql

public String getCountSql(String selectSql,
                          String alias)

newSqlInfo

protected FastSqlInfo newSqlInfo()

getAttrValue

protected Object getAttrValue(FastEntity<?> entity,
                              String attr)

getColumnValue

protected Object getColumnValue(FastEntity<?> entity,
                                FastColumnInfo<?> columnInfo)

convertInPlaceholder

protected String convertInPlaceholder(Object value,
                                      List<Object> values)

getAlias

protected String getAlias(String sql)

getTokenIndex

protected int[] getTokenIndex(String token,
                              String sql,
                              String... endToken)

getTokenValue

protected String getTokenValue(String token,
                               String sql)

appendWhere

public FastSqlInfo appendWhere(String sqlStr,
                               FastEntity<?> entity)

条件属性 转为 sql语句

条件属性格式：
分组符号+连接符号+属性名+比较符号（例如：&name?% 翻译后为：and name like '值%' ）
分组符号 @[0-9] 翻译成sql and ()
分组符号 |[0-9] 翻译成sql or ()
连接符号：& 翻译成sql and
连接符号：@ 翻译成sql and
连接符号：|| 翻译成sql or
比较符号：? 翻译成sql like
比较符号：!? 翻译成sql not like
比较符号：# 翻译成sql in
比较符号：!# 翻译成sql not in
比较符号：~ 翻译成sql is null
比较符号：!~ 翻译成sql is not null
前缀符号：__ 翻译成sql . (别名前缀，例如：a__name 翻译后为：a.name)
以下特性被忽略转换： 以^符号开头的属性 （例如：^test ）

getType

public String getType()