ru.bgcrm.dao.process

Class StatusDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.process.StatusDAO

public class StatusDAO
extends CommonDAO

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_LEFT_JOIN, SQL_LIMIT, 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

Methods

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	updateStatus(Status status)

Methods inherited from class ru.bgcrm.dao.CommonDAO

addLikeSql, convertDateToSqlDate, convertDateToTimestamp, deleteById, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, getMySQLLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, 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

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