TableManager (sql2java-base 1.0.1 API)

所有超级接口:

SqlRunner

所有已知实现类:

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

作者:

guyadong

嵌套类概要

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

static interface TableManager.Action

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

方法概要

方法
限定符和类型	方法和说明
`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.
`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`	`deleteByIndex(java.lang.String indexName, java.lang.Object... indexValues)` Deletes rows using key.
`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`	`deleteImportedBeans(B bean, java.lang.String fkName)` delete all imported beans by fkName
`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.
`<T extends BaseBean> T[]`	`getImportedBeans(B bean, java.lang.String fkName)` Retrieves imported T objects by fkIndex.
`<T extends BaseBean> java.util.List<T>`	`getImportedBeansAsList(B bean, java.lang.String fkname)` Retrieves imported T objects by ikIndex.
`<T extends BaseBean> T`	`getReferencedBean(B bean, java.lang.String fkName)` Retrieves the T object referenced by fkName.
`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.
`B[]`	`loadByIndex(java.lang.String indexName, java.lang.Object... indexValues)` Retrieves a array of B bean using the index specified by keyIndex.
`java.util.List<B>`	`loadByIndexAsList(java.lang.String indexName, java.lang.Object... indexValues)` Retrieves a list of B bean using the index specified by indexName.
`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, 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.
`TableListener<B>`	`registerListener(TableListener<B> listener)` Registers a unique `TableListener` listener.
`B`	`save(B bean)` Saves the B bean into the database.
`B[]`	`save(B[] beans)` Saves an array of B bean into the database.
`B`	`save(B bean, java.util.Map<java.lang.String,BaseBean> referenceBeans, java.util.Map<java.lang.String,java.util.Collection<BaseBean>> importedBeans)` Save the B bean and referenced beans and imported beans 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.
`B`	`saveAsTransaction(B bean, java.util.Map<java.lang.String,BaseBean> referenceBeans, java.util.Map<java.lang.String,java.util.Collection<BaseBean>> importedBeans)` Transaction version for sync save
`<C extends java.util.Collection<B>> C`	`saveAsTransaction(C beans)` Saves a collection of B bean into the database.
`<T extends BaseBean,C extends java.util.Collection<T>> C`	`setImportedBeans(B bean, C importedBeans, java.lang.String fkName)` Set the importedBeans associates to the bean by fkIndex
`<T extends BaseBean> T[]`	`setImportedBeans(B bean, T[] importedBeans, java.lang.String fkName)` Set the importedBeans associates to the bean by `ikIndex`
`<T extends BaseBean> T`	`setReferencedBean(B bean, T beanToSet, java.lang.String fkName)` Associates the B object to the T object by fkName field.
`void`	`unregisterListener(TableListener<B> listener)` remove listener.

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

- 方法详细资料
 - 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 ?
 Constant.SEARCH_EXACT
 Constant.SEARCH_LIKE
 Constant.SEARCH_STARTING_LIKE
 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
 - 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
 - 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,
 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
 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 ?
 Constant.SEARCH_EXACT
 Constant.SEARCH_LIKE
 Constant.SEARCH_STARTING_LIKE
 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 ?
 Constant.SEARCH_EXACT
 Constant.SEARCH_LIKE
 Constant.SEARCH_STARTING_LIKE
 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?
 Constant.SEARCH_EXACT
 Constant.SEARCH_LIKE
 Constant.SEARCH_STARTING_LIKE
 Constant.SEARCH_ENDING_LIKE
 
 返回:
 all the B beans matching the template
 
 抛出:
 
 RuntimeDaoException
 - loadByIndex
```
B[] loadByIndex(java.lang.String indexName,
 java.lang.Object... indexValues)
 throws RuntimeDaoException
```
 Retrieves a array of B bean using the index specified by keyIndex.
 
 参数:
 indexName - name of index
 indexValues - key values of index
 
 返回:
 B array
 
 抛出:
 
 RuntimeDaoException
 另请参阅:
 #loadByIndexAsList(int ,Object ...)
 - loadByIndexAsList
```
java.util.List loadByIndexAsList(java.lang.String indexName,
 java.lang.Object... indexValues)
 throws RuntimeDaoException
```
 Retrieves a list of B bean using the index specified by indexName.
 
 参数:
 indexName - name of index
 indexValues - key values of index
 
 返回:
 a list of B bean
 
 抛出:
 
 RuntimeDaoException
 - loadUniqueByIndex
```
B loadUniqueByIndex(java.lang.String indexName,
 java.lang.Object... indexValues)
 throws RuntimeDaoException
```
 抛出:
 
 RuntimeDaoException
 - loadUniqueByIndexChecked
```
B loadUniqueByIndexChecked(java.lang.String indexName,
 java.lang.Object... indexValues)
 throws ObjectRetrievalException
```
 抛出:
 
 ObjectRetrievalException
 - deleteByIndex
```
int deleteByIndex(java.lang.String indexName,
 java.lang.Object... indexValues)
 throws RuntimeDaoException
```
 Deletes rows using key.
 
 参数:
 indexName - name of index
 indexValues - key values of index
 
 返回:
 the number of deleted objects
 
 抛出:
 
 RuntimeDaoException
 - registerListener
```
TableListener 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
 - 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
 - save
```
B save(B bean,
 java.util.Map<java.lang.String,BaseBean> referenceBeans,
 java.util.Map<java.lang.String,java.util.Collection<BaseBean>> importedBeans)
 throws RuntimeDaoException
```
 Save the B bean and referenced beans and imported beans into the database.
 
 参数:
 bean - the B bean to be saved
 referenceBeans - referenced beans beans
 importedBeans - imported beans
 
 返回:
 the inserted or updated B bean
 
 抛出:
 
 RuntimeDaoException
 - saveAsTransaction
```
B saveAsTransaction(B bean,
 java.util.Map<java.lang.String,BaseBean> referenceBeans,
 java.util.Map<java.lang.String,java.util.Collection<BaseBean>> importedBeans)
 throws RuntimeDaoException
```
 Transaction version for sync save
 
 参数:
 bean - the B bean to be saved
 referenceBeans - referenced beans beans
 importedBeans - imported beans
 
 返回:
 the inserted or updated B bean
 
 抛出:
 
 RuntimeDaoException
 另请参阅:
 save(BaseBean ,Map,Map)
 - 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
 - getReferencedBean
```
<T extends BaseBean> T getReferencedBean(B bean,
 java.lang.String fkName)
 throws RuntimeDaoException
```
 Retrieves the T object referenced by fkName.
 
 类型参数:
 T -
 参数:
 bean - the B object to use
 fkName - foreign key name.
 
 返回:
 the associated T bean or null if bean is null
 
 抛出:
 
 RuntimeDaoException
 - setReferencedBean
```
<T extends BaseBean> T setReferencedBean(B bean,
 T beanToSet,
 java.lang.String fkName)
 throws RuntimeDaoException
```
 Associates the B object to the T object by fkName field.
 
 类型参数:
 T - see also getReferencedBean(BaseBean, String)
 参数:
 bean - the B object to use
 beanToSet - the T object to associate to the B bean
 fkName - see also getReferencedBean(BaseBean, String)
 
 返回:
 always beanToSet saved
 
 抛出:
 
 RuntimeDaoException
 - getImportedBeans
```
<T extends BaseBean> T[] getImportedBeans(B bean,
 java.lang.String fkName)
 throws RuntimeDaoException
```
 Retrieves imported T objects by fkIndex.
 
 类型参数:
 T -
 参数:
 bean - the B object to use
 fkName - foreign key name.
 
 返回:
 the associated T beans or null if bean is null
 
 抛出:
 
 RuntimeDaoException
 - getImportedBeansAsList
```
<T extends BaseBean> java.util.List<T> getImportedBeansAsList(B bean,
 java.lang.String fkname)
 throws RuntimeDaoException
```
 Retrieves imported T objects by ikIndex.
 
 类型参数:
 T - see also getImportedBeans(BaseBean, String)
 参数:
 bean - the B object to use
 fkname - foreign key name.see also getImportedBeans(BaseBean, String)
 
 返回:
 the associated T beans or null if bean is null
 
 抛出:
 
 RuntimeDaoException
 - setImportedBeans
```
<T extends BaseBean> T[] setImportedBeans(B bean,
 T[] importedBeans,
 java.lang.String fkName)
 throws RuntimeDaoException
```
 Set the importedBeans associates to the bean by ikIndex
 
 类型参数:
 T - see also getImportedBeans(BaseBean, String)
 参数:
 bean - the bean object to use
 importedBeans - the T object to associate to bean
 fkName - foreign key name.see also getImportedBeans(BaseBean, String)
 
 返回:
 importedBeans always
 
 抛出:
 
 RuntimeDaoException
 - setImportedBeans
```
<T extends BaseBean,C extends java.util.Collection<T>> C setImportedBeans(B bean,
 C importedBeans,
 java.lang.String fkName)
 throws RuntimeDaoException
```
 Set the importedBeans associates to the bean by fkIndex
 
 类型参数:
 T - see also getImportedBeans(BaseBean, String)
 参数:
 bean - the bean object to use
 importedBeans - the T object to associate to bean
 fkName - foreign key name. see also getImportedBeans(BaseBean, String)
 
 返回:
 importedBeans always
 
 抛出:
 
 RuntimeDaoException
 - deleteImportedBeans
```
int deleteImportedBeans(B bean,
 java.lang.String fkName)
 throws RuntimeDaoException
```
 delete all imported beans by fkName
 
 参数:
 bean -
 fkName - foreign key name
 
 返回:
 deleted row count
 
 抛出:
 
 RuntimeDaoException

接口 TableManager<B extends BaseBean>

嵌套类概要

方法概要

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

方法详细资料

countAll

countUsingTemplate

countUsingTemplate

countWhere

deleteAll

deleteByWhere

deleteUsingTemplate

deleteByPrimaryKey

delete

delete

delete

loadAll

loadAll

loadAll

loadAll

loadAllAsList

loadAllAsList

loadByPrimaryKey

loadByPrimaryKeyChecked

loadByPrimaryKey

loadByPrimaryKeyChecked

existsPrimaryKey

existsByPrimaryKey

checkDuplicate

loadByWhere

loadByWhere

loadByWhere

loadByWhere

loadByWhere

loadByWhere

loadByWhereAsList

loadByWhereAsList

loadByWhereAsList

loadByWhereForAction

loadUniqueUsingTemplate

loadUniqueUsingTemplateChecked

loadUsingTemplate

loadUsingTemplate

loadUsingTemplate

loadUsingTemplate

loadUsingTemplate

loadUsingTemplate

loadUsingTemplateAsList

loadUsingTemplateAsList

loadUsingTemplateAsList

loadByIndex

loadByIndexAsList

loadUniqueByIndex

loadUniqueByIndexChecked

deleteByIndex

registerListener

unregisterListener

save

save

saveAsTransaction

saveAsTransaction

save

save

saveAsTransaction

loadColumnAsList

getReferencedBean

setReferencedBean

getImportedBeans

getImportedBeansAsList

setImportedBeans

setImportedBeans

deleteImportedBeans