/**
* 获取送件箱邮件信息对象
*
* @param uinfo 读邮件的用户对象
* @param mid 邮件ID
* @return MailInfo 邮件信息对象
*/
public static MailInfo getSendInfo(UserInfo uinfo, int mid) throws SQLException {
if (uinfo == null) return null;
DBSource dbsrc = new DBSource();
try {
/** 从数据库中检索邮件信息 */
String sql =
"select id,receiverid,receivername,sub,content,sendtime from sendbox where id=? and senderid=?";
dbsrc.prepareStatement(sql);
dbsrc.setInt(1, mid);
dbsrc.setInt(2, uinfo.getId());
dbsrc.executeQuery();
if (dbsrc.next()) {
MailInfo minfo = new MailInfo();
minfo.setId(dbsrc.getInt("id"));
minfo.setReceiverId(dbsrc.getInt("receiverid"));
minfo.setReceiverName(dbsrc.getString("receivername"));
minfo.setSub(dbsrc.getString("sub"));
minfo.setContent(dbsrc.getString("content"));
minfo.setSendTime(dbsrc.getTimestamp("sendtime"));
return minfo;
}
} finally {
if (dbsrc != null) dbsrc.close();
}
return null;
}
/**
* 获取邮件信息对象
*
* @param uinfo 读邮件的用户对象
* @param mid 邮件ID
* @return MailInfo 邮件信息对象
*/
public static MailInfo getMailInfo(UserInfo uinfo, int mid) throws SQLException {
if (uinfo == null) return null;
DBSource dbsrc = new DBSource();
MailInfo minfo = null;
try {
/** 从数据库中检索邮件信息 */
String sql =
"select id,senderid,sendername,sub,content,mstatus,sendtime from mailbox where id=? and receiverid=?";
dbsrc.prepareStatement(sql);
dbsrc.setInt(1, mid);
dbsrc.setInt(2, uinfo.getId());
dbsrc.executeQuery();
if (dbsrc.next()) {
minfo = new MailInfo();
minfo.setId(dbsrc.getInt("id"));
minfo.setSenderId(dbsrc.getInt("senderid"));
minfo.setSenderName(dbsrc.getString("sendername"));
minfo.setSub(dbsrc.getString("sub"));
minfo.setContent(dbsrc.getString("content"));
minfo.setStatus(dbsrc.getInt("mstatus"));
minfo.setSendTime(dbsrc.getTimestamp("sendtime"));
}
if (minfo != null) {
sql = "update mailbox set mstatus=? where id=? and receiverid=?";
dbsrc.prepareStatement(sql);
dbsrc.setInt(1, SysUtils.MAIL_STATUS_READ);
dbsrc.setInt(2, minfo.getId());
dbsrc.setInt(3, uinfo.getId());
int ret = dbsrc.executeUpdate();
if (ret != 1) {
return null;
}
return minfo;
}
} finally {
if (dbsrc != null) dbsrc.close();
}
return null;
}
/**
* 删除活动留言
*
* @param mapping 路径映射对象
* @param form 表单对象
* @param request 请求对象
* @param response 响应对象
* @return ActionForward
* @throws Exception
*/
public ActionForward doDeleteJoinMes(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
// 初始化
ErrorInformation errInfo = new ActivityErrInfo();
RequestUtils requ = RequestUtils.getInstance(request);
int id = requ.getInt("actid");
int joiner_id = requ.getInt("joiner_id");
int status = requ.getInt("status");
String mes = requ.getString("mestime");
Timestamp mestime = Timestamp.valueOf(mes);
// 获取登录用户信息
UserInfo loginUser = UserInfo.getLoginUser(request);
if (loginUser == null) // 检查用户是否登录
errInfo.saveError(ActivityErrInfo.NEED_LOGIN);
else {
try {
// 如果没有出错，则删除
int ret = JoinActivityDAO.deleteJoinMes(id, joiner_id, status, mestime);
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 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();
}
}
/**
* 删除参与/关注活动信息（从参与活动列表和关注活动列表中删除）
*
* @param mapping 路径映射对象
* @param form 表单对象
* @param request 请求对象
* @param response 响应对象
* @return ActionForward
* @throws Exception
*/
public ActionForward doDeleteJoinAct(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
// 初始化
ErrorInformation errInfo = new ActivityErrInfo();
RequestUtils requ = RequestUtils.getInstance(request);
int id = requ.getInt("id");
int joiner_id = requ.getInt("joiner_id");
int status = requ.getInt("status");
// 获取登录用户及角色信息
UserInfo loginUser = UserInfo.getLoginUser(request);
if (loginUser == null) // 检查用户是否登录
errInfo.saveError(ActivityErrInfo.NEED_LOGIN);
else {
try {
// 如果没有出错，则删除
int ret = JoinActivityDAO.deleteJoinAct(id, joiner_id, status);
if (ret < 1) errInfo.saveError(ActivityErrInfo.ERR_UNKNOWN);
// 因从列表中删除某一活动，用户积分减10
if (errInfo.isEmpty()) {
int rt = AuthUserDAO.addScore(loginUser, -Utils.SCORE_JOIN_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/index.jsp", true);
}
/**
* 更新参与/关注活动状态
*
* @param mapping 路径映射对象
* @param form 表单对象
* @param request 请求对象
* @param response 响应对象
* @return ActionForward
* @throws Exception
*/
public ActionForward doUpdateActivityStatus(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
// 初始化信息
ErrorInformation errInfo = new ActivityErrInfo();
RequestUtils requ = RequestUtils.getInstance(request);
int id = requ.getInt("id");
int joiner_id = requ.getInt("joiner_id");
int status = requ.getInt("status");
// 获取登录用户信息
UserInfo loginUser = UserInfo.getLoginUser(request);
if (loginUser == null) // 检查用户是否登录
errInfo.saveError(ActivityErrInfo.NEED_LOGIN);
else {
try {
// 如果没有出错，则更改
int ret = JoinActivityDAO.UpdateActivityStatus(id, joiner_id, status);
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 mapping.findForward("activity");
}
/**
* 删除参与/关注活动信息（从数据库中删除）
*
* @param mapping 路径映射对象
* @param form 表单对象
* @param request 请求对象
* @param response 响应对象
* @return ActionForward
* @throws Exception
*/
public ActionForward doDeleteAct(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
// 初始化
ErrorInformation errInfo = new ActivityErrInfo();
RequestUtils requ = RequestUtils.getInstance(request);
int id = requ.getInt("actid");
// 获取登录用户信息
UserInfo loginUser = UserInfo.getLoginUser(request);
if (loginUser == null) // 检查用户是否登录
errInfo.saveError(ActivityErrInfo.NEED_LOGIN);
else {
try {
// 如果没有出错，则删除
int ret = ActivityDAO.deleteActivity(id);
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/index.jsp", true);
}
/**
* 给某活动留言
*
* @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);
}