public class DbTableQuery extends DbTableQueryBase<DbTableQuery>
| 限定符和类型 | 字段和说明 |
|---|---|
protected DataItem |
_item |
_cache, limit_size, limit_start, limit_top| 构造器和说明 |
|---|
DbTableQuery(DbContext context) |
| 限定符和类型 | 方法和说明 |
|---|---|
long |
insert()
执行插入并返回自增值,使用set接口的数据
(默认,只会插入不是null的数据)
|
Command |
insertAsCmd() |
long |
insertBy(String conditionFields)
根据字段和数据自动形成插入条件
|
DbTableQuery |
set(String name,
Object value) |
DbTableQuery |
setDf(String name,
Object value,
Object def) |
DbTableQuery |
setEntity(Object data) |
DbTableQuery |
setEntityIf(Object data,
Fun2<Boolean,String,Object> condition) |
DbTableQuery |
setIf(boolean condition,
String name,
Object value) |
DbTableQuery |
setInc(String name,
long value) |
DbTableQuery |
setMap(Map<String,Object> data) |
DbTableQuery |
setMapIf(Map<String,Object> data,
Fun2<Boolean,String,Object> condition) |
int |
update()
执行更新并返回影响行数,使用set接口的数据
(默认,只会更新不是null的数据)
|
Command |
updateAsCmd() |
int |
updateBy(String conditionFields) |
long |
upsert(String conditionFields)
已过时。
|
long |
upsertBy(String conditionFields) |
append, build, cacheTag, caching, count, count, delete, deleteAsCmd, deleteCompile, exists, from, hint, innerJoin, insert, insert, insertAsCmd, insertBy, insertCompile, insertList, insertList, insertList, leftJoin, limit, limit, log, on, onEq, paging, rightJoin, select, selectArray, selectAsCmd, selectCompile, selectCount, selectCount, selectDataItem, selectDataList, selectDataPage, selectDo, selectExists, selectItem, selectList, selectMap, selectMapList, selectMapPage, selectPage, selectQ, selectValue, selectValue, selectVariate, table, top, update, update, updateAsCmd, updateBy, updateCompile, updateList, updateList, updateList, upsert, upsertBy, usingCache, usingCache, usingExpr, usingExpr, usingNull, usingNull, with, withand, and, andBtw, andByAsc, andByDesc, andEq, andGt, andGte, andIf, andIn, andLk, andLt, andLte, andNbtw, andNeq, andNin, andNlk, begin, begin, beginBtw, beginEq, beginGt, beginGte, beginIn, beginLk, beginLt, beginLte, beginNbtw, beginNeq, beginNin, beginNlk, dbType, end, fmtColumn, fmtCondition, fmtMutColumns, fmtObject, fmtSchema, groupBy, having, or, or, orBtw, orderBy, orderByAsc, orderByDesc, orderByDo, orEq, orGt, orGte, orIf, orIn, orLk, orLt, orLte, orNbtw, orNeq, orNin, orNlk, where, where, where, whereBtw, whereEntity, whereEntityIf, whereEq, whereGt, whereGte, whereIf, whereIn, whereLk, whereLt, whereLte, whereMap, whereMapIf, whereNbtw, whereNeq, whereNin, whereNlk, whereTrueprotected DataItem _item
public DbTableQuery(DbContext context)
public DbTableQuery set(String name, Object value)
public DbTableQuery setInc(String name, long value)
public DbTableQuery setDf(String name, Object value, Object def)
public DbTableQuery setIf(boolean condition, String name, Object value)
public DbTableQuery setMap(Map<String,Object> data)
public DbTableQuery setMapIf(Map<String,Object> data, Fun2<Boolean,String,Object> condition)
public DbTableQuery setEntity(Object data)
public long insert()
throws SQLException
SQLExceptionpublic Command insertAsCmd()
public long insertBy(String conditionFields) throws SQLException
SQLExceptionpublic int update()
throws SQLException
SQLExceptionpublic Command updateAsCmd() throws SQLException
SQLExceptionpublic int updateBy(String conditionFields) throws SQLException
SQLException@Deprecated public long upsert(String conditionFields) throws SQLException
SQLExceptionpublic long upsertBy(String conditionFields) throws SQLException
SQLExceptionCopyright © 2023. All rights reserved.