类 SqlBuilder
- java.lang.Object
-
- top.daxian1218.dust.db.dict.SqlBuilder
-
- 直接已知子类:
ClickHouseBuilder
,HighgoBuilder
,MssqlBuilder
,MySqlBuilder
,OracleBuilder
,PostgreSqlBuilder
public abstract class SqlBuilder extends java.lang.Object
-
-
构造器概要
构造器 构造器 说明 SqlBuilder()
-
方法概要
所有方法 实例方法 抽象方法 具体方法 修饰符和类型 方法 说明 java.lang.StringBuilder
BatchInsertSql(DictObj destObj, DictObjTable tb)
java.lang.StringBuilder
batchUpdateSql(DictObj destObj, java.lang.String tbName)
protected void
executeCommand(HSqlCommand cmd, IDataAdapter adapter)
执行SqlCommand,如果SqlCommand没有参数,则不需要执行;用于insert和updateprotected void
filterCommandParameter(DictObjRow row, HSqlCommand cmd)
根据SqlCommand的列信息将DictObjRow转化为参数protected abstract java.lang.String
getDbValue(java.lang.Object o)
protected HSqlCommand
getDeleteSqlCore(DictObj destObj, DictObjTable tb)
java.lang.String
getInsertSql(DictObj destObj, java.lang.String tbName)
protected HSqlCommand
getInsertSqlCore(DictObj destObj, DictObjTable tb)
protected abstract long
getLastId(IDataAdapter adapter, DictObj destObj, java.lang.String incrementColumn)
protected SelectSqlGenerator
getSelectGenerator(DictObj obj)
java.lang.String
getSelectSql(DictObj obj)
java.lang.String
getSelectWhere(DictObj obj)
java.lang.String
getUpdateSql(DictObj destObj, java.lang.String tbName)
protected HSqlCommand
getUpdateSqlCore(DictObj destObj, DictObjTable tb)
protected boolean
handleInsertSqlCoreColumn(DictObjColumn col, HInsertSqlCommand cmd)
自定义处理插入列protected boolean
handleUpdateSqlCoreColumn(DictObjColumn col, HUpdateSqlCommand cmd)
自定义处理更新列abstract boolean
isSupport(java.lang.String dbType)
void
save(DictObj destObj, IDataAdapter adapter, boolean autoCommit)
void
search(DictObj destObj, IDataAdapter adapter)
-
-
-
方法详细资料
-
isSupport
public abstract boolean isSupport(java.lang.String dbType)
-
getSelectWhere
public java.lang.String getSelectWhere(DictObj obj)
-
getDbValue
protected abstract java.lang.String getDbValue(java.lang.Object o)
-
getSelectGenerator
protected SelectSqlGenerator getSelectGenerator(DictObj obj)
-
getSelectSql
public java.lang.String getSelectSql(DictObj obj)
-
getInsertSql
public java.lang.String getInsertSql(DictObj destObj, java.lang.String tbName)
-
getUpdateSql
public java.lang.String getUpdateSql(DictObj destObj, java.lang.String tbName)
-
handleInsertSqlCoreColumn
protected boolean handleInsertSqlCoreColumn(DictObjColumn col, HInsertSqlCommand cmd)
自定义处理插入列- 参数:
col
-cmd
-- 返回:
-
handleUpdateSqlCoreColumn
protected boolean handleUpdateSqlCoreColumn(DictObjColumn col, HUpdateSqlCommand cmd)
自定义处理更新列- 参数:
col
-cmd
-- 返回:
-
getInsertSqlCore
protected HSqlCommand getInsertSqlCore(DictObj destObj, DictObjTable tb)
-
getUpdateSqlCore
protected HSqlCommand getUpdateSqlCore(DictObj destObj, DictObjTable tb)
-
getDeleteSqlCore
protected HSqlCommand getDeleteSqlCore(DictObj destObj, DictObjTable tb)
-
BatchInsertSql
public java.lang.StringBuilder BatchInsertSql(DictObj destObj, DictObjTable tb)
-
batchUpdateSql
public java.lang.StringBuilder batchUpdateSql(DictObj destObj, java.lang.String tbName)
-
filterCommandParameter
protected void filterCommandParameter(DictObjRow row, HSqlCommand cmd)
根据SqlCommand的列信息将DictObjRow转化为参数- 参数:
row
-cmd
-
-
executeCommand
protected void executeCommand(HSqlCommand cmd, IDataAdapter adapter)
执行SqlCommand,如果SqlCommand没有参数,则不需要执行;用于insert和update- 参数:
cmd
-adapter
-
-
search
public void search(DictObj destObj, IDataAdapter adapter)
-
save
public void save(DictObj destObj, IDataAdapter adapter, boolean autoCommit)
-
getLastId
protected abstract long getLastId(IDataAdapter adapter, DictObj destObj, java.lang.String incrementColumn)
-
-