//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 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.StringUtil;
import com.dut.struts.form.TousenUpdateActionForm;

/** 
 * MyEclipse Struts
 * Creation date: 04-17-2006
 * 
 * XDoclet definition:
 * @struts.action path="/tousenInputDispatch" name="tousenUpdateActionForm" scope="request" validate="true"
 */
public class TousenInputDispatchAction extends Action {

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

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

	/** 
	 * Method execute
	 * 壓值 并轉(zhuǎn)向 TousenRegistConf.jsp
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 * 劉濤 2006-04-24
	 */
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response) {
		TousenUpdateActionForm tousenUpdateActionForm = (TousenUpdateActionForm) form;
		// TODO Auto-generated method stub
		ActionForward forward = new ActionForward();
		
		StringUtil U1=new StringUtil();
		String year="";
		String number="";
		year=year=request.getParameter("nen");
		String yeshu_id=tousenUpdateActionForm.getYeshu();
		String dengji_id=tousenUpdateActionForm.getDengji();
		System.out.println("yeshu_id===3==>"+yeshu_id);
		System.out.println("dengji_id===3==>"+dengji_id);
		String sq1="select hagaki_mei from hagakicd where Hagaki_id="+yeshu_id;
		String sq2="select toukyu_mei from toukyucd where Toukyu_id="+dengji_id;	
		String yeshu_values=StringUtil.trans_date(KensyouLogic .getDataNameThrough(sq1));
		String dengji_values=StringUtil.trans_date(KensyouLogic .getDataNameThrough(sq2));
		System.out.println("yeshu_values====="+yeshu_values);	
		System.out.println("dengji_values====="+dengji_values);		
	    number = request.getParameter("number");
		String login_time=(String) request.getSession().getAttribute("nowdate");
		/****************把數(shù)據(jù)壓到session 里****************/
		request.getSession().setAttribute("year",year);
		request.getSession().setAttribute("yeshu_id",yeshu_id);
		request.getSession().setAttribute("dengji_id",dengji_id);
		request.getSession().setAttribute("yeshu_values",yeshu_values);
		request.getSession().setAttribute("dengji_values",dengji_values);
		request.getSession().setAttribute("number",number);
		request.getSession().setAttribute("login_time",login_time); 
		
		if(request.getParameter("name")!=null)
		{
			System.out.println("name===");
			/******頁面轉(zhuǎn)向 TousenRegistConf.jsp*********/
			forward=mapping.findForward("t_regist");
		}
	
		return forward;
	}

}