admingroupmanageaction.java

基于struts的网上商店源码

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.mole.struts.action;

import java.util.ArrayList;

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.CustomerGroupListBean;
import com.mole.struts.bean.Page;
import com.mole.struts.dao.CustomerGroupListDAO;
import com.mole.struts.dao.DBConnector;

/**
 * MyEclipse Struts Creation date: 12-24-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action input="/merchantGroupManage.jsp" validate="true"
 * @struts.action-forward name="goManage" path="/merchantGroupManage.jsp"
 */
public class AdminGroupManageAction extends Action {
	/*
	 * Generated Methods
	 */
	private CustomerGroupListDAO dao;
	private ArrayList<CustomerGroupListBean> list;

	/**
	 * 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
		if (null == dao)
			dao = new CustomerGroupListDAO();
		Page page = new Page();
		DBConnector dbc = new DBConnector();
		String sql;
		String action = request.getParameter("action");
		String groupID = request.getParameter("groupID");
		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 ("lock".equals(action)) {
			sql = "update [CustomerGroup] set [State]=? where [ID]=?";
			try {
				dbc.executeUpdate(sql, 1, groupID);
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		// 激活一个群
		if ("unlock".equals(action)) {
			sql = "update [CustomerGroup] set [State]=? where [ID]=?";
			try {
				dbc.executeUpdate(sql, 0, groupID);
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		// 获取所有群列表
		int count = dao.getAllPageInfo(pageSize);
		page.setPageSize(pageSize);
		page.setRecordCount(count);
		page.setPageCount((count + pageSize - 1) / pageSize);
		page.setCurrentPage(currentPage);
		list = new ArrayList<CustomerGroupListBean>();
		try {
			list = dao.queryAllGroups(page.getCurrentPage());
		} catch (Exception e) {
			e.printStackTrace();
		}
		request.setAttribute("GroupList", list);
		request.setAttribute("Page", page);
		return mapping.findForward("goManage");
	}
}