ru.bgcrm.dao

Class NewsDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.NewsDAO

public class NewsDAO
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
NewsDAO(java.sql.Connection con)

Method Summary

Modifier and Type	Method and Description
void	deleteNews(int newsId)
News	getNews(int newsId)
void	searchNewsList(SearchResult<News> searchResult, int userId, java.lang.Boolean read, java.lang.String text)
void	setNewsAllRead(int userId)
void	setNewsRead(int newsId, int userId, boolean value)
int	updateNews(News news)
void	updateNewsGroups(News news, java.util.Set<java.lang.Integer> groupIds)
void	updateNewsUsers(News news, java.util.Set<java.lang.Integer> userIds)

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

NewsDAO

public NewsDAO(java.sql.Connection con)

Method Detail

searchNewsList

public void searchNewsList(SearchResult<News> searchResult,
                           int userId,
                           java.lang.Boolean read,
                           java.lang.String text)
                    throws BGException

Throws:

BGException

getNews

public News getNews(int newsId)
             throws BGException

Throws:

BGException

updateNews

public int updateNews(News news)
               throws BGException

Throws:

BGException

updateNewsUsers

public void updateNewsUsers(News news,
                            java.util.Set<java.lang.Integer> userIds)
                     throws BGException

Throws:

BGException

updateNewsGroups

public void updateNewsGroups(News news,
                             java.util.Set<java.lang.Integer> groupIds)
                      throws BGException

Throws:

BGException

setNewsRead

public void setNewsRead(int newsId,
                        int userId,
                        boolean value)
                 throws java.sql.SQLException

Throws:

java.sql.SQLException

setNewsAllRead

public void setNewsAllRead(int userId)
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

deleteNews

public void deleteNews(int newsId)
                throws BGException

Throws:

BGException