Package ru.bitel.oss.kernel.directories.address.server.bean

Class AreaDao

java.lang.Object

ru.bitel.bgbilling.kernel.base.server.logger.BGLogger

ru.bitel.bgbilling.common.dao.AbstractDaoConstant

ru.bitel.bgbilling.common.dao.AbstractDao<Area>

ru.bitel.bgbilling.common.dao.AbstractIdDao<Area>

ru.bitel.bgbilling.common.dao.AbstractDirectoryIdDao<Area>

ru.bitel.oss.kernel.directories.address.server.bean.AbstractAddressDao<Area>

ru.bitel.oss.kernel.directories.address.server.bean.AreaDao

All Implemented Interfaces:

Directory<Area>

public class AreaDao
extends AbstractAddressDao<Area>

Nested Class Summary

Nested classes/interfaces inherited from class ru.bitel.bgbilling.common.dao.AbstractDao

ru.bitel.bgbilling.common.dao.AbstractDao.ListParams

Field Summary

Fields inherited from class ru.bitel.bgbilling.common.dao.AbstractDao

orderByPattern

Fields inherited from class ru.bitel.bgbilling.common.dao.AbstractDaoConstant

con, ERROR, fields, moduleId, SQL_ALL, SQL_AND, SQL_DELETE, SQL_DISTINCT, SQL_EQ, SQL_EQCS, SQL_FROM, SQL_GROUP, SQL_IN, SQL_INSERT, SQL_JOIN, SQL_LEFT_JOIN, SQL_LIMIT, SQL_NOT_IN, SQL_ON, SQL_ON_DUPLICATE_KEY_UPDATE, SQL_ORDER, SQL_SELECT, SQL_SET, SQL_UPDATE, SQL_VALUES, SQL_WHERE, tableName

Constructor Summary

Constructors

Constructor	Description
AreaDao(Connection con)

Method Summary

Modifier and Type	Method	Description
int	cityAreaCount(int cityId)
protected List<Area>	directoryItemsImpl()
Area	get(String title, int cityId)
protected Area	getDirectoryItemTitleImpl(String title)
protected Area	getFromRS(ResultSet rs)
protected String	getQuery()
protected String	getQueryById()
List<Area>	list(int cityId)
List<Area>	list(int cityId, String title)
protected List<Area>	list(String filter, String orderBy, Object... params)
protected List<Area>	listImpl(ru.bitel.bgbilling.common.dao.AbstractDao.ListParams listParams)
protected Area	newBean()
void	searchAreaList(SearchResult<Area> searchResult, int cityId, String areaMask)
protected <T> void	searchStreetList(SearchResult<T> searchResult, int cityId, String mask, Function<ResultSet,T> function)
protected void	updateImpl(Area b)

Methods inherited from class ru.bitel.oss.kernel.directories.address.server.bean.AbstractAddressDao

deleteRows, get, getBaseFromRS, getEntityCount

Methods inherited from class ru.bitel.bgbilling.common.dao.AbstractDirectoryIdDao

deleteDirectoryItem, directoryItems, getDirectoryItem, getDirectoryItem, getDirectoryItemIdImpl, updateDirectoryItem

Methods inherited from class ru.bitel.bgbilling.common.dao.AbstractIdDao

delete, executeUpdate, get, getAndDelete, getAndUpdate, loadData, opt, prepareStatement, sqlCommand, sqlCommandAndTable, sqlInsertValues, sqlQuery, sqlUpdateSet, sqlWhereId

Methods inherited from class ru.bitel.bgbilling.common.dao.AbstractDao

deleteImpl, dropTemporaryTable, eq, getById, getImpl, getListFromRS, getPeriod, getQueryWithFilter, getSQLOrder, list, list, listCountImplPS, listImplPS, ormFromResultSet, ormUpdateImpl, ormUpdateImpl, ormUpdateImpl, ormUpdateImpl, queryPeriod, setPageRecordCount, update

Methods inherited from class ru.bitel.bgbilling.common.dao.AbstractDaoConstant

delete, delete, getSQLOrder, getSQLOrderFields, getTableName, psSetDate, psSetDateOrNull, psSetInt, psSetIntOrNull, psSetPeriod, psSetString, psSetStringOrNull, psSetTimestampOrNull, queryAndIn, setStatementParam

Methods inherited from class ru.bitel.bgbilling.kernel.base.server.logger.BGLogger

error, error, error, getLogger, logError, logError, warn

Methods inherited from class java.lang.Object

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

Methods inherited from interface ru.bitel.bgbilling.kernel.directory.api.common.bean.Directory

deleteDirectoryItem, directoryItems, getDirectoryItem, getDirectoryItem, optDirectoryItem, updateDirectoryItem

Constructor Details

AreaDao

public AreaDao(Connection con)

Method Details

newBean

protected Area newBean()

Specified by:

newBean in class AbstractAddressDao<Area>

searchAreaList

public void searchAreaList(SearchResult<Area> searchResult,
 int cityId,
 String areaMask)

cityAreaCount

public int cityAreaCount(int cityId)
                  throws SQLException

Throws:

SQLException

getFromRS

protected Area getFromRS(ResultSet rs)
                  throws SQLException

Specified by:

getFromRS in class ru.bitel.bgbilling.common.dao.AbstractDao<B extends CityItem>

Throws:

SQLException

updateImpl

protected void updateImpl(Area b)
                   throws SQLException

Specified by:

updateImpl in class ru.bitel.bgbilling.common.dao.AbstractDao<B extends CityItem>

Throws:

SQLException

directoryItemsImpl

protected List<Area> directoryItemsImpl()
                                 throws SQLException

Overrides:

directoryItemsImpl in class ru.bitel.bgbilling.common.dao.AbstractDirectoryIdDao<B extends CityItem>

Throws:

SQLException

getDirectoryItemTitleImpl

protected Area getDirectoryItemTitleImpl(String title)
                                  throws SQLException

Overrides:

getDirectoryItemTitleImpl in class ru.bitel.bgbilling.common.dao.AbstractDirectoryIdDao<B extends CityItem>

Throws:

SQLException

get

public Area get(String title,
 int cityId)
         throws SQLException

Throws:

SQLException

list

public List<Area> list(int cityId)
                throws SQLException

Throws:

SQLException

list

public List<Area> list(int cityId,
 String title)
                throws SQLException

Throws:

SQLException

list

protected List<Area> list(String filter,
 String orderBy,
 Object... params)
                   throws SQLException

Overrides:

list in class ru.bitel.bgbilling.common.dao.AbstractDao<B extends CityItem>

Throws:

SQLException

listImpl

protected List<Area> listImpl(ru.bitel.bgbilling.common.dao.AbstractDao.ListParams listParams)
                       throws SQLException

Overrides:

listImpl in class ru.bitel.bgbilling.common.dao.AbstractDao<B extends CityItem>

Throws:

SQLException

getQueryById

protected String getQueryById()

Overrides:

getQueryById in class ru.bitel.bgbilling.common.dao.AbstractDao<B extends CityItem>

getQuery

protected String getQuery()

Overrides:

getQuery in class AbstractAddressDao<B extends CityItem>

searchStreetList

protected <T> void searchStreetList(SearchResult<T> searchResult,
 int cityId,
 String mask,
 Function<ResultSet,T> function)