market_info_detailaction.java

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

/**
/**
 * @author 郑文金
 *关于"市场行情"中各个市场和行情详细数据信息的action
 * 
 * 
 */
package struts.action;

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 javabean.*;
import java.sql.*;
import java.util.Vector;
public class Market_info_detailAction extends Action {
	

	private ConnectionPool pool;
	private Connection con;
	public Market_info_detailAction() throws SQLException
	{
		pool=ConnectionPool.getInstance();               //初始化连接池
	}
	
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception 
	{
		Vector vec=new Vector();
		con=pool.getConnection();  //从池中获得一个连接
		MarketDao mk=new MarketDao(con);
		CodeString codestring=new CodeString();
		String sc=request.getParameter("sc");//获得获得用户想要查找的信息的市场
		sc=codestring.getString(sc);
		request.setAttribute("sc",sc);
		String pz=request.getParameter("pz");//获得获得用户想要查找的信息的品种
		pz=codestring.getString(pz).trim();
		request.setAttribute("pz",pz);
		String dates=request.getParameter("dates");//获得用户想要查找的信息的日期
		dates=codestring.getString(dates);
		request.setAttribute("dates",dates);
		
		String max_date1="";
		String max_date2="";
		
		String s="";
		//if(pz.equals("其它"))//其它类
		//{
		//	s="select * from schqb where pz  not in('纯棉纱','涤棉纱','纯涤纱','人棉纱','涤粘纱','坯布') and sc not in ('西南市场','盛泽市场','宁波市场','钱请市场','织里城市场','佛山市场')";
		//}
		if(pz.equals(""))//如果品种为空，则表示点击的是市场，就按市场来查询
		{
			String str1="select max(pubdate) as max_date1 from schqb where sc="+"'"+sc+"'";//按市场查询出最近更新的日期
			ResultSet rs1=mk.query(str1);
			while(rs1.next())
			{
				max_date1=rs1.getString("max_date1");
			}
			String str2="select pubdate from schqb where pubdate= "+"'"+dates+"'"+" and sc= "+"'"+sc+"'";
			ResultSet rs2=mk.query(str2);
			if(!rs2.next())//如果不存在用户提交的日期,就显示最新日期的信息
			{
				dates=max_date1;
				request.setAttribute("dates",dates);
			}
			s="select * from schqb where sc= "+"'"+sc+"'"+"and pubdate= "+"'"+dates+"'"+" order by pz";
		}
		if(sc.equals(""))//如果市场为空，则表示点击的是品种，就按品种来查询
		{			
			String str1="select max(pubdate) as max_date2 from schqb where pz="+"'"+pz+"'";//按产品类型查询出最近更新的日期
			ResultSet rs1=mk.query(str1);
			while(rs1.next())
			{
				max_date2=rs1.getString("max_date2");
			}
			String str2="select pubdate from schqb where pubdate= "+"'"+dates+"'"+" and pz= "+"'"+pz+"'";
			ResultSet rs2=mk.query(str2);
			if(!rs2.next())//如果不存在用户提交的日期,就显示最新日期的信息
			{
				dates=max_date2;
				request.setAttribute("dates",dates);
			}
			s="select * from schqb where pz= "+"'"+pz+"'"+" and pubdate= "+"'"+dates+"'"+" order by sc";
		}
		vec=mk.schq_info(s);
		request.setAttribute("vec",vec);
		con.close();
		return mapping.findForward("market_info_detail");
	}

}