customergroupcreateaction.java

基于struts的网上商店源码

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

import java.util.ArrayList;

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: 11-24-2007 Creator: Li Bin XDoclet
 * definition:
 * 
 * @struts.action input="/customerGroupCreate.jsp" validate="true"
 * @struts.action-forward name="goCreate" path="/customerGroupCreate.jsp"
 */
public class CustomerGroupCreateAction 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 user = String.valueOf(request.getSession().getAttribute("user"));
		String action = request.getParameter("action");
		// 获取用户风格
		String sql = "SELECT [BlogStyle] FROM [Customer] WHERE [ID]=?";
		String style = "";
		ArrayList<Object[]> al = null;
		try {
			al = dbc.executeQuery(sql, user);
		} catch (Exception e) {
			e.printStackTrace();
		}
		if (null != al)
			style = ((Object[]) al.get(0))[0].toString().trim();
		request.setAttribute("BlogStyle", style);
		// 创建群
		if (null != action) {
			String groupName = request.getParameter("groupName");
			String groupKey = request.getParameter("groupKeyWord");
			String groupDesc = request.getParameter("groupDesc");
			String groupImage = request.getParameter("image");
			if (groupDesc == null)
				groupDesc = "";
			if (groupImage == null)
				groupImage = "";
			try {
				dbc.executeStoredProcedure("sp_CreateGroup(?,?,?,?,?)",
						groupName, groupKey, groupDesc, groupImage, user);
			} catch (Exception e) {
				e.printStackTrace();
			}
			return new ActionForward("/customerGroupList.do?action=joined");
		}
		return mapping.findForward("goCreate");
	}
}