Package ru.bitel.bgbilling.kernel.base.phone.server.bean

Class RangeMapDao

java.lang.Object

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

ru.bitel.bgbilling.common.dao.AbstractDaoConstant

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

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

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

ru.bitel.bgbilling.kernel.base.phone.server.bean.RangeMapDao

All Implemented Interfaces:

Directory<RangeMap>

public class RangeMapDao
extends ru.bitel.bgbilling.common.dao.AbstractDirectoryIdDao<RangeMap>

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
RangeMapDao(Connection con, int moduleId)

Method Summary

Modifier and Type	Method	Description
void	deleteItem(int rangeMapId, int id)
String	exportMap(int costMapId)
protected RangeMap	getFromRS(ResultSet rs)
void	importMap(int costMapId, String data, String prfx, boolean update)
List<RangeMap>	list()
List<RangeMap>	list(String orderBy)
List<RangeMapItem>	listItems(int costMapId, Date date)
protected void	updateImpl(RangeMap rangeMap)
void	updateItem(int costMapId, RangeMapItem item)

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

deleteDirectoryItem, directoryItems, directoryItemsImpl, getDirectoryItem, getDirectoryItem, getDirectoryItemIdImpl, getDirectoryItemTitleImpl, 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, get, getById, getImpl, getListFromRS, getPeriod, getQueryById, getQueryWithFilter, getSQLOrder, list, list, listCountImplPS, listImpl, 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

optDirectoryItem

Constructor Details

RangeMapDao

public RangeMapDao(Connection con,
 int moduleId)

Method Details

getFromRS

protected RangeMap getFromRS(ResultSet rs)
                      throws SQLException

Specified by:

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

Throws:

SQLException

updateImpl

protected void updateImpl(RangeMap rangeMap)
                   throws SQLException

Specified by:

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

Throws:

SQLException

list

public List<RangeMap> list(String orderBy)
                    throws SQLException

Throws:

SQLException

list

public List<RangeMap> list()
                    throws SQLException

Overrides:

list in class ru.bitel.bgbilling.common.dao.AbstractDao<RangeMap>

Throws:

SQLException

listItems

public List<RangeMapItem> listItems(int costMapId,
 Date date)
                             throws SQLException

Throws:

SQLException

updateItem

public void updateItem(int costMapId,
 RangeMapItem item)
                throws SQLException

Throws:

SQLException

deleteItem

public void deleteItem(int rangeMapId,
 int id)
                throws SQLException

Throws:

SQLException

importMap

public void importMap(int costMapId,
 String data,
 String prfx,
 boolean update)
               throws ru.bitel.bgbilling.common.BGException

Throws:

ru.bitel.bgbilling.common.BGException

exportMap

public String exportMap(int costMapId)
                 throws SQLException

Throws:

SQLException