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和update
|
protected 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) |
public abstract boolean isSupport(java.lang.String dbType)
public java.lang.String getSelectWhere(DictObj obj)
protected abstract java.lang.String getDbValue(java.lang.Object o)
protected SelectSqlGenerator getSelectGenerator(DictObj obj)
public java.lang.String getSelectSql(DictObj obj)
public java.lang.String getInsertSql(DictObj destObj, java.lang.String tbName)
public java.lang.String getUpdateSql(DictObj destObj, java.lang.String tbName)
protected boolean handleInsertSqlCoreColumn(DictObjColumn col, HInsertSqlCommand cmd)
col
- cmd
- protected boolean handleUpdateSqlCoreColumn(DictObjColumn col, HUpdateSqlCommand cmd)
col
- cmd
- protected HSqlCommand getInsertSqlCore(DictObj destObj, DictObjTable tb)
protected HSqlCommand getUpdateSqlCore(DictObj destObj, DictObjTable tb)
protected HSqlCommand getDeleteSqlCore(DictObj destObj, DictObjTable tb)
public java.lang.StringBuilder BatchInsertSql(DictObj destObj, DictObjTable tb)
public java.lang.StringBuilder batchUpdateSql(DictObj destObj, java.lang.String tbName)
protected void filterCommandParameter(DictObjRow row, HSqlCommand cmd)
row
- cmd
- protected void executeCommand(HSqlCommand cmd, IDataAdapter adapter)
cmd
- adapter
- public void search(DictObj destObj, IDataAdapter adapter)
public void save(DictObj destObj, IDataAdapter adapter, boolean autoCommit)
protected abstract long getLastId(IDataAdapter adapter, DictObj destObj, java.lang.String incrementColumn)