//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.text.SimpleDateFormat;
import java.util.Date;

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.logic.InputCheckUtil;
import com.dut.logic.logic.KensyouLogic;
import com.dut.logic.util.NumberUtil;
import com.dut.logic.util.StringUtil;
import com.dut.struts.form.KensyoInputActionForm;

/** 
 * MyEclipse Struts
 * Creation date: 04-05-2006
 * 
 * XDoclet definition:
 * @struts.action path="/kensyoInput" name="kensyoInputActionForm" scope="request" validate="true"
 */
public class KensyoInputAction extends Action {

	/** 
	 * 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) {
		KensyoInputActionForm kensyoInputActionForm = (KensyoInputActionForm) form;
		// TODO Auto-generated method stub
		ActionErrors errors=new ActionErrors();
		BatchDBConnectionUtil BU1=new BatchDBConnectionUtil();
		StringUtil U1=new StringUtil();
		
		/*********************從頁面獲取到的值***************************/
		String t_year=(String) request.getAttribute("t_year");
		String yeshu=(String) kensyoInputActionForm.getYeshu();
		String dengji=(String) kensyoInputActionForm.getDengji();
		String t_lastnumber=(String) request.getAttribute("t_lastnumber");
		String sk_year=(String) request.getAttribute("sk_year");
		String sz_year=(String) request.getAttribute("sz_year");
		
		/*******************根據id來從表中獲取到相對應的文字標簽*************/
		String sq1="select hagaki_mei from hagakicd where Hagaki_id="+yeshu;
		String sq2="select toukyu_mei from toukyucd where Toukyu_id="+dengji;	
		String yeshu_values=StringUtil.trans_date(KensyouLogic .getDataNameThrough(sq1));
		String dengji_values=StringUtil.trans_date(KensyouLogic .getDataNameThrough(sq2));	

		/***************把從頁面取到的數據壓到session里********************/
		request.getSession().setAttribute("nian", t_year);
		request.getSession().setAttribute("t_year", t_year);
		request.getSession().setAttribute("t_yeshu", yeshu);
		request.getSession().setAttribute("t_dengji", dengji);
		request.getSession().setAttribute("yeshu", yeshu_values);
		request.getSession().setAttribute("dengji", dengji_values);
		request.getSession().setAttribute("t_lastnumber", t_lastnumber);
		request.getSession().setAttribute("sk_year", sk_year);
		request.getSession().setAttribute("sz_year", sz_year);

		/***********頁面轉向 轉向KensyoRegistConf.jsp**********/
		ActionForward forward=mapping.findForward("k_RegistConf");			
		return forward;
	}

}