adminoperatemerchantaction.java

基于struts的网上商店源码

/*
 * 作者：王亮亮
 * 时间：2007年12月10日
 * 功能：查询和操作商家信息
 */
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.bean.AdminOperateMerchantBean;
import com.mole.struts.bean.Page;
import com.mole.struts.dao.AdminOperateMerchantDAO;
import com.mole.struts.dao.DBConnector;

/**
 * MyEclipse Struts Creation date: 12-10-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 */
public class AdminOperateMerchantAction extends Action {
	/*
	 * Generated Methods
	 */
	private AdminOperateMerchantDAO dao;

	/**
	 * 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
		String LoginID = String.valueOf(request.getSession().getAttribute(
				"user"));
		if (LoginID == null)
			return mapping.findForward("goLogin");
		if (null == dao)
			dao = new AdminOperateMerchantDAO();
		Page page = new Page();
		String queryType = request.getParameter("queryType");
		String value = request.getParameter("value");
		String action = request.getParameter("action");
		if (action != null) {

			DBConnector dbc = new DBConnector();
			String sql;
			if (action.equals("more")) {
				String id = request.getParameter("ID");
				ArrayList<Object[]> merchantInfo = null;

				sql = "select a.ID,a.LoginName,a.State,a.Name,a.Gender,a.Email,a.Telephone,a.Cellphone,a.Address,a.CreateDate,a.LastLogin,b.Name from Merchant a join Store b on a.StoreID=b.ID where a.ID="
						+ id + "";
				try {
					merchantInfo = dbc.executeQuery(sql);
					request.setAttribute("merchantInfo", merchantInfo);
					return mapping.findForward("adminQueryMerchant");
				} catch (Exception e) {
					e.printStackTrace();
					HttpSession session = request.getSession();
					session.setAttribute("title", "错误信息");
					session.setAttribute("message", "查询失败！");
					session.setAttribute("returnUrl", "show.do?action=goLogin");
					return mapping.findForward("goMessage");
				}
			} else if (action.equals("delete")) {
				String storeID = request.getParameter("storeID");
				sql = "update Merchant set State=1 where StoreID='" + storeID
						+ "'";
				String sql2 = "update Store set State=1 where ID='" + storeID
						+ "'";
				try {
					dbc.executeUpdate(sql);
					dbc.executeUpdate(sql2);
				} catch (Exception e) {
					e.printStackTrace();
					HttpSession session = request.getSession();
					session.setAttribute("title", "错误信息");
					session.setAttribute("message", "删除商家失败！");
					session.setAttribute("returnUrl", "show.do?action=goLogin");
					return mapping.findForward("goMessage");
				}
			}
		}
		int pageSize = (request.getParameter("pageSizeSelect") == null ? 10
				: Integer.parseInt(request.getParameter("pageSizeSelect")));
		int currentPage = (request.getParameter("page") == null ? 1 : Integer
				.parseInt(request.getParameter("page")));
		if (queryType == null) {
			queryType = "";
			value = "";
		}
		value = value.trim();
		request.setAttribute("queryType", queryType);
		request.setAttribute("value", value);
		int count = dao.getPageInfo(queryType, value, pageSize);
		page.setPageSize(pageSize);
		page.setRecordCount(count);
		page.setPageCount((count + pageSize - 1) / pageSize);
		page.setCurrentPage(currentPage);
		ArrayList<AdminOperateMerchantBean> a1 = new ArrayList<AdminOperateMerchantBean>();
		try {
			a1 = dao.queryMerchant(queryType, value, currentPage, pageSize);
		} catch (Exception e) {
			e.printStackTrace();
			HttpSession session = request.getSession();
			session.setAttribute("title", "错误信息");
			session.setAttribute("message", "查询失败！");
			session.setAttribute("returnUrl", "show.do?action=goLogin");
			return mapping.findForward("goMessage");
		}
		request.setAttribute("merchantInfo", a1);
		request.setAttribute("Page", page);
		return mapping.findForward("adminOperateMerchant");

	}
}