ru.bgcrm.dao.process

Class StatusDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.process.StatusDAO

public class StatusDAO
extends CommonDAO

Nested Class Summary

Nested classes/interfaces inherited from class ru.bgcrm.dao.CommonDAO

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

Field Summary

Fields inherited from class ru.bgcrm.dao.CommonDAO

con, dateFormat_DDMMYYYY, dateFormat_DDMMYYYY_HHMM, log, SQL_AND, SQL_DELETE, SQL_DESC, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT, SQL_INSERT_IGNORE, SQL_LEFT_JOIN, SQL_LEFT_OUTER_JOIN, SQL_LIMIT, SQL_ON_DUP_KEY_UPDATE, SQL_OR, SQL_ORDER_BY, SQL_REPLACE, SQL_SELECT, SQL_SELECT_ALL_FROM, SQL_SELECT_COUNT_ROWS, SQL_SET, SQL_UPDATE, SQL_WHERE

Constructor Summary

Constructors

Constructor and Description
StatusDAO(java.sql.Connection con)

Method Summary

Modifier and Type	Method and Description
void	deleteStatus(int id)
Status	getStatus(int id)
static Status	getStatusFromRs(java.sql.ResultSet rs)
java.util.List<Status>	getStatusList()
java.util.List<Status>	getStatusList(java.util.Set<java.lang.Integer> ids)
void	searchStatus(SearchResult<Status> searchResult)
void	searchStatus(SearchResult<Status> searchResult, int statusId, java.lang.String filterLike)
void	updateStatus(Status status)

Methods inherited from class ru.bgcrm.dao.CommonDAO

deleteById, execute, execute, execute, executeInsert, executeUpdate, getById, getFoundRows, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, getLikePatternEnd, getLikePatternStart, getLikePatternSub, getMySQLLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, update, updateColumn, updateIds, updateIds

Methods inherited from class java.lang.Object

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

Constructor Detail

StatusDAO

public StatusDAO(java.sql.Connection con)

Method Detail

searchStatus

public void searchStatus(SearchResult<Status> searchResult)
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

searchStatus

public void searchStatus(SearchResult<Status> searchResult,
                         int statusId,
                         java.lang.String filterLike)
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatus

public Status getStatus(int id)
                 throws java.sql.SQLException

Throws:

java.sql.SQLException

deleteStatus

public void deleteStatus(int id)
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

updateStatus

public void updateStatus(Status status)
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatusList

public java.util.List<Status> getStatusList()
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatusList

public java.util.List<Status> getStatusList(java.util.Set<java.lang.Integer> ids)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatusFromRs

public static Status getStatusFromRs(java.sql.ResultSet rs)
                              throws java.sql.SQLException

Throws:

java.sql.SQLException