adminserveraction.java

个人网上银行系统设计该系统使用MySQL数据库。

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

import java.util.ArrayList;
import java.util.HashMap;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.actions.LookupDispatchAction;

import com.perwebbank.DBOpertion;
import com.perwebbank.form.LockAccount;
import com.perwebbank.form.ServerForm;

/**
 * MyEclipse Struts Creation date: 12-14-2006
 * 
 * XDoclet definition:
 * 
 * @struts.action
 */
public class AdminServerAction extends LookupDispatchAction {
	/*
	 * Generated Methods
	 */

	protected Map getKeyMethodMap() {
		Map<String, String> map = new HashMap<String, String>();
		map.put("admin.button.lock", "lock");
		map.put("admin.button.unlock", "unlock");		
		return map;
	}

	/**
	 * Method execute
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward lock(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		LockAccount lockAccount = (LockAccount)form;
		int status = 0;
		int account = Integer.parseInt(lockAccount.getAccount());
		System.out.println(lockAccount.getAccount());
		String sql = "update customer set status = '" + status
				+ "' where account= '" + account + "'";
		DBOpertion.getStatement();
		DBOpertion.exeuteUpdate(sql);
		DBOpertion.closeStatement();
		DBOpertion.closeConnection();
		ArrayList<ServerForm> array = (ArrayList<ServerForm>) request.getSession().getAttribute("array");
		ServerForm sform = (ServerForm) array.get(account-1);
		System.out.println(sform.getAccount());
		sform.setStatus(String.valueOf(status));
		array.remove(account-1);
		array.add(account-1, sform);
		request.getSession().setAttribute("array",array);		
		return mapping.findForward("admin");
	}

	public ActionForward unlock(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		LockAccount lockAccount = (LockAccount)form;
		int status = 1;
		int account = Integer.parseInt(lockAccount.getAccount());
		System.out.println(lockAccount.getAccount());
		String sql = "update customer set status = '" + status
				+ "' where account= '" + account + "'";
		DBOpertion.getStatement();
		DBOpertion.exeuteUpdate(sql);
		DBOpertion.closeStatement();
		DBOpertion.closeConnection();
		ArrayList<ServerForm> array = (ArrayList<ServerForm>) request.getSession().getAttribute("array");
		ServerForm sform = (ServerForm) array.get(account-1);
		System.out.println(sform.getAccount());
		sform.setStatus(String.valueOf(status));
		array.remove(account-1);
		array.add(account-1, sform);
		request.getSession().setAttribute("array",array);		
		return mapping.findForward("admin");	
	}

}