adminaddmerchantnextaction.java

基于struts的网上商店源码

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

/**
 * MyEclipse Struts Creation date: 12-15-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action path="/adminAddMerchantNext" name="adminAddMerchantNextForm"
 *                input="/form/adminAddMerchantNext.jsp" scope="request"
 *                validate="true"
 */
public class AdminAddMerchantNextAction 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) {
		AdminAddMerchantNextForm adminAddMerchantNextForm = (AdminAddMerchantNextForm) form;// TODO
																							// Auto-generated
																							// method
																							// stub
		String LoginID = String.valueOf(request.getSession().getAttribute(
				"user"));
		if (LoginID == null)
			return mapping.findForward("goLogin");
		String areaID = adminAddMerchantNextForm.getAreaID();
		String typeID = adminAddMerchantNextForm.getTypeID();
		String typeID2 = adminAddMerchantNextForm.getTypeID2();
		String typeID3 = adminAddMerchantNextForm.getTypeID3();
		String typeID4 = adminAddMerchantNextForm.getTypeID4();
		String chargeID = adminAddMerchantNextForm.getChargeID();
		String name = adminAddMerchantNextForm.getName();
		String address = adminAddMerchantNextForm.getAddress();
		String scale = adminAddMerchantNextForm.getScale();
		String vip = adminAddMerchantNextForm.getVip();
		String telephone = adminAddMerchantNextForm.getTelephone();
		String ID = areaID + String.format("%03d", Integer.parseInt(typeID))
				+ String.format("%03d", Integer.parseInt(chargeID));
		DBConnector dbc = new DBConnector();
		String sql = "insert Store(ID,AreaID,TypeID,"
				+ ("0".equals(typeID2) ? "" : "TypeID2,")
				+ ("0".equals(typeID3) ? "" : "TypeID3,")
				+ ("0".equals(typeID4) ? "" : "TypeID4,")
				+ "ChargeID,Name,Address,Scale,VIP,Telephone,State) values(?,?,?,"
				+ ("0".equals(typeID2) ? "" : typeID2 + ",")
				+ ("0".equals(typeID3) ? "" : typeID3 + ",")
				+ ("0".equals(typeID4) ? "" : typeID4 + ",") + "?,?,?,?,?,?,0)";
		String result;
		try {
			dbc.executeUpdate(sql, ID, areaID, typeID, chargeID, name, address,
					scale, vip, telephone);
			sql = "update Merchant set StoreID='" + ID + "' where ID="
					+ chargeID;
			dbc.executeUpdate(sql);
			request.setAttribute("result", "注册成功");
			return mapping.findForward("adminAddMerchantResult");
		} catch (Exception e) {
			e.printStackTrace();
			request.setAttribute("result", "注册失败");
			return mapping.findForward("adminAddMerchantResult");
		}

	}
}