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

Class SubscriptionDao

java.lang.Object

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

ru.bitel.bgbilling.common.dao.AbstarctDaoConstant

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

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

ru.bitel.oss.systems.inventory.subscription.server.bean.SubscriptionDao

public class SubscriptionDao
extends ru.bitel.bgbilling.common.dao.AbstractIdDao<Subscription>

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

Method Summary

Modifier and Type	Method	Description
protected Subscription	getFromRS(ResultSet rs)
List<Subscription>	list(int contractId, Date time)
List<Subscription>	list(int contractId, Date date, boolean history, boolean needNonActive)
void	update(Subscription subscription, boolean checkDeactivated)
protected void	updateImpl(Subscription subscription)
protected void	updateImpl(Subscription subscription, boolean checkDeactivated)

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

Methods inherited from class java.lang.Object

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

Constructor Details

SubscriptionDao

public SubscriptionDao(Connection con,
 int moduleId,
 int userId)

Method Details

getFromRS

protected Subscription getFromRS(ResultSet rs)
                          throws SQLException

Specified by:

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

Throws:

SQLException

update

public void update(Subscription subscription,
 boolean checkDeactivated)
            throws SQLException

Throws:

SQLException

updateImpl

protected void updateImpl(Subscription subscription)
                   throws SQLException

Specified by:

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

Throws:

SQLException

updateImpl

protected void updateImpl(Subscription subscription,
 boolean checkDeactivated)
                   throws SQLException

Throws:

SQLException

list

public List<Subscription> list(int contractId,
 Date time)
                        throws SQLException

Throws:

SQLException

list

public List<Subscription> list(int contractId,
 Date date,
 boolean history,
 boolean needNonActive)
                        throws SQLException

Throws:

SQLException