DBClient (sorm-码云(gitee.com))

java.lang.Object
- sf.database.dao.DaoSupport
- - sf.database.dao.DBClient

All Implemented Interfaces:

DBMethod

Direct Known Subclasses:

DaoTemplate
```
public class DBClient
extends DaoSupport
implements DBMethod
```
dbclient基础多数据源下需要使用多个DBClient,当前dbClient支持主从功能.

Author:

sxf

Field Summary

Fields
Modifier and Type	Field and Description
`protected ThreadLocal<DBContext>`	`dbContexts` sql执行上下文.
`protected DBDynmicSQL`	`dbDynmicSQL`
`protected DBJooq`	`dbJooq`
`protected DBQueryDSL`	`dbQueryDSL`
`protected MapperBuilder`	`mapperBuilder`

Fields inherited from class sf.database.dao.DaoSupport
crud, dataSource

Constructor Summary

Constructors
Constructor and Description

DBClient()

DBClient(DataSource dataSource)

Constructors
Constructor and Description
`DBClient()`
`DBClient(DataSource dataSource)`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`int[]`	`batchDelete(Collection<? extends DBObject> modelList)` 批量删除
`int[]`	`batchInsert(Collection<? extends DBObject> modelList)` 批量插入
`int[]`	`batchInsert(Collection<? extends DBObject> modelList, boolean useAll)` 批量插入
`int[]`	`batchInsertFast(Collection<? extends DBObject> modelList)` 快速插入方法
`int[]`	`batchInsertFast(Collection<? extends DBObject> modelList, boolean useAll)` 快速插入方法
`int[]`	`batchUpdate(Collection<? extends DBObject> modelList)` 更新对象,如果有乐观锁,会根据乐观锁条件更新,并会更新数据库中的乐观锁条件.但不会更新对象的乐观锁字段的值.
`int[]`	`batchUpdate(Collection<? extends DBObject> modelList, boolean useNvl)` 更新对象,如果有乐观锁,会根据乐观锁条件更新,并会更新数据库中的乐观锁条件.但不会更新对象的乐观锁字段的值.
`protected void`	`closeConnection(Connection conn, DataSource ds)` 释放一个连接，如果 Connection 不在事务中，则关闭它，否则不处理。
`protected void`	`closeConnection(DBContext context, Connection conn, DataSource ds)`
`boolean`	`createTable(Class<?> clz)` 建表
`boolean`	`createTables()` 创建全部表
`<T extends DBObject> int`	`delete(T obj)` 删除实体,根据设置的值删除
`<T extends DBObject> int`	`deleteByPrimaryKeys(Class<T> clz, Object... keyParams)` 根据主键删除实体
`<T extends DBObject> int`	`deleteCascade(T obj, DBCascadeField... fields)` 将对象删除的同时，也将指定级联字段的所有关联字段关联的对象统统删除注意：
`<T extends DBObject> int`	`deleteLinks(T obj, DBCascadeField... fields)` 仅删除对象所有的关联字段，并不包括对象本身。注意：
`<T extends DBObject> int`	`deleteRelation(T obj, DBCascadeField... fields)` 多对多关联是通过一个中间表将两条数据表记录关联起来。
`boolean`	`dropTable(Class<?> clz)` 删除表
`<T> T`	`execute(ConnectionCallback<T> action)` 数据迭代接口执行回调,主要是用于存储过程调用直接获取connection,注意连接不可手动关闭
`<T> T`	`execute(ConnectionCallback<T> action, boolean readonly)` 数据迭代接口执行回调,主要是用于存储过程调用直接获取connection,注意连接不可手动关闭
`<R> R`	`execute(Function<DataSource,R> func, boolean readonly)`
`int`	`execute(SQLContext context)`
`int`	`execute(String sql, Object... parameters)` 执行单一sql
`int[]`	`executeBatch(String sql, List<Object[]> parameters)` 批量执行SQL
`int[]`	`executeBatch(String sql, List<Object[]> parameters, boolean insertFast, int batchSize, List<String> pkeys, List<Map<String,Object>> keyValues)`
`int[]`	`executeBatchTemplate(String sqlId, List<Map<String,Object>> parameters)`
`int[]`	`executeBatchTemplate(String sqlId, List<Map<String,Object>> parameters, boolean insertFast, int batchSize, List<String> pkeys, List<Map<String,Object>> keyValues)` 批量处理,带返回主键值的功能.
`int[]`	`executeBatchTemplateSource(String sqlSource, List<Map<String,Object>> parameters)`
`int[]`	`executeBatchTemplateSource(String sqlSource, List<Map<String,Object>> parameters, boolean insertFast, int batchSize, List<String> pkeys, List<Map<String,Object>> keyValues)`
`<R> R`	`executeFunc(Function<Connection,R> func)` 回调
`<R> R`	`executeFunc(Function<Connection,R> func, boolean readonly)` 回调
`int`	`executeTemplate(String sqlId, Map<String,Object> paramters)`
`int`	`executeTemplateSource(String sqlSource, Map<String,Object> paramters)`
`<T extends DBObject> boolean`	`exists(T query)`
`<T extends DBObject> boolean`	`existsByPrimaryKeys(Class<T> clz, Object... keyParams)`
`<T extends DBObject> List<T>`	`fetchCascade(T query, Class<T> clz, DBCascadeField... fields)` 查找对象列表,并查询级联字段
`<T extends DBObject> T`	`fetchLinks(T obj)` 根据一个正则表达式，获取对象所有的关联字段
`<T extends DBObject> T`	`fetchLinks(T obj, DBCascadeField... fields)` 根据字段，获取对象所有的关联字段
`void`	`genPojoCodes(String pkg, String srcPath, GenConfig config)` 根据表名生成对应的pojo类
`protected Connection`	`getConnection(DataSource ds)` 获取一个当前线程的连接(事务中)，如果没有，则新建一个。
`protected Connection`	`getConnection(DBContext context, DataSource ds)`
`protected DataSource`	`getDataSource(boolean readonly)` 从clz中获取数据源
`<T extends DBObject> DBDialect`	`getDialect(boolean readonly)` 获取dialect
`DBDynmicSQL`	`getDynmicSQL()`
`DBJooq`	`getJooq()`
`<T> T`	`getMapper(Class<T> mapperInterface)` 通过mapper接口生成dao代理
`DBQueryDSL`	`getQueryDSL()`
`<T extends DBObject> int`	`insert(T obj)` 保存
`<T extends DBObject> int`	`insert(T obj, boolean fast, boolean useOptimisticLock)` 插入结果
`int`	`insertCascade(DBObject obj, DBCascadeField... fields)` 将对象插入数据库同时，也将指定级联字段的所有关联字段关联的对象统统插入相应的数据库
`<T extends DBObject> int`	`insertFast(T obj)` 快速插入方法,不返还主键.
`<T extends DBObject> T`	`insertLinks(T obj, DBCascadeField... fields)` 仅将对象所有的关联字段插入到数据库中，并不包括对象本身
`<T extends DBObject> T`	`insertRelation(T obj, DBCascadeField... fields)` 将对象的一个或者多个，多对多的关联信息，插入数据表
`int`	`insertTemplate(String sqlId, Map<String,Object> paramters, List<String> pkeys, Map<String,Object> keyValues)` 带主键返回的插入
`int`	`insertTemplateSource(String sqlSource, Map<String,Object> paramters, List<String> pkeys, Map<String,Object> keyValues)`
`<T extends DBObject> int`	`merge(T obj)` 合并结果,根据传入主键确定是保存还是修改数据.
`boolean`	`refreshTable(Class<?> clz)` 刷新某张表
`void`	`refreshTable(Class<?> clz, MetadataEventListener listener)` 检查并修改数据库中的表，使其和传入的实体模型保持一致。
`boolean`	`refreshTable(TableMapping meta, MetadataEventListener event, boolean modifyConstraint, boolean modifyIndexes)` 检查并修改数据库中的表，使其和传入的实体模型保持一致。
`boolean`	`refreshTables()` 刷新表
`List<Map<String,Object>>`	`select(Example example)`
`List<Map<String,Object>>`	`select(String sql, Object... paras)` 查询 map ,注意返回结果字段不区分大小写.
`Object[]`	`selectArray(Example example)`
`Object[]`	`selectArray(String sql, Object... parameters)` 查询结果为数组
`Object[]`	`selectArrayTemplate(String sqlId, Map<String,Object> parameters)`
`Object[]`	`selectArrayTemplateSource(String sqlSource, Map<String,Object> parameters)`
`<T extends DBObject> T`	`selectByPrimaryKeys(Class<T> clz, Object... keyParams)` 根据主键查询
`<T extends DBObject> long`	`selectCount(T query)` 查询总数
`<T> void`	`selectIterator(OrmIterator<T> ormIt, Class<T> beanClass, boolean usePage, String sql, Object... parameters)` 是否使用假分页开启迭代模式
`<T> void`	`selectIterator(OrmIterator<T> ormIt, Class<T> beanClass, String sql, Object... parameters)` 数据迭代接口
`<T extends DBObject> void`	`selectIterator(OrmIterator<T> ormIt, T query)` 查询迭代结果.回调形式.
`<T extends DBObject> void`	`selectIterator(OrmIterator<T> ormIt, T query, long start, int limit)` 查询限制条数和起始位置的迭代结果.回调形式.
`<T> void`	`selectIteratorTemplate(OrmIterator<T> ormIt, Class<T> beanClass, String sqlId, Map<String,Object> parameters)`
`<T> void`	`selectIteratorTemplateSource(OrmIterator<T> ormIt, Class<T> beanClass, String sqlSource, Map<String,Object> parameters)`
`<T> List<T>`	`selectList(Class<T> beanClass, Example example)`
`<T> List<T>`	`selectList(Class<T> beanClass, long start, int limit, Example example)`
`<T> List<T>`	`selectList(Class<T> beanClass, long start, int limit, String sql, Object... parameters)`
`<T> List<T>`	`selectList(Class<T> beanClass, SQLContext context)`
`<T> List<T>`	`selectList(Class<T> beanClass, SQLContext context, long start, int limit)`
`<T> List<T>`	`selectList(Class<T> beanClass, String sql, Object... parameters)` 根据sql查询,返回对应的列表
`List<?>`	`selectList(String resultSetMapping, long start, int limit, String sql, Object... parameters)` 根据@SqlResultSetMapping设置返回值,返回的为单个对象,或数组对象
`List<?>`	`selectList(String resultSetMapping, String sql, Object... parameters)` 根据@SqlResultSetMapping设置返回值,返回的为单个对象,或数组对象
`<T extends DBObject> List<T>`	`selectList(T query)` 查询列表
`<T extends DBObject> List<T>`	`selectList(T query, long start, int limit)` 查询列表
`<T> List<T>`	`selectListForUpdate(Class<T> beanClass, Example example)`
`<T extends DBObject> List<T>`	`selectListForUpdate(T query)` 使用select ...
`<T> List<T>`	`selectListTemplate(Class<T> beanClass, String sqlId, Map<String,Object> parameters)`
`<T> List<T>`	`selectListTemplateSource(Class<T> beanClass, long start, int limit, String sqlSource, Map<String,Object> parameters)`
`<T> List<T>`	`selectListTemplateSource(Class<T> beanClass, String sqlSource, Map<String,Object> parameters)`
`<T> T`	`selectOne(Class<T> beanClass, Example example)`
`<T> T`	`selectOne(Class<T> clz, SQLContext context)`
`<T> T`	`selectOne(Class<T> beanClass, String sql, Object... parameters)` 查询单一对象
`Object`	`selectOne(String resultSetMapping, String sql, Object... parameters)` 根据@SqlResultSetMapping设置返回值,返回的为单个对象,或数组对象
`<T extends DBObject> T`	`selectOne(T query)` 查询一条记录，如果结果不唯一则抛出异常
`<T> T`	`selectOneForUpdate(Class<T> beanClass, Example example)`
`<T extends DBObject> T`	`selectOneForUpdate(T query)` 使用select ...
`<T> T`	`selectOneTemplate(Class<T> beanClass, String sqlId, Map<String,Object> parameters)`
`<T> T`	`selectOneTemplateSource(Class<T> beanClass, String sqlSource, Map<String,Object> parameters)`
`<T> Page<T>`	`selectPage(Class<T> clz, SQLContext context, long start, int limit)`
`<T> Page<T>`	`selectPage(long start, int limit, Class<T> beanClass, Example example)`
`<T> Page<T>`	`selectPage(long start, int limit, Class<T> beanClass, String sql, Object... parameters)` 分页查询
`<T extends DBObject> Page<T>`	`selectPage(T query, long start, int limit)` 查询并分页
`<T> Page<T>`	`selectPageRaw(long start, int limit, Class<T> beanClass, String countSql, Object[] countParas, String listSql, Object[] listParas)` 最原始的分页方法,假分页实现,使用result跳过数据,实现
`<T> Page<T>`	`selectPageRaw(long start, int limit, Class<T> beanClass, String countSql, Object[] countParas, String listSql, Object[] listParas, PageStrategy strategy)` 最原始的分页方法,假分页实现,使用result跳过数据,实现
`<T> Page<T>`	`selectPageRawTemplate(long start, int limit, Class<T> beanClass, String countSqlId, Map<String,Object> countParas, String listSqlId, Map<String,Object> listParas)` 最原始的分页方法,使用原生sql实现
`<T> Page<T>`	`selectPageRawTemplateSource(long start, int limit, Class<T> beanClass, String countSqlSource, Map<String,Object> countParas, String listSqlSource, Map<String,Object> pageParas)`
`<T> Page<T>`	`selectPageTemplate(long start, int limit, Class<T> beanClass, String sqlId, Map<String,Object> parameters)`
`<T> Page<T>`	`selectPageTemplateSource(long start, int limit, Class<T> beanClass, String sqlSource, Map<String,Object> parameters)`
`<T> void`	`selectResultSet(ResultSetCallback<T> callback, String sql, Object... parameters)` 数据迭代接口
`<T> void`	`selectStream(OrmStream<T> ormStream, Class<T> beanClass, boolean usePage, String sql, Object... parameters)` 数据迭代接口
`<T> void`	`selectStream(OrmStream<T> ormStream, Class<T> beanClass, String sql, Object... parameters)` 数据迭代接口
`<T extends DBObject> void`	`selectStream(OrmStream<T> ormStream, T query)` stream lambda形式迭代结果.
`<T> void`	`selectStreamTemplate(OrmStream<T> ormStream, Class<T> beanClass, String sqlId, Map<String,Object> parameters)`
`<T> void`	`selectStreamTemplateSource(OrmStream<T> ormStream, Class<T> beanClass, String sqlSource, Map<String,Object> parameters)`
`List<Map<String,Object>>`	`selectTemplate(String sqlId, Map<String,Object> parameter)`
`List<Map<String,Object>>`	`selectTemplateSource(String sqlSource, Map<String,Object> parameter)`
`<T extends DBObject> void`	`setNewOptimisticLockValues(T obj)` 警告:从数据库中获取最新的乐观锁的值到对象中,一般情况下,该方法用不到.慎用.
`<T extends DBObject> void`	`truncate(Class<T> clz)` 清空表数据
`int`	`truncate(Connection con, TableMapping meta)` 执行 truncate table XXXX 命令，快速清光表的数据
`<T extends DBObject> int`	`update(T obj)` 更新对象(乐观锁不作为更新条件)
`<T extends DBObject> int`	`updateAndSet(T obj)` 乐观锁, 以特定字段的值作为限制条件,更新对象,并更新该字段的值.参考字段的Java属性名.必须设置了@Version标签注意:对于时间作为乐观锁,由于数据库和java时间存在差异,如果需要设置更新后的值,需要重新调用OptimisticLock.setNewOptimisticLockValues查询方法设置最新的值.
`int`	`updateCascade(DBObject obj, DBCascadeField... fields)` 将对象更新的同时，也将指定级联字段的所有关联字段关联的对象统统更新
`<T extends DBObject> int`	`updateLinks(T obj, DBCascadeField... fields)` 仅更新对象所有的关联字段，并不包括对象本身
`<T extends DBObject> int`	`updateRelation(T obj, DBCascadeField... fields)` 多对多关联是通过一个中间表将两条数据表记录关联起来。
`<T extends DBObject> int`	`updateWithVersion(T obj)` 根据乐观锁条件更新,并会更新数据库中的乐观锁条件.但不会更新对象的乐观锁字段的值.
`DBClient`	`useContext(DBContext context)` 使用上下文语境(一次性的,每次使用后必须重新设置,供以后扩展使用.)

Methods inherited from class sf.database.dao.DaoSupport
getDialect, setDataSource, start

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - mapperBuilder
```
protected MapperBuilder mapperBuilder
```
  - dbJooq
```
protected volatile DBJooq dbJooq
```
  - dbQueryDSL
```
protected volatile DBQueryDSL dbQueryDSL
```
  - dbDynmicSQL
```
protected volatile DBDynmicSQL dbDynmicSQL
```
  - dbContexts
```
protected ThreadLocal<DBContext> dbContexts
```
    sql执行上下文.
- Constructor Detail
  - DBClient
```
public DBClient(DataSource dataSource)
```
  - DBClient
```
public DBClient()
```
- Method Detail
  - useContext
```
public DBClient useContext(DBContext context)
```
    使用上下文语境(一次性的,每次使用后必须重新设置,供以后扩展使用.)
    
    Specified by:
    
    useContext in interface DBMethod
    
    Parameters:
    
    context - 执行上下文.
    
    Returns:
  - getDataSource
```
protected DataSource getDataSource(boolean readonly)
```
    Description copied from class: DaoSupport
    
    从clz中获取数据源
    
    Overrides:
    
    getDataSource in class DaoSupport
    
    Parameters:
    
    readonly - 是否只读
    
    Returns:
  - getConnection
```
protected Connection getConnection(DataSource ds)
```
    Description copied from class: DaoSupport
    
    获取一个当前线程的连接(事务中)，如果没有，则新建一个。
    
    Overrides:
    
    getConnection in class DaoSupport
  - getConnection
```
protected Connection getConnection(DBContext context,
                                   DataSource ds)
```
  - closeConnection
```
protected void closeConnection(Connection conn,
                               DataSource ds)
```
    Description copied from class: DaoSupport
    
    释放一个连接，如果 Connection 不在事务中，则关闭它，否则不处理。
    
    Overrides:
    
    closeConnection in class DaoSupport
  - closeConnection
```
protected void closeConnection(DBContext context,
                               Connection conn,
                               DataSource ds)
```
  - getDialect
```
public <T extends DBObject> DBDialect getDialect(boolean readonly)
```
    Description copied from interface: DBMethod
    
    获取dialect
    
    Specified by:
    
    getDialect in interface DBMethod
    
    Parameters:
    
    readonly - 是否只读
    
    Returns:
  - existsByPrimaryKeys
```
public <T extends DBObject> boolean existsByPrimaryKeys(Class<T> clz,
                                                        Object... keyParams)
```
    Specified by:
    
    existsByPrimaryKeys in interface DBMethod
    
    Returns:
  - exists
```
public <T extends DBObject> boolean exists(T query)
```
    Specified by:
    
    exists in interface DBMethod
    
    Returns:
  - selectByPrimaryKeys
```
public <T extends DBObject> T selectByPrimaryKeys(Class<T> clz,
                                                  Object... keyParams)
```
    Description copied from interface: DBMethod
    
    根据主键查询
    
    Specified by:
    
    selectByPrimaryKeys in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    clz - 实体类
    
    keyParams - 主键参数
    
    Returns:
    
    实体
  - selectCount
```
public <T extends DBObject> long selectCount(T query)
```
    Description copied from interface: DBMethod
    
    查询总数
    
    Specified by:
    
    selectCount in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    query - 查询
    
    Returns:
    
    实体
  - selectOne
```
public <T extends DBObject> T selectOne(T query)
```
    Description copied from interface: DBMethod
    
    查询一条记录，如果结果不唯一则抛出异常
    
    Specified by:
    
    selectOne in interface DBMethod
    
    Parameters:
    
    query - 查询条件
    
    Returns:
    
    查询结果
  - selectOneForUpdate
```
public <T extends DBObject> T selectOneForUpdate(T query)
```
    Description copied from interface: DBMethod
    
    使用select ... for update 查询数据
    
    Specified by:
    
    selectOneForUpdate in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    query - 查询条件
    
    Returns:
    
    实体
  - selectList
```
public <T extends DBObject> List<T> selectList(T query)
```
    Description copied from interface: DBMethod
    
    查询列表
    Specified by:
    
    selectList in interface DBMethod
    
    Parameters:
    query - 查询请求。
    
    如果设置了Query条件，按query条件查询。否则——
    
    如果设置了主键值，按主键查询，否则——
    
    按所有设置过值的字段作为条件查询。
    Returns:
    
    结果
  - selectList
```
public <T extends DBObject> List<T> selectList(T query,
                                               long start,
                                               int limit)
```
    Description copied from interface: DBMethod
    
    查询列表
    
    Specified by:
    
    selectList in interface DBMethod
    
    Parameters:
    
    query - 查询请求。
    
    start - 开始条数
    
    limit - 结束条数
    
    Returns:
  - selectListForUpdate
```
public <T extends DBObject> List<T> selectListForUpdate(T query)
```
    Description copied from interface: DBMethod
    
    使用select ... for update 查询数据
    
    Specified by:
    
    selectListForUpdate in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    query - 查询
    
    Returns:
    
    实体
  - selectPage
```
public <T extends DBObject> Page<T> selectPage(T query,
                                               long start,
                                               int limit)
```
    Description copied from interface: DBMethod
    
    查询并分页
    
    Specified by:
    
    selectPage in interface DBMethod
    
    Parameters:
    
    query - 查询请求
    
    start - 起始记录，offset。从0开始。
    
    limit - 限制记录条数。如每页10条传入10。
    
    Returns:
    
    分页对象
  - selectPage
```
public <T> Page<T> selectPage(Class<T> clz,
                              SQLContext context,
                              long start,
                              int limit)
```
    Specified by:
    
    selectPage in interface DBMethod
    
    Returns:
  - selectOne
```
public <T> T selectOne(Class<T> clz,
                       SQLContext context)
```
    Specified by:
    
    selectOne in interface DBMethod
    
    Returns:
  - selectList
```
public <T> List<T> selectList(Class<T> beanClass,
                              SQLContext context)
```
    Specified by:
    
    selectList in interface DBMethod
    
    Returns:
  - selectList
```
public <T> List<T> selectList(Class<T> beanClass,
                              SQLContext context,
                              long start,
                              int limit)
```
    Specified by:
    
    selectList in interface DBMethod
    
    Returns:
  - selectIterator
```
public <T extends DBObject> void selectIterator(OrmIterator<T> ormIt,
                                                T query)
```
    Description copied from interface: DBMethod
    
    查询迭代结果.回调形式.
    
    Specified by:
    
    selectIterator in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    ormIt - 迭代回调方法
    
    query - 查询
  - selectIterator
```
public <T extends DBObject> void selectIterator(OrmIterator<T> ormIt,
                                                T query,
                                                long start,
                                                int limit)
```
    Description copied from interface: DBMethod
    
    查询限制条数和起始位置的迭代结果.回调形式.
    
    Specified by:
    
    selectIterator in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    ormIt - 迭代回调方法
    
    query - 查询
    
    start - 起始数
    
    limit - 限制数
  - selectStream
```
public <T extends DBObject> void selectStream(OrmStream<T> ormStream,
                                              T query)
```
    Description copied from interface: DBMethod
    
    stream lambda形式迭代结果.
    
    Specified by:
    
    selectStream in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    ormStream - 迭代回调方法
    
    query - 查询
  - insert
```
public <T extends DBObject> int insert(T obj)
```
    Description copied from interface: DBMethod
    
    保存
    
    Specified by:
    
    insert in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    obj - 实体
    
    Returns:
    
    执行结果
  - insertFast
```
public <T extends DBObject> int insertFast(T obj)
```
    Description copied from interface: DBMethod
    
    快速插入方法,不返还主键.
    
    Specified by:
    
    insertFast in interface DBMethod
    
    Parameters:
    
    obj - 实体
    
    Returns:
    
    执行结果
  - insert
```
public <T extends DBObject> int insert(T obj,
                                       boolean fast,
                                       boolean useOptimisticLock)
```
    Description copied from interface: DBMethod
    
    插入结果
    
    Specified by:
    
    insert in interface DBMethod
    
    Parameters:
    
    obj - 实体
    
    fast - 是否为快速插入
    
    useOptimisticLock - 是否使用乐观锁功能
    
    Returns:
    
    执行结果
  - merge
```
public <T extends DBObject> int merge(T obj)
```
    Description copied from interface: DBMethod
    
    合并结果,根据传入主键确定是保存还是修改数据.
    
    Specified by:
    
    merge in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    obj - 实体
    
    Returns:
    
    执行结果
  - update
```
public <T extends DBObject> int update(T obj)
```
    Description copied from interface: DBMethod
    
    更新对象(乐观锁不作为更新条件)
    
    Specified by:
    
    update in interface DBMethod
    
    Parameters:
    
    obj - 待更新的实体
    
    Returns:
    
    返还执行的记录数
  - updateAndSet
```
public <T extends DBObject> int updateAndSet(T obj)
```
    Description copied from interface: DBMethod
    
    乐观锁, 以特定字段的值作为限制条件,更新对象,并更新该字段的值.参考字段的Java属性名.必须设置了@Version标签注意:对于时间作为乐观锁,由于数据库和java时间存在差异,如果需要设置更新后的值,需要重新调用OptimisticLock.setNewOptimisticLockValues查询方法设置最新的值. 锁更新规则
    1.对于数字,则+1;
    2.对于日期取当前时间戳.
    3.对于字符串,取UUID的值.
    
    执行的sql如下:
    update t_user set age=30, city="广州", version=version+1 where name="wendal" and version=124;
    
    Specified by:
    
    updateAndSet in interface DBMethod
    
    Parameters:
    
    obj - 需要更新的对象, 必须带主键,并设置过主键的值.
    
    Returns:
    
    若更新成功, 返回值大于0, 否则等于0
  - updateWithVersion
```
public <T extends DBObject> int updateWithVersion(T obj)
```
    Description copied from interface: DBMethod
    
    根据乐观锁条件更新,并会更新数据库中的乐观锁条件.但不会更新对象的乐观锁字段的值. 基于版本的更新，版本不一样无法更新数据
    
    Specified by:
    
    updateWithVersion in interface DBMethod
    
    Parameters:
    
    obj - 需要更新的对象, 必须有@Version属性
    
    Returns:
    
    若更新成功, 大于0, 否则等于0
  - setNewOptimisticLockValues
```
public <T extends DBObject> void setNewOptimisticLockValues(T obj)
```
    Description copied from interface: DBMethod
    
    警告:从数据库中获取最新的乐观锁的值到对象中,一般情况下,该方法用不到.慎用.
    
    Specified by:
    
    setNewOptimisticLockValues in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    obj - 实体
  - deleteByPrimaryKeys
```
public <T extends DBObject> int deleteByPrimaryKeys(Class<T> clz,
                                                    Object... keyParams)
```
    Description copied from interface: DBMethod
    
    根据主键删除实体
    
    Specified by:
    
    deleteByPrimaryKeys in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    clz - 实体类
    
    keyParams - 主键值
    
    Returns:
    
    执行结果
  - delete
```
public <T extends DBObject> int delete(T obj)
```
    Description copied from interface: DBMethod
    
    删除实体,根据设置的值删除
    
    Specified by:
    
    delete in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    obj - 实体
    
    Returns:
    
    执行结果
  - truncate
```
public <T extends DBObject> void truncate(Class<T> clz)
```
    Description copied from interface: DBMethod
    
    清空表数据
    
    Specified by:
    
    truncate in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    clz - 实体类
  - truncate
```
public int truncate(Connection con,
                    TableMapping meta)
```
    执行 truncate table XXXX 命令，快速清光表的数据
    
    Parameters:
    
    meta - 表名 // route 路由结果。该表对应的所有实例。
  - batchInsert
```
public int[] batchInsert(Collection<? extends DBObject> modelList)
```
    Description copied from interface: DBMethod
    
    批量插入
    
    Specified by:
    
    batchInsert in interface DBMethod
    
    Parameters:
    
    modelList - 对象列表
    
    Returns:
    
    执行结果
  - batchInsert
```
public int[] batchInsert(Collection<? extends DBObject> modelList,
                         boolean useAll)
```
    Description copied from interface: DBMethod
    
    批量插入
    
    Specified by:
    
    batchInsert in interface DBMethod
    
    Parameters:
    
    modelList - 对象列表
    
    useAll - 是否单一sql做完批量插入
    
    Returns:
    
    执行结果
  - batchInsertFast
```
public int[] batchInsertFast(Collection<? extends DBObject> modelList)
```
    Description copied from interface: DBMethod
    
    快速插入方法
    
    Specified by:
    
    batchInsertFast in interface DBMethod
    
    Parameters:
    
    modelList - 对象列表
    
    Returns:
    
    执行结果
  - batchInsertFast
```
public int[] batchInsertFast(Collection<? extends DBObject> modelList,
                             boolean useAll)
```
    Description copied from interface: DBMethod
    
    快速插入方法
    
    Specified by:
    
    batchInsertFast in interface DBMethod
    
    Parameters:
    
    modelList - 对象列表
    
    useAll - 是否单一sql做完批量插入
    
    Returns:
    
    执行结果
  - batchUpdate
```
public int[] batchUpdate(Collection<? extends DBObject> modelList)
```
    Description copied from interface: DBMethod
    
    更新对象,如果有乐观锁,会根据乐观锁条件更新,并会更新数据库中的乐观锁条件.但不会更新对象的乐观锁字段的值.
    
    Specified by:
    
    batchUpdate in interface DBMethod
    
    Parameters:
    
    modelList - 对象列表
    
    Returns:
    
    执行结果
  - batchUpdate
```
public int[] batchUpdate(Collection<? extends DBObject> modelList,
                         boolean useNvl)
```
    Description copied from interface: DBMethod
    
    更新对象,如果有乐观锁,会根据乐观锁条件更新,并会更新数据库中的乐观锁条件.但不会更新对象的乐观锁字段的值.
    
    Specified by:
    
    batchUpdate in interface DBMethod
    
    Parameters:
    
    modelList - 对象列表
    
    useNvl - 是否使用nvl函数去重
    
    Returns:
    
    执行结果
  - batchDelete
```
public int[] batchDelete(Collection<? extends DBObject> modelList)
```
    Description copied from interface: DBMethod
    
    批量删除
    
    Specified by:
    
    batchDelete in interface DBMethod
    
    Parameters:
    
    modelList - 对象列表
    
    Returns:
    
    执行结果
  - genPojoCodes
```
public void genPojoCodes(String pkg,
                         String srcPath,
                         GenConfig config)
```
    Description copied from interface: DBMethod
    
    根据表名生成对应的pojo类
    
    Specified by:
    
    genPojoCodes in interface DBMethod
    
    Parameters:
    
    pkg - 包名,如 com.test
    
    config - 配置生成的风格
  - createTable
```
public boolean createTable(Class<?> clz)
```
    Description copied from interface: DBMethod
    
    建表
    
    Specified by:
    
    createTable in interface DBMethod
    
    Parameters:
    
    clz -
    
    Returns:
  - createTables
```
public boolean createTables()
```
    创建全部表
    
    Specified by:
    
    createTables in interface DBMethod
    
    Returns:
  - dropTable
```
public boolean dropTable(Class<?> clz)
```
    Description copied from interface: DBMethod
    
    删除表
    
    Specified by:
    
    dropTable in interface DBMethod
    
    Returns:
  - refreshTables
```
public boolean refreshTables()
```
    Description copied from interface: DBMethod
    
    刷新表
    
    Specified by:
    
    refreshTables in interface DBMethod
    
    Returns:
  - refreshTable
```
public boolean refreshTable(Class<?> clz)
```
    Description copied from interface: DBMethod
    
    刷新某张表
    
    Specified by:
    
    refreshTable in interface DBMethod
    
    Parameters:
    
    clz - 实体类
    
    Returns:
  - refreshTable
```
public void refreshTable(Class<?> clz,
                         MetadataEventListener listener)
                  throws SQLException
```
    检查并修改数据库中的表，使其和传入的实体模型保持一致。
    
    Specified by:
    
    refreshTable in interface DBMethod
    
    Parameters:
    
    clz - 要更新的表对应的类
    
    listener - 事件监听器，可以监听刷新过程的事件
    
    Throws:
    
    SQLException
  - refreshTable
```
public boolean refreshTable(TableMapping meta,
                            MetadataEventListener event,
                            boolean modifyConstraint,
                            boolean modifyIndexes)
                     throws SQLException
```
    检查并修改数据库中的表，使其和传入的实体模型保持一致。
    
    Specified by:
    
    refreshTable in interface DBMethod
    
    Parameters:
    
    meta - 要更新的表的元数据
    
    event - 事件监听器，可以监听刷新过程的事件
    
    modifyConstraint - 更改约束
    
    modifyIndexes - 更改索引
    
    Returns:
    
    Throws:
    
    SQLException
    
    See Also:
    
    MetadataEventListener
  - fetchCascade
```
public <T extends DBObject> List<T> fetchCascade(T query,
                                                 Class<T> clz,
                                                 DBCascadeField... fields)
```
    Description copied from interface: DBMethod
    
    查找对象列表,并查询级联字段
    
    Specified by:
    
    fetchCascade in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    query - 查询
    
    clz - 实体类
    
    fields - 级联字段
    
    Returns:
    
    列表
  - fetchLinks
```
public <T extends DBObject> T fetchLinks(T obj)
```
    Description copied from interface: DBMethod
    
    根据一个正则表达式，获取对象所有的关联字段
    
    Specified by:
    
    fetchLinks in interface DBMethod
    
    Parameters:
    
    obj - 数据对象,不可以是Class啊!!!传对象或集合啊!!!
    
    Returns:
    
    更新后的数据对象本身
    
    See Also:
    
    OneToOne, ManyToMany, OneToMany
  - fetchLinks
```
public <T extends DBObject> T fetchLinks(T obj,
                                         DBCascadeField... fields)
```
    Description copied from interface: DBMethod
    
    根据字段，获取对象所有的关联字段
    
    Specified by:
    
    fetchLinks in interface DBMethod
    
    Parameters:
    
    obj - 数据对象,不可以是Class啊!!!传对象或集合啊!!!
    
    Returns:
    
    更新后的数据对象本身
    
    See Also:
    
    OneToOne, ManyToMany, OneToMany
  - execute
```
public int execute(SQLContext context)
```
    Specified by:
    
    execute in interface DBMethod
    
    Returns:
  - insertCascade
```
public int insertCascade(DBObject obj,
                         DBCascadeField... fields)
```
    Description copied from interface: DBMethod
    
    将对象插入数据库同时，也将指定级联字段的所有关联字段关联的对象统统插入相应的数据库
    关于关联字段更多信息，请参看 '@One' | '@Many' | '@ManyMany' 更多的描述
    
    Specified by:
    
    insertCascade in interface DBMethod
    
    fields - 指定字段,控制力度更细,至少一个或多个描述了什么样的关联字段将被关注。如果为 null，则表示全部的关联字段都会被插入
    
    Returns:
  - insertLinks
```
public <T extends DBObject> T insertLinks(T obj,
                                          DBCascadeField... fields)
```
    Description copied from interface: DBMethod
    
    仅将对象所有的关联字段插入到数据库中，并不包括对象本身
    
    Specified by:
    
    insertLinks in interface DBMethod
    
    Parameters:
    
    obj - 数据对象
    
    fields - 字段名称，描述了什么样的关联字段将被关注。如果为 null，则表示全部的关联字段都会被插入
    
    Returns:
    
    数据对象本身
    
    See Also:
    
    OneToOne, ManyToMany, OneToMany
  - insertRelation
```
public <T extends DBObject> T insertRelation(T obj,
                                             DBCascadeField... fields)
```
    Description copied from interface: DBMethod
    
    将对象的一个或者多个，多对多的关联信息，插入数据表
    
    Specified by:
    
    insertRelation in interface DBMethod
    
    Parameters:
    
    obj - 对象
    
    fields - 正则表达式，描述了那种多对多关联字段将被执行该操作
    
    Returns:
    
    对象自身
    
    See Also:
    
    ManyToMany
  - updateCascade
```
public int updateCascade(DBObject obj,
                         DBCascadeField... fields)
```
    Description copied from interface: DBMethod
    
    将对象更新的同时，也将指定级联字段的所有关联字段关联的对象统统更新
    关于关联字段更多信息，请参看 '@One' | '@Many' | '@ManyMany' 更多的描述
    
    Specified by:
    
    updateCascade in interface DBMethod
    
    Parameters:
    
    obj - 数据对象
    
    fields - 指定字段,控制力度更细,至少一个或多个,描述了什么样的关联字段将被关注。如果为 null，则表示全部的关联字段都会被更新
    
    Returns:
    
    执行结果
  - updateLinks
```
public <T extends DBObject> int updateLinks(T obj,
                                            DBCascadeField... fields)
```
    Description copied from interface: DBMethod
    
    仅更新对象所有的关联字段，并不包括对象本身
    
    Specified by:
    
    updateLinks in interface DBMethod
    
    Parameters:
    
    obj - 数据对象
    
    fields - 字段名称，描述了什么样的关联字段将被关注。如果为 null，则表示全部的关联字段都会被更新
    
    Returns:
    
    对象内部更新的级联数量
    
    See Also:
    
    OneToOne, ManyToMany, OneToMany
  - updateRelation
```
public <T extends DBObject> int updateRelation(T obj,
                                               DBCascadeField... fields)
```
    Description copied from interface: DBMethod
    
    多对多关联是通过一个中间表将两条数据表记录关联起来。
    而这个中间表可能还有其他的字段，比如描述关联的权重等
    这个操作可以让你一次更新某一个对象中多个多对多关联的数据
    
    Specified by:
    
    updateRelation in interface DBMethod
    
    Parameters:
    
    obj - 数据对象
    
    fields - 字段名称，描述了那种多对多关联字段将被执行该操作
    
    Returns:
    
    共有多少条数据被更新
    
    See Also:
    
    ManyToMany
  - deleteCascade
```
public <T extends DBObject> int deleteCascade(T obj,
                                              DBCascadeField... fields)
```
    Description copied from interface: DBMethod
    
    将对象删除的同时，也将指定级联字段的所有关联字段关联的对象统统删除 注意：
    Java 对象的字段会被保留，这里的删除，将只会删除数据库中的记录
    关于关联字段更多信息，请参看 '@One' | '@Many' | '@ManyMany' 更多的描述
    
    Specified by:
    
    deleteCascade in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    obj - 对象
    
    fields - 指定字段,控制力度更细,至少一个或多个描述了什么样的关联字段将被关注。如果为 null，则表示全部的关联字段都会被删除
    
    Returns:
    
    执行结果
  - deleteLinks
```
public <T extends DBObject> int deleteLinks(T obj,
                                            DBCascadeField... fields)
```
    Description copied from interface: DBMethod
    
    仅删除对象所有的关联字段，并不包括对象本身。 注意：
    Java 对象的字段会被保留，这里的删除，将只会删除数据库中的记录
    关于关联字段更多信息，请参看 '@One' | '@Many' | '@ManyMany' 更多的描述
    
    Specified by:
    
    deleteLinks in interface DBMethod
    
    Parameters:
    
    obj - 数据对象
    
    fields - 字段名称，描述了什么样的关联字段将被关注。如果为 null，则表示全部的关联字段都会被删除
    
    Returns:
    
    被影响的记录行数
    
    See Also:
    
    OneToOne, ManyToOne, ManyToMany
  - deleteRelation
```
public <T extends DBObject> int deleteRelation(T obj,
                                               DBCascadeField... fields)
```
    Description copied from interface: DBMethod
    
    多对多关联是通过一个中间表将两条数据表记录关联起来。
    而这个中间表可能还有其他的字段，比如描述关联的权重等
    这个操作可以让你一次删除某一个对象中多个多对多关联的数据
    
    Specified by:
    
    deleteRelation in interface DBMethod
    
    fields - 字段名称，描述了那种多对多关联字段将被执行该操作
    
    Returns:
    
    共有多少条数据被更新
    
    See Also:
    
    ManyToMany
  - selectPage
```
public <T> Page<T> selectPage(long start,
                              int limit,
                              Class<T> beanClass,
                              Example example)
```
    Specified by:
    
    selectPage in interface DBMethod
    
    Returns:
  - selectArray
```
public Object[] selectArray(Example example)
```
    Specified by:
    
    selectArray in interface DBMethod
    
    Returns:
  - selectList
```
public <T> List<T> selectList(Class<T> beanClass,
                              Example example)
```
    Specified by:
    
    selectList in interface DBMethod
    
    Returns:
  - selectList
```
public <T> List<T> selectList(Class<T> beanClass,
                              long start,
                              int limit,
                              Example example)
```
    Specified by:
    
    selectList in interface DBMethod
    
    Returns:
  - selectListForUpdate
```
public <T> List<T> selectListForUpdate(Class<T> beanClass,
                                       Example example)
```
    Specified by:
    
    selectListForUpdate in interface DBMethod
    
    Returns:
  - selectOne
```
public <T> T selectOne(Class<T> beanClass,
                       Example example)
```
    Specified by:
    
    selectOne in interface DBMethod
    
    Returns:
  - selectOneForUpdate
```
public <T> T selectOneForUpdate(Class<T> beanClass,
                                Example example)
```
    Specified by:
    
    selectOneForUpdate in interface DBMethod
    
    Returns:
  - select
```
public List<Map<String,Object>> select(Example example)
```
    Specified by:
    
    select in interface DBMethod
    
    Returns:
  - select
```
public List<Map<String,Object>> select(String sql,
                                       Object... paras)
```
    Description copied from interface: DBMethod
    
    查询 map ,注意返回结果字段不区分大小写.
    
    Specified by:
    
    select in interface DBMethod
    
    Parameters:
    
    sql - 原始语句
    
    paras - 参数
    
    Returns:
    
    列表
  - selectOne
```
public <T> T selectOne(Class<T> beanClass,
                       String sql,
                       Object... parameters)
```
    Description copied from interface: DBMethod
    
    查询单一对象
    
    Specified by:
    
    selectOne in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    beanClass - 实体类
    
    sql - 语句
    
    parameters - 参数
    
    Returns:
    
    单一对象
  - selectList
```
public <T> List<T> selectList(Class<T> beanClass,
                              String sql,
                              Object... parameters)
```
    Description copied from interface: DBMethod
    
    根据sql查询,返回对应的列表
    
    Specified by:
    
    selectList in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    beanClass - 返回结果,可以为实体类,Map,List,Object[]
    
    sql - 原始语句
    
    parameters - 参数
    
    Returns:
    
    列表
  - selectList
```
public <T> List<T> selectList(Class<T> beanClass,
                              long start,
                              int limit,
                              String sql,
                              Object... parameters)
```
    Specified by:
    
    selectList in interface DBMethod
    
    Returns:
  - selectArray
```
public Object[] selectArray(String sql,
                            Object... parameters)
```
    Description copied from interface: DBMethod
    
    查询结果为数组
    
    Specified by:
    
    selectArray in interface DBMethod
    
    Parameters:
    
    sql - 原始语句
    
    parameters - 参数
    
    Returns:
    
    数组
  - selectPage
```
public <T> Page<T> selectPage(long start,
                              int limit,
                              Class<T> beanClass,
                              String sql,
                              Object... parameters)
```
    Description copied from interface: DBMethod
    
    分页查询
    
    Specified by:
    
    selectPage in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    start - 起始位置
    
    limit - 限制数量
    
    beanClass - 返回结果,可以为实体类,Map,List,Object[]
    
    sql - 原始语句
    
    parameters - 参数
    
    Returns:
    
    分页结果
  - selectPageRaw
```
public <T> Page<T> selectPageRaw(long start,
                                 int limit,
                                 Class<T> beanClass,
                                 String countSql,
                                 Object[] countParas,
                                 String listSql,
                                 Object[] listParas)
```
    Description copied from interface: DBMethod
    
    最原始的分页方法,假分页实现,使用result跳过数据,实现
    
    Specified by:
    
    selectPageRaw in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    start - 起始位置
    
    limit - 限制数量
    
    beanClass - 返回结果,可以为实体类,Map,List,Object[]
    
    countSql - 查询总数的语句
    
    countParas - 查询总数的参数
    
    listSql - 查询列表的语句,不能包含限制条数(start和limit)的内容.
    
    listParas - 查询列表的参数
    
    Returns:
    
    分页结果
  - selectPageRaw
```
public <T> Page<T> selectPageRaw(long start,
                                 int limit,
                                 Class<T> beanClass,
                                 String countSql,
                                 Object[] countParas,
                                 String listSql,
                                 Object[] listParas,
                                 PageStrategy strategy)
```
    Description copied from interface: DBMethod
    
    最原始的分页方法,假分页实现,使用result跳过数据,实现
    
    Specified by:
    
    selectPageRaw in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    start - 起始位置
    
    limit - 限制数量
    
    beanClass - 返回结果,可以为实体类,Map,List,Object[]
    
    countSql - 查询总数的语句
    
    countParas - 查询总数的参数
    
    listSql - 查询列表的语句
    
    listParas - 查询列表的参数
    
    strategy - 分页策略
    
    Returns:
    
    分页结果
  - selectIterator
```
public <T> void selectIterator(OrmIterator<T> ormIt,
                               Class<T> beanClass,
                               String sql,
                               Object... parameters)
```
    Description copied from interface: DBMethod
    
    数据迭代接口
    
    Specified by:
    
    selectIterator in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    ormIt - 回调
    
    beanClass - 返回结果,可以为实体类,Map,List,Object[]
    
    sql - 原始语句
    
    parameters - 参数
  - selectIterator
```
public <T> void selectIterator(OrmIterator<T> ormIt,
                               Class<T> beanClass,
                               boolean usePage,
                               String sql,
                               Object... parameters)
```
    Description copied from interface: DBMethod
    
    是否使用假分页开启迭代模式
    
    Specified by:
    
    selectIterator in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    ormIt - 回调
    
    beanClass - 返回结果,可以为实体类,Map,List,Object[]
    
    usePage - 是否使用分页模式,如果为true,使用分页语句实现迭代功能
    
    sql - 原始语句
    
    parameters - 泛型
  - selectStream
```
public <T> void selectStream(OrmStream<T> ormStream,
                             Class<T> beanClass,
                             String sql,
                             Object... parameters)
```
    Description copied from interface: DBMethod
    
    数据迭代接口
    
    Specified by:
    
    selectStream in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    ormStream - 回调
    
    beanClass - 返回结果,可以为实体类,Map,List,Object[]
    
    sql - 原始语句
    
    parameters - 参数
  - selectStream
```
public <T> void selectStream(OrmStream<T> ormStream,
                             Class<T> beanClass,
                             boolean usePage,
                             String sql,
                             Object... parameters)
```
    Description copied from interface: DBMethod
    
    数据迭代接口
    
    Specified by:
    
    selectStream in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    ormStream - 回调
    
    beanClass - 返回结果,可以为实体类,Map,List,Object[]
    
    usePage - 是否使用分页语句实现迭代
    
    sql - 原始语句
    
    parameters - 参数
  - selectResultSet
```
public <T> void selectResultSet(ResultSetCallback<T> callback,
                                String sql,
                                Object... parameters)
```
    Description copied from interface: DBMethod
    
    数据迭代接口
    
    Specified by:
    
    selectResultSet in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    callback - 回调
    
    sql - 原始语句
    
    parameters - 参数
  - execute
```
public <T> T execute(ConnectionCallback<T> action)
```
    Description copied from interface: DBMethod
    
    数据迭代接口执行回调,主要是用于存储过程调用直接获取connection,注意连接不可手动关闭
    
    Specified by:
    
    execute in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    action - 回调
    
    Returns:
    
    结果
  - execute
```
public <T> T execute(ConnectionCallback<T> action,
                     boolean readonly)
```
    Description copied from interface: DBMethod
    
    数据迭代接口执行回调,主要是用于存储过程调用直接获取connection,注意连接不可手动关闭
    
    Specified by:
    
    execute in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    action - 回调
    
    readonly - 是否只读
    
    Returns:
    
    结果
  - execute
```
public <R> R execute(Function<DataSource,R> func,
                     boolean readonly)
```
    Specified by:
    
    execute in interface DBMethod
    
    Returns:
  - executeFunc
```
public <R> R executeFunc(Function<Connection,R> func,
                         boolean readonly)
```
    Description copied from interface: DBMethod
    
    回调
    
    Specified by:
    
    executeFunc in interface DBMethod
    
    Returns:
  - executeFunc
```
public <R> R executeFunc(Function<Connection,R> func)
```
    Description copied from interface: DBMethod
    
    回调
    
    Specified by:
    
    executeFunc in interface DBMethod
    
    Returns:
  - execute
```
public int execute(String sql,
                   Object... parameters)
```
    Description copied from interface: DBMethod
    
    执行单一sql
    
    Specified by:
    
    execute in interface DBMethod
    
    Parameters:
    
    sql - 原始语句
    
    parameters - 参数
    
    Returns:
    
    执行结果
  - executeBatch
```
public int[] executeBatch(String sql,
                          List<Object[]> parameters)
```
    Description copied from interface: DBMethod
    
    批量执行SQL
    
    Specified by:
    
    executeBatch in interface DBMethod
    
    Parameters:
    
    sql - 原始语句
    
    parameters - 参数
    
    Returns:
    
    执行结果
  - executeBatch
```
public int[] executeBatch(String sql,
                          List<Object[]> parameters,
                          boolean insertFast,
                          int batchSize,
                          List<String> pkeys,
                          List<Map<String,Object>> keyValues)
```
    Specified by:
    
    executeBatch in interface DBMethod
    
    Returns:
  - selectList
```
public List<?> selectList(String resultSetMapping,
                          String sql,
                          Object... parameters)
```
    Description copied from interface: DBMethod
    
    根据@SqlResultSetMapping设置返回值,返回的为单个对象,或数组对象
    
    Specified by:
    
    selectList in interface DBMethod
    
    Parameters:
    
    resultSetMapping - @SqlResultSetMapping 中的name
    
    Returns:
  - selectList
```
public List<?> selectList(String resultSetMapping,
                          long start,
                          int limit,
                          String sql,
                          Object... parameters)
```
    Description copied from interface: DBMethod
    
    根据@SqlResultSetMapping设置返回值,返回的为单个对象,或数组对象
    
    Specified by:
    
    selectList in interface DBMethod
    
    Parameters:
    
    resultSetMapping - @SqlResultSetMapping 中的name
    
    Returns:
  - selectOne
```
public Object selectOne(String resultSetMapping,
                        String sql,
                        Object... parameters)
```
    Description copied from interface: DBMethod
    
    根据@SqlResultSetMapping设置返回值,返回的为单个对象,或数组对象
    
    Specified by:
    
    selectOne in interface DBMethod
    
    Parameters:
    
    resultSetMapping - @SqlResultSetMapping 中的name
    
    Returns:
  - selectTemplate
```
public List<Map<String,Object>> selectTemplate(String sqlId,
                                               Map<String,Object> parameter)
```
    Specified by:
    
    selectTemplate in interface DBMethod
    
    Returns:
  - selectOneTemplate
```
public <T> T selectOneTemplate(Class<T> beanClass,
                               String sqlId,
                               Map<String,Object> parameters)
```
    Specified by:
    
    selectOneTemplate in interface DBMethod
    
    Returns:
  - selectArrayTemplate
```
public Object[] selectArrayTemplate(String sqlId,
                                    Map<String,Object> parameters)
```
    Specified by:
    
    selectArrayTemplate in interface DBMethod
    
    Returns:
  - selectPageTemplate
```
public <T> Page<T> selectPageTemplate(long start,
                                      int limit,
                                      Class<T> beanClass,
                                      String sqlId,
                                      Map<String,Object> parameters)
```
    Specified by:
    
    selectPageTemplate in interface DBMethod
    
    Returns:
  - selectPageRawTemplate
```
public <T> Page<T> selectPageRawTemplate(long start,
                                         int limit,
                                         Class<T> beanClass,
                                         String countSqlId,
                                         Map<String,Object> countParas,
                                         String listSqlId,
                                         Map<String,Object> listParas)
```
    Description copied from interface: DBMethod
    
    最原始的分页方法,使用原生sql实现
    
    Specified by:
    
    selectPageRawTemplate in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    start - 起始位置
    
    limit - 限制数量
    
    beanClass - 返回结果,可以为实体类,Map,List,Object[]
    
    countSqlId - 查询总数的语句id
    
    countParas - 查询总数的参数
    
    listSqlId - 分页列表查询语句id,不能包含了start和limit的内容
    
    listParas - 分页列表查询参数
    
    Returns:
    
    分页结果
  - selectIteratorTemplate
```
public <T> void selectIteratorTemplate(OrmIterator<T> ormIt,
                                       Class<T> beanClass,
                                       String sqlId,
                                       Map<String,Object> parameters)
```
    Specified by:
    
    selectIteratorTemplate in interface DBMethod
  - selectStreamTemplate
```
public <T> void selectStreamTemplate(OrmStream<T> ormStream,
                                     Class<T> beanClass,
                                     String sqlId,
                                     Map<String,Object> parameters)
```
    Specified by:
    
    selectStreamTemplate in interface DBMethod
  - insertTemplate
```
public int insertTemplate(String sqlId,
                          Map<String,Object> paramters,
                          List<String> pkeys,
                          Map<String,Object> keyValues)
```
    Description copied from interface: DBMethod
    
    带主键返回的插入
    
    Specified by:
    
    insertTemplate in interface DBMethod
    
    pkeys - 主键列
    
    keyValues - 可以插入值的Map,一般为new HashMap();
    
    Returns:
  - executeTemplate
```
public int executeTemplate(String sqlId,
                           Map<String,Object> paramters)
```
    Specified by:
    
    executeTemplate in interface DBMethod
    
    Returns:
  - executeBatchTemplate
```
public int[] executeBatchTemplate(String sqlId,
                                  List<Map<String,Object>> parameters)
```
    Specified by:
    
    executeBatchTemplate in interface DBMethod
    
    Returns:
  - executeBatchTemplate
```
public int[] executeBatchTemplate(String sqlId,
                                  List<Map<String,Object>> parameters,
                                  boolean insertFast,
                                  int batchSize,
                                  List<String> pkeys,
                                  List<Map<String,Object>> keyValues)
```
    Description copied from interface: DBMethod
    
    批量处理,带返回主键值的功能.
    
    Specified by:
    
    executeBatchTemplate in interface DBMethod
    
    Returns:
  - selectListTemplate
```
public <T> List<T> selectListTemplate(Class<T> beanClass,
                                      String sqlId,
                                      Map<String,Object> parameters)
```
    Specified by:
    
    selectListTemplate in interface DBMethod
    
    Returns:
  - selectTemplateSource
```
public List<Map<String,Object>> selectTemplateSource(String sqlSource,
                                                     Map<String,Object> parameter)
```
    Specified by:
    
    selectTemplateSource in interface DBMethod
    
    Returns:
  - selectOneTemplateSource
```
public <T> T selectOneTemplateSource(Class<T> beanClass,
                                     String sqlSource,
                                     Map<String,Object> parameters)
```
    Specified by:
    
    selectOneTemplateSource in interface DBMethod
    
    Returns:
  - selectArrayTemplateSource
```
public Object[] selectArrayTemplateSource(String sqlSource,
                                          Map<String,Object> parameters)
```
    Specified by:
    
    selectArrayTemplateSource in interface DBMethod
    
    Returns:
  - selectPageTemplateSource
```
public <T> Page<T> selectPageTemplateSource(long start,
                                            int limit,
                                            Class<T> beanClass,
                                            String sqlSource,
                                            Map<String,Object> parameters)
```
    Specified by:
    
    selectPageTemplateSource in interface DBMethod
    
    Returns:
  - selectPageRawTemplateSource
```
public <T> Page<T> selectPageRawTemplateSource(long start,
                                               int limit,
                                               Class<T> beanClass,
                                               String countSqlSource,
                                               Map<String,Object> countParas,
                                               String listSqlSource,
                                               Map<String,Object> pageParas)
```
    Specified by:
    
    selectPageRawTemplateSource in interface DBMethod
    
    listSqlSource - 分页列表查询模板语句,不能包含了start和limit的内容
    
    Returns:
  - selectIteratorTemplateSource
```
public <T> void selectIteratorTemplateSource(OrmIterator<T> ormIt,
                                             Class<T> beanClass,
                                             String sqlSource,
                                             Map<String,Object> parameters)
```
    Specified by:
    
    selectIteratorTemplateSource in interface DBMethod
  - selectStreamTemplateSource
```
public <T> void selectStreamTemplateSource(OrmStream<T> ormStream,
                                           Class<T> beanClass,
                                           String sqlSource,
                                           Map<String,Object> parameters)
```
    Specified by:
    
    selectStreamTemplateSource in interface DBMethod
  - insertTemplateSource
```
public int insertTemplateSource(String sqlSource,
                                Map<String,Object> paramters,
                                List<String> pkeys,
                                Map<String,Object> keyValues)
```
    Specified by:
    
    insertTemplateSource in interface DBMethod
    
    Returns:
  - executeTemplateSource
```
public int executeTemplateSource(String sqlSource,
                                 Map<String,Object> paramters)
```
    Specified by:
    
    executeTemplateSource in interface DBMethod
    
    Returns:
  - executeBatchTemplateSource
```
public int[] executeBatchTemplateSource(String sqlSource,
                                        List<Map<String,Object>> parameters)
```
    Specified by:
    
    executeBatchTemplateSource in interface DBMethod
    
    Returns:
  - executeBatchTemplateSource
```
public int[] executeBatchTemplateSource(String sqlSource,
                                        List<Map<String,Object>> parameters,
                                        boolean insertFast,
                                        int batchSize,
                                        List<String> pkeys,
                                        List<Map<String,Object>> keyValues)
```
    Specified by:
    
    executeBatchTemplateSource in interface DBMethod
    
    Returns:
  - selectListTemplateSource
```
public <T> List<T> selectListTemplateSource(Class<T> beanClass,
                                            String sqlSource,
                                            Map<String,Object> parameters)
```
    Specified by:
    
    selectListTemplateSource in interface DBMethod
    
    Returns:
  - selectListTemplateSource
```
public <T> List<T> selectListTemplateSource(Class<T> beanClass,
                                            long start,
                                            int limit,
                                            String sqlSource,
                                            Map<String,Object> parameters)
```
    Specified by:
    
    selectListTemplateSource in interface DBMethod
    
    Returns:
  - getDynmicSQL
```
public DBDynmicSQL getDynmicSQL()
```
    Specified by:
    
    getDynmicSQL in interface DBMethod
    
    Returns:
  - getQueryDSL
```
public DBQueryDSL getQueryDSL()
```
    Specified by:
    
    getQueryDSL in interface DBMethod
    
    Returns:
  - getJooq
```
public DBJooq getJooq()
```
    Specified by:
    
    getJooq in interface DBMethod
    
    Returns:
  - getMapper
```
public <T> T getMapper(Class<T> mapperInterface)
```
    通过mapper接口生成dao代理
    
    Specified by:
    
    getMapper in interface DBMethod
    
    Type Parameters:
    
    T - 泛型
    
    Parameters:
    
    mapperInterface -
    
    Returns:

Class DBClient

Field Summary

Fields inherited from class sf.database.dao.DaoSupport

Constructor Summary

Method Summary

Methods inherited from class sf.database.dao.DaoSupport

Methods inherited from class java.lang.Object

Field Detail

mapperBuilder

dbJooq

dbQueryDSL

dbDynmicSQL

dbContexts

Constructor Detail

DBClient

DBClient

Method Detail

useContext

getDataSource

getConnection

getConnection

closeConnection

closeConnection

getDialect

existsByPrimaryKeys

exists

selectByPrimaryKeys

selectCount

selectOne

selectOneForUpdate

selectList

selectList

selectListForUpdate

selectPage

selectPage

selectOne

selectList

selectList

selectIterator

selectIterator

selectStream

insert

insertFast

insert

merge

update

updateAndSet

updateWithVersion

setNewOptimisticLockValues

deleteByPrimaryKeys

delete

truncate

truncate

batchInsert

batchInsert

batchInsertFast

batchInsertFast

batchUpdate

batchUpdate

batchDelete

genPojoCodes

createTable

createTables

dropTable

refreshTables

refreshTable

refreshTable

refreshTable

fetchCascade

fetchLinks

fetchLinks

execute

insertCascade

insertLinks

insertRelation

updateCascade

updateLinks

updateRelation

deleteCascade

deleteLinks