Package ru.bitel.bgbilling.kernel.admin.web.server.bean

Class WebMenuDao

java.lang.Object

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

ru.bitel.bgbilling.common.dao.AbstarctDaoConstant

ru.bitel.bgbilling.common.dao.AbstractDao<WebMenuItem>

ru.bitel.bgbilling.common.dao.AbstractIdDao<WebMenuItem>

ru.bitel.bgbilling.kernel.admin.web.server.bean.WebMenuDao

public class WebMenuDao
extends ru.bitel.bgbilling.common.dao.AbstractIdDao<WebMenuItem>

Field Summary

Fields

Modifier and Type	Field	Description
static final String	TABLE_CONTRACT_WEB_MENU

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

con, moduleId, orderByPattern, tableName

Fields inherited from class ru.bitel.bgbilling.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
WebMenuDao(Connection con)

Method Summary

Modifier and Type	Method	Description
void	deleteData(int webMenuItemId)
Map<Integer,Integer>	getContractCount()
String	getData(int webMenuItemId)
protected WebMenuItem	getFromRS(ResultSet rs)
int	getWebMenuIdForContract(int contractId)
List<WebMenuItem>	list()
void	setWebMenuIdForContract(int webMenuItemId, int contractId)
void	updateData(int webMenuItemId, String data)
protected void	updateImpl(WebMenuItem webMenuItem)
WebMenuItem	updateInfo(WebMenuItem webMenuItem)

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

delete, executeUpdate, get, getAndDelete, getAndUpdate, opt, prepareStatement, sqlCommand, sqlCommandAndTable, sqlQuery, sqlWhereId

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

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

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

getSQLOrder

Methods inherited from class ru.bitel.bgbilling.kernel.base.server.logger.BGLogger

error, error, error, getLogger, logError, logError

Methods inherited from class java.lang.Object

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

Field Details

TABLE_CONTRACT_WEB_MENU

public static final String TABLE_CONTRACT_WEB_MENU

See Also:

• Constant Field Values

Constructor Details

WebMenuDao

public WebMenuDao(Connection con)

Method Details

getWebMenuIdForContract

public int getWebMenuIdForContract(int contractId)
                            throws SQLException

Throws:

SQLException

setWebMenuIdForContract

public void setWebMenuIdForContract(int webMenuItemId,
 int contractId)
                             throws SQLException

Throws:

SQLException

getData

public String getData(int webMenuItemId)
               throws SQLException

Throws:

SQLException

deleteData

public void deleteData(int webMenuItemId)
                throws ru.bitel.bgbilling.common.BGMessageException,
SQLException

Throws:

ru.bitel.bgbilling.common.BGMessageException

SQLException

list

public List<WebMenuItem> list()
                       throws SQLException

Throws:

SQLException

getContractCount

public Map<Integer,Integer> getContractCount()
                                      throws SQLException

Throws:

SQLException

updateInfo

public WebMenuItem updateInfo(WebMenuItem webMenuItem)
                       throws Exception

Throws:

Exception

updateData

public void updateData(int webMenuItemId,
 String data)
                throws Exception

Throws:

Exception

getFromRS

protected WebMenuItem getFromRS(ResultSet rs)
                         throws SQLException

Specified by:

getFromRS in class ru.bitel.bgbilling.common.dao.AbstractDao<WebMenuItem>

Throws:

SQLException

updateImpl

protected void updateImpl(WebMenuItem webMenuItem)
                   throws SQLException

Specified by:

updateImpl in class ru.bitel.bgbilling.common.dao.AbstractDao<WebMenuItem>

Throws:

SQLException