gjzsaction.java

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

package struts.action;

import java.sql.ResultSet;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

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.GjzsForm;
import javabean.dbconnect;
import javabean.PubDate;


public class GjzsAction extends Action {


	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception {
			
		HttpSession session=request.getSession();
		GjzsForm gjzsForm = (GjzsForm) form;
		PubDate date1=new PubDate();
		
		String date=date1.getDate();
		String uid=(String)session.getAttribute("uid");
		
		String dqs=gjzsForm.getDqs();
		String lsdk=gjzsForm.getLsdk();
		String ldfs=gjzsForm.getLdfs();
		String rj=gjzsForm.getRj();

		String hs=gjzsForm.getHs();
		String sz=gjzsForm.getSz();
		String shez=gjzsForm.getShez();
		String bp=gjzsForm.getBp();
	    String twjq=gjzsForm.getTwjq();
		String hxsb=gjzsForm.getHxsb();

		
		String dqszd=gjzsForm.getDqszd();
		String lsdkzd=gjzsForm.getLsdkzd();
		String ldfszd=gjzsForm.getLdfszd();
		String rjzd=gjzsForm.getRjzd();

		String hszd=gjzsForm.getHszd();
		String szzd=gjzsForm.getSzzd();
		String shezzd=gjzsForm.getShezzd();
		String bpzd=gjzsForm.getBpzd();
		String twjqzd=gjzsForm.getTwjqzd();
		String hxsbzd=gjzsForm.getHxsbzd();				  
				  
		dbconnect db=new dbconnect();
       
       String s[]=new String[11];
	   s[1]= "'道琼斯'"+","+"'"+dqs+"'"+","+"'"+dqszd+"'"+","+"'"+date+"'";
	   s[2]= "'纳斯达克'"+","+"'"+lsdk+"'"+","+"'"+lsdkzd+"'"+","+"'"+date+"'";
	   s[3]= "'伦敦富时'"+","+"'"+ldfs+"'"+","+"'"+ldfszd+"'"+","+"'"+date+"'";
	   s[4]= "'日经'"+","+"'"+rj+"'"+","+"'"+rjzd+"'"+","+"'"+date+"'";
	   s[5]= "'恒生'"+","+"'"+hs+"'"+","+"'"+hszd+"'"+","+"'"+date+"'";
	   s[6]= "'上证'"+","+"'"+sz+"'"+","+"'"+szzd+"'"+","+"'"+date+"'";
	   s[7]= "'深证'"+","+"'"+shez+"'"+","+"'"+shezzd+"'"+","+"'"+date+"'";
	   s[8]= "'标普500'"+","+"'"+bp+"'"+","+"'"+bpzd+"'"+","+"'"+date+"'";
	   s[9]= "'台湾加权'"+","+"'"+twjq+"'"+","+"'"+twjqzd+"'"+","+"'"+date+"'";
	   s[10]= "'金融时报'"+","+"'"+hxsb+"'"+","+"'"+hxsbzd+"'"+","+"'"+date+"'";
	   
	   int i=0;
	   String sql="";
	   ResultSet rs=null;
	   for(int j=1;j<11;j++)
	   {
	     sql="insert into GJZS values "+"("+s[j]+")";
	     rs=db.executeQuery(sql);
	   }	
	   
	  gjzsForm.reset(mapping,request);
	return (mapping.findForward("success"));
	
	}

}