TableManager (sql2java-base 5.6.2 API)

所有超级接口:

SqlRunner
```
public interface TableManager
extends SqlRunner
```
Interface to handle database calls (save, load, count, etc...) for table.

作者:

guyadong

嵌套类概要

嵌套类
限定符和类型接口和说明

static interface TableManager.Action

static interface TableManager.DoEach
interface for iterate

嵌套类
限定符和类型	接口和说明
`static interface`	`TableManager.Action<B>`
`static interface`	`TableManager.DoEach<B>` interface for iterate

方法概要

所有方法实例方法抽象方法已过时的方法
限定符和类型	方法和说明
`B`	`addIfAbsent(B bean)` If the specified key is not already exist, add it to database.
`B`	`checkDuplicate(B bean)` Check duplicated row by primary keys,if row exists throw exception
`java.util.List<B>`	`childListOfSelfRef(java.lang.String fkName, B bean)` return child bean list (self included) by the self-reference field specified by fkName throw `RuntimeDaoException` if self-reference field is cycle
`java.util.List<B>`	`childListOfSelfRef(java.lang.String fkName, java.lang.Object... primaryKeys)` return child bean list (self included) by the self-reference field specified by fkName throw `RuntimeDaoException` if self-reference field is cycle
`java.util.Set<B>`	`childrenOfBeansOfSelfRef(java.lang.String fkName, java.lang.Iterable<B> beans)` return child bean list (self included) by the self-reference field specified by fkName throw `RuntimeDaoException` if self-reference field is cycle
`<T> java.util.Set<B>`	`childrenOfPksOfSelfRef(java.lang.String fkName, java.lang.Iterable<T> primaryKeys)` return child bean list (self included) by the self-reference field specified by fkName throw `RuntimeDaoException` if self-reference field is cycle
`java.util.Set<B>`	`childrenOfSelfRef(java.lang.String fkName, B bean)` return child bean list (self included) by the self-reference field specified by fkName throw `RuntimeDaoException` if self-reference field is cycle
`java.util.Set<B>`	`childrenOfSelfRef(java.lang.String fkName, java.lang.Object... primaryKeys)` return child bean list (self included) by the self-reference field specified by fkName throw `RuntimeDaoException` if self-reference field is cycle
`int`	`countAll()` Retrieves the number of rows of the table.
`int`	`countUsingTemplate(B bean)` count the number of elements of a specific bean
`int`	`countUsingTemplate(B bean, int searchType)` count the number of elements of a specific bean given the search type
`int`	`countWhere(java.lang.String where)` Retrieves the number of rows of the table with a 'where' clause.
`B`	`createBean()` Creates a new B instance.
`B`	`createBeanWithPimaryKeys(boolean returnNullIfNullElement, java.lang.Object... primaryValues)` Creates a new B instance.
`int`	`delete(B... beans)` Delete beans.
`int`	`delete(B bean)` Delete row according to primary keys of bean.
`int`	`delete(java.util.Collection<B> beans)` Delete beans.
`int`	`deleteAll()` Deletes all rows from table.
`int`	`deleteByPrimaryKey(java.lang.Object... keys)` Delete row according to its primary keys.
`int`	`deleteByWhere(java.lang.String where)` Deletes rows from the table using a 'where' clause.
`int`	`deleteUsingTemplate(B bean)` Deletes rows using a template.
`boolean`	`existsByPrimaryKey(B bean)` Returns true if this table contains row specified by primary key fields of B.
`boolean`	`existsPrimaryKey(java.lang.Object... keys)` Returns true if this table contains row with primary key fields.
`<C extends java.lang.Iterable<B>> void`	`fastInsert(int[] fieldList, C beans)` Insert the B bean list into the database.
`void`	`foreach(TableManager.DoEach<B> each, boolean stopOnError)` Retrieves each row of B bean given a SQL where clause and a list of fields, and dealt with each action.
`void`	`foreachByJoinWhere(TableManager.DoEach<B> each, boolean stopOnError, java.lang.String join, java.lang.String where)` Retrieves each row of B bean given a SQL where clause and a list of fields, and dealt with each action.
`void`	`foreachByWhere(TableManager.DoEach<B> each, boolean stopOnError, java.lang.String where)` Retrieves each row of B bean given a SQL where clause and a list of fields, and dealt with each action.
`IDataSourceConfig`	`getDataSourceConfig()`
`GeometryDataCodec`	`getGeometryDataCodec()`
`ListenerContainer<B>`	`getListenerContainer()`
`java.util.List<B>`	`listOfSelfRef(java.lang.String fkName, B bean)` return bean list ( include `bean` ) by the self-reference field specified by fkName first element is top bean
`java.util.List<B>`	`listOfSelfRef(java.lang.String fkName, java.lang.Object... primaryKeys)` return bean list ( include bean specified by `primaryKeys` ) by the self-reference field specified by fkName first element is top bean
`B[]`	`loadAll()` Loads all the rows from table.
`B[]`	`loadAll(int startRow, int numRows)` Loads the given number of rows from table, given the start row.
`int`	`loadAll(int startRow, int numRows, TableManager.Action<B> action)` Loads the given number of rows from table, given the start row and dealt with action.
`int`	`loadAll(TableManager.Action<B> action)` Loads each row from table and dealt with action.
`java.util.List<B>`	`loadAllAsList()` Loads all the rows from table.
`java.util.List<B>`	`loadAllAsList(int startRow, int numRows)` Loads the given number of rows from table, given the start row.
`java.util.List<B>`	`loadByJoinWhereAsList(java.lang.String join, java.lang.String where)` 已过时。 replaced by `loadByJoinWhereAsList(String, String, Supplier)`，since 3.35.0
`java.util.List<B>`	`loadByJoinWhereAsList(java.lang.String join, java.lang.String where, int[] fieldList, int startRow, int numRows)` 已过时。 replaced by `loadByJoinWhereAsList(String, String, int[], int, int, Supplier)`，since 3.35.0
`java.util.List<B>`	`loadByJoinWhereAsList(java.lang.String join, java.lang.String where, int[] fieldList, int startRow, int numRows, com.google.common.base.Supplier<IManagerContext> contextSupplier)` 根据 JOIN 和 WHERE 条件执行查询，并将查询结果转换为 B 类型的列表返回。
`java.util.List<B>`	`loadByJoinWhereAsList(java.lang.String join, java.lang.String where, java.lang.Object[] argList, int[] fieldList)` 已过时。 replaced by `loadByJoinWhereAsList(String, String, Object[], int[], Supplier)`，since 3.35.0
`<T> java.util.List<T>`	`loadByJoinWhereAsList(java.lang.String join, java.lang.String where, java.lang.Object[] argList, int[] fieldList, int startRow, int numRows, com.google.common.base.Function<B,T> transformer)` 已过时。 replaced by `loadByJoinWhereAsList(String, String, Object[], int[], int, int, Function, Supplier)`，since 3.35.0
`<T> java.util.List<T>`	`loadByJoinWhereAsList(java.lang.String join, java.lang.String where, java.lang.Object[] argList, int[] fieldList, int startRow, int numRows, com.google.common.base.Function<B,T> transformer, com.google.common.base.Supplier<IManagerContext> contextSupplier)` 根据 JOIN 和 WHERE 条件执行查询，并将查询结果转换为指定类型的列表返回。
`java.util.List<B>`	`loadByJoinWhereAsList(java.lang.String join, java.lang.String where, java.lang.Object[] argList, int[] fieldList, com.google.common.base.Supplier<IManagerContext> contextSupplier)` 根据 JOIN 和 WHERE 条件执行查询，并将查询结果转换为 B 类型的列表返回。
`java.util.List<B>`	`loadByJoinWhereAsList(java.lang.String join, java.lang.String where, com.google.common.base.Supplier<IManagerContext> contextSupplier)` 根据 JOIN 和 WHERE 条件执行查询，并将查询结果转换为 B 类型的列表返回。
`int`	`loadByJoinWhereForAction(java.lang.String join, java.lang.String where, java.lang.Object[] argList, int[] fieldList, int startRow, int numRows, TableManager.Action<B> action)` 已过时。 replaced by `loadByJoinWhereForAction(String, String, Object[], int[], int, int, Action, Supplier)`，since 3.35.0
`int`	`loadByJoinWhereForAction(java.lang.String join, java.lang.String where, java.lang.Object[] argList, int[] fieldList, int startRow, int numRows, TableManager.Action<B> action, com.google.common.base.Supplier<IManagerContext> contextSupplier)` 根据 JOIN 和 WHERE 条件执行查询，并对查询结果执行指定操作。
`B`	`loadByPrimaryKey(B bean)` Loads a B bean from the table using primary key fields of `bean`.
`B`	`loadByPrimaryKey(java.lang.Object... keys)` Loads a B bean from the table using primary key fields.
`B`	`loadByPrimaryKeyChecked(B bean)` see also `loadByPrimaryKey(BaseBean)`
`B`	`loadByPrimaryKeyChecked(java.lang.Object... keys)` see also `loadByPrimaryKey(Object...)`
`B[]`	`loadByWhere(java.lang.String where)` Retrieves an array of B given a sql 'where' clause.
`B[]`	`loadByWhere(java.lang.String where, int[] fieldList)` Retrieves an array of B bean given a sql where clause, and a list of fields.
`B[]`	`loadByWhere(java.lang.String where, int[] fieldList, int startRow, int numRows)` Retrieves an array of B bean given a sql where clause and a list of fields, and startRow and numRows.
`int`	`loadByWhere(java.lang.String where, int[] fieldList, int startRow, int numRows, TableManager.Action<B> action)` Retrieves each row of B bean given a sql where clause and a list of fields, and startRow and numRows, and dealt with action.
`int`	`loadByWhere(java.lang.String where, int[] fieldList, TableManager.Action<B> action)` Retrieves each row of B bean given a sql where clause, and a list of fields, and dealt with action.
`int`	`loadByWhere(java.lang.String where, TableManager.Action<B> action)` Retrieves each row of B bean given a sql 'where' clause and dealt with action.
`java.util.List<B>`	`loadByWhereAsList(java.lang.String where)` Retrieves a list of B bean given a sql 'where' clause.
`java.util.List<B>`	`loadByWhereAsList(java.lang.String where, int[] fieldList)` Retrieves a list of B bean given a sql where clause, and a list of fields.
`java.util.List<B>`	`loadByWhereAsList(java.lang.String where, int[] fieldList, int startRow, int numRows)` Retrieves a list of B bean given a sql where clause and a list of fields, and startRow and numRows.
`int`	`loadByWhereForAction(java.lang.String where, java.lang.Object[] argList, int[] fieldList, int startRow, int numRows, TableManager.Action<B> action)` Retrieves each row of B bean given a sql where clause and a list of fields, and startRow and numRows, and dealt wity action It is up to you to pass the 'WHERE' in your where clauses.
`<T> java.util.List<T>`	`loadColumnAsList(java.lang.String column, boolean distinct, java.lang.String where, int startRow, int numRows)` Load column from table.
`B`	`loadUniqueByIndex(java.lang.String indexName, java.lang.Object... indexValues)` 根据索引名称和索引值加载唯一的记录。
`B`	`loadUniqueByIndexChecked(java.lang.String indexName, java.lang.Object... indexValues)` 根据指定索引名称和索引值加载唯一的记录，并进行参数检查。
`B`	`loadUniqueUsingTemplate(B bean)` Loads a unique B bean from a template one giving a c
`B`	`loadUniqueUsingTemplateChecked(B bean)` Loads a unique B bean from a template one giving a c
`B[]`	`loadUsingTemplate(B bean)` Loads an array of B from a template one.
`int`	`loadUsingTemplate(B bean, int[] fieldList, int startRow, int numRows, int searchType, TableManager.Action<B> action)` Loads each row from a template one, given the start row and number of rows and dealt with action.
`B[]`	`loadUsingTemplate(B bean, int startRow, int numRows)` Loads an array of B bean from a template one, given the start row and number of rows.
`B[]`	`loadUsingTemplate(B bean, int startRow, int numRows, int searchType)` Loads a list of B bean from a template one, given the start row and number of rows.
`int`	`loadUsingTemplate(B bean, int startRow, int numRows, TableManager.Action<B> action)` Loads each row from a template one, given the start row and number of rows and dealt with action.
`int`	`loadUsingTemplate(B bean, TableManager.Action<B> action)` Loads each row from a template one and dealt with action.
`java.util.List<B>`	`loadUsingTemplateAsList(B bean)` Loads a list of B bean from a template one.
`java.util.List<B>`	`loadUsingTemplateAsList(B bean, int startRow, int numRows)` Loads a list of B bean from a template one, given the start row and number of rows.
`java.util.List<B>`	`loadUsingTemplateAsList(B bean, int startRow, int numRows, int searchType)` Loads an array of B bean from a template one, given the start row and number of rows.
`boolean`	`lockAndUpdate(B bean)` 锁定并更新指定的`bean`。
`java.util.List<B>`	`lockAndUpdate(java.lang.String join, java.lang.String where, java.lang.Object[] argList, int[] fieldList, int lockLimit, LockUpateRunner<B> updateRunner)` 已过时。 use `lockAndUpdate(String, String, Object[], int[], int, LockUpateRunner, Supplier)`
`java.util.List<B>`	`lockAndUpdate(java.lang.String join, java.lang.String where, java.lang.Object[] argList, int[] fieldList, int lockLimit, LockUpateRunner<B> updateRunner, com.google.common.base.Supplier<IManagerContext> contextSupplier)` 锁定符合条件的行并根据锁定的行执行指定的更新操作。
`java.util.List<B>`	`lockAndUpdate(java.lang.String join, java.lang.String where, java.lang.Object[] argList, int limit, LockUpateRunner<B> updateRunner)` 已过时。 use `lockAndUpdate(String, String, Object[], int, LockUpateRunner, Supplier)`
`java.util.List<B>`	`lockAndUpdate(java.lang.String join, java.lang.String where, java.lang.Object[] argList, int limit, LockUpateRunner<B> updateRunner, com.google.common.base.Supplier<IManagerContext> contextSupplier)` 锁定符合条件的行并根据锁定的行执行指定的更新操作。
`void`	`registerListener(TableListener<B> listener)` Registers a unique `TableListener` listener.
`int`	`rowCountWhere(java.lang.String where, java.lang.Object... argList)` Retrieves the number of rows of the table with a 'where' clause.
`B`	`save(B bean)` Saves the B bean into the database.
`B[]`	`save(B[] beans)` Saves an array of B bean into the database.
`<C extends java.util.Collection<B>> C`	`save(C beans)` Saves a collection of B bean into the database as transaction.
`B[]`	`saveAsTransaction(B[] beans)` Saves an array of B bean into the database as transaction.
`<C extends java.util.Collection<B>> C`	`saveAsTransaction(C beans)` Saves a collection of B bean into the database.
`boolean`	`setValueIfNonEqual(B bean, java.lang.String column, java.lang.Object value)` set a value to the given field in bean if value is not equal to the given field of old record in database
`boolean`	`setValueIfNonNull(B bean, java.lang.String column, java.lang.Object value)` set a value to the given field in bean if the given field of old record in database is not null
`java.util.List<B>`	`tryLockRows(java.lang.String join, java.lang.String where, java.lang.Object[] argList, int[] fieldList, int lockLimit, Constant.RowLockType rowLockType)` 已过时。 use `tryLockRows(String, String, Object[], int[], int, Constant.RowLockType, Supplier)`
`java.util.List<B>`	`tryLockRows(java.lang.String join, java.lang.String where, java.lang.Object[] argList, int[] fieldList, int lockLimit, Constant.RowLockType rowLockType, com.google.common.base.Supplier<IManagerContext> contextSupplier)` (悲观锁)尝试锁定满足条件的行。
`void`	`unregisterListener(TableListener<B> listener)` remove listener.
`int`	`updateWithCondition(B bean, java.lang.String extraUpdateExp, java.lang.Object[] extraUpdateExpArgList)` 根据指定条件更新数据库中 B 类型的 bean 记录。

从接口继承的方法 gu.sql2java.SqlRunner
rowCountOf, runAsTransaction, runAsTransaction, runSql, runSql, runSqlAsList, runSqlAsList, runSqlAsList, runSqlForMap, runSqlForValue, runWithNoPage, runWithNoPage

- 方法详细资料
 - createBean
```
B createBean()
```
 Creates a new B instance.
 
 返回:
 
 the new B instance
 - createBeanWithPimaryKeys
```
B createBeanWithPimaryKeys(boolean returnNullIfNullElement,
 java.lang.Object... primaryValues)
```
 Creates a new B instance.
 
 参数:
 
 returnNullIfNullElement - return null if exist null element
 
 primaryValues - values of primary keys
 
 返回:
 
 B instance OR null if exist null value in primaryValues
 
 从以下版本开始:
 
 3.35.0
 - countAll
```
int countAll()
 throws RuntimeDaoException
```
 Retrieves the number of rows of the table.
 
 返回:
 
 the number of rows returned
 
 抛出:
 
 RuntimeDaoException
 - countUsingTemplate
```
int countUsingTemplate(B bean)
 throws RuntimeDaoException
```
 count the number of elements of a specific bean
 
 参数:
 
 bean - the bean to look for ant count
 
 返回:
 
 the number of rows returned
 
 抛出:
 
 RuntimeDaoException
 - countUsingTemplate
```
int countUsingTemplate(B bean,
 int searchType)
 throws RuntimeDaoException
```
 count the number of elements of a specific bean given the search type
 
 参数:
 
 bean - the template to look for
 
 searchType - exact ? like ? starting like ? ending link ?
 0 Constant.SEARCH_EXACT
 1 Constant.SEARCH_LIKE
 2 Constant.SEARCH_STARTING_LIKE
 3 Constant.SEARCH_ENDING_LIKE
 
 返回:
 
 the number of rows returned
 
 抛出:
 
 RuntimeDaoException
 - countWhere
```
int countWhere(java.lang.String where)
 throws RuntimeDaoException
```
 Retrieves the number of rows of the table with a 'where' clause. It is up to you to pass the 'WHERE' in your where clauses.
 
 参数:
 
 where - the restriction clause
 
 返回:
 
 the number of rows returned
 
 抛出:
 
 RuntimeDaoException
 - rowCountWhere
```
int rowCountWhere(java.lang.String where,
 java.lang.Object... argList)
 throws RuntimeDaoException
```
 Retrieves the number of rows of the table with a 'where' clause. It is up to you to pass the 'WHERE' in your where clauses.
 
 参数:
 
 where - the restriction clause
 
 argList - the arguments to use fill given prepared statement,may be null
 
 返回:
 
 the number of rows returned
 
 抛出:
 
 RuntimeDaoException
 - deleteAll
```
int deleteAll()
 throws RuntimeDaoException
```
 Deletes all rows from table.
 
 返回:
 
 the number of deleted rows.
 
 抛出:
 
 RuntimeDaoException
 - deleteByWhere
```
int deleteByWhere(java.lang.String where)
 throws RuntimeDaoException
```
 Deletes rows from the table using a 'where' clause. It is up to you to pass the 'WHERE' in your where clauses.
 Attention, if 'WHERE' is omitted it will delete all records.
 
 参数:
 
 where - the sql 'where' clause
 
 返回:
 
 the number of deleted rows
 
 抛出:
 
 RuntimeDaoException
 - deleteUsingTemplate
```
int deleteUsingTemplate(B bean)
 throws RuntimeDaoException
```
 Deletes rows using a template.
 
 参数:
 
 bean - the template object(s) to be deleted
 
 返回:
 
 the number of deleted objects
 
 抛出:
 
 RuntimeDaoException
 - deleteByPrimaryKey
```
int deleteByPrimaryKey(java.lang.Object... keys)
 throws RuntimeDaoException
```
 Delete row according to its primary keys.
 
 参数:
 
 keys - primary keys value
 for fd_face table
 PK# 1 fd_face.id type Integer
 for fd_feature table
 PK# 1 fd_feature.md5 type String
 for fd_image table
 PK# 1 fd_image.md5 type String
 for fd_store table
 PK# 1 fd_store.md5 type String
 
 返回:
 
 the number of deleted rows
 
 抛出:
 
 RuntimeDaoException
 - delete
```
int delete(B bean)
 throws RuntimeDaoException
```
 Delete row according to primary keys of bean.
 
 参数:
 
 bean - will be deleted ,all keys must not be null
 
 返回:
 
 the number of deleted rows,0 returned if bean is null
 
 抛出:
 
 RuntimeDaoException
 - delete
```
int delete(B... beans)
 throws RuntimeDaoException
```
 Delete beans.
 
 参数:
 
 beans - B array will be deleted
 
 返回:
 
 the number of deleted rows
 
 抛出:
 
 RuntimeDaoException
 - delete
```
int delete(java.util.Collection beans)
 throws RuntimeDaoException
```
 Delete beans.
 
 参数:
 
 beans - B collection will be deleted
 
 返回:
 
 the number of deleted rows
 
 抛出:
 
 RuntimeDaoException
 - setValueIfNonNull
```
boolean setValueIfNonNull(B bean,
 java.lang.String column,
 java.lang.Object value)
```
 set a value to the given field in bean if the given field of old record in database is not null
 
 参数:
 
 bean -
 
 column - column name
 
 value -
 
 返回:
 
 true if not equal with old record in database,otherwise false
 
 从以下版本开始:
 
 3.15.4
 - setValueIfNonEqual
```
boolean setValueIfNonEqual(B bean,
 java.lang.String column,
 java.lang.Object value)
```
 set a value to the given field in bean if value is not equal to the given field of old record in database
 
 参数:
 
 bean -
 
 column - column name
 
 value -
 
 返回:
 
 true if not equal with old record in database,otherwise false
 
 从以下版本开始:
 
 3.15.4
 - loadAll
```
B[] loadAll()
 throws RuntimeDaoException
```
 Loads all the rows from table.
 
 返回:
 
 an array of B bean
 
 抛出:
 
 RuntimeDaoException
 - loadAll
```
int loadAll(TableManager.Action action)
 throws RuntimeDaoException
```
 Loads each row from table and dealt with action.
 
 参数:
 
 action - Action object for do something(not null)
 
 返回:
 
 the count dealt by action
 
 抛出:
 
 RuntimeDaoException
 - loadAll
```
B[] loadAll(int startRow,
 int numRows)
 throws RuntimeDaoException
```
 Loads the given number of rows from table, given the start row.
 
 参数:
 
 startRow - the start row to be used (first row = 1, last row = -1)
 
 numRows - the number of rows to be retrieved (all rows = a negative number)
 
 返回:
 
 an array of B bean
 
 抛出:
 
 RuntimeDaoException
 - loadAll
```
int loadAll(int startRow,
 int numRows,
 TableManager.Action action)
 throws RuntimeDaoException
```
 Loads the given number of rows from table, given the start row and dealt with action.
 
 参数:
 
 startRow - the start row to be used (first row = 1, last row = -1)
 
 numRows - the number of rows to be retrieved (all rows = a negative number)
 
 action - Action object for do something(not null)
 
 返回:
 
 the count dealt by action
 
 抛出:
 
 RuntimeDaoException
 - loadAllAsList
```
java.util.List loadAllAsList()
 throws RuntimeDaoException
```
 Loads all the rows from table.
 
 返回:
 
 a list of B bean
 
 抛出:
 
 RuntimeDaoException
 - loadAllAsList
```
java.util.List loadAllAsList(int startRow,
 int numRows)
 throws RuntimeDaoException
```
 Loads the given number of rows from table, given the start row.
 
 参数:
 
 startRow - the start row to be used (first row = 1, last row = -1)
 
 numRows - the number of rows to be retrieved (all rows = a negative number)
 
 返回:
 
 a list of B bean
 
 抛出:
 
 RuntimeDaoException
 - loadByPrimaryKey
```
B loadByPrimaryKey(B bean)
 throws RuntimeDaoException
```
 Loads a B bean from the table using primary key fields of bean.
 
 参数:
 
 bean - the B bean with primary key fields
 
 返回:
 
 a unique B or null if not found or bean is null
 
 抛出:
 
 RuntimeDaoException
 - loadByPrimaryKeyChecked
```
B loadByPrimaryKeyChecked(B bean)
 throws RuntimeDaoException,
 ObjectRetrievalException
```
 see also loadByPrimaryKey(BaseBean)
 
 参数:
 
 bean -
 
 返回:
 
 a unique B ,otherwise throw exception
 
 抛出:
 
 ObjectRetrievalException - not found
 
 RuntimeDaoException
 - loadByPrimaryKey
```
B loadByPrimaryKey(java.lang.Object... keys)
 throws RuntimeDaoException
```
 Loads a B bean from the table using primary key fields. when you don't know which is primary key of table,you can use the method.
 
 参数:
 
 keys - primary keys value:
 for fd_face table
 PK# 1 fd_face.id type Integer
 for fd_feature table
 PK# 1 fd_feature.md5 type String
 for fd_image table
 PK# 1 fd_image.md5 type String
 for fd_store table
 PK# 1 fd_store.md5 type String
 
 返回:
 
 a unique B or null if not found
 
 抛出:
 
 RuntimeDaoException
 - loadByPrimaryKeyChecked
```
B loadByPrimaryKeyChecked(java.lang.Object... keys)
 throws RuntimeDaoException,
 ObjectRetrievalException
```
 see also loadByPrimaryKey(Object...)
 
 参数:
 
 keys -
 
 返回:
 
 a unique B,otherwise throw exception
 
 抛出:
 
 ObjectRetrievalException - not found
 
 RuntimeDaoException
 - existsPrimaryKey
```
boolean existsPrimaryKey(java.lang.Object... keys)
 throws RuntimeDaoException
```
 Returns true if this table contains row with primary key fields.
 
 参数:
 
 keys - primary keys value
 
 抛出:
 
 RuntimeDaoException
 
 另请参阅:
 
 loadByPrimaryKey(Object...)
 - existsByPrimaryKey
```
boolean existsByPrimaryKey(B bean)
 throws RuntimeDaoException
```
 Returns true if this table contains row specified by primary key fields of B.
 when you don't know which is primary key of table,you can use the method.
 
 参数:
 
 bean - the B bean with primary key fields
 
 抛出:
 
 RuntimeDaoException
 
 另请参阅:
 
 loadByPrimaryKey(BaseBean)
 - checkDuplicate
```
B checkDuplicate(B bean)
 throws RuntimeDaoException,
 ObjectRetrievalException
```
 Check duplicated row by primary keys,if row exists throw exception
 
 参数:
 
 bean - the B bean with primary key fields
 
 返回:
 
 always bean
 
 抛出:
 
 ObjectRetrievalException - has duplicated record
 
 RuntimeDaoException
 
 另请参阅:
 
 existsByPrimaryKey(BaseBean)
 - loadByWhere
```
B[] loadByWhere(java.lang.String where)
 throws RuntimeDaoException
```
 Retrieves an array of B given a sql 'where' clause.
 
 参数:
 
 where - the sql 'where' clause
 
 抛出:
 
 RuntimeDaoException
 - loadByWhere
```
int loadByWhere(java.lang.String where,
 TableManager.Action action)
 throws RuntimeDaoException
```
 Retrieves each row of B bean given a sql 'where' clause and dealt with action.
 
 参数:
 
 where - the sql 'where' clause
 
 action - Action object for do something(not null)
 
 返回:
 
 the count dealt by action
 
 抛出:
 
 RuntimeDaoException
 - loadByWhere
```
B[] loadByWhere(java.lang.String where,
 int[] fieldList)
 throws RuntimeDaoException
```
 Retrieves an array of B bean given a sql where clause, and a list of fields. It is up to you to pass the 'WHERE' in your where clauses.
 
 参数:
 
 where - the sql 'WHERE' clause
 
 fieldList - array of field's ID
 
 抛出:
 
 RuntimeDaoException
 - loadByWhere
```
int loadByWhere(java.lang.String where,
 int[] fieldList,
 TableManager.Action action)
 throws RuntimeDaoException
```
 Retrieves each row of B bean given a sql where clause, and a list of fields, and dealt with action. It is up to you to pass the 'WHERE' in your where clauses.
 
 参数:
 
 where - the sql 'WHERE' clause
 
 fieldList - array of field's ID
 
 action - Action object for do something(not null)
 
 返回:
 
 the count dealt by action
 
 抛出:
 
 RuntimeDaoException
 - loadByWhere
```
B[] loadByWhere(java.lang.String where,
 int[] fieldList,
 int startRow,
 int numRows)
 throws RuntimeDaoException
```
 Retrieves an array of B bean given a sql where clause and a list of fields, and startRow and numRows. It is up to you to pass the 'WHERE' in your where clauses.
 
 参数:
 
 where - the sql 'where' clause
 
 fieldList - table of the field's associated constants
 
 startRow - the start row to be used (first row = 1, last row = -1)
 
 numRows - the number of rows to be retrieved (all rows = a negative number)
 
 抛出:
 
 RuntimeDaoException
 - loadByWhere
```
int loadByWhere(java.lang.String where,
 int[] fieldList,
 int startRow,
 int numRows,
 TableManager.Action action)
 throws RuntimeDaoException
```
 Retrieves each row of B bean given a sql where clause and a list of fields, and startRow and numRows, and dealt with action. It is up to you to pass the 'WHERE' in your where clauses.
 
 参数:
 
 where - the sql 'where' clause
 
 fieldList - table of the field's associated constants
 
 startRow - the start row to be used (first row = 1, last row = -1)
 
 numRows - the number of rows to be retrieved (all rows = a negative number)
 
 action - Action object for do something(not null)
 
 返回:
 
 the count dealt by action
 
 抛出:
 
 RuntimeDaoException
 - loadByWhereAsList
```
java.util.List loadByWhereAsList(java.lang.String where)
 throws RuntimeDaoException
```
 Retrieves a list of B bean given a sql 'where' clause.
 
 参数:
 
 where - the sql 'where' clause
 
 抛出:
 
 RuntimeDaoException
 - loadByWhereAsList
```
java.util.List loadByWhereAsList(java.lang.String where,
 int[] fieldList)
 throws RuntimeDaoException
```
 Retrieves a list of B bean given a sql where clause, and a list of fields. It is up to you to pass the 'WHERE' in your where clauses.
 
 参数:
 
 where - the sql 'WHERE' clause
 
 fieldList - array of field's ID
 
 抛出:
 
 RuntimeDaoException
 - loadByWhereAsList
```
java.util.List loadByWhereAsList(java.lang.String where,
 int[] fieldList,
 int startRow,
 int numRows)
 throws RuntimeDaoException
```
 Retrieves a list of B bean given a sql where clause and a list of fields, and startRow and numRows. It is up to you to pass the 'WHERE' in your where clauses.
 
 参数:
 
 where - the sql 'where' clause
 
 fieldList - table of the field's associated constants
 
 startRow - the start row to be used (first row = 1, last row = -1)
 
 numRows - the number of rows to be retrieved (all rows = a negative number)
 
 抛出:
 
 RuntimeDaoException
 - loadByWhereForAction
```
int loadByWhereForAction(java.lang.String where,
 java.lang.Object[] argList,
 int[] fieldList,
 int startRow,
 int numRows,
 TableManager.Action action)
 throws RuntimeDaoException
```
 Retrieves each row of B bean given a sql where clause and a list of fields, and startRow and numRows, and dealt wity action It is up to you to pass the 'WHERE' in your where clauses.
 
 参数:
 
 where - the sql 'where' clause
 
 argList - the arguments to use fill given prepared statement,may be null
 
 fieldList - table of the field's associated constants
 
 startRow - the start row to be used (first row = 1, last row = -1)
 
 numRows - the number of rows to be retrieved (all rows = a negative number)
 
 action - Action object for do something(not null)
 
 返回:
 
 the count dealt by action
 
 抛出:
 
 RuntimeDaoException
 - loadByJoinWhereAsList
```
java.util.List loadByJoinWhereAsList(java.lang.String join,
 java.lang.String where,
 com.google.common.base.Supplier<IManagerContext> contextSupplier)
 throws RuntimeDaoException
```
 根据 JOIN 和 WHERE 条件执行查询，并将查询结果转换为 B 类型的列表返回。
 此方法为 loadByJoinWhereAsList(String, String, Object[], int[], int, int, Function, Supplier) 的便捷方法。
 等价于:
```
 loadByJoinWhereAsList(join, where, null, null, 1, -1, Functions.identity(), contextSupplier);
 
```
 参数:
 
 join - JOIN 子句，用于表连接操作，可传入 null 或空字符串表示不使用 JOIN。
 
 where - WHERE 条件表达式，需以 'WHERE' 开头，也可以为 null 或空字符串。
 
 contextSupplier - 管理器上下文提供者，用于提供查询所需的上下文信息。可为 null。
 
 返回:
 
 B 类型对象列表。
 
 抛出:
 
 RuntimeDaoException - 当数据访问发生异常时抛出。
 
 从以下版本开始:
 
 3.35.0
 - loadByJoinWhereAsList
```
java.util.List loadByJoinWhereAsList(java.lang.String join,
 java.lang.String where)
 throws RuntimeDaoException
```
 已过时。 replaced by loadByJoinWhereAsList(String, String, Supplier)，since 3.35.0
 
 Retrieves a list of B bean given a sql 'where' clause.
 
 参数:
 
 join - the sql 'join' clause
 
 where - the sql 'where' clause
 
 抛出:
 
 RuntimeDaoException
 - loadByJoinWhereAsList
```
java.util.List loadByJoinWhereAsList(java.lang.String join,
 java.lang.String where,
 java.lang.Object[] argList,
 int[] fieldList,
 com.google.common.base.Supplier<IManagerContext> contextSupplier)
 throws RuntimeDaoException
```
 根据 JOIN 和 WHERE 条件执行查询，并将查询结果转换为 B 类型的列表返回。
 
 参数:
 
 join - JOIN 子句，用于表连接操作，可传入 null 或空字符串表示不使用 JOIN。
 
 where - WHERE 条件表达式，需以 'WHERE' 开头，也可以为 null 或空字符串。
 
 argList - WHERE 条件中的参数列表，用于填充 SQL 语句中的占位符 '?'。
 
 fieldList - 要查询的字段 ID 列表，可传入 null 或空数组表示查询所有字段。
 
 contextSupplier - 管理器上下文提供者，用于提供查询所需的上下文信息。可为 null。
 
 返回:
 
 B 类型对象列表。
 
 抛出:
 
 RuntimeDaoException - 当数据访问发生异常时抛出。
 
 从以下版本开始:
 
 3.35.0
 - loadByJoinWhereAsList
```
java.util.List loadByJoinWhereAsList(java.lang.String join,
 java.lang.String where,
 java.lang.Object[] argList,
 int[] fieldList)
 throws RuntimeDaoException
```
 已过时。 replaced by loadByJoinWhereAsList(String, String, Object[], int[], Supplier)，since 3.35.0
 
 Retrieves a list of B bean given a sql where clause, and a list of fields. It is up to you to pass the 'WHERE' in your where clauses.
 
 参数:
 
 join - the sql 'join' clause
 
 where - the sql 'WHERE' clause
 
 argList - the arguments to use fill given prepared statement,may be null
 
 fieldList - array of field's ID
 
 抛出:
 
 RuntimeDaoException
 - loadByJoinWhereAsList
```
java.util.List loadByJoinWhereAsList(java.lang.String join,
 java.lang.String where,
 int[] fieldList,
 int startRow,
 int numRows,
 com.google.common.base.Supplier<IManagerContext> contextSupplier)
 throws RuntimeDaoException
```
 根据 JOIN 和 WHERE 条件执行查询，并将查询结果转换为 B 类型的列表返回。
 loadByJoinWhereAsList(String, String, Object[], int[], int, int, Function, Supplier)的便利方法
 等价于:
```
 loadByJoinWhereAsList(join, where, null, fieldList, startRow, numRows, Functions.identity(), contextSupplier);
 
```
 参数:
 
 join - JOIN 子句，用于表连接操作，可传入 null 或空字符串表示不使用 JOIN。
 
 where - WHERE 条件表达式，需以 'WHERE' 开头，也可以为 null 或空字符串。
 
 fieldList - 要查询的字段 ID 列表，可传入 null 或空数组表示查询所有字段。
 
 startRow - 查询结果的起始行号，从 1 开始计数。
 
 numRows - 要查询的行数，-1 表示查询所有行。
 
 contextSupplier - 管理器上下文提供者，用于提供查询所需的上下文信息。可为 null。
 
 返回:
 
 B 类型对象列表。
 
 抛出:
 
 RuntimeDaoException - 当数据访问发生异常时抛出。
 
 从以下版本开始:
 
 3.35.0
 - loadByJoinWhereAsList
```
java.util.List loadByJoinWhereAsList(java.lang.String join,
 java.lang.String where,
 int[] fieldList,
 int startRow,
 int numRows)
 throws RuntimeDaoException
```
 已过时。 replaced by loadByJoinWhereAsList(String, String, int[], int, int, Supplier)，since 3.35.0
 
 Retrieves a list of B bean given a sql where clause and a list of fields, and startRow and numRows. It is up to you to pass the 'WHERE' in your where clauses.
 
 参数:
 
 join - the sql 'join' clause
 
 where - the sql 'where' clause
 
 fieldList - table of the field's associated constants
 
 startRow - the start row to be used (first row = 1, last row = -1)
 
 numRows - the number of rows to be retrieved (all rows = a negative number)
 
 抛出:
 
 RuntimeDaoException
 - loadByJoinWhereAsList
```
<T> java.util.List<T> loadByJoinWhereAsList(java.lang.String join,
 java.lang.String where,
 java.lang.Object[] argList,
 int[] fieldList,
 int startRow,
 int numRows,
 com.google.common.base.Function<B,T> transformer,
 com.google.common.base.Supplier<IManagerContext> contextSupplier)
 throws RuntimeDaoException
```
 根据 JOIN 和 WHERE 条件执行查询，并将查询结果转换为指定类型的列表返回。
 
 参数:
 
 join - JOIN 子句，用于表连接操作，可传入 null 或空字符串表示不使用 JOIN。
 
 where - WHERE 条件表达式，需以 'WHERE' 开头，也可以为 null 或空字符串。
 
 argList - WHERE 条件中的参数列表，用于填充 SQL 语句中的占位符 '?'。
 
 fieldList - 要查询的字段 ID 列表，可传入 null 或空数组表示查询所有字段。
 
 startRow - 查询结果的起始行号，从 1 开始计数。
 
 numRows - 要查询的行数，-1 表示查询所有行。
 
 transformer - 用于将查询结果的 B 类型对象转换为 T 类型对象的转换器。
 
 contextSupplier - 管理器上下文提供者，用于提供查询所需的上下文信息。可为 null。
 
 返回:
 
 转换后的 T 类型对象列表。
 
 抛出:
 
 RuntimeDaoException - 当数据访问发生异常时抛出。
 
 从以下版本开始:
 
 3.35.0
 - loadByJoinWhereAsList
```
<T> java.util.List<T> loadByJoinWhereAsList(java.lang.String join,
 java.lang.String where,
 java.lang.Object[] argList,
 int[] fieldList,
 int startRow,
 int numRows,
 com.google.common.base.Function<B,T> transformer)
 throws RuntimeDaoException
```
 已过时。 replaced by loadByJoinWhereAsList(String, String, Object[], int[], int, int, Function, Supplier)，since 3.35.0
 
 Retrieves a list of T bean given a sql where clause and a list of fields, and startRow and numRows. It is up to you to pass the 'WHERE' in your where clauses.
 
 参数:
 
 join - the sql 'join' clause
 
 where - the sql 'where' clause
 
 argList - the arguments to use fill given prepared statement,may be null
 
 fieldList - table of the field's associated constants
 
 startRow - the start row to be used (first row = 1, last row = -1)
 
 numRows - the number of rows to be retrieved (all rows = a negative number)
 
 transformer - cast B to T
 
 抛出:
 
 RuntimeDaoException
 - loadByJoinWhereForAction
```
int loadByJoinWhereForAction(java.lang.String join,
 java.lang.String where,
 java.lang.Object[] argList,
 int[] fieldList,
 int startRow,
 int numRows,
 TableManager.Action action,
 com.google.common.base.Supplier<IManagerContext> contextSupplier)
 throws RuntimeDaoException
```
 根据 JOIN 和 WHERE 条件执行查询，并对查询结果执行指定操作。
 
 参数:
 
 join - JOIN 子句，用于表连接操作，可传入 null 或空字符串表示不使用 JOIN。
 
 where - WHERE 条件表达式，需以 'WHERE' 开头，也可以为 null 或空字符串。
 
 argList - WHERE 条件中的参数列表，用于填充 SQL 语句中的占位符 '?'。
 
 fieldList - 要查询的字段 ID 列表，可传入 null 或空数组表示查询所有字段。
 
 startRow - 查询结果的起始行号，从 1 开始计数。
 
 numRows - 要查询的行数，-1 表示查询所有行。
 
 action - 对查询结果执行的操作，每个结果行都会调用该操作。
 
 contextSupplier - 管理器上下文提供者，用于提供查询所需的上下文信息。可为 null。
 
 返回:
 
 执行操作的结果行数。
 
 抛出:
 
 RuntimeDaoException - 当数据访问发生异常时抛出。
 
 从以下版本开始:
 
 3.35.0
 - loadByJoinWhereForAction
```
int loadByJoinWhereForAction(java.lang.String join,
 java.lang.String where,
 java.lang.Object[] argList,
 int[] fieldList,
 int startRow,
 int numRows,
 TableManager.Action action)
 throws RuntimeDaoException
```
 已过时。 replaced by loadByJoinWhereForAction(String, String, Object[], int[], int, int, Action, Supplier)，since 3.35.0
 
 Retrieves each row of B bean given a sql where clause and a list of fields, and startRow and numRows, and dealt with action. It is up to you to pass the 'WHERE' in your where clauses.
 
 参数:
 
 join - the sql 'join' clause
 
 where - the sql 'where' clause
 
 argList - the arguments to use fill given prepared statement,may be null
 
 fieldList - table of the field's associated constants
 
 startRow - the start row to be used (first row = 1, last row = -1)
 
 numRows - the number of rows to be retrieved (all rows = a negative number)
 
 action - Action object for do something(not null)
 
 返回:
 
 the count dealt by action
 
 抛出:
 
 RuntimeDaoException
 - loadUniqueUsingTemplate
```
B loadUniqueUsingTemplate(B bean)
 throws RuntimeDaoException
```
 Loads a unique B bean from a template one giving a c
 
 参数:
 
 bean - the B bean to look for
 
 返回:
 
 the bean matching the template,or null if not found or null input argument
 
 抛出:
 
 ObjectRetrievalException - more than one row
 
 RuntimeDaoException
 - loadUniqueUsingTemplateChecked
```
B loadUniqueUsingTemplateChecked(B bean)
 throws RuntimeDaoException,
 ObjectRetrievalException
```
 Loads a unique B bean from a template one giving a c
 
 参数:
 
 bean - the B bean to look for
 
 返回:
 
 the bean matching the template
 
 抛出:
 
 ObjectRetrievalException - not found or more than one row
 
 RuntimeDaoException
 - loadUsingTemplate
```
B[] loadUsingTemplate(B bean)
 throws RuntimeDaoException
```
 Loads an array of B from a template one.
 
 参数:
 
 bean - the B bean template to look for
 
 返回:
 
 all the B beans matching the template
 
 抛出:
 
 RuntimeDaoException
 - loadUsingTemplate
```
int loadUsingTemplate(B bean,
 TableManager.Action action)
 throws RuntimeDaoException
```
 Loads each row from a template one and dealt with action.
 
 参数:
 
 bean - the B bean template to look for
 
 action - Action object for do something(not null)
 
 返回:
 
 the count dealt by action
 
 抛出:
 
 RuntimeDaoException
 - loadUsingTemplate
```
B[] loadUsingTemplate(B bean,
 int startRow,
 int numRows)
 throws RuntimeDaoException
```
 Loads an array of B bean from a template one, given the start row and number of rows.
 
 参数:
 
 bean - the B bean template to look for
 
 startRow - the start row to be used (first row = 1, last row=-1)
 
 numRows - the number of rows to be retrieved (all rows = a negative number)
 
 返回:
 
 all the B matching the template
 
 抛出:
 
 RuntimeDaoException
 - loadUsingTemplate
```
int loadUsingTemplate(B bean,
 int startRow,
 int numRows,
 TableManager.Action action)
 throws RuntimeDaoException
```
 Loads each row from a template one, given the start row and number of rows and dealt with action.
 
 参数:
 
 bean - the B bean template to look for
 
 startRow - the start row to be used (first row = 1, last row=-1)
 
 numRows - the number of rows to be retrieved (all rows = a negative number)
 
 action - Action object for do something(not null)
 
 返回:
 
 the count dealt by action
 
 抛出:
 
 RuntimeDaoException
 - loadUsingTemplate
```
int loadUsingTemplate(B bean,
 int[] fieldList,
 int startRow,
 int numRows,
 int searchType,
 TableManager.Action action)
 throws RuntimeDaoException
```
 Loads each row from a template one, given the start row and number of rows and dealt with action.
 
 参数:
 
 bean - the B template to look for
 
 fieldList - table of the field's associated constants
 
 startRow - the start row to be used (first row = 1, last row=-1)
 
 numRows - the number of rows to be retrieved (all rows = a negative number)
 
 searchType - exact ? like ? starting like ? ending link ?
 0 Constant.SEARCH_EXACT
 1 Constant.SEARCH_LIKE
 2 Constant.SEARCH_STARTING_LIKE
 3 Constant.SEARCH_ENDING_LIKE
 
 action - Action object for do something(not null)
 
 返回:
 
 the count dealt by action
 
 抛出:
 
 RuntimeDaoException
 - loadUsingTemplate
```
B[] loadUsingTemplate(B bean,
 int startRow,
 int numRows,
 int searchType)
 throws RuntimeDaoException
```
 Loads a list of B bean from a template one, given the start row and number of rows.
 
 参数:
 
 bean - the B bean template to look for
 
 startRow - the start row to be used (first row = 1, last row=-1)
 
 numRows - the number of rows to be retrieved (all rows = a negative number)
 
 searchType - exact ? like ? starting like ? ending link ?
 0 Constant.SEARCH_EXACT
 1 Constant.SEARCH_LIKE
 2 Constant.SEARCH_STARTING_LIKE
 3 Constant.SEARCH_ENDING_LIKE
 
 返回:
 
 all the B bean matching the template
 
 抛出:
 
 RuntimeDaoException
 - loadUsingTemplateAsList
```
java.util.List loadUsingTemplateAsList(B bean)
 throws RuntimeDaoException
```
 Loads a list of B bean from a template one.
 
 参数:
 
 bean - the B bean template to look for
 
 返回:
 
 all the B beans matching the template
 
 抛出:
 
 RuntimeDaoException
 - loadUsingTemplateAsList
```
java.util.List loadUsingTemplateAsList(B bean,
 int startRow,
 int numRows)
 throws RuntimeDaoException
```
 Loads a list of B bean from a template one, given the start row and number of rows.
 
 参数:
 
 bean - the B bean template to look for
 
 startRow - the start row to be used (first row = 1, last row=-1)
 
 numRows - the number of rows to be retrieved (all rows = a negative number)
 
 返回:
 
 all the B bean matching the template
 
 抛出:
 
 RuntimeDaoException
 - loadUsingTemplateAsList
```
java.util.List loadUsingTemplateAsList(B bean,
 int startRow,
 int numRows,
 int searchType)
 throws RuntimeDaoException
```
 Loads an array of B bean from a template one, given the start row and number of rows.
 
 参数:
 
 bean - the B bean template to look for
 
 startRow - the start row to be used (first row = 1, last row=-1)
 
 numRows - the number of rows to be retrieved (all rows = a negative number)
 
 searchType - exact ? like ? starting like ? ending link?
 0 Constant.SEARCH_EXACT
 1 Constant.SEARCH_LIKE
 2 Constant.SEARCH_STARTING_LIKE
 3 Constant.SEARCH_ENDING_LIKE
 
 返回:
 
 all the B beans matching the template
 
 抛出:
 
 RuntimeDaoException
 - foreachByWhere
```
void foreachByWhere(TableManager.DoEach each,
 boolean stopOnError,
 java.lang.String where)
 throws RuntimeDaoException
```
 Retrieves each row of B bean given a SQL where clause and a list of fields, and dealt with each action. It is up to you to pass the 'WHERE' in your where clauses.
 
 参数:
 
 each - DoForEach object for do something(not null)
 
 stopOnError - stop on error
 
 where - the SQL 'where' clause, retrieves all rows if null or empty
 
 抛出:
 
 RuntimeDaoException
 - foreachByJoinWhere
```
void foreachByJoinWhere(TableManager.DoEach each,
 boolean stopOnError,
 java.lang.String join,
 java.lang.String where)
 throws RuntimeDaoException
```
 Retrieves each row of B bean given a SQL where clause and a list of fields, and dealt with each action. It is up to you to pass the 'WHERE' in your where clauses.
 
 参数:
 
 each - DoForEach object for do something(not null)
 
 stopOnError - stop on error
 
 join - the sql 'join' clause
 
 where - the SQL 'where' clause, retrieves all rows if null or empty
 
 抛出:
 
 RuntimeDaoException
 - foreach
```
void foreach(TableManager.DoEach each,
 boolean stopOnError)
 throws RuntimeDaoException
```
 Retrieves each row of B bean given a SQL where clause and a list of fields, and dealt with each action. It is up to you to pass the 'WHERE' in your where clauses.
 
 参数:
 
 each - DoForEach object for do something(not null)
 
 stopOnError - stop on error
 
 抛出:
 
 RuntimeDaoException
 - registerListener
```
void registerListener(TableListener listener)
```
 Registers a unique TableListener listener.
 do nothing if TableListener instance exists
 
 参数:
 
 listener -
 - unregisterListener
```
void unregisterListener(TableListener listener)
```
 remove listener.
 
 参数:
 
 listener -
 - save
```
B save(B bean)
throws RuntimeDaoException
```
 Saves the B bean into the database.
 
 参数:
 
 bean - the B bean to be saved
 
 返回:
 
 the inserted or updated bean,or null if bean is null
 
 抛出:
 
 RuntimeDaoException
 - addIfAbsent
```
B addIfAbsent(B bean)
 throws RuntimeDaoException
```
 If the specified key is not already exist, add it to database. This is equivalent to
```
 
 if (!existsByPrimaryKey(bean))
 return insert(bean);
 else
 return loadByPrimaryKey(bean);
 
```
 except that the action is performed atomically .
 参数:
 
 bean - the B bean to be saved
 
 返回:
 
 the previous value exists in database, or saved bean if not exists bean , or null if bean is null
 
 抛出:
 
 RuntimeDaoException
 - save
```
B[] save(B[] beans)
 throws RuntimeDaoException
```
 Saves an array of B bean into the database.
 
 参数:
 
 beans - the array of B bean to be saved
 
 返回:
 
 always beans saved
 
 抛出:
 
 RuntimeDaoException
 - saveAsTransaction
```
<C extends java.util.Collection> C saveAsTransaction(C beans)
 throws RuntimeDaoException
```
 Saves a collection of B bean into the database.
 
 参数:
 
 beans - the B bean table to be saved
 
 返回:
 
 alwarys beans saved
 
 抛出:
 
 RuntimeDaoException
 - saveAsTransaction
```
B[] saveAsTransaction(B[] beans)
 throws RuntimeDaoException
```
 Saves an array of B bean into the database as transaction.
 
 参数:
 
 beans - the B bean table to be saved
 
 返回:
 
 alwarys beans saved
 
 抛出:
 
 RuntimeDaoException
 
 另请参阅:
 
 save(BaseBean[])
 - save
```
<C extends java.util.Collection> C save(C beans)
 throws RuntimeDaoException
```
 Saves a collection of B bean into the database as transaction.
 
 参数:
 
 beans - the B bean table to be saved
 
 返回:
 
 alwarys beans saved
 
 抛出:
 
 RuntimeDaoException
 - fastInsert
```
<C extends java.lang.Iterable> void fastInsert(int[] fieldList,
 C beans)
```
 Insert the B bean list into the database. no support TableListener
 
 参数:
 
 fieldList - table of the field's associated constants,if null as all field
 
 beans - the B bean list to be saved
 
 抛出:
 
 RuntimeDaoException
 
 从以下版本开始:
 
 3.15.4
 - loadColumnAsList
```
<T> java.util.List<T> loadColumnAsList(java.lang.String column,
 boolean distinct,
 java.lang.String where,
 int startRow,
 int numRows)
 throws RuntimeDaoException
```
 Load column from table.
 
 参数:
 
 column - column name or java file name of B
 
 distinct - select distinct values
 
 where - the sql 'where' clause
 
 startRow - the start row to be used (first row = 1, last row = -1)
 
 numRows - the number of rows to be retrieved (all rows = a negative number)
 
 返回:
 
 an list of column
 
 抛出:
 
 RuntimeDaoException
 - getListenerContainer
```
ListenerContainer getListenerContainer()
```
 返回:
 
 ListenerContainer instance of current table manager
 - getDataSourceConfig
```
IDataSourceConfig getDataSourceConfig()
```
 返回:
 
 data source information
 - getGeometryDataCodec
```
GeometryDataCodec getGeometryDataCodec()
```
 返回:
 
 Geometry Data code/decode instance
 
 从以下版本开始:
 
 3.18.0
 - lockAndUpdate
```
java.util.List lockAndUpdate(java.lang.String join,
 java.lang.String where,
 java.lang.Object[] argList,
 int[] fieldList,
 int lockLimit,
 LockUpateRunner updateRunner,
 com.google.common.base.Supplier<IManagerContext> contextSupplier)
 throws RuntimeDaoException
```
 锁定符合条件的行并根据锁定的行执行指定的更新操作。
 该方法会在事务中尝试锁定符合条件的行，若成功锁定则调用传入的更新操作对锁定的行进行更新。
 如果没有锁定到任何行，返回空表。
 NOTE:锁定成功传递给更新操作的行对象(updateRunner)的锁定行对象中仅包含的字段由fieldList决定。
 示例：
```
	String extraLimitExp = "(SELECT COUNT(*) FROM (SELECT coupon_id FROM test.t_coupon WHERE user_id = ? AND coupon_name=?) as c2)<1";
	Object[] extraLimitExpArgList = new Object[] {lockUserId, couponName};
 // 锁定t_coupon表中user_id字段为null的1行，锁定成功则更新锁定行，将当前用户ID写入锁定行的user_id，代表当前用户占有此记录。
 // 在更新锁定行时，extraLimitExp表达判断t_coupon表中是否已经存在user_id为当前用户的记录，如果是则更新失败。
 // 这样就确保t_coupon表中只有一条被当前用户占有的记录，即只能抢到一张优惠券。
 List<CouponBean> lockedCouponId = couponManager.lockAndUpdate("", 
 builder.toString(), argList, new int[] {0},1,
 (lockedRows) -> {
 for(Iterator<CouponBean> itor=lockedRows.iterator(); itor.hasNext();){
 CouponBean r = itor.next();
 r.setUserId(lockUserId);
 if (couponManager.updateWithCondition(r, extraLimitExp, extraLimitExpArgList) == 0) {
 // 更新失败删除当前元素
 itor.remove();
 }
 }
 });
 
 
```
 参数:
 
 join - 连接条件，用于表连接操作。为 null 时不添加连接条件。
 
 where - 筛选条件，用于过滤符合条件的行。为 null 时不添加筛选条件。
 
 argList - 参数列表，用于填充where语句中的占位符。为 null 则不填充。
 
 fieldList - 字段列表，指定要查询的字段。为 null 时查询所有字段。
 
 lockLimit - 锁定行数限制，若大于0，则锁定符合条件的前N行。为0时，锁定符合条件的所有行。
 
 updateRunner - 行更新逻辑，用于根据锁定的行执行更新逻辑，为 null时无效。
 
 contextSupplier - 管理器上下文提供者，用于提供查询所需的上下文信息。
 
 返回:
 
 锁定义并更新的行记录。根据参数fieldList指定的字段，返回行记录。
 
 抛出:
 
 RuntimeDaoException - 执行过程中出现运行时数据访问异常时抛出。
 
 从以下版本开始:
 
 3.35.0
 - lockAndUpdate
```
java.util.List lockAndUpdate(java.lang.String join,
 java.lang.String where,
 java.lang.Object[] argList,
 int[] fieldList,
 int lockLimit,
 LockUpateRunner updateRunner)
 throws RuntimeDaoException
```
 已过时。 use lockAndUpdate(String, String, Object[], int[], int, LockUpateRunner, Supplier)
 锁定符合条件的行并根据锁定的行执行指定的更新操作。
 lockAndUpdate(String, String, Object[], int[], int, LockUpateRunner, Supplier)的便利方法。
 等价于:
```
 lockAndUpdate(join, where, argList, fieldList, lockLimit, updateRunner, null);
 
```
 参数:
 
 join - 连接条件，用于表连接操作。
 
 where - 筛选条件，用于过滤符合条件的行。
 
 argList - 参数列表，用于填充where语句中的占位符。为 null 则不填充。
 
 fieldList - 字段列表，指定要查询的字段。为 null 时查询所有字段。
 
 lockLimit - 锁定行数限制，若大于0，则锁定符合条件的前N行。为0时，锁定符合条件的所有行。
 
 updateRunner - 行更新逻辑，用于对锁定的行进行更新，不能为 null。
 
 返回:
 
 锁定义并更新的行记录。包含锁定义行的主键值。
 
 抛出:
 
 RuntimeDaoException - 执行过程中出现运行时数据访问异常时抛出。
 
 从以下版本开始:
 
 3.35.0
 - lockAndUpdate
```
java.util.List lockAndUpdate(java.lang.String join,
 java.lang.String where,
 java.lang.Object[] argList,
 int limit,
 LockUpateRunner updateRunner,
 com.google.common.base.Supplier<IManagerContext> contextSupplier)
 throws RuntimeDaoException
```
 锁定符合条件的行并根据锁定的行执行指定的更新操作。
 该方法会在事务中尝试锁定符合条件的行，若成功锁定则调用传入的更新操作对锁定的行进行更新。
 如果没有锁定到任何行，返回空表。
 NOTE:锁定成功传递给更新操作的行对象(updateRunner)的锁定行对象中仅包含主键字段。
 
 参数:
 
 join - 连接条件，用于表连接操作。
 
 where - 筛选条件，用于过滤符合条件的行。
 
 argList - 参数列表，用于填充where语句中的占位符。为 null 则不填充。
 
 limit - 锁定行数限制，若大于0，则锁定符合条件的前N行。为0时，锁定符合条件的所有行。
 
 updateRunner - 行更新逻辑，用于对锁定的行进行更新，不能为 null。
 
 contextSupplier - 管理器上下文提供者，用于提供查询所需的上下文信息。
 
 返回:
 
 锁定义并更新的行记录。包含锁定义行的主键值。
 
 抛出:
 
 RuntimeDaoException - 执行过程中出现运行时数据访问异常时抛出。
 
 从以下版本开始:
 
 3.35.0
 - lockAndUpdate
```
java.util.List lockAndUpdate(java.lang.String join,
 java.lang.String where,
 java.lang.Object[] argList,
 int limit,
 LockUpateRunner updateRunner)
 throws RuntimeDaoException
```
 已过时。 use lockAndUpdate(String, String, Object[], int, LockUpateRunner, Supplier)
 锁定符合条件的行并根据锁定的行执行指定的更新操作。
 lockAndUpdate(String, String, Object[], int, LockUpateRunner, Supplier)的便利方法
 等价于:
```
 return lockAndUpdate(join, where, argList, limit, updateRunner, null);
 
```
 参数:
 
 join - 连接条件，用于表连接操作。为 null 时不添加连接条件。
 
 where - 筛选条件，用于过滤符合条件的行。为 null 时不添加筛选条件。
 
 argList - 参数列表，用于填充where语句中的占位符。为 null 则不填充。
 
 limit - 锁定并更新的最大行数
 
 updateRunner - 用于执行更新操作的执行器
 
 返回:
 
 被锁定并更新的行对应的 Java Bean 列表
 
 抛出:
 
 RuntimeDaoException - 运行时数据访问异常
 
 从以下版本开始:
 
 3.35.0
 - lockAndUpdate
```
boolean lockAndUpdate(B bean)
 throws RuntimeDaoException
```
 锁定并更新指定的bean。
 该方法会先检查传入的bean：
 如果为空或为新记录，返回false。如果bean的主键存在空值则抛出 RuntimeDaoException 异常。
 接着会根据bean的主键生成 WHERE 条件，调用 lockAndUpdate(String, String, Object[], int[], int, LockUpateRunner) 方法进行锁定并更新操作。
 若锁定过程中出现问题，返回false。
 
 参数:
 
 bean - 要锁定并更新的记录，类型为 B。
 
 返回:
 
 是否成功锁定并更新
 
 抛出:
 
 RuntimeDaoException - 当传入的bean为空或主键存在空值时抛出。
 
 从以下版本开始:
 
 3.35.0
 - updateWithCondition
```
int updateWithCondition(B bean,
 java.lang.String extraUpdateExp,
 java.lang.Object[] extraUpdateExpArgList)
 throws RuntimeDaoException
```
 根据指定条件更新数据库中 B 类型的 bean 记录。
 该方法会根据传入的 bean 对象的修改信息生成更新语句，同时可以结合额外的更新条件进行更新操作。
 如果 bean 为 null 或者没有被修改，则不会进行更新操作，直接返回 0。
 如果 bean 是新创建的，也不会进行更新操作，直接返回 0。
 如果表存在乐观锁字段，会在更新时进行乐观锁检查。
 
 参数:
 
 bean - 要更新的 B 类型的 bean 对象
 
 extraUpdateExp - 额外的更新条件表达式，可为 null
 
 extraUpdateExpArgList - 额外更新条件表达式对应的参数列表，可为 null
 
 返回:
 
 受影响的行数 1，如果没有进行更新操作则返回 0
 
 抛出:
 
 RuntimeDaoException - 当发生数据库操作异常时抛出
 
 从以下版本开始:
 
 3.35.0
 - tryLockRows
```
java.util.List tryLockRows(java.lang.String join,
 java.lang.String where,
 java.lang.Object[] argList,
 int[] fieldList,
 int lockLimit,
 Constant.RowLockType rowLockType,
 com.google.common.base.Supplier<IManagerContext> contextSupplier)
 throws RuntimeDaoException
```
 (悲观锁)尝试锁定满足条件的行。
 该方法适用于事务中执行，锁定满足查询条件的行，用于后续记录更新操作
 最终返回被锁定的行对应的 Java Bean 列表。
 示例：
```
 // 尝试锁定t_coupon表中满足user_id为null的1行，行锁定类型为 FOR_UPDATE
 // 等价执行 SQL：SELECT coupon_id FROM test.t_coupon WHERE user_id IS NULL LIMIT 1 FOR UPDATE
 List list = couponManager.tryLockRows(null, "WHERE user_id IS NULL", null, new int[]{0}, 1, RowLockType.FOR_UPDATE);
 
```
 参数:
 
 join - 连接条件，用于表连接操作。为 null 时不添加连接条件。
 
 where - 筛选条件，用于过滤符合条件的行。为 null 时不添加筛选条件。
 
 argList - 参数列表，用于填充where语句中的占位符。为 null 则不填充。
 
 fieldList - 字段列表，指定要查询的字段。为 null 时查询所有字段。
 
 lockLimit - 锁定的最大行数
 
 rowLockType - 行锁定类型
 
 contextSupplier - 管理器上下文提供者，用于提供查询所需的上下文信息。
 
 返回:
 
 被锁定的行对应的 Java Bean 列表
 
 抛出:
 
 RuntimeDaoException - 运行时数据访问异常
 
 从以下版本开始:
 
 3.35.0
 - tryLockRows
```
java.util.List tryLockRows(java.lang.String join,
 java.lang.String where,
 java.lang.Object[] argList,
 int[] fieldList,
 int lockLimit,
 Constant.RowLockType rowLockType)
 throws RuntimeDaoException
```
 已过时。 use tryLockRows(String, String, Object[], int[], int, Constant.RowLockType, Supplier)
 (悲观锁)尝试锁定满足条件的行。
 tryLockRows(String, String, Object[], int[], int, Constant.RowLockType, Supplier) 等价于:
```
 tryLockRows(join, where, argList, fieldList, lockLimit, rowLockType, null);
 
```
 参数:
 
 join - JOIN 子句，用于表连接操作，可传入 null 或空字符串表示不使用 JOIN。
 
 where - WHERE 条件表达式，需以 'WHERE' 开头，也可以为 null 或空字符串。
 
 argList - WHERE 条件中的参数列表，用于填充 SQL 语句中的占位符 '?'，可为 null。
 
 fieldList - 要查询的字段 ID 列表，可传入 null 或空数组表示查询所有字段。
 
 lockLimit - 要锁定的最大行数限制。
 
 rowLockType - 行锁类型，指定锁定行的方式。
 
 返回:
 
 锁定行对应的 B 类型对象列表。
 
 抛出:
 
 RuntimeDaoException - 当数据访问发生异常时抛出。
 
 从以下版本开始:
 
 3.35.0
 - loadUniqueByIndexChecked
```
B loadUniqueByIndexChecked(java.lang.String indexName,
 java.lang.Object... indexValues)
 throws ObjectRetrievalException
```
 根据指定索引名称和索引值加载唯一的记录，并进行参数检查。
 如果索引值包含 null，将抛出 ObjectRetrievalException 异常。
 - indexName: 索引名称
 - indexValues: 索引值，可变参数

参数:: indexName - 索引名称; indexValues - 索引值数组
返回:: 符合条件的唯一记录对应的 B 类型对象
抛出:: ObjectRetrievalException - 当索引值包含 null 或加载记录失败时抛出
从以下版本开始:: 3.35.0

loadUniqueByIndex
```
B loadUniqueByIndex(java.lang.String indexName,
                    java.lang.Object... indexValues)
             throws RuntimeDaoException
```
根据索引名称和索引值加载唯一的记录。
该方法会根据指定的索引名称和对应的索引值，从数据库中查询并返回唯一匹配的记录。如果索引值包含 null，则返回 null。

参数:

indexName - 索引名称

indexValues - 索引值

返回:

匹配的记录对象，如果未找到或索引值包含 null 则返回 null

抛出:

RuntimeDaoException - 当数据访问发生错误时抛出

从以下版本开始:

3.35.0

listOfSelfRef
```
java.util.List listOfSelfRef(java.lang.String fkName,
 java.lang.Object... primaryKeys)
 throws RuntimeDaoException
```
return bean list ( include bean specified by primaryKeys ) by the self-reference field specified by fkName
first element is top bean

参数:

fkName - foreign key name

primaryKeys - values of primary keys

返回:

empty list if input primary key is null
first element equal last if self-reference field is cycle

抛出:

RuntimeDaoException

从以下版本开始:

3.35.0

listOfSelfRef
```
java.util.List listOfSelfRef(java.lang.String fkName,
 B bean)
 throws RuntimeDaoException
```
return bean list ( include bean ) by the self-reference field specified by fkName
first element is top bean

参数:

fkName - foreign key name

bean -

返回:

empty list if input primary key is null
first element equal last if self-reference field is cycle

抛出:

RuntimeDaoException

从以下版本开始:

3.35.0

childListOfSelfRef
```
java.util.List childListOfSelfRef(java.lang.String fkName,
 B bean)
 throws java.lang.IllegalStateException,
 RuntimeDaoException
```
return child bean list (self included) by the self-reference field specified by fkName
throw RuntimeDaoException if self-reference field is cycle

参数:

fkName - foreign key name

bean -

返回:

child bean list,empty list if not found record

抛出:

java.lang.IllegalStateException - if self-reference field is cycle

RuntimeDaoException

从以下版本开始:

3.35.0

childListOfSelfRef
```
java.util.List childListOfSelfRef(java.lang.String fkName,
 java.lang.Object... primaryKeys)
 throws java.lang.IllegalStateException,
 RuntimeDaoException
```
return child bean list (self included) by the self-reference field specified by fkName
throw RuntimeDaoException if self-reference field is cycle

参数:

fkName - foreign key name

primaryKeys - values of primary keys

返回:

child bean list,empty list if not found record

抛出:

java.lang.IllegalStateException - if self-reference field is cycle

RuntimeDaoException

从以下版本开始:

3.35.0

childrenOfSelfRef
```
java.util.Set childrenOfSelfRef(java.lang.String fkName,
 B bean)
 throws java.lang.IllegalStateException,
 RuntimeDaoException
```
return child bean list (self included) by the self-reference field specified by fkName
throw RuntimeDaoException if self-reference field is cycle

参数:

fkName - foreign key name

bean -

返回:

child bean list,empty list if not found record

抛出:

java.lang.IllegalStateException - if self-reference field is cycle

RuntimeDaoException

从以下版本开始:

3.35.0

childrenOfSelfRef
```
java.util.Set childrenOfSelfRef(java.lang.String fkName,
 java.lang.Object... primaryKeys)
 throws java.lang.IllegalStateException,
 RuntimeDaoException
```
return child bean list (self included) by the self-reference field specified by fkName
throw RuntimeDaoException if self-reference field is cycle

参数:

fkName - foreign key name

primaryKeys - values of primary keys

返回:

child bean list,empty list if not found record

抛出:

java.lang.IllegalStateException - if self-reference field is cycle

RuntimeDaoException

从以下版本开始:

3.35.0

childrenOfBeansOfSelfRef
```
java.util.Set childrenOfBeansOfSelfRef(java.lang.String fkName,
 java.lang.Iterable beans)
 throws RuntimeDaoException
```
return child bean list (self included) by the self-reference field specified by fkName
throw RuntimeDaoException if self-reference field is cycle

参数:

fkName - foreign key name

beans - B beans with primary keys

返回:

child bean list,empty list if not found record

抛出:

java.lang.IllegalStateException - if self-reference field is cycle

RuntimeDaoException

从以下版本开始:

3.35.0

childrenOfPksOfSelfRef
```
<T> java.util.Set childrenOfPksOfSelfRef(java.lang.String fkName,
 java.lang.Iterable<T> primaryKeys)
 throws RuntimeDaoException
```
return child bean list (self included) by the self-reference field specified by fkName
throw RuntimeDaoException if self-reference field is cycle

参数:

fkName - foreign key name

primaryKeys - values of primary keys

返回:

child bean list,empty list if not found record

抛出:

java.lang.IllegalStateException - if self-reference field is cycle

RuntimeDaoException

从以下版本开始:

3.35.0

接口 TableManager<B extends BaseBean>

嵌套类概要

方法概要

从接口继承的方法 gu.sql2java.SqlRunner

方法详细资料

createBean

createBeanWithPimaryKeys

countAll

countUsingTemplate

countUsingTemplate

countWhere

rowCountWhere

deleteAll

deleteByWhere

deleteUsingTemplate

deleteByPrimaryKey

delete

delete

delete

setValueIfNonNull

setValueIfNonEqual

loadAll

loadAll

loadAll

loadAll

loadAllAsList

loadAllAsList

loadByPrimaryKey

loadByPrimaryKeyChecked

loadByPrimaryKey

loadByPrimaryKeyChecked

existsPrimaryKey

existsByPrimaryKey

checkDuplicate

loadByWhere

loadByWhere

loadByWhere

loadByWhere

loadByWhere

loadByWhere

loadByWhereAsList

loadByWhereAsList

loadByWhereAsList

loadByWhereForAction

loadByJoinWhereAsList

loadByJoinWhereAsList

loadByJoinWhereAsList

loadByJoinWhereAsList

loadByJoinWhereAsList

loadByJoinWhereAsList

loadByJoinWhereAsList

loadByJoinWhereAsList

loadByJoinWhereForAction

loadByJoinWhereForAction

loadUniqueUsingTemplate

loadUniqueUsingTemplateChecked

loadUsingTemplate

loadUsingTemplate

loadUsingTemplate

loadUsingTemplate

loadUsingTemplate

loadUsingTemplate

loadUsingTemplateAsList

loadUsingTemplateAsList

loadUsingTemplateAsList

foreachByWhere

foreachByJoinWhere

foreach

registerListener

unregisterListener

save

addIfAbsent

save

saveAsTransaction

saveAsTransaction

save

fastInsert

loadColumnAsList

getListenerContainer

getDataSourceConfig