backylhq_zmqhaction.java

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

// Created by Xslt generator for Eclipse.
// XSL :  not found (java.io.FileNotFoundException:  (Bad file descriptor))
// Default XSL used : easystruts.jar$org.easystruts.xslgen.JavaClass.xsl

package struts.action;

import java.sql.ResultSet;
import javabean.PubDate;
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;
import struts.form.Backylhq_zmqhForm;

/** 
 * Backylhq_zmqhAction.java created by EasyStruts - XsltGen.
 * http://easystruts.sf.net
 * created on 10-22-2004
 * 
 * XDoclet definition:
 * @struts:action path="/backylhq_zmqh" name="backylhq_zmqhForm" input="/form/backylhq_zmqh.jsp" validate="true"
 * @struts:action-forward name="/BackYLHQ_zmqh.jsp" path="/BackYLHQ_zmqh.jsp"
 */
public class Backylhq_zmqhAction extends Action {

	// --------------------------------------------------------- Instance Variables

	// --------------------------------------------------------- Methods
	private String types;
	private int price_f;//first
	private int price_h;//higth
	private int price_l;//low
	private int price_e;//end
	private int price_js;//average
	private int zd;//涨跌
	private int cjl;//成交量
	private int bd;//变动
	private int ccl;//持仓量
	/** 
	 * Method execute
	 * @param ActionMapping mapping
	 * @param ActionForm form
	 * @param HttpServletRequest request
	 * @param HttpServletResponse response
	 * @return ActionForward
	 * @throws Exception
	 */
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception {
		Backylhq_zmqhForm backylhq_zmqhForm = (Backylhq_zmqhForm) form;
		
		String sql;
		dbconnect db=new dbconnect();
		ResultSet rs;
		bd=backylhq_zmqhForm.getbd();
		zd=backylhq_zmqhForm.getzd();
		cjl=backylhq_zmqhForm.getcjl();
		ccl=backylhq_zmqhForm.getccl();
		price_js=backylhq_zmqhForm.getprice_js();
		price_e=backylhq_zmqhForm.getprice_e();
		price_h=backylhq_zmqhForm.getprice_h();
		price_l=backylhq_zmqhForm.getprice_l();
		price_f=backylhq_zmqhForm.getprice_f();
		types=backylhq_zmqhForm.gettypes();
		PubDate pub=new PubDate();
		int id=0;
		String pubdate=pub.getshortPubdate();
		
		sql="select * from ylhq1_zmqh where pubdate='"+pubdate+"' and types='"+types+"'";
		rs=db.executeQuery(sql);
		if(rs.next())
		{
			return(new ActionForward(mapping.getInput()));
		}
		else
		{
			sql="select count(id) from ylhq1_zmqh";
			rs=db.executeQuery(sql);
			if(rs.next())
			{
				id=rs.getInt(1);
			}
			rs.close();
		
			sql="insert into ylhq1_zmqh values('"+(id+1)+"','"+types+"','"+price_f+"','"+price_h+"','"+price_l+"','"+price_e+"','"+price_js+"','"+zd+"','"+cjl+"','"+ccl+"','"+bd+"','"+pubdate+"')";
			rs=db.executeQuery(sql);
			rs.close();
		}
		
		return mapping.findForward("BackSuccess");		
		
		//throw new UnsupportedOperationException("Generated method 'execute(...)' not implemented.");
	}

}