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

Class GeographicCodeDao

java.lang.Object
ru.bitel.bgbilling.kernel.base.server.logger.BGLogger
ru.bitel.bgbilling.common.dao.AbstractDaoConstant
ru.bitel.bgbilling.kernel.base.phone.server.dao.GeographicCodeDao
public class GeographicCodeDao extends ru.bitel.bgbilling.common.dao.AbstractDaoConstant

  • Field Summary

    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_ORDER, SQL_SELECT, SQL_SET, SQL_UPDATE, SQL_VALUES, SQL_WHERE

  • Constructor Summary

    Constructors
    Constructor
    Description
    GeographicCodeDao(Connection con, int moduleId)
     

  • Method Summary

    Modifier and Type
    Method
    Description
    int
    delete(String code)
     
    GeographicCode
    getTree()
     
    GeographicCode
    getTree(boolean destinationTitle)
     
    org.json.JSONArray
    getTreeJson()
     
    void
    importFromFile(String data, String prfx, boolean addNew, boolean updateExist)
     
    void
    importFromFile(String data, String prfx, boolean addNew, boolean updateExist, boolean compact)
     
    List<GeographicCode>
    list()
     
    static List<String>
    parsePrefixes(String string, boolean withRanges)
     
    void
    update(GeographicCode code)
     

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

    getPeriod, getPlaceholders, getSQLOrder, getSQLOrderFields, getTableName, psSetDate, psSetDateOrNull, psSetInt, psSetIntOrNull, psSetPeriod, psSetString, psSetStringOrNull, psSetTimestampOrNull, queryAndIn, setStatementParam, sqlDelete, sqlDeleteBatch, sqlInsert, sqlInsertBatch, sqlInsertGetId, sqlInsertGetLongId, sqlInsertOnDuplicateKeyUpdate, sqlInsertSelect, sqlInsertUpdateById, sqlSelectCountAsInt, sqlUpdate, sqlUpdateBatch

    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

    • GeographicCodeDao

      public GeographicCodeDao(Connection con, int moduleId)

  • Method Details

    • list

      public List<GeographicCode> list() throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • getTree

      public GeographicCode getTree(boolean destinationTitle) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • getTreeJson

      public org.json.JSONArray getTreeJson() throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • getTree

      public GeographicCode getTree() throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • update

      public void update(GeographicCode code) throws SQLException
      Throws:
      SQLException

    • delete

      public int delete(String code) throws SQLException
      Throws:
      SQLException

    • importFromFile

      public void importFromFile(String data, String prfx, boolean addNew, boolean updateExist) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • importFromFile

      public void importFromFile(String data, String prfx, boolean addNew, boolean updateExist, boolean compact) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • parsePrefixes

      public static List<String> parsePrefixes(String string, boolean withRanges)