backylhq_qtylaction.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.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;

/** 
 * Backylhq_qtylAction.java created by EasyStruts - XsltGen.
 * http://easystruts.sf.net
 * created on 10-24-2004
 * 
 * XDoclet definition:
 * @struts:action validate="true"
 */
public class Backylhq_qtylAction 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 {


			ResultSet rs;
			dbconnect db=new dbconnect();
			String sql;
			Vector vector1=new Vector();
			Vector vector2=new Vector();
			Vector vector3=new Vector();
			Vector vector4=new Vector();
			Vector vector5=new Vector();
			
			sql="select distinct(names) from YLHQ1_QTTITLENAMES ";
			rs=db.executeQuery(sql);
			while(rs.next())
			{
				vector1.add(new org.apache.struts.util.LabelValueBean(rs.getString("names"),rs.getString("names")));
			}
			rs.close();
		
			sql="select distinct(types) from YLHQ1_qtTITLETYPES ";
			rs=db.executeQuery(sql);
			while(rs.next())
			{
				vector2.add(new org.apache.struts.util.LabelValueBean(rs.getString("types"),rs.getString("types")));
			}
			rs.close();
		
			sql="select distinct(market) from YLHQ1TITLEMARKET ";
			rs=db.executeQuery(sql);
			while(rs.next())
			{
				vector3.add(new org.apache.struts.util.LabelValueBean(rs.getString("market"),rs.getString("market")));
			}
			rs.close();
		
			sql="select distinct(areas) from YLHQ1TITLEAREAS ";
			rs=db.executeQuery(sql);
			while(rs.next())
			{
				vector4.add(new org.apache.struts.util.LabelValueBean(rs.getString("areas"),rs.getString("areas")));
			}
			rs.close();

			sql="select distinct(danw) from YLHQ1TITLEDANW ";
			rs=db.executeQuery(sql);
			while(rs.next())
			{
				vector5.add(new org.apache.struts.util.LabelValueBean(rs.getString("danw"),rs.getString("danw")));
			}
			rs.close();
		
			request.setAttribute("vector1",vector1);
			request.setAttribute("vector2",vector2);
			request.setAttribute("vector3",vector3);
			request.setAttribute("vector4",vector4);
			request.setAttribute("vector5",vector5);
		
			return mapping.findForward("BackSuccess");
		//throw new UnsupportedOperationException("Generated method 'execute(...)' not implemented.");
	}

}