Package ru.bitel.oss.systems.inventory.resource.server.bean

Class IpResourceDao

java.lang.Object

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

ru.bitel.bgbilling.common.dao.AbstarctDaoConstant

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

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

ru.bitel.oss.systems.inventory.resource.server.bean.IpResourceDao

public class IpResourceDao
extends ru.bitel.bgbilling.common.dao.AbstractIdDao<IpResource>

Field Summary

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

con, moduleId, orderByPattern, tableName

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

ERROR, fields, SQL_ALL, SQL_AND, SQL_CALC_FOUND_ROWS, 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

Constructor Summary

Constructors

Constructor	Description
IpResourceDao(Connection con, int moduleId)

Method Summary

Modifier and Type	Method	Description
protected IpResource	getFromRS(ResultSet rs)
IpResource	getIpResourceFromRS(String prefix, ResultSet rs)
List<IpResource>	list()
List<IpResource>	list(int categoryId)
List<IpResource>	list(int categoryId, Date dateFrom, Date dateTo)	Возвращает список ресурсов, которые активны в указанный период.
List<IpResource>	list(Collection<Integer> categoryIds, Collection<Integer> resourceIds, Date dateFrom, Date dateTo, Boolean dynamic)	Возвращает список ресурсов, которые активны в указанный период.
List<IpResource>	list(Set<Integer> categoryIds, Date dateFrom, Date dateTo)	Возвращает список ресурсов, которые активны в указанный период.
protected void	updateImpl(IpResource ipResource)

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

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

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

delete, deleteImpl, eq, get, getById, getImpl, getListFromRS, getPeriod, getQueryById, getSQLOrder, getTableName, list, list, listImpl, listImpl, listImplPS, listImplPS, ormFromResultSet, ormUpdateImpl, ormUpdateImpl, ormUpdateImpl, ormUpdateImpl, psSetPeriod, queryPeriod, setStatementParam, update

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

getSQLOrder, sqlLimit

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

Constructor Details

IpResourceDao

public IpResourceDao(Connection con,
 int moduleId)

Method Details

getFromRS

protected IpResource getFromRS(ResultSet rs)
                        throws SQLException

Specified by:

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

Throws:

SQLException

getIpResourceFromRS

public IpResource getIpResourceFromRS(String prefix,
 ResultSet rs)
                               throws SQLException

Throws:

SQLException

updateImpl

protected void updateImpl(IpResource ipResource)
                   throws SQLException

Specified by:

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

Throws:

SQLException

list

public List<IpResource> list(Collection<Integer> categoryIds,
 Collection<Integer> resourceIds,
 Date dateFrom,
 Date dateTo,
 Boolean dynamic)
                      throws SQLException

Возвращает список ресурсов, которые активны в указанный период.

Parameters:

dateFrom -

categoryId -

dateTocategoryIds -

Returns:

Throws:

ru.bitel.bgbilling.common.BGException

SQLException

list

public List<IpResource> list(Set<Integer> categoryIds,
 Date dateFrom,
 Date dateTo)
                      throws SQLException

Возвращает список ресурсов, которые активны в указанный период.

Parameters:

dateFrom -

categoryId -

dateTocategoryIds -

Returns:

Throws:

ru.bitel.bgbilling.common.BGException

SQLException

list

public List<IpResource> list(int categoryId,
 Date dateFrom,
 Date dateTo)
                      throws SQLException

Возвращает список ресурсов, которые активны в указанный период.

Parameters:

categoryId -

dateFrom -

dateTocategoryIds -

Returns:

Throws:

ru.bitel.bgbilling.common.BGException

SQLException

list

public List<IpResource> list(int categoryId)
                      throws SQLException

Throws:

SQLException

list

public List<IpResource> list()
                      throws SQLException

Throws:

SQLException