TableManager (sql2java-base 5.3.10-patch1 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.
`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.

从接口继承的方法 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

接口 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