ru.bgcrm.dao

Class AbstractDAO<B extends Id>

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.AbstractDAO<B>

public abstract class AbstractDAO<B extends Id>
extends CommonDAO

DAO для работы с конкретным объектом.

Nested Class Summary

Nested classes/interfaces inherited from class ru.bgcrm.dao.CommonDAO

CommonDAO.ObjectExtractor<T>, CommonDAO.RecordUpdater<T extends Id>

Field Summary

Fields

Modifier and Type	Field and Description
protected static java.util.regex.Pattern	orderByPattern
protected java.lang.String	tableName

Fields inherited from class ru.bgcrm.dao.CommonDAO

con, dateFormat_DDMMYYYY, dateFormat_DDMMYYYY_HHMM, log, SQL_AND, SQL_DELETE, SQL_DESC, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT, SQL_INSERT_IGNORE, SQL_LEFT_JOIN, SQL_LEFT_OUTER_JOIN, SQL_LIMIT, SQL_ON_DUP_KEY_UPDATE, SQL_OR, SQL_ORDER_BY, SQL_REPLACE, SQL_SELECT, SQL_SELECT_ALL_FROM, SQL_SELECT_COUNT_ROWS, SQL_SET, SQL_UPDATE, SQL_WHERE

Constructor Summary

Constructors

Constructor and Description
AbstractDAO(java.sql.Connection con, java.lang.String tableName)
AbstractDAO(java.sql.Connection con, java.lang.String tableName, java.util.Date date)

Method Summary

Modifier and Type	Method and Description
int	delete(int id)
protected int	deleteById(int id)
protected int	deleteImpl(int id)
B	get(int id)
protected B	get(java.lang.String filter, java.lang.Object... params)
protected B	getById(int id)
protected abstract B	getFromRS(java.sql.ResultSet rs)
protected B	getImpl(int id)
protected void	getListFromRS(java.sql.ResultSet rs, java.util.List<B> result)
protected java.lang.String	getTableName(java.lang.String tableName, java.util.Date date)
protected java.util.List<B>	list(java.lang.String filter, java.lang.String orderBy, java.lang.Object... params)
protected java.util.List<B>	listImpl(java.lang.String filter, java.lang.String orderBy, java.lang.Object... params)
protected void	processException(java.sql.SQLException e)
void	update(B b)
protected abstract void	updateImpl(B b)

Methods inherited from class ru.bgcrm.dao.CommonDAO

deleteById, execute, execute, execute, executeInsert, executeUpdate, getById, getFoundRows, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, getLikePatternEnd, getLikePatternStart, getLikePatternSub, getMySQLLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, update, updateColumn, updateIds, updateIds

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

tableName

protected final java.lang.String tableName

orderByPattern

protected static final java.util.regex.Pattern orderByPattern

Constructor Detail

AbstractDAO

public AbstractDAO(java.sql.Connection con,
                   java.lang.String tableName)

AbstractDAO

public AbstractDAO(java.sql.Connection con,
                   java.lang.String tableName,
                   java.util.Date date)

Method Detail

getTableName

protected java.lang.String getTableName(java.lang.String tableName,
                                        java.util.Date date)

processException

protected void processException(java.sql.SQLException e)
                         throws BGException

Throws:

BGException

update

public void update(B b)
            throws BGException

Throws:

BGException

updateImpl

protected abstract void updateImpl(B b)
                            throws BGException,
                                   java.sql.SQLException

Throws:

BGException

java.sql.SQLException

get

public B get(int id)
      throws BGException

Throws:

BGException

getImpl

protected B getImpl(int id)
             throws BGException,
                    java.sql.SQLException

Throws:

BGException

java.sql.SQLException

getById

protected B getById(int id)
             throws BGException,
                    java.sql.SQLException

Throws:

BGException

java.sql.SQLException

list

protected java.util.List<B> list(java.lang.String filter,
                                 java.lang.String orderBy,
                                 java.lang.Object... params)
                          throws BGException

Throws:

BGException

get

protected B get(java.lang.String filter,
                java.lang.Object... params)
         throws BGException

Throws:

BGException

listImpl

protected java.util.List<B> listImpl(java.lang.String filter,
                                     java.lang.String orderBy,
                                     java.lang.Object... params)
                              throws BGException,
                                     java.sql.SQLException

Throws:

BGException

java.sql.SQLException

getFromRS

protected abstract B getFromRS(java.sql.ResultSet rs)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

getListFromRS

protected void getListFromRS(java.sql.ResultSet rs,
                             java.util.List<B> result)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

delete

public int delete(int id)
           throws BGException

Throws:

BGException

deleteImpl

protected int deleteImpl(int id)
                  throws BGException,
                         java.sql.SQLException

Throws:

BGException

java.sql.SQLException

deleteById

protected int deleteById(int id)
                  throws java.sql.SQLException

Throws:

java.sql.SQLException