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

Class DevicePortDao

java.lang.Object
ru.bitel.bgbilling.kernel.base.server.logger.BGLogger
ru.bitel.common.dao.AbstarctDaoConstant
ru.bitel.common.dao.AbstractDao<DeviceInterface>
ru.bitel.oss.systems.inventory.resource.server.bean.DevicePortDao
All Implemented Interfaces:
AutoCloseable
public class DevicePortDao extends ru.bitel.common.dao.AbstractDao<DeviceInterface>

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

  • Method Summary

    Modifier and Type
    Method
    Description
    void
    delete(int deviceId, int port)
     
    DeviceInterface
    get(int deviceId, int port)
     
    protected DeviceInterface
    getFromRS(ResultSet rs)
     
    protected DeviceInterface
    getFromRS(ResultSet rs, boolean title, boolean indexList)
     
    List<DeviceInterface>
    list(int deviceId, int status, boolean title, boolean indexList, boolean subscription)
     
    List<DeviceInterface>
    list(int deviceId, int status, boolean title, boolean indexList, String interfaceTitle)
     
    void
    updateDevicePortComment(int deviceId, int port, String comment)
     
    protected void
    updateImpl(DeviceInterface deviceInterface)
     

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

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

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

    getSQLOrder, psSetDate, psSetInt, psSetString, 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

    • DevicePortDao

      public DevicePortDao(Connection con, int moduleId)

  • Method Details

    • getFromRS

      protected DeviceInterface getFromRS(ResultSet rs) throws SQLException, ru.bitel.bgbilling.common.BGException
      Specified by:
      getFromRS in class ru.bitel.common.dao.AbstractDao<DeviceInterface>
      Throws:
      SQLException
      ru.bitel.bgbilling.common.BGException

    • getFromRS

      protected DeviceInterface getFromRS(ResultSet rs, boolean title, boolean indexList) throws SQLException, ru.bitel.bgbilling.common.BGException
      Throws:
      SQLException
      ru.bitel.bgbilling.common.BGException

    • updateDevicePortComment

      public void updateDevicePortComment(int deviceId, int port, String comment) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • updateImpl

      protected void updateImpl(DeviceInterface deviceInterface) throws ru.bitel.bgbilling.common.BGException, SQLException
      Specified by:
      updateImpl in class ru.bitel.common.dao.AbstractDao<DeviceInterface>
      Throws:
      ru.bitel.bgbilling.common.BGException
      SQLException

    • list

      public List<DeviceInterface> list(int deviceId, int status, boolean title, boolean indexList, String interfaceTitle) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • list

      public List<DeviceInterface> list(int deviceId, int status, boolean title, boolean indexList, boolean subscription) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • delete

      public void delete(int deviceId, int port) throws Exception
      Throws:
      Exception

    • get

      public DeviceInterface get(int deviceId, int port) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException