TableManager (sql2java-base 5.5.0-patch2 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
`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.
`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()`
`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)` Retrieves a list of B bean given a sql 'where' clause.
`java.util.List<B>`	`loadByJoinWhereAsList(java.lang.String join, 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.
`java.util.List<B>`	`loadByJoinWhereAsList(java.lang.String join, java.lang.String where, java.lang.Object[] argList, int[] fieldList)` Retrieves a list of B bean given a sql where clause, and a list of fields.
`<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)` Retrieves a list of T bean given a sql where clause and a list of fields, and startRow and numRows.
`int`	`loadByJoinWhereForAction(java.lang.String join, 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 with action.
`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`	`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, java.lang.String extraLimitExp, java.lang.Object[] extraLimitExpArgList, LockUpateRunner<B> updateRunner)` 锁定符合条件的行并根据锁定的行执行指定的更新操作。
`java.util.List<B>`	`lockAndUpdate(java.lang.String join, java.lang.String where, java.lang.Object[] argList, java.lang.String extraLimitExp, java.lang.Object[] extraLimitExpArgList, LockUpateRunner<B> updateRunner)` 锁定符合条件的行并根据锁定的行执行指定的更新操作。
`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
`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
 - 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
 - loadByJoinWhereAsList
```
java.util.List loadByJoinWhereAsList(java.lang.String join,
 java.lang.String where)
 throws RuntimeDaoException
```
 Retrieves a list of B bean given a sql 'where' clause.
 
 参数:
 
 join - the sql 'join' 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
 - loadByJoinWhereAsList
```
java.util.List loadByJoinWhereAsList(java.lang.String join,
 java.lang.String where,
 java.lang.Object[] argList,
 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.
 
 参数:
 
 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
 - 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
 - loadByJoinWhereAsList
```
java.util.List loadByJoinWhereAsList(java.lang.String join,
 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.
 
 参数:
 
 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)
 throws RuntimeDaoException
```
 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
 - 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
 - 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
```
 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,
 java.lang.String extraLimitExp,
 java.lang.Object[] extraLimitExpArgList,
 LockUpateRunner updateRunner)
 throws RuntimeDaoException
```
 锁定符合条件的行并根据锁定的行执行指定的更新操作。
 该方法会在事务中尝试锁定符合条件的行，若成功锁定则调用传入的更新操作对锁定的行进行更新。
 如果没有锁定到任何行，返回空表。
 NOTE:锁定成功传递给更新操作的行对象(updateRunner)的锁定行对象中仅包含的字段由fieldList决定。
 
 参数:
 
 join - 连接条件，用于表连接操作。为 null 时不添加连接条件。
 
 where - 筛选条件，用于过滤符合条件的行。为 null 时不添加筛选条件。
 
 argList - 参数列表，用于填充SQL语句中的占位符。为 null 则不填充。
 
 fieldList - 字段列表，指定要查询的字段。为 null 时查询所有字段。
 
 lockLimit - 锁定行数限制，若大于0，则锁定符合条件的前N行。为0时，锁定符合条件的所有行。
 
 extraLimitExp - 额外的筛选条件，用于过滤符合条件的行，可为{code null}。
 
 extraLimitExpArgList - 额外筛选条件参数列表，用于填充额外筛选条件中的占位符。为 null 则不填充。
 
 updateRunner - 行更新逻辑，用于根据锁定的行执行更新逻辑，不能为 null。
 
 返回:
 
 锁定义并更新的行记录。根据参数fieldList指定的字段，返回行记录。
 
 抛出:
 
 RuntimeDaoException - 执行过程中出现运行时数据访问异常时抛出。
 
 从以下版本开始:
 
 3.35.0
 - lockAndUpdate
```
java.util.List lockAndUpdate(java.lang.String join,
 java.lang.String where,
 java.lang.Object[] argList,
 java.lang.String extraLimitExp,
 java.lang.Object[] extraLimitExpArgList,
 LockUpateRunner updateRunner)
 throws RuntimeDaoException
```
 锁定符合条件的行并根据锁定的行执行指定的更新操作。
 该方法会在事务中尝试锁定符合条件的行，若成功锁定则调用传入的更新操作对锁定的行进行更新。
 如果没有锁定到任何行，返回空表。
 NOTE:锁定成功传递给更新操作的行对象(updateRunner)的锁定行对象中仅包含主键字段。
 
 参数:
 
 join - 连接条件，用于表连接操作。
 
 where - 筛选条件，用于过滤符合条件的行。
 
 argList - 参数列表，用于填充SQL语句中的占位符。为 null 则不填充。
 
 extraLimitExp - 额外的筛选条件，用于过滤符合条件的行，可为{code null}。
 
 extraLimitExpArgList - 额外筛选条件参数列表，用于填充额外筛选条件中的占位符。为 null 则不填充。
 
 updateRunner - 行更新逻辑，用于对锁定的行进行更新，不能为 null。
 
 返回:
 
 锁定义并更新的行记录。包含锁定义行的主键值。
 
 抛出:
 
 RuntimeDaoException - 执行过程中出现运行时数据访问异常时抛出。
 
 从以下版本开始:
 
 3.35.0
 - lockAndUpdate
```
boolean lockAndUpdate(B bean)
 throws RuntimeDaoException
```
 锁定并更新指定的bean。
 该方法会先检查传入的bean：
 如果为空或为新记录，返回false。如果bean的主键存在空值则抛出 RuntimeDaoException 异常。
 接着会根据bean的主键生成 WHERE 条件，调用 #lockAndUpdate(String, String, Object[], int[], int, String, Object[], java.util.function.Consumer) 方法进行锁定并更新操作。
 若锁定过程中出现问题，返回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

接口 TableManager<B extends BaseBean>

嵌套类概要

方法概要

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

方法详细资料

createBean

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

loadByJoinWhereAsList

loadByWhereAsList

loadByJoinWhereAsList

loadByWhereAsList

loadByJoinWhereAsList

loadByJoinWhereAsList

loadByWhereForAction

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

getGeometryDataCodec

lockAndUpdate

lockAndUpdate

lockAndUpdate

updateWithCondition