deletecard1action.java

是一个用VB编写得银行ATM机交易的程序

/*
 * deleteCard1Action.java
 *
 * Created on 2008年2月23日, 下午3:55
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package com.myapp.struts;

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.ActionError;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.myapp.struts.DataStore;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.io.File;

/**
 *
 * @author Administrator
 */
public class deleteCard1Action extends Action {

	/* （非 Javadoc）
	 * @see org.apache.struts.action.Action#execute(org.apache.struts.action.ActionMapping, org.apache.struts.action.ActionForm, javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
	 */
	public ActionForward execute(ActionMapping map, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws Exception {
		// TODO 自动生成方法存根
		String Uname = (String)request.getParameter("UserName");
		
		DataStore ds = DataStore.getInstance();
		
		String sql1 = "delete from cardinfo where UserName='"+ Uname +"'";
		try {
			ds.execute(sql1);
		}catch(Exception e) {
		}
		return (map.findForward("deleteCard11"));
	}
}