ylhq1indexaction.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 java.util.Vector;
import javabean.Ylhq1index;
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;


/** 
 * Ylhq1indexAction.java created by EasyStruts - XsltGen.
 * http://easystruts.sf.net
 * created on 10-19-2004
 * 
 * XDoclet definition:
 * @struts:action path="/ylhq1index" name="ylhq1indexForm" input="/ylhq1index.jsp" validate="true"
 */
public class Ylhq1indexAction 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 {
		
		Vector vector1=new Vector();
		Vector vector2=new Vector();
		String tables="";
			ResultSet rs;
			dbconnect db=new dbconnect();
			String sql="";
		
			sql="select TITLE,ID,PUBDATE from YLHQ1_DT order by id desc ";
			rs=db.executeQuery(sql);
			while(rs.next())
			{
				Ylhq1index ylhq1index_dt=new Ylhq1index();
				ylhq1index_dt.settitles(rs.getString("TITLE"));
				ylhq1index_dt.setid(rs.getInt("ID"));
				ylhq1index_dt.settimes(rs.getString("PUBDATE"));
				vector1.add(ylhq1index_dt);
			}
			rs.close();
			request.setAttribute("vector1",vector1);
		
			sql="select TITLE,ID,PUBDATE from YLHQ1_PS order by id desc ";
			rs=db.executeQuery(sql);
			while(rs.next())
			{
				Ylhq1index ylhq1index_ps=new Ylhq1index();
				ylhq1index_ps.settitles(rs.getString("TITLE"));
				ylhq1index_ps.setid(rs.getInt("ID"));
				ylhq1index_ps.settimes(rs.getString("PUBDATE"));
				vector2.add(ylhq1index_ps);
			}
			rs.close();
			
			tables="原料系列";
			request.setAttribute("tables",tables);
			request.setAttribute("vector2",vector2);
								
		return mapping.findForward("Success");	
		//throw new UnsupportedOperationException("Generated method 'execute(...)' not implemented.");
	}

}