/**
* 删除发件箱中邮件
*
* @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();
}
}
/* （非 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 "";
}
/**
* 给某活动留言
*
* @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(" ", " ");
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");
}
/**
* 添加活动
*
* @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);
}
/**
* 修改一个活动
*
* @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);
}