Class OltPortDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

org.bgerp.plugin.bgb.getolt.dao.OltPortDAO

public class OltPortDAO
extends CommonDAO

Nested Class Summary

Nested classes/interfaces inherited from class CommonDAO

CommonDAO.ObjectExtractor<T>, CommonDAO.RecordUpdater<T>

Field Summary

Fields inherited from class CommonDAO

con, log, SQL_AND, SQL_DELETE, SQL_DELETE_FROM, SQL_DESC, SQL_DISTINCT, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT_IGNORE_INTO, SQL_INSERT_INTO, SQL_LEFT_JOIN, SQL_LIMIT, SQL_ON_DUP_KEY_UPDATE, SQL_ORDER_BY, SQL_REPLACE, SQL_SELECT, SQL_SELECT_ALL_FROM, SQL_SELECT_COUNT_ROWS, SQL_SET, SQL_UNION_ALL, SQL_UPDATE, SQL_VALUES, SQL_VALUES_1, SQL_VALUES_2, SQL_VALUES_3, SQL_VALUES_4, SQL_VALUES_5, SQL_WHERE

Constructor Summary

Constructors

Constructor	Description
OltPortDAO(Connection con)

Method Summary

Modifier and Type	Method	Description
void	deleteByOltId(int oltId)
List<OltPort>	getByOltId(int oltId)
OltPort	getByOltIdAndPort(int oltId, int numPort)
int	insertOrUpdate(OltPort port)

Methods inherited from class CommonDAO

deleteById, foundRows, getById, getGroupedIds, getGroupedIds, getIds, getIds, getPageLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, update, updateColumn, updateIds, updateIds, updateOrInsert

Methods inherited from class Object

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

Constructor Details

OltPortDAO

public OltPortDAO(Connection con)

Method Details

getByOltId

public List<OltPort> getByOltId(int oltId)
                         throws SQLException

Throws:

SQLException

getByOltIdAndPort

public OltPort getByOltIdAndPort(int oltId,
 int numPort)
                          throws SQLException

Throws:

SQLException

insertOrUpdate

public int insertOrUpdate(OltPort port)
                   throws SQLException

Throws:

SQLException

deleteByOltId

public void deleteByOltId(int oltId)
                   throws SQLException

Throws:

SQLException