customergroupforumaction.java

基于struts的网上商店源码

/*
 * 作者:李斌
 * 时间:2007年12月04日
 * 功能:创建用户群
 */
package com.mole.struts.action;

import java.util.ArrayList;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.mole.struts.bean.CustomerGroupForumListBean;
import com.mole.struts.bean.Page;
import com.mole.struts.dao.CustomerGroupForumListDAO;
import com.mole.struts.dao.DBConnector;

/**
 * MyEclipse Struts Creation date: 12-04-2007 Creator: Li Bin XDoclet
 * definition:
 * 
 * @struts.action input="/customerGroupForum.jsp" validate="true"
 * @struts.action-forward name="goForum" path="/customerGroupForum.jsp"
 */
public class CustomerGroupForumAction extends Action {
	/*
	 * Generated Methods
	 */
	private CustomerGroupForumListDAO dao;
	private ArrayList<CustomerGroupForumListBean> list;

	/**
	 * Method execute
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		// TODO Auto-generated method stub
		DBConnector dbc = new DBConnector();
		if (null == dao)
			dao = new CustomerGroupForumListDAO();
		Page page = new Page();
		String blogID = request.getParameter("blogID");
		String groupID = request.getParameter("groupID");
		// String visitorID=request.getParameter("vid");
		String action = request.getParameter("action");
		String user = request.getSession().getAttribute("user").toString();
		// 回复群日志
		if ("issue".equals(action)) {
			String title = request.getParameter("title");
			String content = request.getParameter("content");
			String sql = "insert into [CustomerGroupList]([Title],[Content],[TopicID],[AuthorID],[GroupID]) values(?,?,?,?,?)";
			try {
				dbc.executeUpdate(sql, title, content, blogID, user, groupID);
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		// 获取群日志
		ArrayList<Object[]> blog = null;
		String sql = "select a.[ID],a.[Title],a.[Content],b.[NickName],convert(nvarchar(20),a.[IssueTime],120),a.[AuthorID],a.[GroupID] "
				+ "from [CustomerGroupList] a,[Customer] b where a.[ID]="
				+ blogID
				+ " and a.[GroupID]="
				+ groupID
				+ " and a.[TopicID]=0 and b.[ID]=a.[AuthorID]";
		try {
			blog = dbc.executeQuery(sql);
		} catch (Exception e) {
			e.printStackTrace();
		}
		request.setAttribute("Blog", blog);
		// 获取群主ID
		ArrayList<Object[]> groupHost = null;
		sql = "select [ID] from [CustomerGroupMember] where [GroupID]="
				+ groupID + " and [IsHost]=1";
		try {
			groupHost = dbc.executeQuery(sql);
		} catch (Exception e1) {
			e1.printStackTrace();
		}
		request.setAttribute("GroupHost", groupHost);
		// 获取群日志回复
		int pageSize = (request.getParameter("pageSizeSelect") == null ? 10
				: Integer.parseInt(request.getParameter("pageSizeSelect")));
		int currentPage = (request.getParameter("page") == null ? 1 : Integer
				.parseInt(request.getParameter("page")));
		int count = dao.getPageInfo(blogID, groupID, pageSize);
		page.setPageSize(pageSize);
		page.setRecordCount(count);
		page.setPageCount((count + pageSize - 1) / pageSize);
		page.setCurrentPage(currentPage);
		list = new ArrayList<CustomerGroupForumListBean>();
		try {
			list = dao.queryGroups(blogID, groupID, page.getCurrentPage());
		} catch (Exception e) {
			e.printStackTrace();
			HttpSession session = request.getSession();
			session.setAttribute("title", "错误信息");
			session.setAttribute("message", "用户名或密码错误，请重新登陆！");
			session.setAttribute("returnUrl", "show.do?action=goLogin");
			return mapping.findForward("goMessage");
		}
		request.setAttribute("GroupForum", list);
		request.setAttribute("Page", page);
		return mapping.findForward("goForum");
	}
}