gu.sql2java

Interface TableManager<B extends BaseBean>

All Superinterfaces:

SqlRunner

public interface TableManager<B extends BaseBean>
extends SqlRunner

Interface to handle database calls (save, load, count, etc...) for table.

Author:

guyadong

Nested Class Summary

Nested Classes

Modifier and Type	Interface and Description
static interface	TableManager.Action<B>
static interface	TableManager.DoEach<B> interface for iterate

Method Summary

Modifier and Type	Method and Description
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. when you don't know which is primary key of table,you can use the method.
boolean	existsPrimaryKey(java.lang.Object... keys) Returns true if this table contains row with primary key fields.
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	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.
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	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	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. do nothing if TableListener instance exists
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.
void	unregisterListener(TableListener<B> listener) remove listener.

Methods inherited from interface gu.sql2java.SqlRunner

runAsTransaction, runAsTransaction, runSql, runSql, runSqlAsList, runSqlAsList, runSqlForMap, runSqlForValue

Method Detail

createBean

B createBean()

Creates a new B instance.

Returns:

the new B instance

countAll

int countAll()
      throws RuntimeDaoException

Retrieves the number of rows of the table.

Returns:

the number of rows returned

Throws:

RuntimeDaoException

countUsingTemplate

int countUsingTemplate(B bean)
                throws RuntimeDaoException

count the number of elements of a specific bean

Parameters:

bean - the bean to look for ant count

Returns:

the number of rows returned

Throws:

RuntimeDaoException

countUsingTemplate

int countUsingTemplate(B bean,
                       int searchType)
                throws RuntimeDaoException

count the number of elements of a specific bean given the search type

Parameters:

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

Returns:

the number of rows returned

Throws:

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.

Parameters:

where - the restriction clause

Returns:

the number of rows returned

Throws:

RuntimeDaoException

deleteAll

int deleteAll()
       throws RuntimeDaoException

Deletes all rows from table.

Returns:

the number of deleted rows.

Throws:

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.

Parameters:

where - the sql 'where' clause

Returns:

the number of deleted rows

Throws:

RuntimeDaoException

deleteUsingTemplate

int deleteUsingTemplate(B bean)
                 throws RuntimeDaoException

Deletes rows using a template.

Parameters:

bean - the template object(s) to be deleted

Returns:

the number of deleted objects

Throws:

RuntimeDaoException

deleteByPrimaryKey

int deleteByPrimaryKey(java.lang.Object... keys)
                throws RuntimeDaoException

Delete row according to its primary keys.

Parameters:

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

Returns:

the number of deleted rows

Throws:

RuntimeDaoException

delete

int delete(B bean)
    throws RuntimeDaoException

Delete row according to primary keys of bean.

Parameters:

bean - will be deleted ,all keys must not be null

Returns:

the number of deleted rows,0 returned if bean is null

Throws:

RuntimeDaoException

delete

int delete(B... beans)
    throws RuntimeDaoException

Delete beans.

Parameters:

beans - B array will be deleted

Returns:

the number of deleted rows

Throws:

RuntimeDaoException

delete

int delete(java.util.Collection<B> beans)
    throws RuntimeDaoException

Delete beans.

Parameters:

beans - B collection will be deleted

Returns:

the number of deleted rows

Throws:

RuntimeDaoException

loadAll

B[] loadAll()
     throws RuntimeDaoException

Loads all the rows from table.

Returns:

an array of B bean

Throws:

RuntimeDaoException

loadAll

int loadAll(TableManager.Action<B> action)
     throws RuntimeDaoException

Loads each row from table and dealt with action.

Parameters:

action - Action object for do something(not null)

Returns:

the count dealt by action

Throws:

RuntimeDaoException

loadAll

B[] loadAll(int startRow,
            int numRows)
     throws RuntimeDaoException

Loads the given number of rows from table, given the start row.

Parameters:

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)

Returns:

an array of B bean

Throws:

RuntimeDaoException

loadAll

int loadAll(int startRow,
            int numRows,
            TableManager.Action<B> action)
     throws RuntimeDaoException

Loads the given number of rows from table, given the start row and dealt with action.

Parameters:

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)

Returns:

the count dealt by action

Throws:

RuntimeDaoException

loadAllAsList

java.util.List<B> loadAllAsList()
                         throws RuntimeDaoException

Loads all the rows from table.

Returns:

a list of B bean

Throws:

RuntimeDaoException

loadAllAsList

java.util.List<B> loadAllAsList(int startRow,
                                int numRows)
                         throws RuntimeDaoException

Loads the given number of rows from table, given the start row.

Parameters:

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)

Returns:

a list of B bean

Throws:

RuntimeDaoException

loadByPrimaryKey

B loadByPrimaryKey(B bean)
            throws RuntimeDaoException

Loads a B bean from the table using primary key fields of bean.

Parameters:

bean - the B bean with primary key fields

Returns:

a unique B or null if not found or bean is null

Throws:

RuntimeDaoException

loadByPrimaryKeyChecked

B loadByPrimaryKeyChecked(B bean)
                   throws RuntimeDaoException,
                          ObjectRetrievalException

see also loadByPrimaryKey(BaseBean)

Parameters:

bean -

Returns:

a unique B ,otherwise throw exception

Throws:

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.

Parameters:

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

Returns:

a unique B or null if not found

Throws:

RuntimeDaoException

loadByPrimaryKeyChecked

B loadByPrimaryKeyChecked(java.lang.Object... keys)
                   throws RuntimeDaoException,
                          ObjectRetrievalException

see also loadByPrimaryKey(Object...)

Parameters:

keys -

Returns:

a unique B,otherwise throw exception

Throws:

ObjectRetrievalException - not found

RuntimeDaoException

existsPrimaryKey

boolean existsPrimaryKey(java.lang.Object... keys)
                  throws RuntimeDaoException

Returns true if this table contains row with primary key fields.

Parameters:

keys - primary keys value

Throws:

RuntimeDaoException

See Also:

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.

Parameters:

bean - the B bean with primary key fields

Throws:

RuntimeDaoException

See Also:

loadByPrimaryKey(BaseBean)

checkDuplicate

B checkDuplicate(B bean)
          throws RuntimeDaoException,
                 ObjectRetrievalException

Check duplicated row by primary keys,if row exists throw exception

Parameters:

bean - the B bean with primary key fields

Returns:

always bean

Throws:

ObjectRetrievalException - has duplicated record

RuntimeDaoException

See Also:

existsByPrimaryKey(BaseBean)

loadByWhere

B[] loadByWhere(java.lang.String where)
         throws RuntimeDaoException

Retrieves an array of B given a sql 'where' clause.

Parameters:

where - the sql 'where' clause

Throws:

RuntimeDaoException

loadByWhere

int loadByWhere(java.lang.String where,
                TableManager.Action<B> action)
         throws RuntimeDaoException

Retrieves each row of B bean given a sql 'where' clause and dealt with action.

Parameters:

where - the sql 'where' clause

action - Action object for do something(not null)

Returns:

the count dealt by action

Throws:

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.

Parameters:

where - the sql 'WHERE' clause

fieldList - array of field's ID

Throws:

RuntimeDaoException

loadByWhere

int loadByWhere(java.lang.String where,
                int[] fieldList,
                TableManager.Action<B> 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.

Parameters:

where - the sql 'WHERE' clause

fieldList - array of field's ID

action - Action object for do something(not null)

Returns:

the count dealt by action

Throws:

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.

Parameters:

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)

Throws:

RuntimeDaoException

loadByWhere

int loadByWhere(java.lang.String where,
                int[] fieldList,
                int startRow,
                int numRows,
                TableManager.Action<B> 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.

Parameters:

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)

Returns:

the count dealt by action

Throws:

RuntimeDaoException

loadByWhereAsList

java.util.List<B> loadByWhereAsList(java.lang.String where)
                             throws RuntimeDaoException

Retrieves a list of B bean given a sql 'where' clause.

Parameters:

where - the sql 'where' clause

Throws:

RuntimeDaoException

loadByWhereAsList

java.util.List<B> 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.

Parameters:

where - the sql 'WHERE' clause

fieldList - array of field's ID

Throws:

RuntimeDaoException

loadByWhereAsList

java.util.List<B> 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.

Parameters:

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)

Throws:

RuntimeDaoException

loadByWhereForAction

int loadByWhereForAction(java.lang.String where,
                         int[] fieldList,
                         int startRow,
                         int numRows,
                         TableManager.Action<B> 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.

Parameters:

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)

Returns:

the count dealt by action

Throws:

RuntimeDaoException

loadUniqueUsingTemplate

B loadUniqueUsingTemplate(B bean)
                   throws RuntimeDaoException

Loads a unique B bean from a template one giving a c

Parameters:

bean - the B bean to look for

Returns:

the bean matching the template,or null if not found or null input argument

Throws:

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

Parameters:

bean - the B bean to look for

Returns:

the bean matching the template

Throws:

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.

Parameters:

bean - the B bean template to look for

Returns:

all the B beans matching the template

Throws:

RuntimeDaoException

loadUsingTemplate

int loadUsingTemplate(B bean,
                      TableManager.Action<B> action)
               throws RuntimeDaoException

Loads each row from a template one and dealt with action.

Parameters:

bean - the B bean template to look for

action - Action object for do something(not null)

Returns:

the count dealt by action

Throws:

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.

Parameters:

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)

Returns:

all the B matching the template

Throws:

RuntimeDaoException

loadUsingTemplate

int loadUsingTemplate(B bean,
                      int startRow,
                      int numRows,
                      TableManager.Action<B> action)
               throws RuntimeDaoException

Loads each row from a template one, given the start row and number of rows and dealt with action.

Parameters:

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)

Returns:

the count dealt by action

Throws:

RuntimeDaoException

loadUsingTemplate

int loadUsingTemplate(B bean,
                      int[] fieldList,
                      int startRow,
                      int numRows,
                      int searchType,
                      TableManager.Action<B> action)
               throws RuntimeDaoException

Loads each row from a template one, given the start row and number of rows and dealt with action.

Parameters:

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)

Returns:

the count dealt by action

Throws:

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.

Parameters:

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

Returns:

all the B bean matching the template

Throws:

RuntimeDaoException

loadUsingTemplateAsList

java.util.List<B> loadUsingTemplateAsList(B bean)
                                   throws RuntimeDaoException

Loads a list of B bean from a template one.

Parameters:

bean - the B bean template to look for

Returns:

all the B beans matching the template

Throws:

RuntimeDaoException

loadUsingTemplateAsList

java.util.List<B> 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.

Parameters:

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)

Returns:

all the B bean matching the template

Throws:

RuntimeDaoException

loadUsingTemplateAsList

java.util.List<B> 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.

Parameters:

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

Returns:

all the B beans matching the template

Throws:

RuntimeDaoException

foreachByWhere

void foreachByWhere(TableManager.DoEach<B> 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.

Parameters:

each - DoForEach object for do something(not null)

stopOnError - stop on error

where - the SQL 'where' clause, retrieves all rows if null or empty

Throws:

RuntimeDaoException

foreach

void foreach(TableManager.DoEach<B> 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.

Parameters:

each - DoForEach object for do something(not null)

stopOnError - stop on error

Throws:

RuntimeDaoException

registerListener

void registerListener(TableListener<B> listener)

Registers a unique TableListener listener.
do nothing if TableListener instance exists

Parameters:

listener -

unregisterListener

void unregisterListener(TableListener<B> listener)

remove listener.

Parameters:

listener -

save

B save(B bean)
throws RuntimeDaoException

Saves the B bean into the database.

Parameters:

bean - the B bean to be saved

Returns:

the inserted or updated bean,or null if bean is null

Throws:

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 .

Parameters:

bean - the B bean to be saved

Returns:

the previous value exists in database, or saved bean if not exists bean , or null if bean is null

Throws:

RuntimeDaoException

save

B[] save(B[] beans)
  throws RuntimeDaoException

Saves an array of B bean into the database.

Parameters:

beans - the array of B bean to be saved

Returns:

always beans saved

Throws:

RuntimeDaoException

saveAsTransaction

<C extends java.util.Collection<B>> C saveAsTransaction(C beans)
                                                 throws RuntimeDaoException

Saves a collection of B bean into the database.

Parameters:

beans - the B bean table to be saved

Returns:

alwarys beans saved

Throws:

RuntimeDaoException

saveAsTransaction

B[] saveAsTransaction(B[] beans)
               throws RuntimeDaoException

Saves an array of B bean into the database as transaction.

Parameters:

beans - the B bean table to be saved

Returns:

alwarys beans saved

Throws:

RuntimeDaoException

See Also:

save(BaseBean[])

save

<C extends java.util.Collection<B>> C save(C beans)
                                    throws RuntimeDaoException

Saves a collection of B bean into the database as transaction.

Parameters:

beans - the B bean table to be saved

Returns:

alwarys beans saved

Throws:

RuntimeDaoException

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.

Parameters:

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)

Returns:

an list of column

Throws:

RuntimeDaoException