//Created by MyEclipse Struts
// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_4.0.1/xslt/JavaClass.xsl

package com.dut.struts.action;

import java.sql.ResultSet;
import java.sql.SQLException;
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.dut.dao.BatchDBConnectionUtil;
import com.dut.logic.db.Kyokusyo;
import com.dut.logic.util.StringUtil;
//import com.dut.struts.form.XiaochuActionForm;

/**
 * MyEclipse Struts Creation date: 04-13-2006
 * 
 * XDoclet definition:
 * 
 * @struts.action path="/xiaochu" name="xiaochuActionForm" scope="request"
 *                validate="true"
 */
public class XiaochuAction extends Action {
	

	// --------------------------------------------------------- Instance
	// Variables

	// --------------------------------------------------------- Methods

	/**
	 * Method execute
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		//XiaochuActionForm xiaochuActionForm = (XiaochuActionForm) form;

		String ky1 = (String) request.getParameter("ky");
		String ky=StringUtil.trans(ky1);
		System.out.println("aaaaaaaaaaa"+ky);
		String ss = StringUtil.trans(request.getParameter("name"));
		System.out.println(ss);
		

		// TODO Auto-generated method stub
		
		BatchDBConnectionUtil yy = new BatchDBConnectionUtil();
		yy.executeUpdate("delete from kyokusyo where kyoku_id='"+ky+"'" );
		System.out.println("delete from kyokusyo  where KYOKU_ID='"+ky+"'");

		ActionForward forward = mapping.findForward("xiaochu");
		return forward;

	}

}