//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.SQLException;
import java.util.ArrayList;
import java.util.Iterator;

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

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.dut.dao.BatchDBConnectionUtil;
import com.dut.logic.db.Kensyou;
import com.dut.logic.db.Tousen;
import com.dut.logic.logic.TousenLogic;
import com.dut.logic.util.StringUtil;
import com.dut.struts.form.TousenUpdateActionForm;
import com.mysql.jdbc.ResultSet;

/** 
 * MyEclipse Struts
 * Creation date: 04-17-2006
 * 
 * XDoclet definition:
 * @struts.action path="/tousenDeleteConfDispatch" name="tousenUpdateActionForm" scope="request" validate="true"
 */
public class TousenDeleteConfDispatchAction 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) {
		TousenUpdateActionForm tousenUpdateActionForm = (TousenUpdateActionForm) form;
		ActionForward forward=new ActionForward ();
		ActionErrors errors=new ActionErrors();
		StringUtil U1=new StringUtil();
		ArrayList A_delete=new ArrayList();
		
		if(request.getParameter("name").equals("D_no"))
		{
			forward=mapping.findForward("t_d_search1");
		}
		else
		{
			int h1=Integer.parseInt((String) request.getSession().getAttribute("h1"));
			int h2=Integer.parseInt((String) request.getSession().getAttribute("h2"));
			int h3=Integer.parseInt((String) request.getSession().getAttribute("h3"));
			String h4=(String) request.getSession().getAttribute("h4");
			
			
			String sq0="select * from seikyu where nen="+h1+" and hagaki_id="+h2+" and toukyu_id="+h3+" and bangou='"+h4+"'";
			ResultSet rs=TousenLogic.T_select(sq0);
			try {
				if(rs.next()==true)
				{
					errors.add("message",new ActionError("Data_delete_exist"));
					saveErrors(request,errors);
					return (new ActionForward(mapping.getInput()));
				}
				else
				{
					
					A_delete=(ArrayList) request.getSession().getAttribute("A1");
					Iterator it_delete = A_delete.iterator();

					while(it_delete.hasNext())
					{
						Tousen tou= (Tousen) it_delete.next();
						int t1=tou.getNen();
						int t2=tou.getHagaki_id();
						int t3=tou.getToukyu_id();
						String t4=tou.getTousen_no();
						if(t1==h1&&t2==h2&&t3==h3&&t4.equals(h4))
						{
							A_delete.remove(tou);
							break;
						}
						
					}	
					String sq="delete from tousen where nen="+h1+" and hagaki_id="+h2+" and toukyu_id="+h3+" and tousen_no='"+h4+"'";
					TousenLogic.T_Data(sq);
					
					String size=Integer.toString(A_delete.size());
					System.out.println("size==="+size);
					request.getSession().setAttribute("size",size);
					request.getSession().setAttribute("A1",A_delete);
					forward=mapping.findForward("t_d_search1");
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}

		return forward;
	}

}