예제 #1
0
파일: MailDAO.java 프로젝트: tcongwu/3cmap
  /**
   * 删除发件箱中邮件
   *
   * @param uinfo 用户信息对象
   * @param mlist 要删除的邮件ID列表
   * @return int 操作状态,-1-失败
   * @throws SQLException 数据库异常
   */
  public static int delSendMail(UserInfo uinfo, String mlist) throws SQLException {
    if ((uinfo == null) || StringUtils.isNull(mlist)) {
      return -1;
    }

    DBSource dbsrc = new DBSource();
    try {
      /** 删除收件箱信息表中记录 */
      StringBuffer sql = new StringBuffer("delete from sendbox where id in (");
      sql.append(mlist);
      sql.append(") and senderid=");
      sql.append(uinfo.getId());

      return dbsrc.executeUpdate(sql.toString());
    } finally {
      if (dbsrc != null) dbsrc.close();
    }
  }
예제 #2
0
  /* (非 Javadoc)
   * @see com.zjiao.ErrorInformation#getInformation()
   */
  public String getInformation(int err) {

    if (err == -1) return "";

    String information = null;

    try {

      if (errTable != null) {
        information = (String) errTable.get(new Integer(err));
      }

      if (!StringUtils.isNull(information)) return information;

    } catch (Exception ex) {
    }

    return "";
  }
예제 #3
0
  /**
   * 给某活动留言
   *
   * @param mapping 路径映射对象
   * @param form 表单对象
   * @param request 请求对象
   * @param response 响应对象
   * @return ActionForward
   * @throws Exception
   */
  public ActionForward doAdd(
      ActionMapping mapping,
      ActionForm form,
      HttpServletRequest request,
      HttpServletResponse response)
      throws Exception {

    // 获取初始化信息
    UserInfo loginUser = UserInfo.getLoginUser(request);

    ErrorInformation errInfo = new ActivityErrInfo();
    RequestUtils requ = RequestUtils.getInstance(request);
    Timestamp now = new Timestamp(System.currentTimeMillis());

    int id = requ.getInt("id");
    int actid = requ.getInt("actid");
    String content = requ.getString("message");
    String authorname = requ.getString("authorname");
    String joinerschool = requ.getString("joinerschool");

    if (loginUser == null) errInfo.saveError(ActivityErrInfo.NEED_LOGIN);
    // 检查当前用户是否是正常用户
    else if (loginUser.getUserStatus() != SysUtils.USER_STATUS_NORMAL)
      return mapping.findForward("profile");
    // 留言内容不能为空
    else if (StringUtils.isNull(content)) errInfo.saveError(ActivityErrInfo.NEEDED_FIELD_NOT_NULL);
    else {
      try {
        // 检查被留言的用户是否存在
        if (!AuthUserDAO.isExistUser(id)) {
          errInfo.saveError(ActivityErrInfo.OPERATION_NOT_ALLOW);
        } else {
          // 生成留言信息对象
          content = content.replaceAll(" ", "&nbsp");
          content = content.replaceAll("\n", "<br>");

          JoinActivityInfo board = new JoinActivityInfo();
          board.setActId(actid);
          board.setJoinerId(id);
          board.setJoinername(authorname);
          board.setJointime(now);
          board.setMessage(content);
          board.setMestime(now);
          board.setStatus(Utils.ACTIVITY_MESSAGE);
          board.setJoinerschool(joinerschool);

          int ret = JoinActivityDAO.insertMessage(board);
          if (ret != 1) errInfo.saveError(ActivityErrInfo.ERR_UNKNOWN);
        }

        // 因留言文章,用户积分加2
        if (errInfo.isEmpty()) {
          int rt = AuthUserDAO.addScore(loginUser, Utils.SCORE_MESSAGE_ACTIVITY);
          if (rt < 1) errInfo.saveError(ActivityErrInfo.ERR_UNKNOWN);
        }

      } catch (SQLException e) {
        Logger.Log(Logger.LOG_ERROR, e);
        errInfo.saveError(ActivityErrInfo.DATABASE_ERR);
      }
    }

    if (!errInfo.isEmpty()) {
      errInfo.saveToRequest("err", request);
      return mapping.findForward("error");
    }

    return mapping.findForward("actread");
  }
예제 #4
0
  /**
   * 添加活动
   *
   * @param mapping 路径映射对象
   * @param form 表单对象
   * @param request 请求对象
   * @param response 响应对象
   * @return ActionForward
   * @throws Exception
   */
  public ActionForward doCreateact(
      ActionMapping mapping,
      ActionForm form,
      HttpServletRequest request,
      HttpServletResponse response)
      throws Exception {

    int actid = 0;
    Timestamp now = new Timestamp(System.currentTimeMillis());

    // 初始化
    ActivityInfo act = (ActivityInfo) form;

    ErrorInformation errInfo = new ActivityErrInfo();

    // 转换时间格式
    Calendar cal = Calendar.getInstance();

    String starttime = request.getParameter("starttime");
    String endtime = request.getParameter("endtime");
    String bin_hour = request.getParameter("begin_hour");
    String bin_min = request.getParameter("begin_min");
    String end_hour = request.getParameter("end_hour");
    String end_min = request.getParameter("end_min");

    Timestamp start = Utils.StingToTimestamp(starttime, bin_hour, bin_min);
    Timestamp end = null;

    if (!StringUtils.isNull(endtime)) {
      end = Utils.StingToTimestamp(endtime, end_hour, end_min);
    } else {
      end = Utils.StingToTimestampEnd(starttime, bin_hour, bin_min);
    }

    // 获取登录用户
    UserInfo loginUser = UserInfo.getLoginUser(request);
    if (loginUser == null)
      // 检查用户是否登录
      errInfo.saveError(ActivityErrInfo.NEED_LOGIN);
    // 检查活动名称,活动地点和和活动内容,它们不能为空
    else if (StringUtils.isNull(act.getActname())
        || StringUtils.isNull(act.getActplace())
        || StringUtils.isNull(act.getActcontent()))
      errInfo.saveError(ActivityErrInfo.NEEDED_FIELD_NOT_NULL);
    else {
      // 完善act对象
      act.setAuthorId(loginUser.getId());
      act.setAuthorname(loginUser.getRealName());
      act.setStart(start);
      act.setEnd(end);
      act.setStatus(Utils.ACTIVITY_NORMAL); // 1为正常活动,2表示热点活动;

      try {

        // 如果没有出错,则保存到数据库
        int ret = ActivityDAO.createActivity(act);
        if (ret < 1) {
          errInfo.saveError(ActivityErrInfo.ERR_UNKNOWN);
        }

        // 获得活动id,以便跳转到readact.jsp;
        actid = ActivityDAO.getActIdByActname(act.getActname(), act.getAuthorname(), now);
        if (actid < 0) {
          errInfo.saveError(ActivityErrInfo.ERR_UNKNOWN);
        }

        // 因创建一个活动,用户积分减100
        if (errInfo.isEmpty()) {
          int rt = AuthUserDAO.addScore(loginUser, -Utils.SCORE_BEGIN_ACTIVITY);
          if (rt < 1) errInfo.saveError(ActivityErrInfo.ERR_UNKNOWN);
        }

      } catch (SQLException e) {
        Logger.Log(Logger.LOG_ERROR, e);
        errInfo.saveError(ActivityErrInfo.DATABASE_ERR);
      }
    }
    if (!errInfo.isEmpty()) {
      errInfo.saveToRequest("err", request);
      return mapping.findForward("error");
    }
    return new ActionForward("/activity/readact.jsp?actid=" + actid, true);
  }
예제 #5
0
  /**
   * 修改一个活动
   *
   * @param mapping 路径映射对象
   * @param form 表单对象
   * @param request 请求对象
   * @param response 响应对象
   * @return ActionForward
   * @throws Exception
   */
  public ActionForward doEditact(
      ActionMapping mapping,
      ActionForm form,
      HttpServletRequest request,
      HttpServletResponse response)
      throws Exception {

    // 获取初始化信息
    RequestUtils requ = RequestUtils.getInstance(request);
    ErrorInformation errInfo = new ActivityErrInfo();

    int actid = requ.getInt("actid");

    String actname = request.getParameter("actname");
    String actplace = request.getParameter("actplace");
    String actcontent = request.getParameter("actcontent");
    String phone = request.getParameter("phone");
    String email = request.getParameter("email");

    // 转换时间格式
    Calendar cal = Calendar.getInstance();
    String starttime = request.getParameter("starttime");
    String endtime = request.getParameter("endtime");
    String bin_hour = request.getParameter("begin_hour");
    String bin_min = request.getParameter("begin_min");
    String end_hour = request.getParameter("end_hour");
    String end_min = request.getParameter("end_min");

    Timestamp start = Utils.StingToTimestamp(starttime, bin_hour, bin_min);

    Timestamp end = null;
    if (!StringUtils.isNull(endtime)) {
      end = Utils.StingToTimestamp(endtime, end_hour, end_min);
    } else {
      end = Utils.StingToTimestampEnd(starttime, bin_hour, bin_min);
    }

    // 获取登录用户信息
    UserInfo loginUser = UserInfo.getLoginUser(request);

    if (loginUser == null) // 检查用户是否登录
    errInfo.saveError(ActivityErrInfo.NEED_LOGIN);
    // 检查活动名称,活动地点和和活动内容,它们不能为空
    else if (StringUtils.isNull(actname)
        || StringUtils.isNull(actplace)
        || StringUtils.isNull(actcontent)) errInfo.saveError(ActivityErrInfo.NEEDED_FIELD_NOT_NULL);
    else {
      // 完善act对象
      ActivityInfo act = new ActivityInfo();
      act.setStart(start);
      act.setEnd(end);
      act.setId(actid);
      act.setActname(actname);
      act.setActplace(actplace);
      act.setActcontent(actcontent);
      act.setPhone(phone);
      act.setEmail(email);
      try {
        int ret = ActivityDAO.editActivity(act);
        if (ret < 1) {
          errInfo.saveError(ActivityErrInfo.ERR_UNKNOWN);
        }
      } catch (SQLException e) {
        Logger.Log(Logger.LOG_ERROR, e);
        errInfo.saveError(ActivityErrInfo.DATABASE_ERR);
      }
    }

    if (!errInfo.isEmpty()) {
      errInfo.saveToRequest("err", request);
      return mapping.findForward("error");
    }

    return new ActionForward("/activity/readact.jsp?actid=" + actid, true);
  }