newstopicaction.java

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

package struts.action;


import javabean.*;

import java.sql.ResultSet;
import java.text.DecimalFormat;
import java.util.Vector;
import javabean.dbconnect;

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;

	
public class NewsTopicAction extends Action 
{
	
	ShowAtt show=new ShowAtt();
	dbconnect db=new dbconnect();
		
	public ActionForward execute(
	ActionMapping mapping,
	ActionForm form,
	HttpServletRequest request,
	HttpServletResponse response)
	throws Exception {
				
	Vector vec1=new Vector();
	String sql1="select * from FZDTB order by ID DESC";	//每日更新
	vec1=show.getTitleId(sql1);	    
	request.setAttribute("vec1",vec1);
	/////////////////////////////////////////
	Vector vec2=new Vector();		                            //时讯要闻
	String sql2="select * from FZDTB where TYPE='时讯要闻' order by ID DESC";
	vec2=show.getTitleId(sql2);	    
	request.setAttribute("vec2",vec2);
	/////////////////////////////////////////
	Vector vec3=new Vector();		    
	String sql3="select * from FZKJB order by ID DESC";	 //纺织科技
	vec3=show.getTitleId(sql3);	    
	request.setAttribute("vec3",vec3);
	////////////////////////////////////////
	Vector vec4=new Vector();		    
	String sql4="select * from FZDTB order by ID DESC";	 //纺织动态
	vec4=show.getTitleId(sql4);	    
	request.setAttribute("vec4",vec4);
	//////////////////////////////////////
	Vector vec5=new Vector();		    
	String sql5="select * from HQDTB order by ID DESC";	 //市场行情
	vec5=show.getTitleId(sql5);	    
	request.setAttribute("vec5",vec5);
	//////////////////////////////////////
	Vector vec6=new Vector();		    
	String sql6="select * from TJFX order by ID DESC";	 //综合统计
	vec6=show.getTitleId(sql6);	    
	request.setAttribute("vec6",vec6);
	//////////////////////////////////////
	String sql="select ID,CONTENT from FZDTB where TYPE='点评'";// and ID=(select max(ID) from FZDTB)";
	ResultSet rs=db.executeQuery(sql);
	String content="";                                  //本网点评
	int id=0;
	if(rs.next())
	{
	  content=rs.getString("CONTENT");
	  id=rs.getInt("ID");
	}
	rs.close();
	request.setAttribute("id",String.valueOf(id));
	request.setAttribute("content",content);
	/////////////////gjzs
	
	Vector vec7=new Vector();		    
	String sql7="select * from GJZS where PUBDATE=(select max(PUBDATE) from GJZS)";	 //股价指数
	vec7=show.getGjzs(sql7);	    
	request.setAttribute("vec7",vec7);
	
	///////////////////////hqzs
	
    ///////////////////////////////cn328,cn527,cn229
	String sql8="select * from ylhq1_zmzs where PUBDATE=(select max(PUBDATE) from ylhq1_zmzs)";
	ResultSet rs8=db.executeQuery(sql8);
	int cn328=0;
	int cn328zd=0;
	
	int cn527=0;
	int cn527zd=0;
	
	int cn229=0;
	int cn229zd=0;
	if(rs8.next())
	{
		cn328=rs8.getInt("INDEX1");
		cn328zd=rs8.getInt("zd1");
		
		cn527=rs8.getInt("INDEX2");
		cn527zd=rs8.getInt("zd2");
		
		cn229=rs8.getInt("INDEX3");
		cn229zd=rs8.getInt("zd3");
	}
	rs8.close();
	request.setAttribute("cn328",String.valueOf(cn328));
	request.setAttribute("cn328zd",String.valueOf(cn328zd));
	
	request.setAttribute("cn527",String.valueOf(cn527));
	request.setAttribute("cn527zd",String.valueOf(cn527zd));
		
	request.setAttribute("cn229",String.valueOf(cn229));
	request.setAttribute("cn229zd",String.valueOf(cn229zd));
	
	//////////////////////////////////////长丝切片
	sql="select * from ylhq1_hqzs where types='长丝切片' and PUBDATE=(select max(PUBDATE) from ylhq1_hqzs)";
	rs=db.executeQuery(sql);
	int csqp=0;
	int csqpzd=0;
	if(rs.next())
	{
		csqp=rs.getInt("INDEX");
		csqpzd=rs.getInt("ZD");
	}
	rs.close();
	request.setAttribute("csqp",String.valueOf(csqp));
	request.setAttribute("csqpzd",String.valueOf(csqpzd));
	
    ///////////////////////////////////瓶级切片
	  sql="select * from ylhq1_hqzs where types='瓶级切片' and PUBDATE=(select max(PUBDATE) from ylhq1_hqzs)";
	  rs=db.executeQuery(sql);
	  int pjqp=0;
	  int pjqpzd=0;
	  if(rs.next())
	  {
		pjqp=rs.getInt("INDEX");
		pjqpzd=rs.getInt("ZD");
	  }
	  rs.close();
	  request.setAttribute("pjqp",String.valueOf(pjqp));
	  request.setAttribute("pjqpzd",String.valueOf(pjqpzd));
	  
	  //////////////////////////////////////////涤纶POY
	sql="select * from ylhq1_hqzs where types='涤纶POY' and PUBDATE=(select max(PUBDATE) from ylhq1_hqzs)";
	rs=db.executeQuery(sql);
	int dlpoy=0;
	int dlpoyzd=0;
	if(rs.next())
	{
		dlpoy=rs.getInt("INDEX");
		dlpoyzd=rs.getInt("ZD");
	}
	rs.close();
	request.setAttribute("dlpoy",String.valueOf(dlpoy));
	request.setAttribute("dlpoyzd",String.valueOf(dlpoyzd));
	
	////////////////////////////////////////涤纶DTY
  sql="select * from ylhq1_hqzs where types='涤纶DTY' and PUBDATE=(select max(PUBDATE) from ylhq1_hqzs)";
  rs=db.executeQuery(sql);
  int dldty=0;
  int dldtyzd=0;
  if(rs.next())
  {
	  dldty=rs.getInt("INDEX");
	  dldtyzd=rs.getInt("ZD");
  }
  rs.close();
  request.setAttribute("dldty",String.valueOf(dldty));
  request.setAttribute("dldtyzd",String.valueOf(dldtyzd));
  
    ////////////////////////////////////////涤纶FDY
  sql="select * from ylhq1_hqzs where types='涤纶FDY' and PUBDATE=(select max(PUBDATE) from ylhq1_hqzs)";
  rs=db.executeQuery(sql);
  int dlfdy=0;
  int dlfdyzd=0;
  if(rs.next())
  {
	  dlfdy=rs.getInt("INDEX");
	  dlfdyzd=rs.getInt("ZD");
  }
  rs.close();
  request.setAttribute("dlfdy",String.valueOf(dlfdy));
  request.setAttribute("dlfdyzd",String.valueOf(dlfdyzd));
	
      ///////////////////////////////////////////涤纶短纤
	  String sql9="select * from ylhq1_hqzs where types='涤纶短纤' and PUBDATE=(select max(PUBDATE) from ylhq1_hqzs)";
	  ResultSet rs9=db.executeQuery(sql9);
	  int dndq=0;
	  int dndqzd=0;
	  if(rs9.next())
	  {
		dndq=rs9.getInt("INDEX");
		dndqzd=rs9.getInt("ZD");
	  }
	  rs9.close();
	  request.setAttribute("dndq",String.valueOf(dndq));
	  request.setAttribute("dndqzd",String.valueOf(dndqzd));
	  
	  ///////////////////////////////////////////////粘胶短纤
 	 String sql10="select * from ylhq1_hqzs where types='粘胶短纤' and PUBDATE=(select max(PUBDATE) from ylhq1_hqzs)";
 	 ResultSet rs10=db.executeQuery(sql10);
 	 int njdq=0;
 	 int njdqzd=0;
	  if(rs10.next())
	  {
		njdq=rs10.getInt("INDEX");
		njdqzd=rs10.getInt("ZD");
 	 }
	 rs10.close();
 	 request.setAttribute("njdq",String.valueOf(njdq));
 	 request.setAttribute("njdqzd",String.valueOf(njdqzd));
 	 
    	 ///////////////////////////////////////////////////////腈纶短纤
		String sql11="select * from ylhq1_hqzs where types='腈纶短纤' and PUBDATE=(select max(PUBDATE) from ylhq1_hqzs)";
		ResultSet rs11=db.executeQuery(sql11);
		int jndq=0;
		int jndqzd=0;
		 if(rs11.next())
		 {
		   jndq=rs11.getInt("INDEX");
		   jndqzd=rs11.getInt("ZD");
		}
		rs11.close();
		request.setAttribute("jndq",String.valueOf(jndq));
		request.setAttribute("jndqzd",String.valueOf(jndqzd));

	////////////////////////////////////////////////////////CotlookA
	DecimalFormat df=new DecimalFormat("0.00");
	
	sql="select PRICE from DATA where CODE='1001' order by TIMEDATE desc";
	rs=db.executeQuery(sql);
	float[] cota=new float[2];
	float cotazd=0;
	int flag=0;
	 while(rs.next())
	 {		
		cota[flag]=rs.getFloat("PRICE");
		flag++;		
		if(flag==2) break;
	}
	rs.close();
	cotazd=cota[0]-cota[1];
	request.setAttribute("cota",String.valueOf(cota[0]));
	request.setAttribute("cotazd",df.format(cotazd));
	
	////////////////////////////////////////////////////////////////CotlookB
	sql="select PRICE from DATA where CODE='1002' order by TIMEDATE desc";
	rs=db.executeQuery(sql);
	float[] cotb=new float[2];
	float cotbzd=0;
	flag=0;
	 while(rs.next())
	 {		
		cotb[flag]=rs.getFloat("PRICE");
		flag++;		
		if(flag==2) break;
	}
	rs.close();
	cotbzd=cotb[0]-cotb[1];
	request.setAttribute("cotb",String.valueOf(cotb[0]));
	request.setAttribute("cotbzd",df.format(cotbzd));



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

}