backylhq_alcsaction.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.dbcon_excel;
import javabean.dbcon_oracle;
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_alcsForm;

/** 
 * Backylhq_alcsAction.java created by EasyStruts - XsltGen.
 * http://easystruts.sf.net
 * created on 10-29-2004
 * 
 * XDoclet definition:
 * @struts:action path="/backylhq_alcs" name="backylhq_alcsForm" input="/form/backylhq_alcs.jsp" validate="true"
 * @struts:action-forward name="/BackYLHQ_sjdl.jsp" path="/BackYLHQ_sjdl.jsp"
 */
public class Backylhq_alcsAction extends Action {

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

	// --------------------------------------------------------- Methods

	/** 
	 * 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_alcsForm backylhq_alcsForm = (Backylhq_alcsForm) form;
		
		String sql;
		String sql1;
		dbcon_oracle db=new dbcon_oracle();
		dbcon_excel db_e=new dbcon_excel();
		ResultSet rs,rs1;
		String title=backylhq_alcsForm.gettitle();
			title=new String(title.getBytes("ISO-8859-1"));
		String excel_table=backylhq_alcsForm.getexcel_table().trim();
			excel_table=new String(excel_table.getBytes("ISO-8859-1"));
		String pubdate=backylhq_alcsForm.getpubdate();
		String type;
		String name;
		String area;
		String market;
		String dj;
		String color;
		int price;		
		int id=0;
		
		PubDate pdate=new PubDate();
		String today=pdate.getshortPubdate();
		if(pubdate.compareTo(today)>1)
		{
			return(new ActionForward(mapping.getInput()));
		}
		
		sql="select * from ylhq1_alcs where title='"+title+"' and pubdate='"+pubdate+"'";
		rs=db.executeQuery(sql);
		if(rs.next())
		{
			rs.close();
			return(new ActionForward(mapping.getInput()));
		}
		else
		{
			rs.close();
			sql="select max(id) as id from ylhq1_alcs";
			rs=db.executeQuery(sql);
			if(rs.next())
			{
				id=rs.getInt("id");
			}
			rs.close();
			id=id+1;
		
			sql="select * from  "+excel_table+"";
			rs1=db_e.executeQuery(sql);
			while(rs1.next())
			{
				name=rs1.getString(1).trim();
				type=rs1.getString(2);
				dj=rs1.getString(3).trim();
				color=rs1.getString(4).trim();
				area=rs1.getString(5).trim();
				market=rs1.getString(6).trim();
				price=rs1.getInt(7);
				sql1="insert into ylhq1_alcs values('"+(id)+"','"+title+"','"+type+"','"+dj+"','"+color+"','"+area+"','"+market+"','"+price+"','"+pubdate+"','"+name+"')";
				rs=db.executeQuery(sql1);
			}
			
			rs.close();
			rs1.close();
		}		
		return mapping.findForward("BackSuccess");
		//throw new UnsupportedOperationException("Generated method 'execute(...)' not implemented.");
	}

}