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

Class StreetDao

java.lang.Object

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

ru.bitel.bgbilling.common.dao.AbstractDaoConstant

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

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

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

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

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

All Implemented Interfaces:

Directory<Street>

public class StreetDao
extends AbstractAddressDao<Street>

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
StreetDao(Connection con)

Method Summary

Modifier and Type	Method	Description
int	cityStreetCount(int cityId)
protected List<Street>	directoryItemsImpl()
Street	get(String title, int cityId)
protected Street	getDirectoryItemTitleImpl(String title)
protected Street	getFromRS(ResultSet rs)
String	getPostIndex(int streetId)
protected String	getQuery()
protected String	getQueryById()
List<Street>	list(int cityId)
List<Street>	list(int cityId, String title)
protected List<Street>	list(String filter, String orderBy, Object... params)
protected List<Street>	listImpl(ru.bitel.bgbilling.common.dao.AbstractDao.ListParams listParams)
protected Street	newBean()
List<Street>	search(int cityId, String title, String cityTitle, Page page)
void	searchStreetList(SearchResult<Street> searchResult, int cityId, String streetMask)
protected <T> void	searchStreetList(SearchResult<T> searchResult, int cityId, String mask, Function<ResultSet,T> function)
protected void	updateImpl(Street 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

StreetDao

public StreetDao(Connection con)

Method Details

newBean

protected Street newBean()

Specified by:

newBean in class AbstractAddressDao<Street>

getPostIndex

public String getPostIndex(int streetId)
                    throws ru.bitel.bgbilling.common.BGException

Throws:

ru.bitel.bgbilling.common.BGException

search

public List<Street> search(int cityId,
 String title,
 String cityTitle,
 Page page)
                    throws Exception

Throws:

Exception

directoryItemsImpl

protected List<Street> directoryItemsImpl()
                                   throws SQLException

Throws:

SQLException

searchStreetList

public void searchStreetList(SearchResult<Street> searchResult,
 int cityId,
 String streetMask)

cityStreetCount

public int cityStreetCount(int cityId)
                    throws SQLException

Throws:

SQLException

getFromRS

protected Street 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(Street b)
                   throws SQLException

Specified by:

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

Throws:

SQLException

getDirectoryItemTitleImpl

protected Street getDirectoryItemTitleImpl(String title)
                                    throws SQLException

Overrides:

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

Throws:

SQLException

get

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

Throws:

SQLException

list

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

Throws:

SQLException

list

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

Throws:

SQLException

list

protected List<Street> 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<Street> 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)