backylhq_dtps1action.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_dtps1Form;

/** 
 * Backylhq_dtps1Action.java created by EasyStruts - XsltGen.
 * http://easystruts.sf.net
 * created on 10-19-2004
 * 
 * XDoclet definition:
 * @struts:action path="/backylhq_dtps1" name="backylhq_dtps1Form" input="/backylhq_dtps1.jsp" validate="true"
 */
public class Backylhq_dtps1Action 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_dtps1Form backylhq_dtps1Form = (Backylhq_dtps1Form) form;
		
		ResultSet rs;
		dbconnect db=new dbconnect();
		ResultSet rs1 = null;
		dbconnect db1=new dbconnect();
		int count=0;
		String title1=(backylhq_dtps1Form.gettitle1()).trim();
			title1=new String(title1.getBytes("ISO-8859-1"));
		String title2=backylhq_dtps1Form.gettitle2();
			title2=new String(title2.getBytes("ISO-8859-1"));
		String titles=title1+title2;
		String sql;
		String show="";
		String content=backylhq_dtps1Form.getcontents();
		
		if(content.length()==0 || content==null)
		{
			return(new ActionForward(mapping.getInput()));
		}
		if(title2.length()==0 || title2==null)
		{
			return(new ActionForward(mapping.getInput()));
		}
			content=new String(content.getBytes("ISO-8859-1"));
			content=content.replaceAll("<","&lt;");    //解决在jsp显示"<"的问题
			content=content.replaceAll(">","&gt;");    //解决在jsp显示">"的问题
			content=content.replaceAll("\n","<br/>&nbsp;&nbsp;");  //解决在jsp换行的问题
			content=content.replaceAll(" ","&nbsp;");  //解决在jsp显示空格的问题
		String contents=content;
		PubDate pb=new PubDate();
		String times=pb.getshortPubdate();
		String table="YLHQ1_DT";
		int id=0;
		String[] strArray=backylhq_dtps1Form.getstrArray();//原料动态，行情评述	
		String strArray1=backylhq_dtps1Form.getstrArray1();//图片选择
		String[] strArrayTP=backylhq_dtps1Form.getcontent();//图片内容
		
		if(strArray1.length()!=0 || strArray1!=null)
		{
			strArray1=new String(strArray1.getBytes("ISO-8859-1"));	
		}
		
		for(count=0;count<strArray.length;count++)
		{
			strArray[count]=new String(strArray[count].getBytes("ISO-8859-1"));
			if(strArray[count].equalsIgnoreCase("原料动态"))
			{
				table="YLHQ1_DT";
				sql="select count(ID) as Count from "+table+"";
				rs=db.executeQuery(sql);
				if(rs.next())
				{
					id=rs.getInt("Count");
				}
				rs.close();
				id=id+1;
				
				sql="insert into "+table+" values('"+id+"','"+titles+"','"+contents+"','"+times+"')";
				rs=db.executeQuery(sql);
				rs.close();
								
				if(strArray1.equalsIgnoreCase("图片选择"))
				{

					for(int count1=0;count1<strArrayTP.length;count1++)
					{
						table="YLHQ1_DT_TP";
						content="Table_Picture/"+strArrayTP[count1];//图片
						sql="insert into YLHQ1_DT_TP values('"+id+"','"+content+"')";
						rs=db.executeQuery(sql);
						rs.close();
					}
				}
			}
			if(strArray[count].equalsIgnoreCase("行情评述"))
			{
				table="YLHQ1_PS";
				sql="select count(ID) as Count from "+table+"";
				rs=db.executeQuery(sql);
				while(rs.next())
				{
					id=rs.getInt("Count");
				}
				rs.close();
				id=id+1;
				sql="insert into "+table+" values('"+id+"','"+titles+"','"+contents+"','"+times+"')";
				rs=db.executeQuery(sql);
				rs.close();		

				if(strArray1.equalsIgnoreCase("图片选择"))
				{

					for(int count1=0;count1<strArrayTP.length;count1++)
					{
						table="YLHQ1_PS_TP";
						content="Table_Picture/"+strArrayTP[count1];//图片
						sql="insert into YLHQ1_PS_TP values('"+id+"','"+content+"')";
						rs=db.executeQuery(sql);
						rs.close();
					}
				}
			}			
			
		}
		
		return mapping.findForward("BackSuccess");
		//throw new UnsupportedOperationException("Generated method 'execute(...)' not implemented.");
	}

}