//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 com.dut.logic.logic.InputCheckUtil;
import java.lang.ClassCastException;


import java.sql.Date;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
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.Hagakicd;
import com.dut.logic.db.Toukyucd;
import com.dut.logic.util.StringUtil;
import com.dut.struts.form.KensyoRegistConfActionForm;

/** 
 * MyEclipse Struts
 * Creation date: 04-09-2006
 * 
 * XDoclet definition:
 * @struts.action path="/kensyoRegistConf" name="kensyoRegistConfActionForm" scope="request" validate="true"
 */
public class KensyoRegistConfAction extends Action {

	BatchDBConnectionUtil U1=new BatchDBConnectionUtil();
	ActionForward forward=new ActionForward();

	/** 
	 * Method execute
	 * 判斷點擊的是[是]按鈕,還是[否]按鈕,然后分別轉向,傳值
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 * 劉濤 2006-04-20
	 */
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response) {
		KensyoRegistConfActionForm kensyoRegistConfActionForm = (KensyoRegistConfActionForm) form;
		
		/************取得session的值 取得在KensyoInputAction中壓得值****************/
		String t_year=(String)request.getSession().getAttribute("t_year");
		String t_yeshu=(String)request.getSession().getAttribute("t_yeshu");
		String t_dengji=(String)request.getSession().getAttribute("t_dengji");	
		String t_lastnumber=(String)request.getSession().getAttribute("t_lastnumber");
		String sk_year=(String)request.getSession().getAttribute("sk_year");
		String sz_year=(String)request.getSession().getAttribute("sz_year");	
		String nowdate=(String)request.getSession().getAttribute("nowdate");

		System.out.println(t_year);	
		System.out.println(t_yeshu);	
		
		/*********************轉換為Int 型**********************/
		int nen=Integer.parseInt(t_year);
		int hagaki_id=Integer.parseInt(t_yeshu);
		int toukyu_id=Integer.parseInt(t_dengji);
		int sketa=Integer.parseInt(t_lastnumber);
		
		/****************判斷點擊的是[否]按鈕*****************/
		if (request.getParameter("name") != null) //false
		{
			
			request.setAttribute("t_year", t_year);
			request.setAttribute("t_yeshu",t_yeshu);
			request.setAttribute("t_dengji",t_dengji);		
			request.setAttribute("t_lastnumber", t_lastnumber);
			request.setAttribute("sk_year", sk_year);
			request.setAttribute("sz_year", sz_year);
			
			/*************頁面轉向 KensyoInput.jsp*********/
			forward=mapping.findForward("k_regist");  
			
		}
		/****************判斷點擊的是[是]按鈕*****************/
		else//true
		{	

			/********************插入到表 kensyou***********************/
			String sq2="insert into Kensyou values("+nen+","+hagaki_id+","+toukyu_id+","+sketa+",'"+sk_year+"','"+sz_year+"','"+nowdate+"','"+nowdate+"')";
			System.out.println(sq2);
			U1.executeUpdate(sq2);	
			/*************頁面轉向 kensyoMenuDispatch.do 轉向KensyoInput.jsp*********/
			forward=mapping.findForward("k_input");	

		}
		
		return forward;
	}

}