//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.KensyoUpdateActionForm;


/** 
 * MyEclipse Struts
 * Creation date: 04-12-2006
 * 
 * XDoclet definition:
 * @struts.action path="/xiuzheng" name="xiuzhengActionForm" scope="request" validate="true"
 */
public class XiuzhengAction 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) {
		KensyoUpdateActionForm xiuzhengActionForm = (KensyoUpdateActionForm) form;
			String ky1 = (String) request.getParameter("ky");
			String ky=StringUtil.trans(ky1);
		   BatchDBConnectionUtil yy =new BatchDBConnectionUtil();
		   ResultSet rs=yy.executeQuery("select * from kyokusyo where KYOKU_ID='"+ky+"'");
		   ArrayList list1 = new ArrayList();
		   try {
		   while(rs.next())
		    {
			
		     String kyy = StringUtil.trans_date(rs.getString("KYOKU_ID"));
		     System.out.println(" ky ===="+ ky);
		     String kym = StringUtil.trans_date(rs.getString("KYOKUSYO_MEI"));
		     int zm = rs.getInt("ZIPCD_MAE");
		     int za = rs.getInt("ZIPCD_ato");
		     
		     String jy = StringUtil.trans_date(rs.getString("JUSYO"));
		     String tel = StringUtil.trans_date(rs.getString("TEL"));
		     Kyokusyo kk = new  Kyokusyo();
		     kk.setKyoku_id(ky);
		     kk.setKyokusyo_mei(kym);
		     kk.setZipcd_ato(za);
		     kk.setZipcd_mae(zm);
		     kk.setJusyo(jy);
		     kk.setTel(tel);
		     list1.add(kk);
    	    		     			     
		    }
		  } catch (SQLException e) {
		   // TODO Auto-generated catch block
		   e.printStackTrace();
		  }
		     request.getSession().setAttribute("list1", list1);	
		   
		  ActionForward forward=mapping.findForward("KyokusyoUpdateInput");
		  return forward;
		  
		 }

		}