public class MessageDAO extends 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 and Description |
---|
MessageDAO(java.sql.Connection con) |
Modifier and Type | Method and Description |
---|---|
void |
addMessage(Message message) |
Message |
getMessageById(int id) |
java.util.List<Message> |
getProcessMessageList(int processId,
int messageId) |
java.util.List<Message> |
getUnsendMessageList(int type,
int maxCount) |
void |
searchMessageList(SearchResult<Message> searchResult,
java.lang.Integer processId,
java.lang.Integer typeId,
java.lang.Integer direction,
java.lang.Boolean processed) |
void |
updateMessage(Message message) |
addLikeSql, convertDateToSqlDate, convertDateToTimestamp, deleteById, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, getMySQLLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, updateColumn, updateIds, updateIds
public Message getMessageById(int id) throws BGException
BGException
public void addMessage(Message message) throws BGException
BGException
public void updateMessage(Message message) throws BGException
BGException
public java.util.List<Message> getUnsendMessageList(int type, int maxCount) throws BGException
BGException
public void searchMessageList(SearchResult<Message> searchResult, java.lang.Integer processId, java.lang.Integer typeId, java.lang.Integer direction, java.lang.Boolean processed) throws BGException
BGException
public java.util.List<Message> getProcessMessageList(int processId, int messageId) throws BGException
BGException