rili_zmzsaction.java

这个程序是花了好几十万请人开发的

// Created by Xslt generator for Eclipse.
// XSL :  not found (java.io.FileNotFoundException:  (Bad file descriptor))
// Default XSL used : easystruts.jar$org.easystruts.xslgen.JavaClass.xsl

package struts.action;

import java.sql.ResultSet;
import java.util.Vector;

import javabean.PubDate;
import javabean.YLHQ_zmzs;
import javabean.dbconnect;
import javabean.Checkdate;
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 struts.form.Rili_zmzsForm;

/** 
 * Rili_zmzsAction.java created by EasyStruts - XsltGen.
 * http://easystruts.sf.net
 * created on 10-24-2004
 * 
 * XDoclet definition:
 * @struts:action path="/rili_zmzs" name="rili_zmzsForm" input="/form/rili_zmzs.jsp" validate="true"
 * @struts:action-forward name="/YLHQ_zmzsD.jsp" path="/YLHQ_zmzsD.jsp"
 */
public class Rili_zmzsAction extends Action {

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

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

	/** 
	 * Method execute
	 * @param ActionMapping mapping
	 * @param ActionForm form
	 * @param HttpServletRequest request
	 * @param HttpServletResponse response
	 * @return ActionForward
	 * @throws Exception
	 */
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception {
		Rili_zmzsForm rili_zmzsForm = (Rili_zmzsForm) form;


		String names=rili_zmzsForm.getnames().trim();
			names=new String(names.getBytes("ISO-8859-1"));
		String sql;	
		String times=rili_zmzsForm.getDates();//得到时间
		String times2;//停止时间	
		int number=0;
		ResultSet rs;
		dbconnect db=new dbconnect();
		Vector vector1=new Vector();
		PubDate pub=new PubDate();
		String times1=pub.getshortPubdate();//当前时间
		Checkdate checkdate=new Checkdate();
		
		sql="select max(pubdate) from ylhq1_zmzs";
		rs=db.executeQuery(sql);
		if(rs.next())
		{
			times1=rs.getString(1);//最大天
		}
		rs.close();
		
		if(times.compareTo(times1)>0)
		{
			checkdate.settimes(times1);
			times2=checkdate.gettimes();
			//times2="2004-10-15";
			sql="select * from ylhq1_zmzs where pubdate between '"+times2+"' and '"+times1+"' order by pubdate desc ";
				rs=db.executeQuery(sql);
				while(rs.next())
				{
					YLHQ_zmzs zmzs=new YLHQ_zmzs();
					zmzs.setpubdate(rs.getString("pubdate"));
					zmzs.setzd1(rs.getInt("zd1"));
					zmzs.setindex1(rs.getInt("index1"));					
					zmzs.settypes1(rs.getString("types1"));
					
					zmzs.setzd2(rs.getInt("zd2"));
					zmzs.setindex2(rs.getInt("index2"));					
					zmzs.settypes2(rs.getString("types2"));	
					
					zmzs.setzd3(rs.getInt("zd3"));
					zmzs.setindex3(rs.getInt("index3"));					
					zmzs.settypes3(rs.getString("types3"));
					vector1.add(zmzs);
				}
				rs.close();
				
				request.setAttribute("vector1",vector1);
				request.setAttribute("names",names);	
				request.setAttribute("times_first",times2);	
				request.setAttribute("times_end",times1);	
		}
		else
		{
			checkdate.settimes(times);
			times2=checkdate.gettimes();
			//times2="2004-10-15";
			//sql="select * from ylhq1_zmzs where pubdate='"+times+"'";
			sql="select * from ylhq1_zmzs where pubdate between '"+times2+"' and '"+times+"' order by pubdate desc ";
				rs=db.executeQuery(sql);
				while(rs.next())
				{
					YLHQ_zmzs zmzs=new YLHQ_zmzs();
					zmzs.setpubdate(rs.getString("pubdate"));
					zmzs.setzd1(rs.getInt("zd1"));
					zmzs.setindex1(rs.getInt("index1"));					
					zmzs.settypes1(rs.getString("types1"));
					
					zmzs.setzd2(rs.getInt("zd2"));
					zmzs.setindex2(rs.getInt("index2"));					
					zmzs.settypes2(rs.getString("types2"));	
					
					zmzs.setzd3(rs.getInt("zd3"));
					zmzs.setindex3(rs.getInt("index3"));					
					zmzs.settypes3(rs.getString("types3"));
					vector1.add(zmzs);
					number++;
				}
				rs.close();
				if(number>0)
				{
					request.setAttribute("vector1",vector1);
					request.setAttribute("names",names);
					request.setAttribute("times_first",times2);
					request.setAttribute("times_end",times);
				}
				else
				{
					checkdate.settimes(times1);
					times2=checkdate.gettimes();
					//times2="2004-10-15";
					sql="select * from ylhq1_zmzs where pubdate between '"+times2+"' and '"+times1+"' order by pubdate desc ";
						rs=db.executeQuery(sql);
						while(rs.next())
						{
							YLHQ_zmzs zmzs=new YLHQ_zmzs();
							zmzs.setpubdate(rs.getString("pubdate"));
							zmzs.setzd1(rs.getInt("zd1"));
							zmzs.setindex1(rs.getInt("index1"));					
							zmzs.settypes1(rs.getString("types1"));
					
							zmzs.setzd2(rs.getInt("zd2"));
							zmzs.setindex2(rs.getInt("index2"));					
							zmzs.settypes2(rs.getString("types2"));	
					
							zmzs.setzd3(rs.getInt("zd3"));
							zmzs.setindex3(rs.getInt("index3"));					
							zmzs.settypes3(rs.getString("types3"));
							vector1.add(zmzs);
						}
						rs.close();
				
						request.setAttribute("vector1",vector1);
						request.setAttribute("names",names);	
						request.setAttribute("times_first",times2);	
						request.setAttribute("times_end",times1);
				}

		}		
		return mapping.findForward("Success");
		//throw new UnsupportedOperationException("Generated method 'execute(...)' not implemented.");
	}

}