Package ru.bitel.bgbilling.kernel.kb.server.dao

Class KbAclDao

java.lang.Object

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

ru.bitel.bgbilling.common.dao.AbstractDaoConstant

ru.bitel.bgbilling.kernel.kb.server.dao.KbAclDao

public class KbAclDao
extends ru.bitel.bgbilling.common.dao.AbstractDaoConstant

Таблица kb_acl: права субъектов на БЗ.

Field Summary

Fields

Modifier and Type	Field	Description
static final String	TABLE_KB_ACL

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
KbAclDao(Connection con)

Method Summary

Modifier and Type	Method	Description
void	deleteById(int id)
void	deleteByKbIdExcept(int kbId, List<Integer> keepIds)	Снять все права на БЗ, кроме указанных id (для пересборки списка).
int	insert(KbAcl acl)	Добавить право.
List<KbAcl>	listByKbId(int kbId)	Все права на БЗ.

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, logError, warn

Methods inherited from class java.lang.Object

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

Field Details

TABLE_KB_ACL

public static final String TABLE_KB_ACL

See Also:

• Constant Field Values

Constructor Details

KbAclDao

public KbAclDao(Connection con)

Method Details

listByKbId

public List<KbAcl> listByKbId(int kbId)

Все права на БЗ.

Parameters:

kbId - id БЗ (колонка kb.id)

insert

public int insert(KbAcl acl)

Добавить право. Дубликат (kb_id + principal + principal_id + capability) отклоняется уникальным индексом.

Returns:

id строки; 0, если не удалось

deleteById

public void deleteById(int id)

deleteByKbIdExcept

public void deleteByKbIdExcept(int kbId,
 List<Integer> keepIds)

Снять все права на БЗ, кроме указанных id (для пересборки списка).