//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.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.Kyokusyo;
import com.dut.logic.logic.KyoukusyoLogic;
import com.dut.logic.util.StringUtil;
import com.dut.struts.form.KensyoInputActionForm;
import com.dut.struts.form.KyokusyoInputActionForm;
import com.dut.struts.form.ShujuyilanAtionForm;


/** 
 * MyEclipse Struts
 * Creation date: 04-26-2006
 * 
 * XDoclet definition:
 * @struts.action path="/shujuyilan" name="kyokusyoInputActionForm" scope="request" validate="true"
 */
public class ShujuyilanAction extends Action {
	
	static String w1="";


	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response) {
		KyokusyoInputActionForm kyokusyoInputActionForm = (KyokusyoInputActionForm) form;
		// TODO Auto-generated method stub
			ActionErrors errors = new ActionErrors();
		   BatchDBConnectionUtil yy =new BatchDBConnectionUtil();
		   String KYOKU_ID = StringUtil.trans(kyokusyoInputActionForm.getKYOKU_ID());
		   String KYOKUSYO_MEI = StringUtil.trans(kyokusyoInputActionForm.getKYOKUSYO_MEI());
		   System.out.println("KYOKU_ID=="+KYOKU_ID);
		   System.out.println("KYOKUSYO_MEI=="+KYOKUSYO_MEI);
		   
		   String sq="select * from kyokusyo where KYOKU_ID ='" + KYOKU_ID + "' and KYOKUSYO_MEI ='" + KYOKUSYO_MEI +"'";
		   w1="where KYOKU_ID ='" + KYOKU_ID + "' and KYOKUSYO_MEI ='" + KYOKUSYO_MEI +"'";
		   request.getSession().setAttribute("w1",w1);
		   System.out.println("sq==="+sq);
		   
		   ResultSet rs=yy.executeQuery(sq);
		   
		   System.out.println("sq1111=="+sq);
		   try {
			System.out.println("sq22222=="+rs.next());
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}  
		   ArrayList list1 = new ArrayList();
		   

		   KyoukusyoLogic kk=new KyoukusyoLogic();
		   int page = kk.getPage();
			int maxRows = kk.getfiednum("select count(*) from Kyokusyo where KYOKU_ID =" + KYOKU_ID 
		   + " and KYOKUSYO_MEI =" + KYOKUSYO_MEI,page ,10);
			System.out.println("maxRows111==="+maxRows);
		   list1=kk.getCurrentPageData(page,10,maxRows);
		   if(list1.size()==0)
		   {
			    System.out.println("page++++" + page);
				errors.add("message", new ActionError("kongle"));
				saveErrors(request, errors);
				return (new ActionForward(mapping.getInput()));  
		   }
			request.getSession().setAttribute("list1", list1);
		    	
		   
		  ActionForward forward=mapping.findForward("KyokusyoSearch");
		  return forward;
		  
		 }
	
	public static String W()
	{
		return w1;
	}

	}