adminstoretypeaction.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.AdminStoreTypeBean;
import com.mole.struts.dao.AdminStoreTypeDAO;
import com.mole.struts.form.AdminStoreTypeForm;

/**
 * MyEclipse Struts Creation date: 12-22-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 * @struts.action-forward name="goAdminStoreTypeDetail"
 *                        path="/adminStoreTypeDetail.jsp"
 * @struts.action-forward name="goAdminStoreType" path="/adminStoreType.jsp"
 */
public class AdminStoreTypeAction 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) {
		AdminStoreTypeDAO dao = null;
		AdminStoreTypeBean[] records = null;
		AdminStoreTypeForm atForm = (AdminStoreTypeForm) form;

		String action = request.getParameter("action");
		if (action == null || action.equals("new")) {// 获取浏览商业类型页面
			Object daoObj = request.getSession().getAttribute("pageDataRecord");
			if (daoObj != null && daoObj instanceof AdminStoreTypeDAO) {
				dao = (AdminStoreTypeDAO) daoObj;
			} else {
				dao = new AdminStoreTypeDAO(" ID,Name,Description ",
						" StoreType WHERE ID=ID ", " ID ", null, " ID ", 10);
				request.getSession().setAttribute("pageDataRecord", dao);
			}
			String pageIndex = atForm.getPageIndex();
			String pageSizeSelect = atForm.getPageSizeSelect();
			if (pageIndex != null && !pageIndex.equals("")) {
				dao.setCurrentPage(Integer.parseInt(pageIndex));
				dao.setPageSize(Integer.parseInt(pageSizeSelect));
			}
		} else if (action.equals("add")) {// 获取添加商业类型页面
			AdminStoreTypeBean bean = new AdminStoreTypeBean();
			request.setAttribute("record", bean);
			request.setAttribute("pageAction", "add");
			return mapping.findForward("goAdminStoreTypeDetail");
		} else if (action.equals("modify")) {// 获取修改商业类型页面
			dao = (AdminStoreTypeDAO) request.getSession().getAttribute(
					"pageDataRecord");
			String sql = "SELECT ID,Name,Description FROM StoreType WHERE ID="
					+ atForm.getId();
			AdminStoreTypeBean bean = dao.getStoreTypeInfo(sql);
			request.setAttribute("record", bean);
			request.setAttribute("pageAction", "modify");
			return mapping.findForward("goAdminStoreTypeDetail");
		} else if (action.equals("delete")) {// 删除一条商业类型记录
			dao = (AdminStoreTypeDAO) request.getSession().getAttribute(
					"pageDataRecord");
			String sql = "DELETE FROM StoreType WHERE ID=" + atForm.getId();
			dao.executeUpdate(sql);
			dao.getDBRecordCount();
		} else if (action.equals("onAdd")) {// 添加一条商业类型记录
			dao = (AdminStoreTypeDAO) request.getSession().getAttribute(
					"pageDataRecord");
			String sql = "INSERT INTO [StoreType]([Name],[Description]) "
					+ "VALUES('" + atForm.getName() + "','"
					+ atForm.getDescription() + "')";
			dao.executeUpdate(sql);
			dao.getDBRecordCount();
		} else if (action.equals("onModify")) {// 修改一条商业类型记录
			dao = (AdminStoreTypeDAO) request.getSession().getAttribute(
					"pageDataRecord");
			String sql = "UPDATE StoreType SET Name='" + atForm.getName()
					+ "',Description='" + atForm.getDescription()
					+ "' WHERE ID=" + atForm.getId();
			dao.executeUpdate(sql);
		}
		records = dao.getStoreTypePage();
		request.setAttribute("storeType", records);
		return mapping.findForward("goAdminStoreType");
	}
}