hqtbaction.java

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

package struts.action;


import javabean.*;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.Vector;
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.PriceForm;
	
public class HqtbAction extends Action 
{
	
	public ActionForward execute(
	ActionMapping mapping,
	ActionForm form,
	HttpServletRequest request,
	HttpServletResponse response)
	throws Exception {

	/////////////////////小程序
	
	ConnectionPool pool=null;
	pool=ConnectionPool.getInstance();
	Connection con=null;
	try
	{
	con=pool.getConnection();
	}
	catch(SQLException e){
	}
	priceDB pricedb=new priceDB(con);
	Vector vec=new Vector();
			Vector veckind=new Vector();
			PubDate nowdate=new PubDate();
					DataClass hqclass=new DataClass();
			AppletPrama appletprama=new AppletPrama(con);
			//PriceForm priceform=(PriceForm)form;
			
			String code=request.getParameter("code");
			if(code==null)
			{
				code="1001".trim();
			}
			else
			{
				code=code.trim();
			}
			String title=appletprama.getTitle(code);
					String danwei=appletprama.getDanwei(code);
					String maxdate=appletprama.getMaxdate(code);
					String mindate=appletprama.getMindate(code);
					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("mindate",mindate);
					request.setAttribute("maxprice",String.valueOf(maxprice));
					request.setAttribute("minprice",String.valueOf(minprice));
					request.setAttribute("now",now);
					request.setAttribute("code1",code);
					/*for(int i=0;i<vec.size();i++)
					{
						hqclass=(DataClass)vec.get(i);
						request.setAttribute("price"+i,String.valueOf(hqclass.getPrice()));
					}*/
					
					
					int j=0;
							if(vec!=null)
							{
								if(vec.size()>120)
								{
									for(int i=(vec.size()-120);i<vec.size();i++)
									{
										hqclass=(DataClass)vec.get(i);
										j=i-(vec.size()-120);
										request.setAttribute("price"+j,String.valueOf(hqclass.getPrice()));
					
									}
									request.setAttribute("number",String.valueOf(120));
									mindate=((DataClass)vec.get(vec.size()-120)).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()));
								}
			
			
							}
					
						request.setAttribute("mindate",mindate);
				//request.setAttribute("number",String.valueOf(vec.size()));
			
				String query="select code,title from kind order by code";
						veckind=pricedb.getTitleCode(query);
						request.setAttribute("selectnum",String.valueOf(veckind.size()));
						request.setAttribute("veckind",veckind);
						
			try
			{
				if(con!=null)
				con.close();
			}
			catch(SQLException e){
			}


	 return (mapping.findForward("success"));
   }	

}