/*
 * 作者:李斌
 * 時間:2007年12月05日
 * 功能:創建用戶群
 */
package com.mole.struts.action;

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

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.dao.DBConnector;

/**
 * MyEclipse Struts Creation date: 12-05-2007 Creator: Li Bin XDoclet
 * definition:
 * 
 * @struts.action input="/customerGroupForumIssue.jsp" validate="true"
 * @struts.action-forward name="goIssue" path="/customerGroupForumIssue.jsp"
 */
public class CustomerGroupForumIssueAction extends Action {
	/*
	 * Generated Methods
	 */

	/**
	 * 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();
		String action = request.getParameter("action");
		// 發表新日志
		if ("issue".equals(action)) {
			String groupID = request.getParameter("groupID");
			String user = request.getSession().getAttribute("user").toString();
			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, 0, user, groupID);
			} catch (Exception e) {
				e.printStackTrace();
			}
			return new ActionForward("/customerGroupForumList.do?groupID="
					+ groupID);

		}
		return mapping.findForward("goIssue");
	}
}