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

Class CityDao

java.lang.Object

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

ru.bitel.bgbilling.common.dao.AbstractDaoConstant

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

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

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

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

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

All Implemented Interfaces:

Directory<City>

public class CityDao
extends AbstractAddressDao<City>
implements Directory<City>

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

Method Summary

Modifier and Type	Method	Description
int	countryCityCount(int countryId)
protected List<City>	directoryItemsImpl()
City	get(String title, int countryId)
protected City	getDirectoryItemTitleImpl(String title)
protected City	getFromRS(ResultSet rs)
protected String	getQuery()
protected String	getQueryById()
List<City>	list(int countryId)
List<City>	list(int countryId, String title)
protected List<City>	listImpl(ru.bitel.bgbilling.common.dao.AbstractDao.ListParams listParams)
protected City	newBean()
void	searchCityList(SearchResult<City> searchResult, int countryId, String cityMask)
protected void	updateImpl(City city)

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, 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

CityDao

public CityDao(Connection con)

Method Details

newBean

protected City newBean()

Specified by:

newBean in class AbstractAddressDao<City>

getFromRS

protected City getFromRS(ResultSet rs)
                  throws SQLException

Specified by:

getFromRS in class ru.bitel.bgbilling.common.dao.AbstractDao<City>

Throws:

SQLException

listImpl

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

Overrides:

listImpl in class ru.bitel.bgbilling.common.dao.AbstractDao<City>

Throws:

SQLException

getQueryById

protected String getQueryById()

Overrides:

getQueryById in class ru.bitel.bgbilling.common.dao.AbstractDao<City>

getQuery

protected String getQuery()

Overrides:

getQuery in class AbstractAddressDao<City>

updateImpl

protected void updateImpl(City city)
                   throws SQLException

Specified by:

updateImpl in class ru.bitel.bgbilling.common.dao.AbstractDao<City>

Throws:

SQLException

directoryItemsImpl

protected List<City> directoryItemsImpl()
                                 throws SQLException

Overrides:

directoryItemsImpl in class ru.bitel.bgbilling.common.dao.AbstractDirectoryIdDao<City>

Throws:

SQLException

list

public List<City> list(int countryId)
                throws SQLException

Throws:

SQLException

list

public List<City> list(int countryId,
 String title)
                throws SQLException

Throws:

SQLException

getDirectoryItemTitleImpl

protected City getDirectoryItemTitleImpl(String title)
                                  throws SQLException

Overrides:

getDirectoryItemTitleImpl in class ru.bitel.bgbilling.common.dao.AbstractDirectoryIdDao<City>

Throws:

SQLException

get

public City get(String title,
 int countryId)
         throws SQLException

Throws:

SQLException

searchCityList

public void searchCityList(SearchResult<City> searchResult,
 int countryId,
 String cityMask)
                    throws SQLException

Throws:

SQLException

countryCityCount

public int countryCityCount(int countryId)
                     throws SQLException

Throws:

SQLException