Package 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	Description
protected static final Pattern	orderByPattern
protected final 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	Description
AbstractDAO(Connection con, String tableName)
AbstractDAO(Connection con, String tableName, Date date)

Method Summary

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

Methods inherited from class ru.bgcrm.dao.CommonDAO

buildPlaceholders, deleteById, execute, execute, execute, executeBatch, 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 Details

tableName

protected final String tableName

orderByPattern

protected static final Pattern orderByPattern

Constructor Details

AbstractDAO

public AbstractDAO(Connection con,
 String tableName)

AbstractDAO

public AbstractDAO(Connection con,
 String tableName,
 Date date)

Method Details

getTableName

protected String getTableName(String tableName,
 Date date)

processException

protected void processException(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,
SQLException

Throws:

BGException

SQLException

get

public B get(int id)
      throws BGException

Throws:

BGException

getImpl

protected B getImpl(int id)
             throws BGException,
SQLException

Throws:

BGException

SQLException

getById

protected B getById(int id)
             throws BGException,
SQLException

Throws:

BGException

SQLException

list

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

Throws:

BGException

get

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

Throws:

BGException

listImpl

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

Throws:

BGException

SQLException

getFromRS

protected abstract B getFromRS(ResultSet rs)
                        throws SQLException

Throws:

SQLException

getListFromRS

protected void getListFromRS(ResultSet rs,
 List<B> result)
                      throws SQLException

Throws:

SQLException

delete

public int delete(int id)
           throws BGException

Throws:

BGException

deleteImpl

protected int deleteImpl(int id)
                  throws BGException,
SQLException

Throws:

BGException

SQLException

deleteById

protected int deleteById(int id)
                  throws SQLException

Throws:

SQLException