admincityinfoaction.java

基于struts的网上商店源码

/*
 * 作者:刘云云
 * 时间:2007年12月22日
 * 功能:平台基础信息维护-开通城市（所在城市）的添加和删除修改。
 */
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.bean.AdminProvinceInfoBean;
import com.mole.struts.bean.MerchantCityInfoBean;
import com.mole.struts.dao.AdminCityInfoDAO;

/**
 * MyEclipse Struts Creation date: 12-22-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 * @struts.action-forward name="goAdminAreaAdd" path="/adminCityAdd.jsp"
 * @struts.action-forward name="goAdminCityInfo" path="/adminCityInfo.jsp"
 */
public class AdminCityInfoAction 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) {

		AdminCityInfoDAO dao = new AdminCityInfoDAO();

		String action = request.getParameter("action");
		if (action == null || action.equals("show")) {// 获取浏览开通城市页面
			AdminProvinceInfoBean[] provinceInfo = dao.getAllProvinceInfo();
			request.setAttribute("provinceInfo", provinceInfo);

			String provinceId = request.getParameter("provinceId");
			provinceId = provinceId == null ? "1" : provinceId;
			request.setAttribute("provinceId", provinceId);

			String sql = "SELECT ID,name FROM city WHERE provinceID="
					+ provinceId;
			MerchantCityInfoBean[] cityInfo = dao.getAllCityInfo(sql);
			request.setAttribute("cityInfo", cityInfo);
			return mapping.findForward("goAdminCityInfo");
		} else if (action.equals("add")) { // 获取添加开通城市页面
			AdminProvinceInfoBean[] provinceInfo = dao.getAllProvinceInfo();
			request.setAttribute("provinceInfo", provinceInfo);

			return mapping.findForward("goAdminCityAdd");
		} else if (action.equals("delete")) {// 删除一条开通城市记录
			String sql = "DELETE FROM Area WHERE cityID="
					+ request.getParameter("id");
			dao.executeUpdate(sql);
			sql = "DELETE FROM city WHERE ID=" + request.getParameter("id");
			dao.executeUpdate(sql);
			return new ActionForward("/adminCityInfo.do?action=show");
		} else if (action.equals("onAdd")) { // 添加一条开通城市记录
			String provinceId = request.getParameter("provinceId");
			String cityId = request.getParameter("cityId");
			String cityName = request.getParameter("cityName");
			String sql = "INSERT INTO city(ID,provinceId,Name) VALUES('"
					+ cityId + "','" + provinceId + "','" + cityName + "')";
			dao.executeUpdate(sql);
			return new ActionForward("/adminCityInfo.do?action=show");
		}
		return null;
	}
}