Exemple #1
0
 /**
  * 根据条件查询站内信(管理员与用户,用户与用户)
  *
  * @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();
   }
 }
Exemple #2
0
 /**
  * 删除团队介绍的数据
  *
  * @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;
 }
Exemple #3
0
 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;
 }
Exemple #4
0
 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;
 }