/**
* 根据条件查询站内信（管理员与用户，用户与用户）
*
* @throws SQLException
* @throws DataException
*/
public void queryMailByCondition(
PageBean pageBean, Integer mailType, String sender, String beginTime, String endTime)
throws SQLException, DataException {
Connection conn = connectionManager.getConnection();
StringBuffer condition = new StringBuffer("and backgroundStatus!=2 ");
if (mailType != null) {
condition.append("and mailType=");
condition.append(mailType);
}
if (StringUtils.isNotBlank(sender)) {
condition.append(" and sender LIKE '%");
condition.append(StringEscapeUtils.escapeSql(sender));
condition.append("%'");
}
if (StringUtils.isNotBlank(beginTime)) {
condition.append(" and sendTime >= '");
condition.append(StringEscapeUtils.escapeSql(beginTime));
condition.append("'");
}
if (StringUtils.isNotBlank(endTime)) {
condition.append(" and sendTime <= '");
condition.append(StringEscapeUtils.escapeSql(endTime));
condition.append("'");
}
try {
dataPage(conn, pageBean, "t_mail", "*", " order by sendTime desc ", condition.toString());
} catch (DataException e) {
log.error(e);
e.printStackTrace();
} finally {
conn.close();
}
}
/**
* 删除团队介绍的数据
*
* @param commonIds id拼接字符串
* @param delimiter 分割符
* @throws DataException
* @throws SQLException
* @return int
*/
public int deleteMailBox(String commonIds, String delimiter) throws DataException, SQLException {
Connection conn = connectionManager.getConnection();
int result = -1;
try {
result = mailBoxManagerDao.deleteMailBox(conn, commonIds, delimiter);
} catch (SQLException e) {
log.error(e);
e.printStackTrace();
throw e;
} catch (DataException e) {
log.error(e);
e.printStackTrace();
throw e;
} finally {
conn.close();
}
return result;
}
public Map<String, String> getMailById(Long id) throws SQLException, DataException {
Connection conn = connectionManager.getConnection();
Map<String, String> map = null;
try {
map = mailBoxManagerDao.getMailById(conn, id);
} catch (SQLException e) {
log.error(e);
e.printStackTrace();
throw e;
} catch (DataException e) {
log.error(e);
e.printStackTrace();
throw e;
} finally {
conn.close();
}
return map;
}
public Long updateMailBoxById(Long id, String title, String content)
throws SQLException, DataException {
Connection conn = connectionManager.getConnection();
Long result = -1L;
try {
result = mailBoxManagerDao.updateMailBoxById(conn, id, title, content);
} catch (SQLException e) {
log.error(e);
e.printStackTrace();
throw e;
} catch (DataException e) {
log.error(e);
e.printStackTrace();
throw e;
} finally {
conn.close();
}
return result;
}