querydetailaction.java

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

// Created by Xslt generator for Eclipse.
// XSL :  not found (java.io.FileNotFoundException:  (系统找不到指定的路径。))
// Default XSL used : easystruts.jar$org.easystruts.xslgen.JavaClass.xsl

package struts.action;

import java.sql.*;
import java.util.Vector;

import javabean.*;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;

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.QuerydetailForm;


//根据showdetail.jsp传过来的时间和code进行查询，然后把结果返回给showdetail.jsp 
public class QuerydetailAction extends Action {


	
	Stringtokenizer SToken=new Stringtokenizer();
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception {
		QuerydetailForm querydetailForm = (QuerydetailForm) form;
		ConnectionPool pool=null;
		pool=ConnectionPool.getInstance();
		Connection con=null;
		try
		{
			con=pool.getConnection();
		}catch(SQLException e){}
		String minyear=querydetailForm.getMinyear();
		String minmonth=querydetailForm.getMinmonth();
		String minday=querydetailForm.getMinday();
		String maxyear=querydetailForm.getMaxyear();
		String maxmonth=querydetailForm.getMaxmonth();
		String maxday=querydetailForm.getMaxday();
		String mindate=(minyear+"-"+minmonth+"-"+minday).trim();
		String maxdate=(maxyear+"-"+maxmonth+"-"+maxday).trim();
		String code=querydetailForm.getCode();
		
		
		Vector vec=new Vector();
		Vector veckind=new Vector();
		PubDate nowdate=new PubDate();
		DataClass hqclass=new DataClass();
		
		AppletPrama appletprama=new AppletPrama(con);
		priceDB pricedb=new priceDB(con);
		if(code==null)
		{
			code="1001";
			maxdate=appletprama.getMaxdate(code);
			mindate=appletprama.getMindate(code);
		}
		
		
		String title=appletprama.getTitle(code);
		String danwei=appletprama.getDanwei(code);
		String maxDBday=appletprama.getMaxdate(code);
		String minDBday=appletprama.getMindate(code);
		if(mindate.compareTo(maxDBday)<0 && maxdate.compareTo(minDBday)>0)
		{
			if(mindate.compareTo(minDBday)<0)
			{
				mindate=minDBday;
			}
			if(maxdate.compareTo(maxDBday)>0)
			{
				maxdate=maxDBday;
			}
		}
		float maxprice=appletprama.getMaxprice(code,mindate,maxdate);
		float minprice=appletprama.getMinprice(code,mindate,maxdate);
		vec=appletprama.getAllprice(code,mindate,maxdate);
		String now=nowdate.getDate();
		request.setAttribute("title",title);
		request.setAttribute("danwei",danwei);
		request.setAttribute("maxdate",maxdate);
		
		request.setAttribute("maxprice",String.valueOf(maxprice));
		request.setAttribute("minprice",String.valueOf(minprice));
		request.setAttribute("now",now);
		request.setAttribute("code",code);
		int j=0;
		if(vec!=null)
		{
			if(vec.size()>365)
			{
				for(int i=(vec.size()-365);i<vec.size();i++)
				{
					hqclass=(DataClass)vec.get(i);
					j=i-(vec.size()-365);
					request.setAttribute("price"+j,String.valueOf(hqclass.getPrice()));
					
				}
				request.setAttribute("number",String.valueOf(365));
				mindate=((DataClass)vec.get(vec.size()-365)).getTimedate();
			}
			else
			{
				for(int i=0;i<vec.size();i++)
				{
					hqclass=(DataClass)vec.get(i);
					
					request.setAttribute("price"+i,String.valueOf(hqclass.getPrice()));
					
				}
				request.setAttribute("number",String.valueOf(vec.size()));
		}
			
			
		}
		
		String str1="select code,title from kind";
		veckind=pricedb.getTitleCode(str1);
		request.setAttribute("veckind",veckind);
		request.setAttribute("mindate",mindate);
		
		
		
		String minselect=SToken.getYear(minDBday);
		String maxselect=SToken.getYear(maxDBday);	
		request.setAttribute("minselect",minselect);
		request.setAttribute("maxselect",maxselect);
		try
		{
			if(con!=null) 
			con.close();
		}catch(SQLException e){}
		return (mapping.findForward("success"));
	}

}