Class DevicePortSubscriptionDao

java.lang.Object
ru.bitel.common.dao.AbstarctDaoConstant
ru.bitel.common.dao.AbstractDao<DevicePortSubscription>
ru.bitel.oss.systems.inventory.resource.server.bean.DevicePortSubscriptionDao
All Implemented Interfaces:
java.lang.AutoCloseable

public class DevicePortSubscriptionDao
extends ru.bitel.common.dao.AbstractDao<DevicePortSubscription>
  • Nested Class Summary

    Nested classes/interfaces inherited from class ru.bitel.common.dao.AbstractDao

    ru.bitel.common.dao.AbstractDao.ResultSetIterator
  • Field Summary

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

    cacheFilter, cacheJoin, cacheOrderBy, cachePaged, cachePS, cacheWhat, con, getByIdPS, moduleId, orderByPattern, tableName

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

    ERROR, SQL_CALC_FOUND_ROWS, SQL_DELETE, SQL_DISTINCT, SQL_EQ, SQL_EQCS, SQL_FROM, SQL_GROUP, SQL_IN, SQL_INSERT, SQL_LIMIT, SQL_ON_DUPLICATE_KEY_UPDATE, SQL_ORDER, SQL_SELECT, SQL_SET, SQL_UPDATE, SQL_VALUES, SQL_WHERE
  • Constructor Summary

    Constructors
    Constructor Description
    DevicePortSubscriptionDao​(java.sql.Connection con, int mid)  
  • Method Summary

    Modifier and Type Method Description
    int deleteBySubscriberId​(int subscriberId)  
    DevicePortSubscription get​(int deviceId, int port, java.util.Date now)  
    protected DevicePortSubscription getFromRS​(java.sql.ResultSet rs)  
    java.util.List<DevicePortSubscription> list​(int deviceId, int port, java.util.Date dateFrom, java.util.Date dateTo)  
    Result<DevicePortSubscription> list​(int deviceId, int port, java.util.Date dateFrom, java.util.Date dateTo, Page page)  
    protected void updateImpl​(DevicePortSubscription b)  

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

    close, delete, deleteImpl, eq, get, getById, getImpl, getListFromRS, getPeriod, getQueryById, getSQLOrder, getTableName, list, list, listImpl, listImpl, listImplPS, listImplPS, ormFromResultSet, ormUpdateImpl, ormUpdateImpl, processException, recycle, setStatementParam, update

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

    getSQLOrder

    Methods inherited from class java.lang.Object

    clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
  • Constructor Details

    • DevicePortSubscriptionDao

      public DevicePortSubscriptionDao​(java.sql.Connection con, int mid)
  • Method Details

    • getFromRS

      protected DevicePortSubscription getFromRS​(java.sql.ResultSet rs) throws java.sql.SQLException, ru.bitel.bgbilling.common.BGException
      Specified by:
      getFromRS in class ru.bitel.common.dao.AbstractDao<DevicePortSubscription>
      Throws:
      java.sql.SQLException
      ru.bitel.bgbilling.common.BGException
    • updateImpl

      protected void updateImpl​(DevicePortSubscription b) throws ru.bitel.bgbilling.common.BGException, java.sql.SQLException
      Specified by:
      updateImpl in class ru.bitel.common.dao.AbstractDao<DevicePortSubscription>
      Throws:
      ru.bitel.bgbilling.common.BGException
      java.sql.SQLException
    • list

      public java.util.List<DevicePortSubscription> list​(int deviceId, int port, java.util.Date dateFrom, java.util.Date dateTo) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException
    • list

      public Result<DevicePortSubscription> list​(int deviceId, int port, java.util.Date dateFrom, java.util.Date dateTo, Page page) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException
    • deleteBySubscriberId

      public int deleteBySubscriberId​(int subscriberId) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException
    • get

      public DevicePortSubscription get​(int deviceId, int port, java.util.Date now) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException