Package ru.bitel.bgbilling.plugins.sqleditor.server.dao

Class SqlHistoryDao

java.lang.Object
ru.bitel.bgbilling.kernel.base.server.logger.BGLogger
ru.bitel.bgbilling.common.dao.AbstractDaoConstant
ru.bitel.bgbilling.plugins.sqleditor.server.dao.SqlHistoryDao
public class SqlHistoryDao 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, tableName

  • Constructor Summary

    Constructors
    Constructor
    Description
    SqlHistoryDao(Connection con)
     

  • Method Summary

    Modifier and Type
    Method
    Description
    void
    deleteByQueryInfo(Date requestDate, String queryBody)
     
    void
    deleteRequest(int historyRequestId)
     
    void
    deleteRequests(List<Integer> requestIds)
     
    SqlHistoryUserConfig
    getHistoryUserConfig(int userId)
     
    List<SqlHistoryRequest>
    getRequestListByUser(int userId, Page page)
     
    void
    updateHistoryUserConfig(SqlHistoryUserConfig historyUserConfig)
     
    void
    updateRequest(SqlHistoryRequest request)
     

    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