adminaddmerchantaction.java

基于struts的网上商店源码

/*
 * 作者：王亮亮
 * 时间：2007年12月15日
 * 功能：添加商家
 */
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.dao.DBConnector;
import com.mole.struts.form.RegisterForm;

/**
 * MyEclipse Struts Creation date: 12-13-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 */
public class AdminAddMerchantAction 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
		RegisterForm rf = (RegisterForm) form;
		String LoginID = String.valueOf(request.getSession().getAttribute(
				"user"));
		if (LoginID == null)
			return mapping.findForward("goLogin");
		DBConnector dbc = new DBConnector();
		String sql = "Insert Merchant(LoginName,Password,Role,Name,Gender,Email,Telephone,CellPhone,Address)values(?,?,1,?,?,?,?,?,?)";
		try {
			dbc.executeUpdate(sql, rf.getLoginName(), rf.getPassword2(), rf
					.getName(), rf.getGender(), rf.getEmail(), rf
					.getTelephone(), rf.getCellphone(), rf.getAddress());

		} catch (Exception e) {
			e.printStackTrace();
			HttpSession session = request.getSession();
			request.setAttribute("result", "注册失败");
			return mapping.findForward("adminAddMerchantResult");
		}

		try {
			sql = "select ID,Name from Province";
			ArrayList<Object[]> province = null;
			province = dbc.executeQuery(sql);
			sql = "select ID,ProvinceID,Name from City";// 查询省代码
			ArrayList<Object[]> cit = null;
			cit = dbc.executeQuery(sql);
			sql = "select ID,CityID,Name from Area";// 查询城市代码
			ArrayList<Object[]> are = null;
			are = dbc.executeQuery(sql);
			sql = "select ID,Name from StoreType";// 查询商店类型
			ArrayList<Object[]> storeType = null;
			storeType = dbc.executeQuery(sql);
			sql = "select ID from Merchant where LoginName='"
					+ rf.getLoginName() + "'";
			ArrayList<Object[]> chargeID = null;
			chargeID = dbc.executeQuery(sql);
			request.setAttribute("province", province);
			ArrayList city = new ArrayList();
			for (int i = 0; i < cit.size(); i++) {
				String a[] = new String[2];
				a[0] = new String();
				a[1] = new String();
				a[0] = ((Object[]) cit.get(i))[0].toString().trim() + "-"
						+ ((Object[]) cit.get(i))[1].toString();
				a[1] = ((Object[]) cit.get(i))[2].toString();
				city.add(a);
			}
			request.setAttribute("city", city);
			ArrayList area = new ArrayList();
			for (int i = 0; i < are.size(); i++) {
				String b[] = new String[2];
				b[0] = new String();
				b[1] = new String();
				b[0] = ((Object[]) are.get(i))[0].toString().trim() + "-"
						+ ((Object[]) are.get(i))[1].toString().trim();
				b[1] = ((Object[]) are.get(i))[2].toString();
				area.add(b);
			}
			request.setAttribute("area", area);
			request.setAttribute("storeType", storeType);
			request.setAttribute("chargeID", chargeID);
			return mapping.findForward("adminAddMerchantNext");
		} catch (Exception e) {
			e.printStackTrace();
			request.setAttribute("result", "对不起，无法进行下一步操作");
			return mapping.findForward("adminAddMerchantResult");
		}

	}
}